> ## 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.

# Projects

> Daily Fees and Revenue for each tracked app and project, broken out to Plasma.

The top of the catalog breaks activity down by who ran it. A project is the entity behind a protocol, such as Uniswap. An app is one deployed version that project runs, such as `uniswap-v3`.

* [`metrics.apps_chains_daily`](/docs/catalog/projects/metrics): one row per app per chain per day.
* [`metrics.projects_chains_daily`](/docs/catalog/projects/metrics): one row per project per chain per day.

Every column is documented at [Projects ▸ Metrics](/docs/catalog/projects/metrics).

## Sample queries

<Tabs>
  <Tab title="Apps on Plasma">
    **Rank the apps active on Plasma by fees over one week.**

    ```sql theme={null}
    select
        apps.name,
        sum(daily.fees) as fees,
        sum(daily.revenue) as revenue
    from `metrics.apps_chains_daily` as daily
    join `dimensions.apps` as apps
        using (app_id)
    where daily.timestamp >= timestamp('2026-08-16')
      and daily.timestamp < timestamp('2026-08-23')
      and daily.chain_id = 'plasma'
    group by apps.name
    order by fees desc
    ```
  </Tab>

  <Tab title="One project's series">
    **Read one project's daily Plasma fees.**

    ```sql theme={null}
    select
        daily.timestamp,
        daily.fees,
        daily.revenue
    from `metrics.projects_chains_daily` as daily
    where daily.timestamp >= timestamp('2026-08-16')
      and daily.timestamp < timestamp('2026-08-23')
      and daily.chain_id = 'plasma'
      and daily.project_id = 'uniswap'
    order by daily.timestamp
    ```
  </Tab>

  <Tab title="Plasma's share">
    **Work out how much of a project runs on Plasma.** Dropping the chain filter and grouping by chain turns the same table into a comparison across every chain the project operates on.

    ```sql theme={null}
    with by_chain as (
        select
            chain_id,
            sum(fees) as fees
        from `metrics.projects_chains_daily`
        where timestamp >= timestamp('2026-08-16')
          and timestamp < timestamp('2026-08-23')
          and project_id = 'uniswap'
        group by chain_id
    )

    select
        chain_id,
        fees,
        fees / sum(fees) over () as share
    from by_chain
    order by fees desc
    limit 20
    ```
  </Tab>
</Tabs>

## Notes

The two tables hold the same measures at two levels. A project figure for one chain and one day is the sum of its apps on that chain and day, worked out once and served at both levels. The same holds across chains: a project's chain rows for one day sum to what `metrics.projects_daily` serves without the chain breakout, so use the chain tables when the chain breakdown is the question.

Each app's activity has a finer table beneath it: a DEX's volume breaks down pool by pool on [DEX](/docs/catalog/chain-verticals/evm/plasma/dex), and bridge volume breaks down transfer by transfer on [Bridges](/docs/catalog/chain-verticals/evm/plasma/bridges). Start with the daily figures and drop down when the question needs the detail.