Supported Metrics
Here's a list of all the metrics we support for Artemis Sheet
🆕 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:
USDC
USDT
DAI
BUSD
etc
Note: All historical market data is fetched as of 12PM UTC
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 ($)
5min
ATL_CHG_PCT
All time low change from today (%)
5min
ATL_DATE
All time low date
5min
🆕 Equity Data
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:
for SPDR S&P 500 ETF Trust (SPY)
GBTC
for Grayscale Bitcoin TrustCOIN
for Coinbase
Append "EQ-" in front of the stock symbol name.
Example: For Coinbase you'd want to have
"EQ-COIN"
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")
Notes
Equities prices forward fill from last close on holidays / weekends.
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
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
Weekly (new data on Tuesday)
WEEKLY_COMMITS_SUB
Number of weekly commits to sub-ecosystem repositories for a given ecosystemFAQ
Weekly (new data on Tuesday)
WEEKLY_DEVS_CORE
Number of weekly developers for a given core ecosystem
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
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_v4
includesTRADING_VOLUME
,TRADING_FEES
,TXN_FEES
but not yetUNIQUE_TRADERS
which is coming soonMetrics for
dYdX
are just for dYdX v3*Currently only for dYdX_v4
TRADING_VOLUME
Returns the latest day of trading volume
Daily
UNIQUE_TRADERS
Returns the latest number of unique traders
Daily
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
DEPOSITS
Returns the latest day of deposits
Daily
BORROWS
Returns the latest amount of outstanding borrows
Daily
🆕 Artemis - DEX
Supported Symbols: UNI
, CAKE
, SUSHI
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
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.
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.
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
TT_USER_MAU
Monthly active interacting addresses of project's revenue-generating smart contracts.
Daily
TT_ACTIVE_DEVELOPERS
Daily active developers to repositories in the Github organization
Daily
TT_BUSINESS_TYPE
Business type
Daily
TT_CODE_COMMITS
Number of commits to core repositories
Daily
TT_NET_DEPOSITS
Total assets supplied to the project's revenue-generating smart contracts
Daily
TT_MARKET_CAP_CIRCULATING
Circulating market cap
Daily
TT_MARKET_CAP_FULLY_DILUTED
Fully diluted market cap
Daily
TT_OUTSTANDING_SUPPLY
Outstanding Stablecoin Supply
Daily
TT_TOKEN_TRADING_VOLUME
Trading volume of token
Daily
TT_TRADING_VOLUME
Trading volume for exchange
Daily
TT_TRANSFER_VOLUME
Transfer volume
Daily
TT_TOKENHOLDERS
Number of addresses with token balance greater than 0
Daily
TT_TREASURY
USD value of the protocol’s funds held on-chain (including unallocated governance tokens)
Daily
TT_TVL
Average value of of funds locked into the protocol's smart contracts
Daily
TT_FEES
Total fees paid to the protocol
Daily
TT_FEES_SUPPLY_SIDE
Fees paid to the LPs
Daily
TT_REVENUE
Fees paid which direclty benefit tokenholders
Daily
TT_OPERATING_EXPENSES
Non-token costs for the protocol (for example, L1 sequencer fees for L2s)
Daily
TT_TOKEN_INCENTIVES
USD value of the protocol’s governance tokens that have been distributed to users
Daily
TT_EXPENSES
Operating Expenses + Token Incentives
Daily
TT_EARNINGS
Revenue - Expenses
Daily
TT_PF_CIRCULATING
Circulating P/F ratio
Daily
TT_PF_FULLY_DILUTED
Fully-diluted P/F ratio
Daily
TT_PS_CIRCULATING
Circulating P/S ratio
Daily
TT_PS_FULLY_DILUTED
Fully-diluted P/S ratio
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
.
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
Last updated