Solana table reference
Full schema for the Supanode Solana Indexer - 21 tables and 463 columns across Pump.fun, PumpSwap, Raydium, Meteora and Jito, with every type, partition key and retention window.
// updated 2026-08-22
The Solana database contains decoded DEX activity plus reusable helper tables. This page documents every table, column, type, and description. For runnable patterns see Query examples; for the conventions that apply across tables see Schema conventions; for connection details see Access.
NOTE
Schema snapshot: 16 August 2026. Row counts and sizes grow continuously. Columns marked (populated since ...) exist on every row but only carry data from that date onward - older rows hold the type default.
Tables overview
| Table | Protocol | Rows | Size | History | Retention |
|---|---|---|---|---|---|
pumpfun_token_creation | Pump.fun | 16,158,167 | 4.10 GB | 2024-01-17 → 2026-08-16 | full history |
pumpfun_all_swaps | Pump.fun | 2,447,780,900 | 322.27 GB | 2024-06-11 → 2026-08-16 | full history |
pumpfun_v2_swaps | Pump.fun | 1,352,692,572 | 185.82 GB | 2024-11-02 → 2026-08-16 | full history |
pfamm_migrations | Pump.fun | 106,004 | 24.4 MB | 2025-08-16 → 2026-08-16 | 1 year |
pumpfun_creator_fee_distributions | Pump.fun | 1,862,105 | 301.8 MB | 2026-02-15 → 2026-08-16 | full history |
pumpfun_amm_admin_set_coin_creator | Pump.fun | 751 | 143.1 KB | 2026-03-15 → 2026-08-16 | full history |
pumpswap_all_swaps | PumpSwap | 5,061,985,647 | 1656.07 GB | 2025-08-16 → 2026-08-16 | 1 year |
raydium_all_swaps | Raydium | 14,866,785 | 2.09 GB | 2026-05-18 → 2026-08-16 | 90 days |
raydium_cpmm_swaps | Raydium | 15,924,873 | 3.73 GB | 2026-05-18 → 2026-08-16 | 90 days |
raydium_launchpad_swaps | Raydium | 22,880,401 | 3.86 GB | 2025-08-16 → 2026-08-16 | 1 year |
raydium_launchpad_token_creation | Raydium | 65,568 | 19.9 MB | 2025-04-16 → 2025-10-15 | full history |
raydium_launchpad_migrations | Raydium | 94 | 478.6 KB | 2025-08-16 → 2026-08-14 | 1 year |
raydium_launchpad_cpmm_migrations | Raydium | 3,664 | 4.0 MB | 2025-08-16 → 2026-08-16 | 1 year |
meteora_swaps | Meteora | 75,434,658 | 13.48 GB | 2026-05-18 → 2026-08-16 | 90 days |
meteora_dynamic_bonding_swaps | Meteora | 152,076,712 | 41.81 GB | 2025-08-18 → 2026-08-16 | 1 year |
jito_tips | Jito | 135,442,770 | 10.22 GB | 2026-08-02 → 2026-08-16 | 14 days |
token_transfers | Helper | 146,085,642 | 22.57 GB | 2026-07-20 → 2026-08-16 | 31 days |
sol_top_ups | Helper | 173,385,646 | 28.29 GB | 2026-07-20 → 2026-08-16 | 31 days |
solana_blocks | Helper | 184,679,641 | 9.46 GB | full chain history → 2026-08-16 | full history |
tx_timestamps | Helper | 2,744,043,346 | 243.84 GB | rolling window | 14 days |
max_caps | Helper | 9,353,726 | 438.8 MB | rolling window | full history |
WARNING
Retention is per table, not one global window. tx_timestamps and jito_tips hold 14 days, token_transfers and sol_top_ups hold 31 days, the Raydium and Meteora AMM tables hold 90 days, and the rest hold a year or their full history. If your analysis needs a longer window on a short-retention table, tell us before you start - extended retention and one-off exports are arranged per customer.
TIP
Always filter on the partition column first. Each table lists its partition key below. A swap query without that filter scans the whole table - on pumpswap_all_swaps that is 1.6 TB.
pumpfun_token_creation
Every Pump.fun launch, with bundle forensics - bundle size and structure, bundled buys, and the dev's balance right after creation.
Partition key: not partitioned
History: 2024-01-17 → 2026-08-16
Retention: full history
Rows: 16,158,167 · Size: 4.10 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
creator | FixedString(48) | Wallet that created the token |
name | FixedString(20) | Token name |
symbol | FixedString(16) | Token ticker symbol |
url | FixedString(256) | Metadata URI (usually IPFS) |
mint | FixedString(48) | Token mint address |
bundle_size | UInt8 | Number of transactions in the bundle |
gas_used | UInt64 | Total gas used for token creation |
amount_of_instructions | Int32 | Number of instructions in the transaction |
amount_of_lookup_reads | Int32 | Number of address lookup table reads |
amount_of_lookup_writes | Int32 | Number of address lookup table writes |
bundle_structure | String | Structure of bundled transactions |
bundled_buys | UInt64 | Total SOL amount in bundled buys |
bundled_buys_count | UInt64 | Number of bundled buy transactions |
dev_balance | UInt64 | Developer's token balance after creation |
creation_ix_index | Int32 | Index of creation instruction |
curve_address | FixedString(48) | Bonding curve account address |
pf_program_index | UInt8 | Pump.fun program index in transaction |
direct_pf_invocation | UInt8 | Whether pump.fun was called directly (1=yes, 0=no) |
version | DateTime64(3) | Record version timestamp (populated since 2024-01-17) |
mayhem_mode | UInt8 | Whether mayhem mode was enabled (populated since 2025-11-12) |
token_program | String | Token program used (SPL Token or Token-2022) (populated since 2024-01-17) |
signature | String | Transaction signature (base58 encoded) (populated since 2024-01-17) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2026-01-22) |
is_cashback_enabled | UInt8 | Whether cashback was enabled for creation (populated since 2026-02-18) |
pumpfun_all_swaps
Pump.fun bonding-curve swaps. The deepest history in the database and one of its largest tables.
Partition key: not partitioned
History: 2024-06-11 → 2026-08-16
Retention: full history
Rows: 2,447,780,900 · Size: 322.27 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
signing_wallet | FixedString(48) | Wallet address that signed the transaction |
direction | String | Trade direction (buy/sell) |
base_coin | FixedString(48) | Base token mint address |
base_coin_amount | UInt64 | Base token amount (raw units, needs decimal adjustment) |
quote_coin_amount | UInt64 | Quote token amount (raw units) |
virtual_token_balance_after | UInt64 | Virtual token reserves after trade (bonding curve state) |
virtual_sol_balance_after | UInt64 | Virtual SOL reserves after trade (bonding curve state) |
signature | FixedString(128) | Transaction signature (base58 encoded) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
is_exact_quote | UInt8 | Whether quote amount was exact (1=yes, 0=no) (populated since 2025-12-03) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2024-11-02) |
pumpfun_v2_swaps
The Pump.fun v2 instruction set, including failed transactions and the compute-budget instruction indexes.
Partition key: (block_date_utc, failed)
History: 2024-11-02 → 2026-08-16
Retention: full history
Rows: 1,352,692,572 · Size: 185.82 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
ix_idx | Int16 | Instruction index within the transaction (populated since 2024-11-02) |
signing_wallet | String | Wallet address that signed the transaction |
fee_payer | String | Wallet that paid the transaction fee (populated since 2024-11-02) |
direction | LowCardinality(String) | Trade direction (buy/sell) |
base_coin | String | Base token mint address |
quote_coin | LowCardinality(String) | Quote token mint address (usually SOL or USDC) |
instruction_type | LowCardinality(String) | Pump.fun instruction variant: buy, sell, buy_v2, sell_v2, buy_exact_sol_in, or buy_exact_quote_in_v2 |
base_coin_amount | UInt64 | Base token amount (raw units, needs decimal adjustment) |
quote_coin_amount | UInt64 | Quote token amount (raw units) |
virtual_token_balance_after | UInt64 | Virtual token reserves after trade (bonding curve state) |
virtual_sol_balance_after | UInt64 | Virtual SOL reserves after trade (bonding curve state) |
signature | String | Transaction signature (base58 encoded) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
lookup_tables | String | Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2024-11-02) |
failed | UInt8 | Whether the transaction failed (1=yes, 0=no) (populated since 2024-11-02) |
pf_program_account_index | Int16 | Default: -1 (populated since 2024-11-02) |
cu_price_ix_index | Int16 | Instruction index of the compute-unit price instruction (populated since 2024-11-02) |
cu_limit_ix_index | Int16 | Instruction index of the compute-unit limit instruction (populated since 2024-11-02) |
tip_index | Int16 | Default: -1 (populated since 2024-11-02) |
pfamm_migrations
Pump.fun graduations to the PumpSwap AMM - one row per migrated mint.
Partition key: block_date_utc
History: 2025-08-16 → 2026-08-16
Retention: 1 year
Rows: 106,004 · Size: 24.4 MB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
user | String | User wallet address |
mint | String | Token mint address |
mint_amount | UInt64 | Token amount migrated |
sol_amount | UInt64 | SOL amount in the migration |
pool_migration_fee | UInt64 | Fee paid for pool migration |
bonding_curve | String | Bonding curve account address |
timestamp | UInt32 | Unix timestamp of migration |
pool | String | Pool account address |
signature | String | Transaction signature (base58 encoded) (populated since 2025-11-10) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2026-01-22) |
pumpfun_creator_fee_distributions
Creator fee payouts: which mint, which wallet received it, how much.
Partition key: toYYYYMMDD(block_time)
History: 2026-02-15 → 2026-08-16
Retention: full history
Rows: 1,862,105 · Size: 301.8 MB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
ix_idx | UInt32 | Instruction index within the transaction |
signature | String | Transaction signature (base58 encoded) |
fee_payer | String | Wallet that paid the transaction fee |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
mint | String | Token mint address |
receiver | String | Creator wallet receiving the fee distribution |
amount | UInt64 | Fee amount distributed (lamports) |
fee_distribution_method | String | Method used for fee distribution (populated since 2026-02-15) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2026-05-29) |
pumpfun_amm_admin_set_coin_creator
Admin changes to a pool's coin creator. A small table, but it decides creator-fee attribution.
Partition key: toYYYYMM(block_time)
History: 2026-03-15 → 2026-08-16
Retention: full history
Rows: 751 · Size: 143.1 KB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
swap_idx | Int32 | Swap index within the transaction |
signature | String | Transaction signature (base58 encoded) |
fee_payer | String | Wallet that paid the transaction fee |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
pool | String | Pool account being modified |
parent_program | String | Parent program that invoked this instruction (for CPI calls) |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
pumpswap_all_swaps
PumpSwap AMM swaps with complete reserve and fee accounting. The largest table here.
Partition key: block_date_utc
History: 2025-08-16 → 2026-08-16
Retention: 1 year
Rows: 5,061,985,647 · Size: 1656.07 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
signing_wallet | String | Wallet address that signed the transaction |
fee_payer | String | Wallet that paid the transaction fee |
direction | LowCardinality(String) | Trade direction (buy/sell) |
base_token | String | Base token mint address |
quote_token | String | Quote token mint address |
base_token_amount | UInt64 | Base token amount (raw units) |
quote_token_amount | UInt64 | Quote token amount (raw units) |
quote_token_amount_limit | UInt64 | Maximum quote token amount limit |
quote_token_amount_without_lp_fee | UInt64 | Quote amount before LP fee deduction |
user_base_token_account | String | User's base token account |
user_quote_token_account | String | User's quote token account |
user_base_token_reserves | UInt64 | User's base token balance |
user_quote_token_reserves | UInt64 | User's quote token balance |
pool_base_token_reserves_before | UInt64 | Pool base token reserves before swap |
pool_quote_token_reserves_before | UInt64 | Pool quote token reserves before swap |
pool_base_token_reserves_after | UInt64 | Pool base token reserves after swap |
pool_quote_token_reserves_after | UInt64 | Pool quote token reserves after swap |
lp_fee_basis_points | UInt16 | LP fee in basis points |
lp_fee | UInt64 | LP fee amount |
protocol_fee_basis_points | UInt16 | Protocol fee in basis points |
protocol_fee | UInt64 | Protocol fee amount |
signature | String | Transaction signature (base58 encoded) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
pool | String | Pool account address (populated since 2025-08-16) |
is_exact_quote | UInt8 | Whether quote amount was exact (1=yes, 0=no) (populated since 2025-12-03) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2025-12-13) |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction (populated since 2026-02-18) |
coin_creator | String | Default: '' (populated since 2026-07-23) |
coin_creator_fees_basis_points | UInt64 | Default: 0 (populated since 2026-07-23) |
coin_creator_fees | UInt64 | Default: 0 (populated since 2026-07-23) |
cash_back_fees_basis_points | UInt64 | Default: 0 (populated since 2026-07-23) |
cash_back_fees | UInt64 | Default: 0 (populated since 2026-07-23) |
buy_back_fees_basis_points | UInt64 | Default: 0 (populated since 2026-07-23) |
buy_back_fees | UInt64 | Default: 0 (populated since 2026-07-23) |
virtual_quote_reserves | Int128 | Default: 0 (populated since 2026-07-23) |
can_boost | UInt8 | Default: 0 (populated since 2026-07-23) |
base_supply | UInt64 | Default: 0 (populated since 2026-07-23) |
raydium_all_swaps
Raydium AMM swaps with pool balances before and after, plus the OpenBook market id.
Partition key: block_date_utc
History: 2026-05-18 → 2026-08-16
Retention: 90 days
Rows: 14,866,785 · Size: 2.09 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
signing_wallet | FixedString(48) | Wallet address that signed the transaction |
direction | String | Trade direction (buy/sell) |
base_coin | FixedString(48) | Base token mint address |
quote_coin | FixedString(48) | Quote token mint address (usually SOL or USDC) |
base_coin_amount | UInt64 | Base token amount (raw units, needs decimal adjustment) |
quote_coin_amount | UInt64 | Quote token amount (raw units) |
base_pool_balance_before | UInt64 | Pool base token balance before swap |
quote_pool_balance_before | UInt64 | Pool quote token balance before swap |
base_pool_balance_after | UInt64 | Pool base token balance after swap |
quote_pool_balance_after | UInt64 | Pool quote token balance after swap |
signature | FixedString(128) | Transaction signature (base58 encoded) |
serum_market_id | FixedString(48) | OpenBook/Serum market ID (for hybrid pools) |
raydium_market_id | FixedString(48) | Raydium AMM market ID |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2026-05-18) |
raydium_cpmm_swaps
Raydium CPMM swaps with pool sizes, per-side fees, and swap type.
Partition key: block_date_utc
History: 2026-05-18 → 2026-08-16
Retention: 90 days
Rows: 15,924,873 · Size: 3.73 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
swap_idx | UInt16 | Swap index within the transaction |
signature | String | Transaction signature (base58 encoded) |
fee_payer | String | Wallet that paid the transaction fee |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
pool_id | String | Pool account address |
signer | String | Wallet address that signed the transaction |
direction | LowCardinality(String) | Trade direction (buy/sell) |
base_coin | String | Base token mint address |
quote_coin | String | Quote token mint address (usually SOL or USDC) |
base_coin_amount | UInt64 | Base token amount (raw units, needs decimal adjustment) |
quote_coin_amount | UInt64 | Quote token amount (raw units) |
base_coin_slippage | Int64 | Slippage on base token |
quote_coin_slippage | Int64 | Slippage on quote token |
parent_program | String | Parent program that invoked this instruction (for CPI calls) |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
input_token_pool_size_before | UInt64 | Input token pool size before swap |
output_token_pool_size_before | UInt64 | Output token pool size before swap |
tokens_in | UInt64 | Tokens received by pool |
tokens_out | UInt64 | Tokens sent from pool |
fee_in_token_in | UInt64 | Fee denominated in input token |
fee_in_token_out | UInt64 | Fee denominated in output token |
swap_type | LowCardinality(String) | Type of swap (BaseIn/BaseOut) |
instruction_input1 | UInt64 | First instruction input parameter |
instruction_input2 | UInt64 | Second instruction input parameter |
input_token_mint | String | Input token mint address |
output_token_mint | String | Output token mint address |
raydium_launchpad_swaps
Raydium Launchpad bonding-curve swaps - this is where LetsBonk.fun activity lands.
Partition key: block_date_utc
History: 2025-08-16 → 2026-08-16
Retention: 1 year
Rows: 22,880,401 · Size: 3.86 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
fee_payer | String | Wallet that paid the transaction fee |
direction | LowCardinality(String) | Trade direction (buy/sell) |
pool_status | UInt8 | Pool status code |
pool_state | String | Pool state account address |
base_token | String | Base token mint address |
quote_token | String | Quote token mint address |
total_base_sell | UInt64 | Total base tokens available for sale |
virtual_base | UInt64 | Virtual base token reserves |
virtual_quote | UInt64 | Virtual quote token reserves |
pool_base_token_reserves_before | UInt64 | Pool base token reserves before swap |
pool_quote_token_reserves_before | UInt64 | Pool quote token reserves before swap |
pool_base_token_reserves_after | UInt64 | Pool base token reserves after swap |
pool_quote_token_reserves_after | UInt64 | Pool quote token reserves after swap |
base_token_amount | UInt64 | Base token amount (raw units) |
quote_token_amount | UInt64 | Quote token amount (raw units) |
protocol_fee | UInt64 | Protocol fee amount |
platform_fee | UInt64 | Platform fee amount |
share_fee | UInt64 | Share/referral fee amount |
signature | String | Transaction signature (base58 encoded) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
raydium_launchpad_token_creation
Raydium Launchpad token launches, with bonding-curve parameters and bundle forensics. Historical only - no new rows since October 2025, as launches moved to the CPMM path.
Partition key: not partitioned
History: 2025-04-16 → 2025-10-15
Retention: full history
Rows: 65,568 · Size: 19.9 MB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
creator | FixedString(48) | Wallet that created the token |
name | FixedString(20) | Token name |
symbol | FixedString(16) | Token ticker symbol |
url | FixedString(256) | Metadata URI (usually IPFS) |
mint | FixedString(48) | Token mint address |
bundle_size | UInt8 | Number of transactions in the bundle |
gas_used | UInt64 | Total gas used for token creation |
amount_of_instructions | Int32 | Number of instructions in the transaction |
amount_of_lookup_reads | Int32 | Number of address lookup table reads |
amount_of_lookup_writes | Int32 | Number of address lookup table writes |
bundle_structure | String | Structure of bundled transactions |
bundled_buys | UInt64 | Total SOL amount in bundled buys |
bundled_buys_count | UInt64 | Number of bundled buy transactions |
dev_balance | UInt64 | Developer's token balance after creation |
creation_ix_index | Int32 | Index of creation instruction |
pool_state | FixedString(48) | Pool state account address |
base_vault | FixedString(48) | Base token vault address |
quote_vault | FixedString(48) | Quote token vault address |
raydium_program_index | UInt8 | Raydium program index in transaction |
direct_raydium_invocation | Bool | Whether Raydium was called directly |
decimals | UInt8 | Token decimals |
cpmm_type | UInt8 | CPMM pool type |
supply | UInt64 | Total token supply |
bonding_curve_sell_amount | UInt64 | Amount available for bonding curve sale |
bonding_curve_raise_amount | UInt64 | Target raise amount for bonding curve |
migrate_type | UInt8 | Migration type after bonding curve |
version | DateTime64(3) | Record version timestamp (populated since 2025-04-16) |
raydium_launchpad_migrations
Raydium Launchpad graduations into AMM / OpenBook markets.
Partition key: block_date_utc
History: 2025-08-16 → 2026-08-14
Retention: 1 year
Rows: 94 · Size: 478.6 KB
| Column | Type | Description |
|---|---|---|
signature | String | Transaction signature (base58 encoded) |
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
payer | String | Wallet that paid for the migration |
base_coin | String | Base token mint address |
quote_coin | String | Quote token mint address (usually SOL or USDC) |
openbook_program | String | OpenBook program address |
serum_market_id | String | OpenBook market ID |
request_queue | String | OpenBook request queue |
event_queue | String | OpenBook event queue |
bids | String | OpenBook bids account |
asks | String | OpenBook asks account |
market_vault_signer | String | OpenBook vault signer |
market_base_vault | String | OpenBook base token vault |
market_quote_vault | String | OpenBook quote token vault |
raydium_program | String | Raydium AMM program address |
raydium_market_id | String | Raydium AMM market ID |
amm_authority | String | Raydium AMM authority |
amm_open_orders | String | Raydium open orders account |
lp_mint | String | LP token mint address |
base_pool_balance_before | String | Pool base token balance before migration |
quote_pool_balance_before | String | Pool quote token balance before migration |
amm_target_orders | String | Raydium target orders account |
amm_config | String | Raydium AMM configuration |
amm_create_fee_dest | String | Destination for AMM creation fee |
authority | String | Launchpad authority account |
pool_state | String | Launchpad pool state account |
global_config | String | Global configuration account |
user_token_coin | String | User's base token account |
user_token_pc | String | User's quote token account |
user_lp_token_account | String | User's LP token account |
token_program | String | Token program address |
associated_token_program | String | Associated token program address |
system_program | String | System program address |
rent_program | String | Rent sysvar address |
raydium_launchpad_cpmm_migrations
Raydium Launchpad graduations into CPMM pools, with every account involved in the migration.
Partition key: block_date_utc
History: 2025-08-16 → 2026-08-16
Retention: 1 year
Rows: 3,664 · Size: 4.0 MB
| Column | Type | Description |
|---|---|---|
signature | String | Transaction signature (base58 encoded) |
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
payer | String | Wallet that paid for the migration |
base_mint | String | Base token mint address |
quote_mint | String | Quote token mint address |
platform_config | String | Platform configuration account |
cpswap_program | String | CPMM swap program address |
cpswap_pool | String | New CPMM pool address |
cpswap_authority | String | CPMM pool authority |
cpswap_lp_mint | String | CPMM LP token mint |
cpswap_base_vault | String | CPMM base token vault |
cpswap_quote_vault | String | CPMM quote token vault |
cpswap_config | String | CPMM configuration account |
cpswap_create_pool_fee | String | Fee account for pool creation |
cpswap_observation | String | CPMM observation account (for TWAP) |
lock_program | String | LP lock program address |
lock_authority | String | LP lock authority |
lock_lp_vault | String | Vault holding locked LP tokens |
authority | String | Launchpad authority account |
pool_state | String | Launchpad pool state account |
global_config | String | Global configuration account |
base_vault | String | Launchpad base token vault |
quote_vault | String | Launchpad quote token vault |
pool_lp_token | String | Pool LP token account |
meteora_swaps
Meteora DLMM swaps with the bin range crossed and the full fee breakdown.
Partition key: block_date
History: 2026-05-18 → 2026-08-16
Retention: 90 days
Rows: 75,434,658 · Size: 13.48 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
signing_wallet | String | Wallet address that signed the transaction |
base_coin | String | Base token mint address |
quote_coin | String | Quote token mint address (usually SOL or USDC) |
base_coin_amount | UInt64 | Base token amount (raw units, needs decimal adjustment) |
quote_coin_amount | UInt64 | Quote token amount (raw units) |
start_bin_id | Int32 | Starting bin ID in the DLMM pool |
end_bin_id | Int32 | Ending bin ID after the swap |
fee | UInt64 | Transaction fee paid (lamports) |
protocol_fee | UInt64 | Protocol fee amount |
fee_bps_low | UInt64 | Lower bound of fee in basis points |
fee_bps_high | UInt64 | Upper bound of fee in basis points |
host_fee | UInt64 | Host/frontend fee amount |
signature | String | Transaction signature (base58 encoded) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee_paid | UInt64 | Total fee paid |
consumed_gas | UInt64 | Compute units actually consumed |
lb_pair | String | Liquidity bin pair (pool) address |
from_wallet | String | Source wallet for the swap |
swap_for_y | UInt8 | Whether swapping for Y token (1=yes, 0=no) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) (populated since 2026-05-18) |
meteora_dynamic_bonding_swaps
Meteora Dynamic Bonding Curve swaps, including slippage, routing amounts, and referral fields.
Partition key: block_date_utc
History: 2025-08-18 → 2026-08-16
Retention: 1 year
Rows: 152,076,712 · Size: 41.81 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
swap_idx | UInt16 | Swap index within the transaction |
signature | String | Transaction signature (base58 encoded) |
fee_payer | String | Wallet that paid the transaction fee |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
pool_id | String | Pool account address |
signer | String | Wallet address that signed the transaction |
direction | LowCardinality(String) | Trade direction (buy/sell) |
base_coin | String | Base token mint address |
quote_coin | String | Quote token mint address (usually SOL or USDC) |
base_coin_amount | UInt64 | Base token amount (raw units, needs decimal adjustment) |
quote_coin_amount | UInt64 | Quote token amount (raw units) |
base_coin_slippage | Int64 | Slippage on base token (negative = less than expected) |
quote_coin_slippage | Int64 | Slippage on quote token (negative = less than expected) |
parent_program | String | Parent program that invoked this instruction (for CPI calls) |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
orig_base_coin_amount | UInt64 | Original base amount before slippage |
orig_quote_coin_amount | UInt64 | Original quote amount before slippage |
config | String | Pool configuration account |
trade_direction | UInt64 | Numeric trade direction indicator |
has_referral | UInt8 | Whether trade included a referral (1=yes, 0=no) |
swap_amount0 | String | First swap amount in the route |
swap_amount1 | String | Second swap amount in the route |
swap_mode | UInt64 | Swap mode (exact in/out) |
input_amount | String | Input amount for the swap |
output_amount | String | Output amount from the swap |
base_mint | String | Base token mint address |
quote_mint | String | Quote token mint address |
referral | String | Referral account address (if any) |
jito_tips
Jito tip payments: who tipped, which tip account received it, how much.
Partition key: block_date_utc
History: 2026-08-02 → 2026-08-16
Retention: 14 days
Rows: 135,442,770 · Size: 10.22 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
signature | String | Transaction signature (base58 encoded) |
signer | String | Wallet address that signed the transaction |
sender | String | Wallet that sent the tip |
tip_account | String | Jito tip account that received the tip |
amount | UInt64 | Tip amount in lamports |
token_transfers
SPL and Token-2022 transfers. The transfer variant is encoded in flavour.
Partition key: block_date_utc
History: 2026-07-20 → 2026-08-16
Retention: 31 days
Rows: 146,085,642 · Size: 22.57 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
failed | UInt8 | Whether the transaction failed (1=yes, 0=no) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
cu_price_ix_index | Int16 | Instruction index of the compute-unit price instruction |
cu_limit_ix_index | Int16 | Instruction index of the compute-unit limit instruction |
num_signatures | UInt8 | Number of signatures on the transaction |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
transaction_version | Int8 | Transaction message version (-1=legacy, 0=v0, -2=unknown) |
lookup_tables | String | Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) |
signature | String | Transaction signature (base58 encoded) |
fee_payer | String | Wallet that paid the transaction fee |
mint | String | Token mint address |
src_wallet | String | Source wallet address |
dst_wallet | String | Destination wallet address |
amount | UInt64 | Token amount transferred in raw base units (apply the mint's decimals for display) |
flavour | UInt8 | Transfer encoding: add 16 for Token-2022; base values are 0=Transfer, 1=TransferChecked, 2=TransferCheckedWithFee, and 3=SetAuthority owner change |
ix_idx | Int16 | Instruction index within the transaction |
sol_top_ups
Native SOL transfers. Use it to trace funding paths into a wallet.
Partition key: block_date_utc
History: 2026-07-20 → 2026-08-16
Retention: 31 days
Rows: 173,385,646 · Size: 28.29 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
block_date_utc | Date | UTC date of the block (for partitioning) |
slot | UInt32 | Solana slot number (block height) |
tx_idx | UInt16 | Transaction index within the block |
failed | UInt8 | Whether the transaction failed (1=yes, 0=no) |
provided_gas_fee | UInt64 | Gas fee provided for the transaction (lamports) |
provided_gas_limit | UInt64 | Compute unit limit requested |
fee | UInt64 | Transaction fee paid (lamports) |
consumed_gas | UInt64 | Compute units actually consumed |
cu_price_ix_index | Int16 | Instruction index of the compute-unit price instruction |
cu_limit_ix_index | Int16 | Instruction index of the compute-unit limit instruction |
num_signatures | UInt8 | Number of signatures on the transaction |
top_level_transfers_json | String | JSON array of top-level SOL/token transfers in the transaction |
transaction_version | Int8 | Transaction message version (-1=legacy, 0=v0, -2=unknown) |
lookup_tables | String | Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) |
signature | String | Transaction signature (base58 encoded) |
fee_payer | String | Wallet that paid the transaction fee |
src_wallet | String | Source wallet address |
dst_wallet | String | Destination wallet address |
amount | UInt64 | Amount of SOL transferred, in lamports |
solana_blocks
Block-level index: hash, validator identity, rewards, and transaction count.
Partition key: not partitioned
History: full chain history → 2026-08-16
Retention: full history
Rows: 184,679,641 · Size: 9.46 GB
| Column | Type | Description |
|---|---|---|
block_time | DateTime | UTC timestamp when the block was produced |
slot | UInt32 | Solana slot number (block height) |
hash | FixedString(48) | Block hash |
validator | FixedString(48) | Validator identity that produced the block |
rewards | UInt64 | Total rewards in the block (lamports) (populated since 2024-11-02) |
amount_of_transactions | UInt64 | Number of transactions in the block (populated since 1969-12-31) |
tx_timestamps
High-precision entry timestamp per transaction - the join target for latency work. See Nanosecond timestamps.
Partition key: toYYYYMMDD(toDateTime(entry_timestamp))
History: rolling window
Retention: 14 days
Rows: 2,744,043,346 · Size: 243.84 GB
| Column | Type | Description |
|---|---|---|
slot | UInt64 | Solana slot number (block height) |
tx_idx | UInt32 | Transaction index within the block |
entry_timestamp | Float64 | Entry timestamp (high-precision Unix timestamp) |
signature | String | Transaction signature (base58 encoded) |
max_caps
Precomputed peak market cap per mint, in SOL and USDC, with the slot at which it was reached.
Partition key: not partitioned
History: rolling window
Retention: full history
Rows: 9,353,726 · Size: 438.8 MB
| Column | Type | Description |
|---|---|---|
token_mint | String | Token mint address |
max_mcap_sol | SimpleAggregateFunction(max, Float32) | Maximum market cap reached (in SOL) |
max_mcap_usdc | SimpleAggregateFunction(max, Float32) | Maximum market cap reached (in USDC) |
max_slot | SimpleAggregateFunction(max, UInt32) | Slot when maximum market cap was reached |
See also
Schema conventions
Shared columns, units, and the gotchas that bite first.
Query examples
Working SQL against these tables.
Access
Connection details and code samples.