TON - Token Terminal Docs

The ton dataset holds the standardized TON tables. History starts 2019-11.

Tables

Table	Since
`block_headers`	Not partitioned
`blocks`	2019-11
`messages`	2019-11
`shards`	Not partitioned
`transactions`	2019-11

Sample queries

transactions and messages split by day on block_timestamp, and blocks on timestamp. Bound that column in every query against them. block_headers and shards carry no partition key, so every query against those two reads the whole table.

Daily transactions

Count daily transactions over one week.

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