Algorand - Token Terminal Docs

The algorand dataset holds the standardized Algorand tables. History starts 2019-06.

Tables

Table	Since
`blocks`	2019-06
`global_state_deltas`	2020-10
`inner_transactions`	2021-11
`local_state_deltas`	2020-12
`logs`	2021-11
`transactions`	2019-06

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 transactions

Count daily transactions over one week.

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