Chainflip - Token Terminal Docs

The chainflip dataset holds the standardized Chainflip tables. History starts 2023-11. Every column is documented at Substrate ▸ Overview.

Tables

Table	Since
`blocks`	2023-11
`events`	2023-11
`extrinsics`	2023-11

Sample queries

The tables split by day on block_timestamp (blocks on timestamp). Bound that column in every query; without a bound the query reads the whole table.

Daily extrinsics

Count daily extrinsics over one week.

select
    timestamp_trunc(block_timestamp, day) as day,
    count(*) as extrinsics
from `chainflip.extrinsics`
where block_timestamp >= timestamp('2026-08-16')
  and block_timestamp < timestamp('2026-08-23')
group by day
order by day