Stacks

stacks holds the standardized Stacks tables. Stacks sits on top of Bitcoin and runs contracts of its own, written in a language called Clarity, so its tables differ from the rest of the Bitcoin family: blocks and transactions carry extra columns for that, and a third table, events, records asset movements, locked STX (the chain’s own token), and the notes its contracts write.

Tables

Table	Since	Description
`blocks`	2024-04	One row per block, with burn-block anchoring and execution cost totals.
`transactions`	2024-04	One row per transaction, with the columns its Clarity type populates.
`events`	2021-01	One row per event: asset transfers, STX locks and contract logs.

Sample queries

Events by type
Priced tokens

Count events by type on one day.

select
    event_type,
    count(*) as events
from `stacks.events`
where block_timestamp >= timestamp('2026-08-20')
  and block_timestamp < timestamp('2026-08-21')
group by event_type
order by events desc

List the Stacks tokens that carried a daily price over one week.

with priced as (
    select
        token_id,
        avg(price) as avg_price,
        count(*) as price_days
    from `metrics_tokens.price_daily`
    where timestamp >= timestamp('2026-08-16')
      and timestamp < timestamp('2026-08-23')
      and chain_id = 'stacks'
    group by token_id
)

select
    tokens.symbol,
    tokens.name,
    priced.avg_price,
    priced.price_days
from priced
join `dimensions.tokens` as tokens using (token_id)
order by priced.avg_price desc
limit 20

Notes

blocks and transactions start on 2024-04-16, so events is the only table with history before 2024. Transactions are keyed on transaction_id, and events on transaction_id and event_index. Stacks transactions come in several kinds, and transaction_type says which. Which columns are filled in follows from that: token_transfer_* for a transfer, contract_call_* for a call into a contract, smart_contract_* for publishing one. The rest are empty. Because Stacks runs contracts, its tokens reach the catalog’s token list where the rest of the Bitcoin family’s do not, and some carry a daily USD price. No app, pool or tokenized asset table covers Stacks. Tokens covers the token list and the daily price table in depth. Chains covers the list of chains we track.

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Tables

Sample queries

Notes

​Tables

​Sample queries

​Notes

Tables

Sample queries

Notes