Ready to execute queries

✨ Welcome to the SolArchive SQL Playground

Query Solana blockchain data directly in your browser using DuckDB-WASM. Use the special syntax to reference datasets:

  • transactions$2025-11-30 - Transactions for Nov 30, 2025
  • tokens$2025-11 - Tokens for November 2025
  • accounts$2025-11 - Account snapshots for November 2025

Note: Queries load a random sample of files from each partition to keep things fast. Adjust the sample size in the toolbar to load more data.

Try selecting an example query from the dropdown above, or write your own SQL!