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 have 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. A Stacks transaction comes in one of several kinds, and transaction_type says which. Each kind fills its own group of columns: token_transfer_* for a transfer, contract_call_* for a call into a contract, smart_contract_* for publishing one. Because Stacks runs contracts, its tokens reach the catalog’s token list, and some have a daily USD price. Tokens covers the token list and the daily price table in depth. Chains covers the list of chains we track.

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, keyed on `transaction_id`, with the columns its Clarity type populates.
`events`	2021-01	One row per event, keyed on `transaction_id` and `event_index`: asset transfers, STX locks and contract logs.

events reaches back to 2021-01, while blocks and transactions begin on 2024-04-16.

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 had 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

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries