🔢 Artemis Sheets
Supported Metrics
🔢 Artemis Sheets
Supported Metrics
Here’s a list of all the metrics we support for Artemis Sheet
💡 Info
🆕 For a list of all the metrics we provide, please use =ARTINFO("ALL","METRICS")
Market Data (CoinGecko)
- Here’s a list of all supported symbols: All CoinGecko assets
- Here’s a list of all metrics we support: All Artemis metrics
- 🆕 Stablecoins are also supported:
USDCUSDTDAIBUSDetc
Note: All historical market data is fetched as of 12PM UTC
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| PRICE | Token price | 5min | ✓ |
| MC | Market Capitalization | 5min | ✓ |
| 24H_VOLUME | 24 hour volume | 5min | ✓ |
| FDMC | Fully diluted market capitalization | 5min | ✓ |
| CIRC_SUPPLY | Circulating supply | 5min | |
| TOT_SUPPLY | Total supply | 5min | |
| MAX_SUPPLY | Max supply | 5min | |
| 30D_VOLUME | 30 day volume | 5min | |
| 24H_PRICE_HIGH | 24 hour price high ($) | 5min | |
| 24H_PRICE_LOW | 24 hour price low ($) | 5min | |
| 24H_PRICE_CHG | 24 hour price change ($) | 5min | |
| 24H_PRICE_CHG_PCT | 24 hour price change (%) | 5min | |
| 7D_PRICE_CHG_PCT | 7 day price change (%) | 5min | |
| 30D_PRICE_CHG_PCT | 30 day price change (%) | 5min | |
| 24H_MC_CHG | 24 hour market cap change ($) | 5min | |
| 24H_MC_CHG_PCT | 24 hour market cap change (%) | 5min | |
| ATH | All time high ($) | 5min | |
| ATH_CHG_PCT | All time high change from today (%) | 5min | |
| ATH_DATE | All time high date | 5min | |
| ATL | All time low ($) | 5mi |
🆕 Equity Data
💡 Info
To pull stock price into sheets, use =ART(“EQ-COIN”, “PRICE”) for Coinbase price.
Instructions
- Find the stock symbol for a stock from Yahoo Finance.
- Examples:
SPY[^1] for SPDR S&P 500 ETF Trust (SPY)GBTCfor Grayscale Bitcoin TrustCOINfor Coinbase
- Examples:
- Append “EQ-” in front of the stock symbol name.
- Example: For Coinbase you’d want to have
"EQ-COIN"
- Example: For Coinbase you’d want to have
- Use the following formula =ART(“EQ-[Stock Symbol]”, “PRICE”) to return the price of the stock
- Example: For Coinbase you’d want use
=ART("EQ-COIN", "PRICE")
- Example: For Coinbase you’d want use
Notes
- Equities prices forward fill from last close on holidays / weekends.
- Here’s a sample sheet using equities price
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| PRICE | Stock price | 5min | ✓ |
Artemis Terminal
Supported Symbols: all chains on app.artemis.xyz
Note: Not all chains have all metrics listed below - check app.artemis.xyz for a list of chain to metric pairings
| Name | Explanation | Update Frequency | Supports Date |
|---|---|---|---|
| DAU | Daily Active Addresses - the number of unique wallet addresses sending an on-chain transaction in a rolling 24 hour period | Daily | ✓ |
| DAU_OVER_100 | Daily Active Addresses where the address has an account balance of >$100.Note: only native tokens and stablecoins are included in the account balance. | Daily | ✓ |
| DAILY_TXNS | Daily Transactions - the total number of transactions registered on-chain in a rolling 24 hour period | Daily | ✓ |
| FEES | Fees paid by protocol users | Daily | ✓ |
| STABLECOIN_MC | $ of Stablecoin custodied on a chain | Daily | ✓ |
| AVG_TXN_FEE | Average transaction fee paid by users | Daily | ✓ |
| REVENUE | Fees accrued to the protocol | Daily | ✓ |
| TWITTER_FOLLOWERS | Total followers on the official Twitter account | Daily | ✓ |
| WEEKLY_COMMITS_CORE | Number of weekly commits to core repositories for a given ecosystem FAQ | Weekly (new data on Tuesday) | ✓ |
| WEEKLY_COMMITS_SUB | Number of weekly commits to sub-ecosystem repositories for a given ecosystem FAQ | Weekly (new data on Tuesday) | ✓ |
| WEEKLY_DEVS_CORE | Number of weekly developers for a given core ecosystem FAQ | Weekly (new data on Tuesday) | ✓ |
| WEEKLY_DEVS_SUB | Number of weekly developers for given sub ecosystems FAQ | Weekly (new data on Tuesday) | ✓ |
| WEEKLY_CONTRACTS_DEPLOYED | Number of unique contracts deployed to the chain | Weekly | ✓ |
| WEEKLY_UNIQUE_CONTRACT_DEPLOYERS | Number of unique wallets deploying to the chain | Weekly | ✓ |
🆕 Artemis - Blockchain Activity Monitor
- Supported Applications: all applications on Artemis Applications
- Supported Categories: all category names on Artemis Blockchain Activity Monitor
- Supported Chains: all chain names on Artemis Blockchain Activity Monitor
For symbol name for a given application, please find the associated symbol ID from Coingecko for the application (e.g symbol UNI for application name Uniswap)
For chain symbol, please simply use the symbol for the given chain e.g Ethereum is ETH
For category on-chain usage for a chain, please append category name-chain so DeFi-ETH
Examples
ART("AAVE","DAU")returns Aave daily active addresses across all chainsART("AAVE-ETH","DAILY_TXNS")returns Aave daily transactions on EthereumART("AAVE-MATIC","GAS_USD")returns Aave daily gas usage in USD on PolygonART("DeFi-ETH", "DAU")returns DeFi daily active addresses on EthereumART("Layer_2-ETH","GAS_USD")returns daily Layer 2 Gas usage in USD on Ethereum
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| DAU | Daily active addresses by a given application for specified chains | Daily | ✓ |
| DAILY_TXNS | Daily transactions by a given application for specified chains | Daily | ✓ |
| GAS_USD | Amount of gas spent by a given application for specified chains | Daily | ✓ |
Artemis - Perpetuals
Supported Symbols: all perpetual exchanges on the Artemis Terminal
VRTX,DYDX,dYdX_v4,RBX,VRTX,HYPERLIQUID,GMX,SNX,MCB,DRIFT,GNS,LVL,PERP- Note:
- 🆕
dYdX_v4includesTRADING_VOLUME,TRADING_FEES,TXN_FEESbut not yetUNIQUE_TRADERSwhich is coming soon - Metrics for
dYdXare just for dYdX v3 - *Currently only for dYdX_v4
- 🆕
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| TRADING_VOLUME | Returns the latest day of trading volume | Daily | ✓ |
| UNIQUE_TRADERS | Returns the latest number of unique traders | Daily | ✓ |
| TRADING_FEES | USDC-denominated trading fees paid by traders | Daily | ✓ |
| TXN_FEES | DYDX-denominated gas fees from transactions, and USDC-denominated gas fees from transactions | Daily | ✓ |
🆕 Artemis - Lending
Supported Symbols: all lending exchanges on the Artemis Terminal
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| DEPOSITS | Returns the latest day of deposits | Daily | ✓ |
| BORROWS | Returns the latest amount of outstanding borrows | Daily | ✓ |
🆕 Artemis - DEX
Supported Symbols: UNI, CAKE, SUSHI
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| DEX_VOLUMES | Daily trading volume on the protocol in USD. | Daily | ✓ |
| TVL | The amount of funds locked in the protocol in USD. | Daily | ✓ |
| FEES | Daily trading fees paid by traders in USD. | Daily | ✓ |
| UNIQUE_TRADERS | Daily unique trading address on the protocol. | Daily | ✓ |
🆕 Artemis - Liquid Staking
Supported Symbols: LDO, RPL, FXS
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| STAKED_ETH | The number of ETH staked in the protocol (incl. rewards) | Daily | ✓ |
| AMT_STAKED_USD | The dollar amount of ETH staked in the protocol (incl. rewards) | Daily | ✓ |
| STAKED_ETH_INFLOW | Daily change in the number of ETH staked in the protocol (incl. rewards) | Daily | ✓ |
| AMT_STAKED_USD_INFLOW | Daily change in the dollar amount of ETH staked in the protocol (incl. rewards) | Daily | ✓ |
DefiLlama
Supported Symbols: All chains and protocols on DefiLlama
Fees, Revenue, TVL, and DEX Volumes can be fetched by protocol version in the Sheets Plug-In. For example: =ART("uniswap-v3", "fees") is supported!
For assets that don’t have an Artemis ID like friend.tech from https://defillama.com/fees/friend.tech, you can just grab the string after fees/ or =ART("friend.tech","revenue") to get revenue over the last 24 hours.
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| TVL | Total Value Locked | Daily | ✓ |
| DEX_VOLUMES | Total volume in USD through on-chain decentralized exchanges | Daily | ✓ |
| FEES | Fees paid by protocol users | Daily | ✓ |
| REVENUE | Fees accrued to the protocol | Daily | ✓ |
TokenTerminal
Supported Symbols: all tokens on TokenTerminal
Note: pulling TokenTerminal data requires a valid API key generated from a TokenTerminal Pro account. This can be entered in Extensions -> Artemis Sheets in Google Sheets and the Ribbon / Taskpane in Excel.
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| TT_ACTIVE_LOANS | Average value of outstanding borrows on the protocol | Daily | ✓ |
| TT_USER_DAU | Daily active interacting addresses of project’s revenue-generating smart contracts. Prev: TT_ACTIVE_USERS | Daily | ✓ |
| TT_USER_WAU | Weekly active interacting addresses of project’s revenue-generating smart contracts. | Daily | ✓ |
NFT Data (CoinGecko)
Supported Symbols: all CoinGecko NFT IDs are supported.
To find an NFT collection’s CoinGecko NFT ID:
- Navigate to the collection’s Coingecko page. E.g. https://www.coingecko.com/en/nft/degods
- The CoinGecko NFT ID is the right-most URL paramter. E.g., for https://www.coingecko.com/en/nft/degods, it is
degods.
| Name | Explanation | Period | Supports Date |
|---|---|---|---|
| NFT_FLOOR_PRICE | The lowest price for an NFT collection that someone can buy directly from the market for a given day in ETH | Daily | ✓ |
| NFT_FLOOR_PRICE_USD | The lowest price for an NFT collection that someone can buy directly from the market for a given day in US Dollars | Daily | ✓ |
| NFT_24H_VOLUME | Total volume of NFTs traded over the course of 24hrs in ETH | Daily | ✓ |
| NFT_24H_VOLUME_USD | Total volume of NFTs traded over the course of 24hrs in US Dollars | Daily | ✓ |
| NFT_FLOOR_MC | The lowest price for an NFT collection that someone can buy directly from the market multiplied by supply for a given day in ETH | Daily | ✓ |
| NFT_FLOOR_MC_USD | The lowest price for an NFT collection that someone can buy directly from the market multiplied by supply for a given day in USD | Daily | ✓ |
| NFT_CURRENT_NUM_ITEMS | The number of NFTs in the NFT collection (only available for current date) | Daily | ✓ |
| NFT_CURRENT_NUM_OWNERS | The number of owners of an NFT collection (only available for current date) | Daily | ✓ |