Page cover image

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)

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

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

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

USDC-denominated trading fees paid by 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

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

Last updated