Apps

An app is one deployed version of a protocol that a project runs, such as orca-whirlpools. The project level sits on Projects.

metrics_app_chains: one table per measure, one row per app per chain per day.

An app’s figure on Solana for one day rolls into its project’s figure on the Projects page, worked out once and served at both levels. An app’s chain rows for one day sum to what metrics_apps serves without the chain breakout, so use these tables when the chain breakdown is the question. An app’s activity has a finer table beneath it: a DEX’s volume breaks down pool by pool on DEX, and bridge volume breaks down transfer by transfer on Bridges. Start with the daily figures and drop down when the question needs the detail. Every column is documented at Apps ▸ Metrics.

Sample queries

Apps on Solana
Solana's share

Rank the apps active on Solana by trading volume over one week.

select
    apps.name,
    sum(daily.trading_volume) as trading_volume
from `metrics_app_chains.trading_volume_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 = 'solana'
group by apps.name
order by trading_volume desc

Work out how much of one app runs on Solana. Dropping the chain filter and grouping by chain turns the same table into a comparison across every chain the app runs on.

with by_chain as (
    select
        chain_id,
        sum(trading_volume) as trading_volume
    from `metrics_app_chains.trading_volume_daily`
    where timestamp >= timestamp('2026-08-16')
      and timestamp < timestamp('2026-08-23')
      and app_id = 'orca-whirlpools'
    group by chain_id
)

select
    chain_id,
    trading_volume,
    trading_volume / sum(trading_volume) over () as share
from by_chain
order by trading_volume desc
limit 20

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries