Documentation

Solana table reference

ClickHouse column types, partition keys and retention for documented Solana DEX data, token transfers and SOL top-ups.

// updated 2026-11-18

The Solana database contains decoded DEX activity and reusable helper tables. For wallet activity, start with Wallet transfers and SOL funding. See Query examples for more SQL and Schema conventions for partitions, units and retention.

NOTE

Schema snapshot: 1 September 2026, 12:33 UTC. Counts and history ranges describe that snapshot. Use DESCRIBE TABLE to check columns against your connection, including those marked as additions from a newer schema. Columns marked (populated since ...) hold the type default in older rows.

NOTE

The snapshot reports 0 rows in tx_timestamps, with its four columns and 14-day TTL still present. An empty historical snapshot does not establish current coverage. Check a bounded recent interval before planning a timing study.

Tables overview

TableProtocolRowsSizeHistoryRetention
pumpfun_token_creationPump.fun16,796,3434.36 GB2024-01-17 → 2026-09-01full history
pumpfun_all_swapsPump.fun2,508,366,154334.22 GB2024-06-11 → 2026-09-01full history
pumpfun_v2_swapsPump.fun1,641,917,804227.81 GB2024-11-02 → 2026-09-01full history
pfamm_migrationsPump.fun121,90228.6 MB2025-09-01 → 2026-09-011 year
pumpfun_creator_fee_distributionsPump.fun1,977,025320.2 MB2026-02-15 → 2026-09-01full history
pumpfun_amm_admin_set_coin_creatorPump.fun806150.5 KB2026-03-15 → 2026-08-31full history
pumpswap_all_swapsPumpSwap5,158,207,7811737.77 GB2025-09-01 → 2026-09-011 year
raydium_all_swapsRaydium20,278,3004.73 GB2024-11-02 → 2026-09-0190 days
raydium_cpmm_swapsRaydium16,641,2873.91 GB2024-11-02 → 2026-09-0190 days
raydium_launchpad_swapsRaydium21,165,6663.60 GB2025-09-01 → 2026-09-011 year
raydium_launchpad_token_creationRaydium66,09920.2 MB2025-04-16 → 2026-09-01full history
raydium_launchpad_migrationsRaydium85431.5 KB2025-09-02 → 2026-08-141 year
raydium_launchpad_cpmm_migrationsRaydium4,2154.3 MB2025-09-01 → 2026-08-311 year
meteora_swapsMeteora82,946,24120.49 GB2026-06-03 → 2026-09-0190 days
meteora_dynamic_bonding_swapsMeteora158,429,22143.50 GB2025-09-01 → 2026-09-011 year
jito_tipsJito155,598,24911.82 GB2026-08-18 → 2026-09-0114 days
token_transfersHelper201,556,68034.91 GB2026-08-01 → 2026-09-0131 days
sol_top_upsHelper218,557,06136.55 GB2024-11-02 → 2026-09-0131 days
solana_blocksHelper188,410,6369.70 GBfull chain history → 2026-09-01full history
tx_timestampsHelper00 Brolling window14 days
max_capsHelper9,353,726438.8 MBrolling windowfull 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 about 1.74 TB in this snapshot.

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-09-01
Retention: full history
Rows: 16,796,343 · Size: 4.36 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
creatorFixedString(48)Wallet that created the token
nameFixedString(20)Token name
symbolFixedString(16)Token ticker symbol
urlFixedString(256)Metadata URI (usually IPFS)
mintFixedString(48)Token mint address
bundle_sizeUInt8Number of transactions in the bundle
gas_usedUInt64Total gas used for token creation
amount_of_instructionsInt32Number of instructions in the transaction
amount_of_lookup_readsInt32Number of address lookup table reads
amount_of_lookup_writesInt32Number of address lookup table writes
bundle_structureStringStructure of bundled transactions
bundled_buysUInt64Total SOL amount in bundled buys
bundled_buys_countUInt64Number of bundled buy transactions
dev_balanceUInt64Developer's token balance after creation
creation_ix_indexInt32Index of creation instruction
curve_addressFixedString(48)Bonding curve account address
pf_program_indexUInt8Pump.fun program index in transaction
direct_pf_invocationUInt8Whether pump.fun was called directly (1=yes, 0=no)
versionDateTime64(3)Record version timestamp (populated since 2024-01-17)
mayhem_modeUInt8Whether mayhem mode was enabled (populated since 2025-11-12)
token_programStringToken program used (SPL Token or Token-2022) (populated since 2024-01-17)
signatureStringTransaction signature (base58 encoded) (populated since 2024-01-17)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2026-01-22)
is_cashback_enabledUInt8Whether cashback was enabled for creation (populated since 2026-02-18)
fee_payerStringWallet that paid the transaction fee (populated since 2024-11-02)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports) (populated since 2024-11-02)
provided_gas_limitUInt64Compute unit limit requested (populated since 2024-11-02)
feeUInt64Transaction fee paid (lamports) (populated since 2024-11-02)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2024-11-02)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
num_signaturesUInt8Number of signatures on the transaction (populated since 2024-11-02)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2024-11-02)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2024-11-02)
blockhash_prefixStringDefault: '' (populated since 2024-11-02)
quote_coinStringQuote token mint address (usually SOL or USDC) (populated since 2026-08-19)

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-09-01
Retention: full history
Rows: 2,508,366,154 · Size: 334.22 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
signing_walletFixedString(48)Wallet address that signed the transaction
directionStringTrade direction (buy/sell)
base_coinFixedString(48)Base token mint address
base_coin_amountUInt64Base token amount (raw units, needs decimal adjustment)
quote_coin_amountUInt64Quote token amount (raw units)
virtual_token_balance_afterUInt64Virtual token reserves after trade (bonding curve state)
virtual_sol_balance_afterUInt64Virtual SOL reserves after trade (bonding curve state)
signatureFixedString(128)Transaction signature (base58 encoded)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
is_exact_quoteUInt8Whether quote amount was exact (1=yes, 0=no) (populated since 2025-12-03)
parent_programStringParent 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-09-01
Retention: full history
Rows: 1,641,917,804 · Size: 227.81 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
ix_idxInt16Instruction index within the transaction (populated since 2024-11-02)
signing_walletStringWallet address that signed the transaction
fee_payerStringWallet that paid the transaction fee (populated since 2024-11-02)
directionLowCardinality(String)Trade direction (buy/sell)
base_coinStringBase token mint address
quote_coinLowCardinality(String)Quote token mint address (usually SOL or USDC)
instruction_typeLowCardinality(String)Pump.fun instruction variant: buy, sell, buy_v2, sell_v2, buy_exact_sol_in, or buy_exact_quote_in_v2
base_coin_amountUInt64Base token amount (raw units, needs decimal adjustment)
quote_coin_amountUInt64Quote token amount (raw units)
virtual_token_balance_afterUInt64Virtual token reserves after trade (bonding curve state)
virtual_sol_balance_afterUInt64Virtual SOL reserves after trade (bonding curve state)
signatureStringTransaction signature (base58 encoded)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2024-11-02)
failedUInt8Whether the transaction failed (1=yes, 0=no) (populated since 2024-11-02)
pf_program_account_indexInt16Default: -1 (populated since 2024-11-02)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2024-11-02)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
tip_indexInt16Default: -1 (populated since 2024-11-02)
blockhash_prefixStringDefault: '' (populated since 2024-11-02)
num_signaturesUInt8Number of signatures on the transaction (populated since 2024-11-02)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (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-09-01 → 2026-09-01
Retention: 1 year
Rows: 121,902 · Size: 28.6 MB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
userStringUser wallet address
mintStringToken mint address
mint_amountUInt64Token amount migrated
sol_amountUInt64SOL amount in the migration
pool_migration_feeUInt64Fee paid for pool migration
bonding_curveStringBonding curve account address
timestampUInt32Unix timestamp of migration
poolStringPool account address
signatureStringTransaction signature (base58 encoded) (populated since 2025-11-10)
parent_programStringParent 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-09-01
Retention: full history
Rows: 1,977,025 · Size: 320.2 MB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
ix_idxUInt32Instruction index within the transaction
signatureStringTransaction signature (base58 encoded)
fee_payerStringWallet that paid the transaction fee
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
mintStringToken mint address
receiverStringCreator wallet receiving the fee distribution
amountUInt64Fee amount distributed (lamports)
fee_distribution_methodStringMethod used for fee distribution (populated since 2026-02-15)
parent_programStringParent 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-31
Retention: full history
Rows: 806 · Size: 150.5 KB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
swap_idxInt32Swap index within the transaction
signatureStringTransaction signature (base58 encoded)
fee_payerStringWallet that paid the transaction fee
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
poolStringPool account being modified
parent_programStringParent program that invoked this instruction (for CPI calls)
top_level_transfers_jsonStringJSON 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-09-01 → 2026-09-01
Retention: 1 year
Rows: 5,158,207,781 · Size: 1737.77 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
signing_walletStringWallet address that signed the transaction
fee_payerStringWallet that paid the transaction fee
directionLowCardinality(String)Trade direction (buy/sell)
base_tokenStringBase token mint address
quote_tokenStringQuote token mint address
base_token_amountUInt64Base token amount (raw units)
quote_token_amountUInt64Quote token amount (raw units)
quote_token_amount_limitUInt64Maximum quote token amount limit
quote_token_amount_without_lp_feeUInt64Quote amount before LP fee deduction
user_base_token_accountStringUser's base token account
user_quote_token_accountStringUser's quote token account
user_base_token_reservesUInt64User's base token balance
user_quote_token_reservesUInt64User's quote token balance
pool_base_token_reserves_beforeUInt64Pool base token reserves before swap
pool_quote_token_reserves_beforeUInt64Pool quote token reserves before swap
pool_base_token_reserves_afterUInt64Pool base token reserves after swap
pool_quote_token_reserves_afterUInt64Pool quote token reserves after swap
lp_fee_basis_pointsUInt16LP fee in basis points
lp_feeUInt64LP fee amount
protocol_fee_basis_pointsUInt16Protocol fee in basis points
protocol_feeUInt64Protocol fee amount
signatureStringTransaction signature (base58 encoded)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
poolStringPool account address (populated since 2025-09-01)
is_exact_quoteUInt8Whether quote amount was exact (1=yes, 0=no) (populated since 2025-12-03)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2025-12-13)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2026-02-18)
coin_creatorStringDefault: '' (populated since 2026-07-23)
coin_creator_fees_basis_pointsUInt64Default: 0 (populated since 2026-07-23)
coin_creator_feesUInt64Default: 0 (populated since 2026-07-23)
cash_back_fees_basis_pointsUInt64Default: 0 (populated since 2026-07-23)
cash_back_feesUInt64Default: 0 (populated since 2026-07-23)
buy_back_fees_basis_pointsUInt64Default: 0 (populated since 2026-07-23)
buy_back_feesUInt64Default: 0 (populated since 2026-07-23)
virtual_quote_reservesInt128Default: 0 (populated since 2026-07-23)
can_boostUInt8Default: 0 (populated since 2026-07-23)
base_supplyUInt64Default: 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: 2024-11-02 → 2026-09-01
Retention: 90 days
Rows: 20,278,300 · Size: 4.73 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
signing_walletFixedString(48)Wallet address that signed the transaction
directionStringTrade direction (buy/sell)
base_coinFixedString(48)Base token mint address
quote_coinFixedString(48)Quote token mint address (usually SOL or USDC)
base_coin_amountUInt64Base token amount (raw units, needs decimal adjustment)
quote_coin_amountUInt64Quote token amount (raw units)
base_pool_balance_beforeUInt64Pool base token balance before swap
quote_pool_balance_beforeUInt64Pool quote token balance before swap
base_pool_balance_afterUInt64Pool base token balance after swap
quote_pool_balance_afterUInt64Pool quote token balance after swap
signatureFixedString(128)Transaction signature (base58 encoded)
serum_market_idFixedString(48)OpenBook/Serum market ID (for hybrid pools)
raydium_market_idFixedString(48)Raydium AMM market ID
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2024-11-02)
instruction_typeLowCardinality(String)Default: '' (populated since 2024-11-02)
blockhash_prefixStringDefault: '' (populated since 2024-11-02)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2024-11-02)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2024-11-02)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
num_signaturesUInt8Number of signatures on the transaction (populated since 2024-11-02)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2024-11-02)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02)

raydium_cpmm_swaps

Raydium CPMM swaps with pool sizes, per-side fees, and swap type.

Partition key: block_date_utc
History: 2024-11-02 → 2026-09-01
Retention: 90 days
Rows: 16,641,287 · Size: 3.91 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
swap_idxUInt16Swap index within the transaction
signatureStringTransaction signature (base58 encoded)
fee_payerStringWallet that paid the transaction fee
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
pool_idStringPool account address
signerStringWallet address that signed the transaction
directionLowCardinality(String)Trade direction (buy/sell)
base_coinStringBase token mint address
quote_coinStringQuote token mint address (usually SOL or USDC)
base_coin_amountUInt64Base token amount (raw units, needs decimal adjustment)
quote_coin_amountUInt64Quote token amount (raw units)
base_coin_slippageInt64Slippage on base token
quote_coin_slippageInt64Slippage on quote token
parent_programStringParent program that invoked this instruction (for CPI calls)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
input_token_pool_size_beforeUInt64Input token pool size before swap
output_token_pool_size_beforeUInt64Output token pool size before swap
tokens_inUInt64Tokens received by pool
tokens_outUInt64Tokens sent from pool
fee_in_token_inUInt64Fee denominated in input token
fee_in_token_outUInt64Fee denominated in output token
swap_typeLowCardinality(String)Type of swap (BaseIn/BaseOut)
instruction_input1UInt64First instruction input parameter
instruction_input2UInt64Second instruction input parameter
input_token_mintStringInput token mint address
output_token_mintStringOutput 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-09-01 → 2026-09-01
Retention: 1 year
Rows: 21,165,666 · Size: 3.60 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
fee_payerStringWallet that paid the transaction fee
directionLowCardinality(String)Trade direction (buy/sell)
pool_statusUInt8Pool status code
pool_stateStringPool state account address
base_tokenStringBase token mint address
quote_tokenStringQuote token mint address
total_base_sellUInt64Total base tokens available for sale
virtual_baseUInt64Virtual base token reserves
virtual_quoteUInt64Virtual quote token reserves
pool_base_token_reserves_beforeUInt64Pool base token reserves before swap
pool_quote_token_reserves_beforeUInt64Pool quote token reserves before swap
pool_base_token_reserves_afterUInt64Pool base token reserves after swap
pool_quote_token_reserves_afterUInt64Pool quote token reserves after swap
base_token_amountUInt64Base token amount (raw units)
quote_token_amountUInt64Quote token amount (raw units)
protocol_feeUInt64Protocol fee amount
platform_feeUInt64Platform fee amount
share_feeUInt64Share/referral fee amount
signatureStringTransaction signature (base58 encoded)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
blockhash_prefixStringDefault: '' (populated since 2026-08-19)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2026-08-19)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-19)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2026-08-19)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2026-08-19)
num_signaturesUInt8Number of signatures on the transaction (populated since 2026-08-19)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-19)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-19)
instruction_typeLowCardinality(String)Default: '' (populated since 2026-08-30)

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 → 2026-09-01
Retention: full history
Rows: 66,099 · Size: 20.2 MB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
creatorFixedString(48)Wallet that created the token
nameFixedString(20)Token name
symbolFixedString(16)Token ticker symbol
urlFixedString(256)Metadata URI (usually IPFS)
mintFixedString(48)Token mint address
bundle_sizeUInt8Number of transactions in the bundle
gas_usedUInt64Total gas used for token creation
amount_of_instructionsInt32Number of instructions in the transaction
amount_of_lookup_readsInt32Number of address lookup table reads
amount_of_lookup_writesInt32Number of address lookup table writes
bundle_structureStringStructure of bundled transactions
bundled_buysUInt64Total SOL amount in bundled buys
bundled_buys_countUInt64Number of bundled buy transactions
dev_balanceUInt64Developer's token balance after creation
creation_ix_indexInt32Index of creation instruction
pool_stateFixedString(48)Pool state account address
base_vaultFixedString(48)Base token vault address
quote_vaultFixedString(48)Quote token vault address
raydium_program_indexUInt8Raydium program index in transaction
direct_raydium_invocationBoolWhether Raydium was called directly
decimalsUInt8Token decimals
cpmm_typeUInt8CPMM pool type
supplyUInt64Total token supply
bonding_curve_sell_amountUInt64Amount available for bonding curve sale
bonding_curve_raise_amountUInt64Target raise amount for bonding curve
migrate_typeUInt8Migration type after bonding curve
versionDateTime64(3)Record version timestamp (populated since 2025-04-16)
instruction_typeLowCardinality(String)Default: '' (populated since 2026-08-30)
amm_fee_onUInt8Default: 0
transfer_fee_basis_pointsUInt16Default: 0
transfer_fee_maxUInt64Default: 0
signatureStringTransaction signature (base58 encoded) (populated since 2026-08-30)
parent_programStringParent program that invoked this instruction (for CPI calls)
fee_payerStringWallet that paid the transaction fee (populated since 2026-08-30)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports) (populated since 2026-08-30)
provided_gas_limitUInt64Compute unit limit requested (populated since 2026-08-30)
feeUInt64Transaction fee paid (lamports) (populated since 2026-08-30)
consumed_gasUInt64Compute units actually consumed (populated since 2026-08-30)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2026-08-30)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2026-08-30)
num_signaturesUInt8Number of signatures on the transaction (populated since 2026-08-30)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-30)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-30)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-30)
blockhash_prefixStringDefault: '' (populated since 2026-08-30)

raydium_launchpad_migrations

Raydium Launchpad graduations into AMM / OpenBook markets.

Partition key: block_date_utc
History: 2025-09-02 → 2026-08-14
Retention: 1 year
Rows: 85 · Size: 431.5 KB

ColumnTypeDescription
signatureStringTransaction signature (base58 encoded)
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
payerStringWallet that paid for the migration
base_coinStringBase token mint address
quote_coinStringQuote token mint address (usually SOL or USDC)
openbook_programStringOpenBook program address
serum_market_idStringOpenBook market ID
request_queueStringOpenBook request queue
event_queueStringOpenBook event queue
bidsStringOpenBook bids account
asksStringOpenBook asks account
market_vault_signerStringOpenBook vault signer
market_base_vaultStringOpenBook base token vault
market_quote_vaultStringOpenBook quote token vault
raydium_programStringRaydium AMM program address
raydium_market_idStringRaydium AMM market ID
amm_authorityStringRaydium AMM authority
amm_open_ordersStringRaydium open orders account
lp_mintStringLP token mint address
base_pool_balance_beforeStringPool base token balance before migration
quote_pool_balance_beforeStringPool quote token balance before migration
amm_target_ordersStringRaydium target orders account
amm_configStringRaydium AMM configuration
amm_create_fee_destStringDestination for AMM creation fee
authorityStringLaunchpad authority account
pool_stateStringLaunchpad pool state account
global_configStringGlobal configuration account
user_token_coinStringUser's base token account
user_token_pcStringUser's quote token account
user_lp_token_accountStringUser's LP token account
token_programStringToken program address
associated_token_programStringAssociated token program address
system_programStringSystem program address
rent_programStringRent sysvar address
parent_programStringParent program that invoked this instruction (for CPI calls)
failedBoolWhether the transaction failed (1=yes, 0=no)
fee_payerStringWallet that paid the transaction fee
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction
num_signaturesUInt8Number of signatures on the transaction
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
blockhash_prefixStringDefault: ''

raydium_launchpad_cpmm_migrations

Raydium Launchpad graduations into CPMM pools, with every account involved in the migration.

Partition key: block_date_utc
History: 2025-09-01 → 2026-08-31
Retention: 1 year
Rows: 4,215 · Size: 4.3 MB

ColumnTypeDescription
signatureStringTransaction signature (base58 encoded)
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
payerStringWallet that paid for the migration
base_mintStringBase token mint address
quote_mintStringQuote token mint address
platform_configStringPlatform configuration account
cpswap_programStringCPMM swap program address
cpswap_poolStringNew CPMM pool address
cpswap_authorityStringCPMM pool authority
cpswap_lp_mintStringCPMM LP token mint
cpswap_base_vaultStringCPMM base token vault
cpswap_quote_vaultStringCPMM quote token vault
cpswap_configStringCPMM configuration account
cpswap_create_pool_feeStringFee account for pool creation
cpswap_observationStringCPMM observation account (for TWAP)
lock_programStringLP lock program address
lock_authorityStringLP lock authority
lock_lp_vaultStringVault holding locked LP tokens
authorityStringLaunchpad authority account
pool_stateStringLaunchpad pool state account
global_configStringGlobal configuration account
base_vaultStringLaunchpad base token vault
quote_vaultStringLaunchpad quote token vault
pool_lp_tokenStringPool LP token account
parent_programStringParent program that invoked this instruction (for CPI calls)
failedBoolWhether the transaction failed (1=yes, 0=no)
fee_payerStringWallet that paid the transaction fee (populated since 2026-08-30)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports) (populated since 2026-08-30)
provided_gas_limitUInt64Compute unit limit requested (populated since 2026-08-30)
feeUInt64Transaction fee paid (lamports) (populated since 2026-08-30)
consumed_gasUInt64Compute units actually consumed (populated since 2026-08-30)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2026-08-30)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction
num_signaturesUInt8Number of signatures on the transaction (populated since 2026-08-30)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-30)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-30)
blockhash_prefixStringDefault: '' (populated since 2026-08-30)

meteora_swaps

Meteora DLMM swaps with the bin range crossed and the full fee breakdown.

Partition key: block_date
History: 2026-06-03 → 2026-09-01
Retention: 90 days
Rows: 82,946,241 · Size: 20.49 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_dateDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
signing_walletStringWallet address that signed the transaction
base_coinStringBase token mint address
quote_coinStringQuote token mint address (usually SOL or USDC)
base_coin_amountUInt64Base token amount (raw units, needs decimal adjustment)
quote_coin_amountUInt64Quote token amount (raw units)
start_bin_idInt32Starting bin ID in the DLMM pool
end_bin_idInt32Ending bin ID after the swap
feeUInt64Transaction fee paid (lamports)
protocol_feeUInt64Protocol fee amount
fee_bps_lowUInt64Lower bound of fee in basis points
fee_bps_highUInt64Upper bound of fee in basis points
host_feeUInt64Host/frontend fee amount
signatureStringTransaction signature (base58 encoded)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
fee_paidUInt64Total fee paid
consumed_gasUInt64Compute units actually consumed
lb_pairStringLiquidity bin pair (pool) address
from_walletStringSource wallet for the swap
swap_for_yUInt8Whether swapping for Y token (1=yes, 0=no)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2026-06-03)
blockhash_prefixStringDefault: '' (populated since 2026-08-19)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-19)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2026-08-19)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2026-08-19)
num_signaturesUInt8Number of signatures on the transaction (populated since 2026-08-19)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-19)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-19)

meteora_dynamic_bonding_swaps

Meteora Dynamic Bonding Curve swaps, including slippage, routing amounts, and referral fields.

Partition key: block_date_utc
History: 2025-09-01 → 2026-09-01
Retention: 1 year
Rows: 158,429,221 · Size: 43.50 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
swap_idxUInt16Swap index within the transaction
signatureStringTransaction signature (base58 encoded)
fee_payerStringWallet that paid the transaction fee
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
pool_idStringPool account address
signerStringWallet address that signed the transaction
directionLowCardinality(String)Trade direction (buy/sell)
base_coinStringBase token mint address
quote_coinStringQuote token mint address (usually SOL or USDC)
base_coin_amountUInt64Base token amount (raw units, needs decimal adjustment)
quote_coin_amountUInt64Quote token amount (raw units)
base_coin_slippageInt64Slippage on base token (negative = less than expected)
quote_coin_slippageInt64Slippage on quote token (negative = less than expected)
parent_programStringParent program that invoked this instruction (for CPI calls)
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
orig_base_coin_amountUInt64Original base amount before slippage
orig_quote_coin_amountUInt64Original quote amount before slippage
configStringPool configuration account
trade_directionUInt64Numeric trade direction indicator
has_referralUInt8Whether trade included a referral (1=yes, 0=no)
swap_amount0StringFirst swap amount in the route
swap_amount1StringSecond swap amount in the route
swap_modeUInt64Swap mode (exact in/out)
input_amountStringInput amount for the swap
output_amountStringOutput amount from the swap
base_mintStringBase token mint address
quote_mintStringQuote token mint address
referralStringReferral account address (if any)
blockhash_prefixStringDefault: '' (populated since 2026-08-19)
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction (populated since 2026-08-19)
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction (populated since 2026-08-19)
num_signaturesUInt8Number of signatures on the transaction (populated since 2026-08-19)
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-19)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-19)
curve_completeUInt8Default: 0 (populated since 2026-08-30)
base_reserve_afterUInt64Default: 0 (populated since 2026-08-30)
quote_reserve_afterUInt64Default: 0 (populated since 2026-08-30)

jito_tips

Jito tip payments: who tipped, which tip account received it, how much.

Partition key: block_date_utc
History: 2026-08-18 → 2026-09-01
Retention: 14 days
Rows: 155,598,249 · Size: 11.82 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
signatureStringTransaction signature (base58 encoded)
signerStringWallet address that signed the transaction
senderStringWallet that sent the tip
tip_accountStringJito tip account that received the tip
amountUInt64Tip amount in lamports

token_transfers

Top-level SPL and Token-2022 instructions, including token transfers and token-account owner changes. For token flow analysis, filter flavour to exclude owner changes. See Wallet transfers and SOL funding for a worked query and coverage of program-executed transfers.

Partition key: block_date_utc
History: 2026-08-01 → 2026-09-01
Retention: 31 days
Rows: 201,556,680 · Size: 34.91 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
failedUInt8Whether the transaction failed (1=yes, 0=no)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction
num_signaturesUInt8Number of signatures on the transaction
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only)
signatureStringTransaction signature (base58 encoded)
fee_payerStringWallet that paid the transaction fee
mintStringToken mint address
src_walletStringOwner of the source token account
dst_walletStringOwner of the destination token account
amountUInt64Token amount transferred in raw base units (apply the mint's decimals for display)
flavourUInt8Transfer encoding: add 16 for Token-2022; base values are 0=Transfer, 1=TransferChecked, 2=TransferCheckedWithFee, and 3=SetAuthority owner change
ix_idxInt16Instruction index within the transaction
signersArray(String)Transaction signers in message order. Documented in the 26 October 2026 schema.

sol_top_ups

SOL balances that went from zero to positive in a successful transaction, excluding token accounts. Each transaction signer gets a row for each qualifying receiver. To trace larger balance changes regardless of the starting balance, see SOL funding.

Partition key: block_date_utc
History: 2024-11-02 → 2026-09-01
Retention: 31 days
Rows: 218,557,061 · Size: 36.55 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
block_date_utcDateUTC date of the block (for partitioning)
slotUInt32Solana slot number (block height)
tx_idxUInt16Transaction index within the block
failedUInt8Whether the transaction failed (1=yes, 0=no)
provided_gas_feeUInt64Gas fee provided for the transaction (lamports)
provided_gas_limitUInt64Compute unit limit requested
feeUInt64Transaction fee paid (lamports)
consumed_gasUInt64Compute units actually consumed
cu_price_ix_indexInt16Instruction index of the compute-unit price instruction
cu_limit_ix_indexInt16Instruction index of the compute-unit limit instruction
num_signaturesUInt8Number of signatures on the transaction
top_level_transfers_jsonStringJSON array of top-level SOL/token transfers in the transaction
transaction_versionInt8Transaction message version (-1=legacy, 0=v0, -2=unknown)
lookup_tablesStringPipe-delimited account addresses loaded through address lookup tables (writable first, then read-only)
signatureStringTransaction signature (base58 encoded)
fee_payerStringWallet that paid the transaction fee
src_walletStringA signer of the transaction. It can differ from the funding source.
dst_walletStringReceiver that went from zero lamports to a positive balance. Can be a program-controlled account.
amountUInt64Receiver's post-transaction balance in lamports. It repeats across rows for the same receiver and transaction.
signersArray(String)Transaction signers in message order. Documented in the 26 October 2026 schema.

solana_blocks

Block-level index: hash, validator identity, rewards, and transaction count.

Partition key: not partitioned
History: full chain history → 2026-09-01
Retention: full history
Rows: 188,410,636 · Size: 9.70 GB

ColumnTypeDescription
block_timeDateTimeUTC timestamp when the block was produced
slotUInt32Solana slot number (block height)
hashFixedString(48)Block hash
validatorFixedString(48)Validator identity that produced the block
rewardsUInt64Total rewards in the block (lamports) (populated since 2024-11-02)
amount_of_transactionsUInt64Number 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: 0 · Size: 0 B

ColumnTypeDescription
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
entry_timestampFloat64Entry timestamp (high-precision Unix timestamp)
signatureStringTransaction 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

ColumnTypeDescription
token_mintStringToken mint address
max_mcap_solSimpleAggregateFunction(max, Float32)Maximum market cap reached (in SOL)
max_mcap_usdcSimpleAggregateFunction(max, Float32)Maximum market cap reached (in USDC)
max_slotSimpleAggregateFunction(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.