Transactions

In progress. This table is not served yet. The page documents it as it lands.

facts.chain_transactions contains one row per transaction on a covered network, with the fee that transaction paid. Every covered network lands in this same table, so one query spans them all. project_id is worked out from dimensions.chains when the table is read, so a change of operator flows into every row.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	The time of the block containing the transaction. Partition column of the underlying sources.
`transaction_hash`	`STRING`	Hash of the transaction.
`chain_id`	`STRING`	Chain the transaction executed on.
`project_id`	`STRING`	Project running the chain, taken from `dimensions.chains`.
`from_address`	`STRING`	Address that sent the transaction.
`token_address`	`STRING`	Address of the chain’s own gas token, the one the fee is charged in.
`fee_amount`	`FLOAT64`	Fee the transaction paid, in units of that gas token.

Sample queries

The table is partitioned on block_timestamp. A query bounded on that column reads only the days it needs. Bound it in every query.

Top fee payers
One address, daily

Rank addresses by fees paid on one chain over one week. We publish no per-address totals, so a figure per address is worked out straight from the transactions.

select
    from_address,
    sum(fee_amount) as fees_paid,
    count(*) as transactions
from `facts.chain_transactions`
where chain_id = 'hyperevm'
  and block_timestamp >= timestamp('2026-08-01')
  and block_timestamp < timestamp('2026-08-08')
group by from_address
order by fees_paid desc
limit 20

Count one address’s transactions per day.

select
    timestamp_trunc(block_timestamp, day) as day,
    count(*) as transactions,
    sum(fee_amount) as fees_paid
from `facts.chain_transactions`
where chain_id = 'hyperevm'
  and from_address = '0x0000000000000000000000000000000000000000'
  and block_timestamp >= timestamp('2026-08-01')
group by day
order by day

Notes

fee_amount is in units of the chain’s gas token rather than in USD, and token_address names that token. The daily fee total per chain in USD is already worked out on Chains ▸ Metrics, where reading it costs a single day of data.

Overview

Core entities

Market verticals

Chain verticals

Columns

Sample queries

Notes

​Columns

​Sample queries

​Notes

Columns

Sample queries

Notes