> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. > ## Agent Instructions > To query the Token Terminal data catalog, read https://tokenterminal.com/docs/catalog/agents-manual.md first. It is the whole catalog as one page: table naming grammar, key columns, partition and cluster rules, units, additivity, and the tables that are documented but not served yet. > Never query a catalog table on a time bound alone. Also filter its cluster key, which you read from INFORMATION_SCHEMA.COLUMNS; an empty result means the object is a view, whose pruning contract is on its page. Compute is billed to the caller's own Google Cloud project. # Financial statements > A protocol's income statement and treasury, by reporting period. One row per project that reports fees, per period: the income statement and treasury beside the project's balances, volumes and user counts, in `reports_projects.financial_statements_quarterly` and in the `financial_statements_weekly`, `_monthly` and `_yearly` tables, which have the same columns. Flows such as `fees` are summed over the period, balances such as `tvl` are read on the period's last day with a value, and user counts such as `daily_active_users` are the average daily count. ## Coverage One row per project, ticked for every line item it reports.
Project Fees Supply-side fees Revenue Token incentives Expenses Earnings Trading volume Token trading volume Code commits Gas used Transaction count, contracts Treasury Treasury, net Total value locked Price Fully diluted market cap Circulating market cap Circulating supply Maximum token supply Token holders Active addresses, daily Core developers Active users, daily Active users, weekly Active users, monthly
`0x`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`1inch`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`aave`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`abracadabra`✓✗✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`acala`✓✓✓✗✗✗✓✓✓✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`across`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`aerodrome`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`aethir`✓✓✓✓✓✓✗✓✗✓✓✗✗✗✓✓✓✓✗✓✓✗✗✗✗
`airswap`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`ajuna`✓✓✓✗✗✗✓✓✓✗✗✗✗✗✓✓✗✗✗✓✓✓✓✓✓
`alephzero`✓✓✓✗✗✗✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`algorand`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`allbridge`✓✓✓✓✓✓✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`alongside`✓✗✓✓✓✓✗✗✗✓✓✓✗✓✗✗✗✗✗✗✓✗✗✗✗
`angle`✓✗✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✗✗✗
`aperture`✓✓✓✓✓✓✓✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`apeswap`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`apollox`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`aptos`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`aragon`✓✗✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✗✓✓✓✗✗✗
`arbitrum`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`astar`✓✓✓✓✓✓✗✗✓✗✗✗✗✓✗✗✗✗✗✓✓✓✓✓✓
`aurafinance`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`avalanche`✓✓✓✗✗✗✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`aventus`✓✗✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`axelar`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`axie`✓✓✓✗✗✗✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✗✗✗
`axiomtrade`✓✓✓✗✗✗✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`balancer`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`bancor`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`bankr`✓✓✓✗✗✗✓✓✗✓✓✗✗✗✓✓✓✓✗✗✓✗✓✓✓
`base`✓✓✓✓✓✓✗✗✓✗✗✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`beethoven`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`benddao`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`benqi`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`benqilsd`✓✗✗✗✗✗✗✗✗✗✗✗✗✓✗✗✗✗✗✗✗✗✓✓✓
`berachain`✓✓✓✗✗✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`betswirl`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`bifrostio`✓✓✓✓✓✓✓✓✓✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`biswap`✓✓✓✗✗✗✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`bitcoin`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`blast`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`bloomtradingbot`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`bloxroute`✓✓✓✗✗✗✗✗✗✓✓✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`blur`✓✓✓✓✓✓✓✓✗✓✓✓✗✗✓✓✓✓✓✓✓✗✓✓✓
`bmx`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`bobanetwork`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`bonkbot`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`bouncefinance`✓✗✓✗✗✗✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓
`bsc`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`bufferfinance`✓✗✗✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`bullx`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`camelot`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`cap`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`cardano`✓✓✓✓✓✓✗✓✓✗✗✓✗✗✓✓✓✓✓✓✓✓✓✓✓
`celestia`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`celo`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`chainflip`✓✓✓✓✓✓✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`chainlink`✓✗✓✗✗✗✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`circle`✓✓✓✓✓✓✓✗✓✗✗✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`clipper`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`coinshift`✓✓✓✓✓✓✗✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`compound`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`conflux`✓✓✓✗✗✗✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`connext`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`convexfinance`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`cosmos`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`cowswap`✓✓✓✓✗✗✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`cronos`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✗✗
`cryptex`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`curve`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`darwinia`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`debridge`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`defisaver`✓✗✓✓✓✓✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✗✗✗
`deriprotocol`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`dexscreener`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗
`dfx`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`dinari`✓✓✓✗✗✗✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✗✗
`dodo`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`dogecoin`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`dolomite`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`dopex`✓✓✓✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`dreamcash`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`dydx`✓✓✓✓✓✓✗✓✓✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`edgex`✓✓✓✗✗✗✗✓✗✗✗✗✗✗✓✓✓✓✗✓✗✗✗✗✗
`eigenlayer`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`elrond`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✗✗
`energyweb`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`equalizer`✓✓✓✗✗✗✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✗✓✓
`ethena`✓✓✓✗✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`ethereum`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`etherex`✓✓✓✓✓✓✓✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`etherfi`✓✓✓✓✓✓✗✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`euler`✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`falconfinance`✓✓✓✗✓✓✗✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`fantom`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✗✓✗✗✗
`fathom`✓✓✓✗✗✗✓✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`felix`✓✓✓✗✗✗✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`filecoin`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✗✓✗✗✗
`flashbots`✓✗✓✓✗✗✗✗✓✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓✓
`flow`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`flyingtulip`✓✓✓✗✗✗✗✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`fomo`✓✓✓✗✗✗✓✗✗✓✓✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`foundation`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`frax`✓✓✓✗✗✗✗✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`fraxtal`✓✓✓✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`friendtech`✓✓✓✓✓✓✓✓✗✓✓✓✗✓✓✓✓✓✗✓✓✗✓✓✓
`gammastrategies`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`gearbox`✓✓✓✗✗✗✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`gmgn`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`gmx`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`gnosis`✓✓✓✗✗✗✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`goldfinch`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`gravityalpha`✓✓✓✗✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`grove`✓✓✓✓✓✓✗✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✗✗✗
`hedera`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`hegic`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`heliopay`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`helium`✓✗✓✗✗✗✗✓✓✓✓✗✗✗✓✓✓✓✓✗✓✓✗✗✗
`hmx`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`holdstation`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`honeypop`✓✓✓✗✗✗✓✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`hop`✓✓✓✓✓✓✗✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓
`houdiniswap`✓✗✓✓✓✓✗✓✗✗✗✓✓✗✓✓✓✓✓✓✗✗✗✗✗
`hydradx`✓✓✓✗✗✓✓✓✓✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`hyena`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`hyperbridge`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`hyperlend`✓✓✓✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`hyperliquid`✓✓✓✗✗✗✓✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`idex`✓✓✓✗✗✗✓✓✗✓✓✗✗✗✓✓✓✓✗✓✓✗✗✗✗
`immutable`✓✓✓✗✗✗✓✓✓✗✗✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`indexcoop`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`injective`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`ink`✓✓✓✓✓✓✗✗✓✗✗✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`instadapp`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`integral`✓✓✓✓✓✓✓✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✗✗✗
`internetcomputer`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✗✓✗✗✗
`iotex`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`ipor`✓✓✓✓✓✓✗✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓
`jito`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✗✗✓✓✓✓✓
`jupiter`✓✓✓✗✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✗✓✓✗✗✗
`kapitaldao`✓✓✓✓✗✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✗✗✗
`karura`✓✓✓✗✗✗✗✓✓✗✗✗✗✗✓✓✓✓✓✗✗✓✗✗✗
`katana`✓✓✓✓✓✓✓✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`katananetwork`✓✓✓✓✓✓✗✓✓✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`kelpdao`✓✓✓✗✗✗✗✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`kilt`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`kleros`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✗✗✗
`kusama`✓✓✓✓✓✗✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`kwenta`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`kyber`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`layer3`✓✗✓✗✓✓✗✓✗✓✓✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`layerzero`✓✓✓✗✓✓✗✓✗✓✓✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`lens`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`levelfinance`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`lido`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`lighter`✓✓✓✗✗✗✗✓✗✗✗✗✗✓✓✓✓✓✗✓✗✗✗✗✗
`linea`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`liquity`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`litecoin`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`litentry`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`livepeer`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✗✗✗
`looksrare`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`maestro`✓✓✓✗✗✗✗✗✗✓✓✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`maiar`✓✓✓✗✗✗✓✓✗✗✗✗✗✗✓✓✓✓✗✗✗✗✗✗✗
`makerdao`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`manifoldxyz`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✗✗✗
`manta`✓✓✓✓✗✗✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`mantra`✓✓✓✓✓✓✓✓✓✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`maple`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`marinade`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✗✗✓✓✓✓✓
`maverick`✓✓✓✗✗✗✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`meanfinance`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✗✗✗
`megaeth`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`merkletrade`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓
`metavault`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`meteora`✓✓✓✗✗✗✓✓✗✓✓✗✗✓✓✓✓✓✗✗✓✗✓✓✓
`mina`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`monad`✓✓✓✗✗✗✗✓✗✗✗✗✗✗✓✓✓✓✗✗✓✗✓✓✓
`moonbeam`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`moonshot`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗
`moonwell`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`morpho`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`movement`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`mummy`✓✓✓✓✓✓✗✗✓✓✓✗✗✓✗✗✗✗✓✗✓✓✓✓✓
`mux`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`mythos`✓✓✓✓✓✓✓✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`native`✓✓✓✗✗✗✓✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`near`✓✓✓✓✓✓✓✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`neuroweb`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✗✗✗✓✓✗✓✓✓
`nexusmutual`✓✓✓✗✗✗✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`nftx`✓✓✓✓✓✓✓✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`notional`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`o1exchange`✓✓✓✗✗✗✓✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`okutrade`✓✓✓✗✗✗✓✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`okx`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`openchat`✓✓✓✗✗✗✗✓✓✗✗✓✗✗✓✗✓✓✓✗✗✓✓✓✓
`opensea`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`optimism`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`opyn`✓✗✓✓✓✓✗✗✓✓✓✗✗✓✗✗✗✗✗✓✓✓✓✓✓
`orca`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✗✓✓✓✓✓
`origin`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`osmosis`✓✓✓✗✗✗✓✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✗✗
`pancakeswap`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`pangolin`✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`paragonperps`✓✓✓✗✗✗✗✗✓✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓✓
`peaq`✓✓✓✓✓✓✗✓✓✗✗✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`pendle`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`pendulum`✓✓✓✗✗✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`perpetualprotocol`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`phala`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`phantom`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`pharaoh`✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✗✓✓✗✓✓✓
`photon`✓✓✓✗✗✗✓✗✗✓✓✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`pikaprotocol`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`plasma`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`pocketnetwork`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✗✓✗✗✗
`polkadot`✓✓✓✓✓✓✗✓✓✗✗✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`polygon`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`polymarket`✓✓✓✓✓✓✓✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`polynomial`✓✓✓✓✓✓✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`pooltogether`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`premia`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`primenumbers`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`pumpfun`✓✓✓✗✗✗✓✓✗✓✓✗✗✗✓✓✓✓✗✗✓✗✓✓✓
`quickswap`✓✓✓✗✗✗✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`radiant`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`ramses`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`rarible`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`raybot`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗
`raydium`✓✓✓✗✗✗✓✓✓✓✓✗✗✓✓✓✓✓✗✗✓✓✓✓✓
`reflexer`✓✗✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✗✗✗
`ren`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`reserve`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`ribbon`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`ringsprotocol`✓✓✓✓✓✓✗✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`ripple`✓✓✓✓✓✓✓✓✓✗✗✗✗✓✓✓✓✓✓✗✓✓✓✓✓
`robinhood`✓✓✓✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`robonomics`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`ronin`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✓✓✓✓✓
`rootstock`✓✓✓✓✓✓✗✗✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓✓✓
`scroll`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`seamlessprotocol`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓
`seinetwork`✓✓✓✗✗✗✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`shadowexchange`✓✓✓✓✓✓✓✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`shoebill`✓✓✓✓✓✓✗✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`silo`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`solana`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`solidlizard`✓✓✓✓✓✓✓✓✗✓✓✗✗✓✓✓✗✗✗✓✓✗✓✓✓
`soltradingbot`✓✓✓✗✗✗✗✓✗✗✗✗✗✗✓✓✗✗✗✗✗✗✓✓✓
`solv`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`sonic`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`sound`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`spark`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`spookyswap`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✗✓✓
`stacks`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`stader`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`stakewise`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`starknet`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`steakhousefinancial`✓✓✓✓✓✓✗✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`stellar`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`sudoswap`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`sui`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`superstate`✓✓✓✗✗✗✗✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✗✗✗
`sushiswap`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`swarm`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`sx`✓✗✓✓✓✓✓✗✓✗✗✗✗✗✗✗✗✗✓✓✗✓✓✗✗
`synapse`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`syncswap`✓✓✓✓✓✓✓✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`synfutures`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`synthetix`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`tempo`✓✓✓✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`terra`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✗✓✗✗✗
`tether`✓✗✓✗✗✗✗✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✗✗✗
`tezos`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✗✓✗✗✗
`thales`✓✓✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`thegraph`✓✗✓✓✓✓✗✓✓✓✓✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`thena`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`thetanuts`✓✓✓✓✓✓✗✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`thruster`✓✓✓✓✓✓✓✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✓✓✓
`tokemak`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✗✗✗
`tokenlon`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`ton`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`tornadocash`✓✗✓✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`toucan`✓✓✓✓✓✓✗✗✓✓✓✗✗✓✗✗✗✗✗✗✓✓✓✓✓
`traderjoe`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`tradexyz`✓✓✓✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓
`trojan`✓✓✓✗✗✗✗✗✗✓✓✗✗✗✗✗✗✗✗✗✓✗✓✓✓
`tron`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`truefi`✓✓✓✓✓✓✗✓✓✓✓✓✓✗✓✓✓✓✗✓✓✓✓✓✓
`unipilot`✓✓✓✓✓✓✗✗✓✓✓✗✗✗✗✗✗✗✗✓✓✓✓✓✓
`uniquenetwork`✓✓✓✗✗✗✓✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`uniswap`✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`uniswaplabs`✓✓✓✓✓✓✓✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`usual`✓✗✓✗✗✗✗✓✗✓✓✗✗✓✓✓✓✓✗✓✓✗✗✗✗
`variational`✓✓✓✗✗✗✗✗✓✓✓✓✓✓✗✗✗✗✗✗✓✓✓✓✓
`velodrome`✓✓✓✓✓✓✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`ventuals`✓✓✓✗✗✗✗✗✓✗✗✗✗✗✗✗✗✗✗✗✗✓✓✓✓
`venus`✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓✓
`versedex`✓✓✓✓✓✓✓✓✗✓✓✗✗✓✓✓✓✓✓✓✓✗✓✓✓
`vertex`✓✓✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`vesta`✓✗✓✓✓✓✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`viction`✓✓✓✗✗✗✗✓✗✗✗✗✗✗✓✓✓✓✓✗✓✗✓✓✓
`virtualsprotocol`✓✓✓✗✗✗✗✓✗✓✓✗✗✗✓✓✓✓✗✗✓✗✗✗✗
`volmex`✓✓✓✓✓✓✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`voltz`✓✓✓✓✓✓✗✗✓✓✓✗✗✗✗✗✗✗✗✗✓✓✓✓✓
`wombat`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`worldmobilechain`✓✓✓✓✓✓✗✓✗✗✗✗✗✗✓✓✓✓✗✓✓✗✓✓✓
`x2y2`✓✓✓✓✓✓✓✓✓✓✓✓✓✗✓✓✓✓✓✓✓✓✓✓✓
`xai`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✓✓✓✓✓✓
`xdc`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓
`xoxno`✓✓✓✓✓✓✓✓✓✗✗✗✗✗✓✓✓✓✗✗✗✓✓✗✗
`xswap`✓✓✓✗✗✗✓✓✓✓✓✗✗✓✓✓✓✓✗✓✓✓✓✓✓
`zcash`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✓✗✗✓✗✗✗
`zerion`✓✗✓✓✓✓✓✗✓✓✓✓✗✗✗✗✗✗✗✗✓✓✓✓✓
`zerolend`✓✓✓✗✗✗✗✓✓✓✓✗✗✓✓✓✓✓✓✓✓✓✓✓✓
`zksyncera`✓✓✓✓✓✓✗✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`zksyncerabridge`✓✗✓✗✗✗✗✗✗✓✓✗✗✓✗✗✗✗✗✗✓✗✓✓✓
`zora`✓✓✓✓✓✓✓✓✓✗✗✗✗✗✓✓✓✓✗✓✓✓✓✓✓
`zyberswap`✓✓✓✓✓✓✓✓✗✓✓✗✗✓✓✓✓✓✓✓✓✗✓✓✓
## Columns
Column Type Description
`project_id` STRING Project the statement belongs to, such as `aave`; joins `dimensions.projects`.
`period_start` TIMESTAMP First moment of the period.
`period_end` TIMESTAMP Last moment of the period.
`period_is_complete` BOOL False while the period is still running. Filter on it to compare finished periods, or leave it in to watch the current one forming.
`fees` FLOAT64 What users paid to use the protocol over the period, USD. A flow, so the periods inside a longer one add up to it.
`fees_supply_side` BIGNUMERIC The share of fees passed on to suppliers, USD.
`revenue` FLOAT64 Fees the protocol kept, USD. Measured directly, so for some projects it differs from `fees` minus `fees_supply_side`, sometimes materially.
`token_incentives` BIGNUMERIC Value of tokens paid out to attract usage, USD. Empty for a project that reports no incentives, which is a different thing from zero.
`expenses` BIGNUMERIC What the protocol spent over the period, USD. Empty for a project that reports no expenses, which is a different thing from zero.
`earnings` BIGNUMERIC What the protocol kept after costs, USD. Measured directly, so it can differ from `revenue` minus `expenses`, and it is negative where a protocol pays out more than it keeps.
`cost_of_revenue` BIGNUMERIC Direct supply-side cost of revenue. Summed over the period.
`operating_expenses` BIGNUMERIC Onchain operating expenses, excluding token incentives. Summed over the period.
`gross_profit` BIGNUMERIC Revenue minus cost of revenue. Summed over the period.
`trading_volume` BIGNUMERIC Cash value of the trades that took place, in USD. Summed over the period.
`transaction_volume` BIGNUMERIC USD value of transactions processed by the project. Summed over the period.
`transfer_volume` FLOAT64 USD value of assets moved through the project's bridge transfers, counted once per transfer. Summed over the period.
`token_trading_volume` FLOAT64 Trading volume of the project's own token. Summed over the period.
`code_commit_count` BIGNUMERIC Commits to public repositories. Summed over the period.
`gas_used` FLOAT64 Gas consumed by transactions calling the project's contracts. Summed over the period.
`transaction_count_contracts` BIGNUMERIC Transactions calling the project's contracts. Summed over the period.
`treasury` BIGNUMERIC Value the protocol held at the close of the period, USD. A balance read at the period end, so four quarterly figures added together mean nothing.
`treasury_net` BIGNUMERIC Value the protocol held at the close of the period in assets other than its own token, USD. Read at the period end, like `treasury`.
`tvl` BIGNUMERIC Value locked in the project's contracts at day end, in USD. Read at the close of the period.
`bridge_deposits` BIGNUMERIC USD value of assets held in the project's bridge contracts on the main chain. Read at the close of the period.
`active_loans` BIGNUMERIC Value of loans outstanding at day end, in USD. Read at the close of the period.
`assets_staked` BIGNUMERIC Value staked at day end, in USD. Read at the close of the period.
`capital_deployed` BIGNUMERIC USD value of user deposits an asset manager has allocated into investments. Read at the close of the period.
`outstanding_supply` FLOAT64 Stablecoin supply issued by the project and outstanding, in USD. Stablecoin issuers only. Read at the close of the period.
`price` FLOAT64 Project token price in USD. Read at the close of the period.
`market_cap_fully_diluted` FLOAT64 Market cap on maximum supply. Read at the close of the period.
`market_cap_circulating` FLOAT64 Market cap on circulating supply. Read at the close of the period.
`token_supply_circulating` BIGNUMERIC Circulating token supply. Read at the close of the period.
`token_supply_maximum` BIGNUMERIC Maximum token supply. Read at the close of the period.
`token_holders` BIGNUMERIC Addresses holding the project's token. Averaged over the days of the period.
`daily_active_addresses` BIGNUMERIC Distinct addresses transacting with the project's contracts per day. Averaged over the days of the period.
`monthly_active_developers` BIGNUMERIC Number of active developers. Averaged over the days of the period.
`daily_active_users` BIGNUMERIC Distinct addresses that used the project that day. A HyperLogLog estimate. Averaged over the days of the period.
`weekly_active_users` BIGNUMERIC Distinct addresses that used the project in the trailing 7 days. A HyperLogLog estimate. Averaged over the days of the period.
`monthly_active_users` BIGNUMERIC Distinct addresses that used the project in the trailing 30 days. A HyperLogLog estimate. Averaged over the days of the period.
## Sample queries **One statement** The columns come back in statement order, `fees` down to `earnings`, then the treasury. `period_is_complete` leaves out the quarter still running. ```sql theme={null} select period_start, period_end, fees, fees_supply_side, revenue, expenses, token_incentives, earnings, treasury_net from `reports_projects.financial_statements_quarterly` where project_id = 'aave' and period_is_complete order by period_start desc ``` **Most profitable protocols** The subquery pins the latest finished quarter, so the ranking reads one period. `earnings` is filled in where a project reports expenses, and the null filter keeps those rows. ```sql theme={null} select projects.name, statements.revenue, statements.earnings from `reports_projects.financial_statements_quarterly` as statements join `dimensions.projects` as projects using (project_id) where statements.period_is_complete and statements.period_start = ( select max(period_start) from `reports_projects.financial_statements_quarterly` where period_is_complete ) and statements.earnings is not null order by statements.earnings desc limit 25 ``` **Quarter over quarter** Every period a project reported is a row, so a comparison is a window function. `lag()` over `period_start` gives the prior period. ```sql theme={null} select period_start, revenue, lag(revenue) over (order by period_start) as revenue_prior, safe_divide( revenue - lag(revenue) over (order by period_start), abs(lag(revenue) over (order by period_start)) ) as revenue_change from `reports_projects.financial_statements_quarterly` where project_id = 'uniswap' and period_is_complete order by period_start desc ``` **Growing on the year** Four quarters back is the same quarter a year earlier, so `lag(revenue, 4)` partitioned by project gives the year-ago figure. The revenue floor keeps a small base from dominating the ranking. ```sql theme={null} with quarters as ( select project_id, period_start, revenue, lag(revenue, 4) over ( partition by project_id order by period_start ) as revenue_year_ago from `reports_projects.financial_statements_quarterly` where period_is_complete ) select projects.name, quarters.revenue, safe_divide(quarters.revenue - quarters.revenue_year_ago, abs(quarters.revenue_year_ago)) as revenue_yoy from quarters join `dimensions.projects` as projects using (project_id) where quarters.period_start = (select max(period_start) from quarters) and quarters.revenue > 1000000 and quarters.revenue_year_ago is not null order by revenue_yoy desc limit 25 ``` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.