> ## 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. # Screener > Every project's latest figures, with averages, totals and changes over six windows, in one row. One row per project in `screeners.projects`, every figure as of `as_of`, the last complete day. Each measure has a column per window and aggregation, named `__`: `fees_30d_sum` is the fees of the 30 days ending on `as_of`, and `tvl_7d_change` is TVL on `as_of` against TVL seven days earlier. ## Columns The two key columns, then one FLOAT64 column per measure, window and aggregation. Every row is a project in `dimensions.projects`, so the join on `project_id` always matches.
Column Type Description
as\_ofTIMESTAMPThe last complete day, the same on every row. Every window ends on it.
project\_idSTRINGProject the row belongs to, such as aave; joins dimensions.projects.
A window is `1d`, `7d`, `30d`, `90d`, `180d` or `365d`, and spans that many days ending on `as_of`, while the `max_` columns read the whole history. Which aggregations a measure has follows its `over_time` in [Metric definitions](/docs/catalog/metric-definitions): only a measure whose `over_time` is `sum` has `sum`.
Column What it holds
\\_\\_avgMean of the daily values over the window.
\\_\\_sumTotal of the daily values over the window. Flows only: the measures ticked under Sum.
\\_\\_changeA comparison of two aggregations: the value on as\_of against the value one window earlier, as (now - then) / abs(then). Null when either value is missing or the earlier one is 0.
\\_\\_trendA comparison of two aggregations: the window's average against the average of the window before it, as (avg - prior) / abs(prior). Null unless the window before has a value on every one of its days, and null when its average is 0.
\\_max\_latestThe value on as\_of. Null when there is none.
\\_max\_athThe highest daily value over the project's whole history.
\\_max\_atlThe lowest daily value over the project's whole history.
Every measure has the `avg`, `change`, `trend` and `max_` columns, and the flows also have `sum`. A distinct count such as `daily_active_users` or `token_holders` takes `avg`, never `sum`.
Measure Sum What it holds
daily\_active\_addresses✗Distinct addresses transacting with the project's contracts per day.
monthly\_active\_addresses✗Distinct addresses transacting with the project's contracts over a rolling 30 days.
weekly\_active\_addresses✗Distinct addresses transacting with the project's contracts over a rolling 7 days.
monthly\_active\_developers✗Number of active developers.
active\_loans✗Value of loans outstanding at day end, in USD.
fees\_per\_daily\_active\_user✗Average fees per user.
revenue\_per\_daily\_active\_user✗Average revenue per user.
assets\_staked✗Value staked at day end, in USD.
bridge\_deposits✗USD value of assets held in the project's bridge contracts on the main chain.
bridged\_supply✗USD value of the project's stablecoins held outside the chain they were issued on.
buybacks✓USD value of the project's own tokens repurchased from the market.
capital\_deployed✗USD value of user deposits an asset manager has allocated into investments.
code\_commit\_count✓Commits to public repositories.
cost\_of\_revenue✓Direct supply-side cost of revenue.
earnings✓What the project kept after costs, in USD. Goes negative when a project pays out more than it retains.
notional\_trading\_volume\_exchange✓Notional value of perpetual futures traded, attributed to the project whose matching engine settled the trade.
expenses✓What the project spent, in USD: cost of revenue, token incentives and operating expenses, wherever each is reported onchain.
fees✓Total fees users paid, in USD. Chain gas plus app trading fees.
fees\_supply\_side✓The part of those fees the project passed on to the supply side, in USD.
flash\_loan\_volume✓Total flash loan volume.
gas\_used✓Gas consumed by transactions calling the project's contracts.
gross\_profit✓Revenue minus cost of revenue.
notional\_trading\_volume\_interface✓Notional value of perpetual futures traded, attributed to the project whose interface the trade was placed through.
liquidation\_volume✓USD value of debt covered in liquidations.
liquidity\_turnover✗Trading volume relative to liquidity.
market\_cap\_circulating✗Market cap on circulating supply.
market\_cap\_fully\_diluted✗Market cap on maximum supply.
open\_interest✗USD notional value of all open positions on the project's derivatives markets.
operating\_expenses✓Onchain operating expenses, excluding token incentives.
outstanding\_supply✗Stablecoin supply issued by the project and outstanding today, in USD. Stablecoin issuers only.
price\_to\_fees\_circulating✗Circulating market cap over annualized fees (trailing 30d run-rate).
price\_to\_fees\_fully\_diluted✗Fully diluted market cap over annualized fees (trailing 30d run-rate).
price✗Project token price in USD.
price\_to\_revenue\_circulating✗Circulating market cap over annualized revenue (trailing 30d run-rate).
price\_to\_revenue\_fully\_diluted✗Fully diluted market cap over annualized revenue (trailing 30d run-rate).
revenue✓Fees the project kept, in USD.
staking\_market\_cap✗USD value of the native token staked to secure the chains the project operates, summed across them.
take\_rate✗Share of fees the project retains as revenue.
token\_incentives✓Value of the project's own token paid out as rewards, in USD.
token\_supply\_circulating✗Circulating token supply.
token\_supply\_maximum✗Maximum token supply.
token\_trading\_volume✓Trading volume of the project's own token.
token\_turnover\_circulating✗Token trading volume over circulating market cap.
token\_turnover\_fully\_diluted✗Token trading volume over fully diluted market cap.
token\_holders✗Addresses holding the project's token.
trade\_count✓Number of trades executed.
tradeable\_asset\_count✗Number of tokens tradeable on the exchange.
tradeable\_pair\_count✗Number of token pairs available for trading on the exchange.
trading\_volume✓Cash value of the trades that took place, in USD.
trade\_size\_average✗Average trading volume per trade.
trading\_volume\_per\_daily\_active\_user✗Average trading volume per user.
transaction\_count\_contracts✓Transactions calling the project's contracts.
transaction\_volume✓USD value of transactions processed by the project.
transfer\_volume✓USD value of assets moved through the project's bridge transfers, counted once per transfer.
treasury✗Value the project held at day end, in USD, its own token included.
treasury\_net✗Value the project held at day end excluding its own token, in USD.
tvl✗Value locked in the project's contracts at day end, in USD.
daily\_active\_users✗Distinct addresses that used the project that day. A HyperLogLog estimate, not a sum of the daily series.
monthly\_active\_users✗Distinct addresses that used the project in the trailing 30 days. A HyperLogLog estimate.
weekly\_active\_users✗Distinct addresses that used the project in the trailing 7 days. A HyperLogLog estimate.
## Sample queries Every column of one row shares the same `as_of`, so the figures read together. ```sql theme={null} select as_of, tvl_max_latest, tvl_7d_change, fees_30d_sum, fees_30d_trend from `screeners.projects` where project_id = 'aave' ``` `fees_30d_sum` is the total of the 30 days ending on `as_of`. The join to `dimensions.projects` on `project_id` adds the name. ```sql theme={null} select projects.name, screener.fees_30d_sum, screener.revenue_30d_sum, screener.fees_30d_trend from `screeners.projects` as screener join `dimensions.projects` as projects using (project_id) where screener.fees_30d_sum is not null order by screener.fees_30d_sum desc limit 25 ``` `tvl_7d_change` compares TVL on `as_of` with TVL seven days earlier, as a fraction. The TVL floor keeps a small base from dominating the ranking. ```sql theme={null} select projects.name, screener.tvl_max_latest, screener.tvl_7d_change from `screeners.projects` as screener join `dimensions.projects` as projects using (project_id) where screener.tvl_max_latest > 10000000 and screener.tvl_7d_change is not null order by abs(screener.tvl_7d_change) desc limit 25 ``` `revenue_365d_sum` is the revenue of the 365 days ending on `as_of`, and `market_cap_circulating_max_latest` the latest circulating market cap. Their ratio is a price-to-sales multiple. ```sql theme={null} select projects.name, screener.market_cap_circulating_max_latest, screener.revenue_365d_sum, safe_divide( screener.market_cap_circulating_max_latest, screener.revenue_365d_sum ) as price_to_sales from `screeners.projects` as screener join `dimensions.projects` as projects using (project_id) where screener.revenue_365d_sum > 1000000 and screener.market_cap_circulating_max_latest > 0 order by price_to_sales limit 25 ``` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.