Page cover image

Time Series Aggregation

Time-series Aggregation

Artemis Sheets allows you to pull in time-series metrics into a single cell. Using one of these functions would sum the requested metric across a given time period and return a value in a single cell.

Supported time frames:

  • L7 - last 7 days

  • L30 - last 30 days

  • L90 - last 90 days

  • CM - current month (returns full calendar month for as-of-date)

  • CQ - current quarter (returns full calendar quarter for as-of-date)

  • LTM - last twelve months

  • YTD - year to date

Sample Syntax

  • Sample syntax #1: "=ART("ETH","L7_REVENUE")

    • The above formula would pull the sum of the past 7 days Revenue from DefiLlama.

  • Sample syntax #2: "=ART("ETH","LTM_TT_REVENUE")

    • The above formula would pull the sum of the past twelve-months Revenue from Token Terminal.

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
Update Frequency
Supports Date

TT_FEES

Total fees paid to the protocol (Token Terminal)

Daily

TT_FEES_SUPPLY_SIDE

Fees paid to the LPs (Token Terminal)

Daily

TT_REVENUE

Fees paid which benefit tokenholders (Token Terminal)

Daily

TT_TOKEN_INCENTIVES

USD value of the protocol’s governance tokens that have been distributed to users (Token Terminal)

Daily

TT_TRADING_VOLUME

Trading volume for exchange (Token Terminal)

Daily

TT_TRANSFER_VOLUME

Transfer volume (Token Terminal)

Daily

TT_USER_DAU

Daily active interacting addresses of project's revenue-generating smart contracts (Token Terminal)

Daily

TT_OPERATING_EXPENSES

Non-token costs for the protocol (for example, L1 sequencer fees for L2s) (Token Terminal)

Daily

TT_EXPENSES

Operating Expenses + Token Incentives (Token Terminal)

Daily

TT_EARNINGS

Revenue - Expenses (Token Terminal)

Daily

FEES

Fees paid by protocol users

Daily

REVENUE

Fees accrued to the protocol

Daily

DEX_VOLUMES

Total volume in USD through on-chain decentralized exchanges (DefiLlama)

Daily

NFT_FLOOR_PRICE

The lowest price for an NFT collection that someone can buy directly from the market for a given day in ETH (NFT Data)

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 (NFT Data)

Daily

NFT_24H_VOLUME

Total volume of NFTs traded over the course of 24hrs in ETH (NFT Data)

Daily

NFT_24H_VOLUME_USD

Total volume of NFTs traded over the course of 24hrs in US Dollars (NFT Data)

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 (NFT Data)

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 (NFT Data)

Daily

Last updated