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

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 ($)	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 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

• 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 ecosystemFAQ	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 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

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_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

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
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:

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.

Name	Explanation	Period	Supports Dates
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