Skip to main content

Solana Data

Bitquery provides Solana blockchain data dumps in Parquet format, designed for large-scale analytics, historical backfills, and data lake integrations. These datasets can be hosted directly in your own cloud storage (for example, AWS S3) and queried using engines like Snowflake, BigQuery, Athena, Spark, etc.

Available Solana Topics​

For Solana, Bitquery currently provides the following datasets:

  • Blocks – Slot-level block metadata

  • Transactions – Full transaction-level data

  • Transfers – Native SOL and token transfers

  • Balance Updates – Account balance changes per slot

  • DEX Pools – Decentralized exchange pool metadata

  • DEX Orders – Order-level DEX activity

  • DEX Trades – Executed trades on Solana DEXs

  • Rewards – Validator and staking rewards

Sample Solana Cloud Dataset​

You can explore schemas and validate your tooling using the public Solana sample datasets:

GitHub reference (schemas & examples)
https://github.com/bitquery/blockchain-cloud-data-dump-sample/tree/main/solana

Example Parquet file (public S3)

https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/solana/balance_updates/390740000_390740049.parquet

Solana Dataset Directory Structure​

bitquery-blockchain-dataset/
└── solana/
├── balance_updates/
│ ├── 390740000_390740049.parquet
│ ├── 390740050_390740099.parquet
│ └── ...
├── blocks/
│ ├── 390740000_390740049.parquet
│ ├── 390740050_390740099.parquet
│ └── ...
├── dex_orders/
│ ├── 390740000_390740049.parquet
│ └── ...
├── dex_pools/
│ ├── 390740000_390740049.parquet
│ └── ...
├── dex_trades/
│ ├── 390740000_390740049.parquet
│ └── ...
├── rewards/
│ ├── 390740000_390740049.parquet
│ └── ...
├── transactions/
│ ├── 390740000_390740049.parquet
│ └── ...
└── transfers/
├── 390740000_390740049.parquet
└── ...

Slot Range Naming Convention​

Each Parquet file name follows this format:

<start_slot>_<end_slot>.parquet

Example:

390740000_390740049.parquet

Get Full Access​

The full dataset is delivered into your own cloud storage (S3, GCS) or warehouse share (Snowflake, BigQuery). To buy or trial it, go to the Bitquery Data Store, fill the API form or contact sales@bitquery.io.

Per-protocol Solana datasets on the Data Store, each with decoded trades priced in USD:

Reading Files with DuckDB​

No key, no client library — point DuckDB at the public sample directly:

SELECT *
FROM read_parquet('https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/solana/balance_updates/390740000_390740049.parquet')
LIMIT 10;

Reading Files in Python​

import pandas as pd

df = pd.read_parquet("https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/solana/balance_updates/390740000_390740049.parquet")
print(df.info())
df.head()

Real-Time vs Batch Data Access​

Cloud data dumps are optimized for batch analytics and historical workloads.

If you require low-latency or streaming Solana data, Bitquery also provides:

Build with Bitquery

Ready to run this in production?

Get an API key and run these queries in minutes, or talk to us about plans and enterprise delivery.