🔢 Artemis Sheets
Time Series Aggregation
🔢 Artemis Sheets
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 | ✓ |