Financial statements

screeners.projects_financial_statements holds one row per project per reporting period length: the income statement and the treasury for the most recent period that has finished. period_granularity takes week, month, quarter or year, so one project carries four rows, each closing on a different date. The income statement reads down in order. Fees are what users paid, fees_supply_side is the share passed on to suppliers, and revenue is what the protocol kept. Expenses and token incentives come off revenue to leave earnings. project_id joins dimensions.projects. Every period on this table has closed. A quarter still running does not appear until it ends, so two projects on the same period_granularity are always comparable.

Columns

Each line item carries three columns: the figure for the period, its change against the period before, and its change against the same period a year earlier. Changes are fractions, so 0.05 is five percent up.

Column	Type	Description
`project_id`	`STRING`	Project the statement belongs to, such as `aave`; joins `dimensions.projects`.
`period_granularity`	`STRING`	Length of the period: `week`, `month`, `quarter` or `year`.
`period_start`	`TIMESTAMP`	First moment of the period.
`period_end`	`TIMESTAMP`	Last moment of the period.
`fees`	`NUMERIC`	What users paid to use the protocol over the period, USD. Also `fees_qoq` and `fees_yoy`.
`fees_supply_side`	`NUMERIC`	The share of fees passed on to suppliers rather than kept, USD. Also `fees_supply_side_qoq` and `fees_supply_side_yoy`.
`revenue`	`NUMERIC`	Fees the protocol kept, USD. Also `revenue_qoq` and `revenue_yoy`.
`expenses`	`NUMERIC`	What the protocol spent over the period, USD. Also `expenses_qoq` and `expenses_yoy`.
`token_incentives`	`NUMERIC`	Value of tokens paid out to attract usage, USD. Also `token_incentives_qoq` and `token_incentives_yoy`.
`earnings`	`NUMERIC`	Revenue after expenses and token incentives, USD. Negative where a protocol pays out more than it keeps. Also `earnings_qoq` and `earnings_yoy`.
`treasury`	`NUMERIC`	Value the protocol held at the close of the period, USD. Also `treasury_qoq` and `treasury_yoy`.
`treasury_net`	`NUMERIC`	Treasury excluding the protocol’s own token, USD. Also `treasury_net_qoq` and `treasury_net_yoy`.

Sample queries

One statement
Most profitable protocols
Paying out more than they keep
Growing on the year

Read one project’s quarterly statement. The columns come back in statement order, fees down to earnings, then the treasury.

select
    period_start,
    period_end,
    fees,
    fees_supply_side,
    revenue,
    expenses,
    token_incentives,
    earnings,
    treasury_net
from `screeners.projects_financial_statements`
where project_id = 'aave'
  and period_granularity = 'quarter'

Rank projects by what they earned last quarter. earnings_qoq says which way each one is moving.

select
    projects.name,
    statements.revenue,
    statements.earnings,
    statements.earnings_qoq
from `screeners.projects_financial_statements` as statements
join `dimensions.projects` as projects
    using (project_id)
where statements.period_granularity = 'quarter'
  and statements.earnings is not null
order by statements.earnings desc
limit 25

Find protocols whose token incentives exceed their revenue. Earnings go negative when the payout is larger than the take.

select
    projects.name,
    statements.revenue,
    statements.token_incentives,
    statements.earnings
from `screeners.projects_financial_statements` as statements
join `dimensions.projects` as projects
    using (project_id)
where statements.period_granularity = 'year'
  and statements.earnings < 0
order by statements.earnings
limit 25

Rank projects by annual revenue growth. period_granularity picks the reporting length, and revenue_yoy compares against the same period a year earlier.

select
    projects.name,
    statements.revenue,
    statements.revenue_yoy,
    statements.earnings_yoy
from `screeners.projects_financial_statements` as statements
join `dimensions.projects` as projects
    using (project_id)
where statements.period_granularity = 'quarter'
  and statements.revenue > 1000000
order by statements.revenue_yoy desc
limit 25

Notes

A line item with no figure for a project is empty rather than zero. A protocol that reports no treasury has no treasury figure, which is not the same as holding nothing. The four period_granularity values close on different dates, so a project’s week row and its quarter row end at different times. Filter to one granularity in every query, or a project returns four rows that do not add up to each other. earnings is revenue after expenses and token incentives, so it is the one line item that can be negative. Ranking on it puts the protocols paying out most at the top when sorted ascending.

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Columns

Sample queries

Notes

​Columns

​Sample queries

​Notes

Columns

Sample queries

Notes