Stacks Datasets
Datasets are curated, ready-to-query views of Stacks data — sBTC, stacking, BNS and more. Each ships a stable read API, a parquet download, a schema reference, and a freshness signal. Free to read and always on — you never run a node.
They share the same publishing harness as Streams bulk dumps: parquet partitioned by Stacks block height, refreshed on a schedule, with a machine-readable manifest at manifest/latest.json.
How it works
Each dataset is a curated view over the raw L1 events — decoded and shaped for one domain, then served two ways: a cursor-paginated JSON API for apps and dashboards, and bulk parquet for warehouses and notebooks.
The shelf
- STX TransfersShipped
Every canonical STX transfer event with sender, recipient, amount, and memo.
- PoX-4 / StackingShipped
Solo, delegated, aggregated stacking calls — every PoX-4 contract call decoded with cycle math, BTC payout addresses, and signer keys.
- sBTCShipped
Deposits, withdrawals (create/accept/reject), signer-set rotations, governance hooks, plus SIP-010 mint/burn/transfer on sbtc-token.
- BNSShipped
BNS-V2 names, namespaces, marketplace listings, plus a current-state projection for fast resolve(fqn).
- Network HealthShipped
Daily rollup of canonical block count, average block time, and reorg count.
How to read
Reads are open — no key needed for low-volume use. Hit the JSON API for live queries, or pull parquet for analytics:
# JSON API — cursor-paginated, anonymous
curl "https://api.secondlayer.tools/v1/datasets/sbtc/events?limit=5"
# Bulk parquet — read straight into DuckDB
SELECT * FROM 'https://data.secondlayer.tools/stacks-datasets/mainnet/v0/sbtc/*.parquet'
LIMIT 5;Read the manifest first — it points at every published file with row counts and SHA-256 checksums.