💡 Info
🆕 For a list of all the metrics we provide, please use =ARTINFO("ALL","METRICS")

​
Market Data (CoinGecko)

💡 Info
For total crypto marketcap, please use =ART(“TOTAL”, MC”)
Note: All historical market data is fetched as of 12PM UTC
NameExplanationPeriodSupports Date
PRICEToken price5min✓
MCMarket Capitalization5min✓
24H_VOLUME24 hour volume5min✓
FDMCFully diluted market capitalization5min✓
CIRC_SUPPLYCirculating supply5min
TOT_SUPPLYTotal supply5min
MAX_SUPPLYMax supply5min
30D_VOLUME30 day volume5min
24H_PRICE_HIGH24 hour price high ($)5min
24H_PRICE_LOW24 hour price low ($)5min
24H_PRICE_CHG24 hour price change ($)5min
24H_PRICE_CHG_PCT24 hour price change (%)5min
7D_PRICE_CHG_PCT7 day price change (%)5min
30D_PRICE_CHG_PCT30 day price change (%)5min
24H_MC_CHG24 hour market cap change ($)5min
24H_MC_CHG_PCT24 hour market cap change (%)5min
ATHAll time high ($)5min
ATH_CHG_PCTAll time high change from today (%)5min
ATH_DATEAll time high date5min
ATLAll 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 for SPDR S&P 500 ETF Trust (SPY)
      • GBTC for Grayscale Bitcoin Trust
      • COIN 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
NameExplanationPeriodSupports Date
PRICEStock price5min✓

​
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
NameExplanationUpdate FrequencySupports Date
DAUDaily Active Addresses - the number of unique wallet addresses sending an on-chain transaction in a rolling 24 hour periodDaily✓
DAU_OVER_100Daily 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_TXNSDaily Transactions - the total number of transactions registered on-chain in a rolling 24 hour periodDaily✓
FEESFees paid by protocol usersDaily✓
STABLECOIN_MC$ of Stablecoin custodied on a chainDaily✓
AVG_TXN_FEEAverage transaction fee paid by usersDaily✓
REVENUEFees accrued to the protocolDaily✓
TWITTER_FOLLOWERSTotal followers on the official Twitter accountDaily✓
WEEKLY_COMMITS_CORENumber of weekly commits to core repositories for a given ecosystem FAQWeekly (new data on Tuesday)✓
WEEKLY_COMMITS_SUBNumber of weekly commits to sub-ecosystem repositories for a given ecosystem FAQWeekly (new data on Tuesday)✓
WEEKLY_DEVS_CORENumber of weekly developers for a given core ecosystem FAQWeekly (new data on Tuesday)✓
WEEKLY_DEVS_SUBNumber of weekly developers for given sub ecosystems FAQWeekly (new data on Tuesday)✓
WEEKLY_CONTRACTS_DEPLOYEDNumber of unique contracts deployed to the chainWeekly✓
WEEKLY_UNIQUE_CONTRACT_DEPLOYERSNumber of unique wallets deploying to the chainWeekly✓

​
🆕 Artemis - Application Activity

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 chains
  • ART("AAVE-ETH","DAILY_TXNS") returns Aave daily transactions on Ethereum
  • ART("AAVE-MATIC","GAS_USD") returns Aave daily gas usage in USD on Polygon
  • ART("DeFi-ETH", "DAU") returns DeFi daily active addresses on Ethereum
  • ART("Layer_2-ETH","GAS_USD") returns daily Layer 2 Gas usage in USD on Ethereum
NameExplanationPeriodSupports Date
DAUDaily active addresses by a given application for specified chainsDaily✓
DAILY_TXNSDaily transactions by a given application for specified chainsDaily✓
GAS_USDAmount of gas spent by a given application for specified chainsDaily✓

​
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 includes TRADING_VOLUME , TRADING_FEES , TXN_FEES but not yet UNIQUE_TRADERS which is coming soon
    • Metrics for dYdX are just for dYdX v3
    • *Currently only for dYdX_v4
NameExplanationPeriodSupports Date
PERP_VOLUMEThe total trading volume on a perpetuals exchangeDaily✓
UNIQUE_TRADERSReturns the latest number of unique tradersDaily✓
TRADING_FEESUSDC-denominated trading fees paid by tradersDaily✓
TXN_FEESDYDX-denominated gas fees from transactions, and USDC-denominated gas fees from transactionsDaily✓

​
🆕 Artemis - Lending

Supported Symbols: all lending exchanges on the Artemis Terminal
NameExplanationPeriodSupports Date
DEPOSITSReturns the latest day of depositsDaily✓
BORROWSReturns the latest amount of outstanding borrowsDaily✓

​
🆕 Artemis - DEX

Supported Symbols: UNI, CAKE, SUSHI
NameExplanationPeriodSupports Date
DEX_VOLUMESDaily trading volume on the protocol in USD.Daily✓
TVLThe amount of funds locked in the protocol in USD.Daily✓
FEESDaily trading fees paid by traders in USD.Daily✓
UNIQUE_TRADERSDaily unique trading address on the protocol.Daily✓

​
🆕 Artemis - Liquid Staking

Supported Symbols: LDO, RPL, FXS
NameExplanationPeriodSupports Date
STAKED_ETHThe number of ETH staked in the protocol (incl. rewards)Daily✓
AMT_STAKED_USDThe dollar amount of ETH staked in the protocol (incl. rewards)Daily✓
STAKED_ETH_INFLOWDaily change in the number of ETH staked in the protocol (incl. rewards)Daily✓
AMT_STAKED_USD_INFLOWDaily 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, you can just grab the string after fees/ or =ART("friend.tech","revenue") to get revenue over the last 24 hours.
NameExplanationPeriodSupports Date
TVLTotal Value LockedDaily✓
DEX_VOLUMESTotal volume in USD through on-chain decentralized exchangesDaily✓
FEESFees paid by protocol usersDaily✓
REVENUEFees accrued to the protocolDaily✓

​
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.
NameExplanationPeriodSupports Date
TT_ACTIVE_LOANSAverage value of outstanding borrows on the protocolDaily✓
TT_USER_DAUDaily active interacting addresses of project’s revenue-generating smart contracts. Prev: TT_ACTIVE_USERSDaily✓
TT_USER_WAUWeekly 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:
  1. Navigate to the collection’s Coingecko page. E.g. https://www.coingecko.com/en/nft/degods
  2. The CoinGecko NFT ID is the right-most URL paramter. E.g., for https://www.coingecko.com/en/nft/degods, it is degods.
NameExplanationPeriodSupports Date
NFT_FLOOR_PRICEThe lowest price for an NFT collection that someone can buy directly from the market for a given day in ETHDaily✓
NFT_FLOOR_PRICE_USDThe lowest price for an NFT collection that someone can buy directly from the market for a given day in US DollarsDaily✓
NFT_24H_VOLUMETotal volume of NFTs traded over the course of 24hrs in ETHDaily✓
NFT_24H_VOLUME_USDTotal volume of NFTs traded over the course of 24hrs in US DollarsDaily✓
NFT_FLOOR_MCThe lowest price for an NFT collection that someone can buy directly from the market multiplied by supply for a given day in ETHDaily✓
NFT_FLOOR_MC_USDThe lowest price for an NFT collection that someone can buy directly from the market multiplied by supply for a given day in USDDaily✓
NFT_CURRENT_NUM_ITEMSThe number of NFTs in the NFT collection (only available for current date)Daily✓
NFT_CURRENT_NUM_OWNERSThe number of owners of an NFT collection (only available for current date)Daily✓