Search
K

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_GMV
Gross merchandise volume (Token Terminal)
Daily
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
FEES
Fees paid by protocol users (DefiLlama)
Daily
REVENUE
Fees accrued to the protocol (DefiLlama)
Daily