Are you an LLM? Read llms.txt for a summary of the docs, or llms-full.txt for the full context.
Skip to content

Solana Tables

Tables containing Solana blockchain data including DEX swaps, token trades, and transaction information.

Last updated: 2026-05-23 21:00 UTC

Tables (19)

TableRowsSize
jito_tips163,385,54612.22 GB
max_caps9,353,726438.8 MB
meteora_dynamic_bonding_swaps121,223,05334.53 GB
meteora_swaps63,970,58011.16 GB
pfamm_migrations75,42515.2 MB
pumpfun_all_swaps2,227,521,668279.34 GB
pumpfun_amm_admin_set_coin_creator34265.3 KB
pumpfun_creator_fee_distributions1,459,963239.9 MB
pumpfun_token_creation13,535,8963.30 GB
pumpfun_v2_swaps4,945,6141.03 GB
pumpswap_all_swaps5,537,777,5971591.48 GB
raydium_all_swaps21,469,1651.85 GB
raydium_cpmm_swaps28,520,6175.84 GB
raydium_launchpad_cpmm_migrations4,0953.9 MB
raydium_launchpad_migrations3641023.3 KB
raydium_launchpad_swaps81,219,76113.39 GB
raydium_launchpad_token_creation65,56819.9 MB
solana_blocks166,201,9018.33 GB
tx_timestamps1,856,043,186165.26 GB

jito_tips

StatisticValue
Rows163,385,546
Size12.22 GB
First Record2024-11-15
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalDay(14)
Columns:
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
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
block_date_utc2026-05-23
slot421,711,764
tx_idx1,503
signature5NqJSzRpyARonAFfqdprKxhXNvGREDmKA7dxTuwVpYvoqPC...
signerFVnv5qH7dsrBzEDwJ8dN2m9PFtKTBAQFtqWF3M9LpwMg
senderFVnv5qH7dsrBzEDwJ8dN2m9PFtKTBAQFtqWF3M9LpwMg
tip_accountDttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL
Example Query:
ClickHouse (solana)

max_caps

StatisticValue
Rows9,353,726
Size438.8 MB
Columns:
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
Latest Record Sample:
ColumnValue
token_mint112BvbiE2nbCcsPCHutzCBJmtSdhY4EXYGKJQyPpump
max_mcap_sol134.592
max_mcap_usdc30780.7
max_slot0
Example Query:
ClickHouse (solana)

meteora_dynamic_bonding_swaps

StatisticValue
Rows121,223,053
Size34.53 GB
First Record2025-08-18
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalYear(1)
Columns:
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)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:19
block_date_utc2026-05-23
slot421,711,757
tx_idx138
swap_idx8
signature45GTw2X23fmxyv4PrvjJNFfT8uuiL58FHtZS9BDPV3bwG2e...
fee_payerAvdQRq82hfuTLAmFMkkPy2XsTdoNzGmU7mq54vGjGDEZ
provided_gas_fee400,000
Example Query:
ClickHouse (solana)

meteora_swaps

StatisticValue
Rows63,970,580
Size11.16 GB
First Record2026-02-22
Last Record2026-05-23
Partition Keyblock_date
TTLblock_date + toIntervalDay(90)
Columns:
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-02-22)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
block_date2026-05-23
slot421,711,764
tx_idx1,484
signing_walletJD6rVaerbyz6wjQ433nrw6bFTgFrp46MiYmi8EtUAfsG
base_coin4nyYwRTETgwa9pAUDxirve3FFUV1zSpsu9mvsPCupump
quote_coinEs9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB
base_coin_amount2,582,929
Example Query:
ClickHouse (solana)

pfamm_migrations

StatisticValue
Rows75,425
Size15.2 MB
First Record2025-05-23
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalYear(1)
Columns:
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 2026-01-21)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2026-01-22)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:54:15
block_date_utc2026-05-23
slot421,710,993
tx_idx607
userBnnNJJgy9w2MLQ9XBKJKG9FQa2r9qdW7u5VpzEkwUcc3
mint8EEvvmDQRxQHWygwMAxUqXReBg9kmGzRfcf9XyHepump
mint_amount206,900,000,000,000
sol_amount84,990,359,064
Example Query:
ClickHouse (solana)

pumpfun_all_swaps

StatisticValue
Rows2,227,521,668
Size279.34 GB
First Record2024-06-11
Last Record2026-05-23
Columns:
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-15)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
slot421,711,764
tx_idx1,502
signing_walletb'BwWK17cbHxwWBKZkUYvzxLcNQ1YVyaFezduWbtm2de6s\x00
directionbuy
base_coinb'CwyxXpdwFnvR2GrfK9Xvv5f96Nfcvfy1ygPcgL8Epump\x00
base_coin_amount1,970,279,349,080
quote_coin_amount23,294,377
Example Query:
ClickHouse (solana)

pumpfun_amm_admin_set_coin_creator

StatisticValue
Rows342
Size65.3 KB
First Record2026-03-15
Last Record2026-05-23
Partition KeytoYYYYMM(block_time)
Columns:
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
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 11:59:33
block_date_utc2026-05-23
slot421,693,716
tx_idx997
swap_idx15
signature3JALGHVznb2dqjQzmE84FYej6BJCr1Rvrz4CskbSbCABheT...
fee_payerDrmq6DFr6j63QgCewPDSVNoumpcgZ12VhaRoe1kMRwR7
provided_gas_fee62,633
Example Query:
ClickHouse (solana)

pumpfun_creator_fee_distributions

StatisticValue
Rows1,459,963
Size239.9 MB
First Record2026-02-15
Last Record2026-05-23
Partition KeytoYYYYMMDD(block_time)
Columns:
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)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:58:42
block_date_utc2026-05-23
slot421,711,664
tx_idx484
ix_idx2
signaturetVzdGkyvTJUpVJmr9tmrhNvSvdEnvzp1L3aYByFdhUZEYeS...
fee_payerJ7oeos72uyK15VRZk4sBp2M79bMsk1siQorz3keJVjHL
provided_gas_fee100
Example Query:
ClickHouse (solana)

pumpfun_token_creation

StatisticValue
Rows13,535,896
Size3.30 GB
First Record2024-11-15
Last Record2026-05-23
Columns:
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-11-15)
mayhem_modeUInt8Whether mayhem mode was enabled (populated since 2025-11-23)
token_programStringToken program used (SPL Token or Token-2022) (populated since 2024-11-15)
signatureStringTransaction signature (base58 encoded) (populated since 2024-11-15)
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)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:21
slot421,711,763
tx_idx1,083
creatorb'HVwXuVnEey6r7qGH6nEJWPCu6rBTAxPaegoJh5H49rPQ\x00
nameb'10m pnl btw\x00\x00\x00\x00\x00\x00\x00\x00\x00'
symbolb'ARYAN\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0
urlb'https://metadata.j7tracker.io/metadata/e9767f6bf
mintb'6UAYtPdr1LsEVExMqqYM9ebDzpkvuhgncqc9kZ96pump\x00
Example Query:
ClickHouse (solana)

pumpfun_v2_swaps

StatisticValue
Rows4,945,614
Size1.03 GB
First Record2024-11-15
Last Record2026-05-23
Partition Key(block_date_utc, failed)
Columns:
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-15)
signing_walletStringWallet address that signed the transaction
fee_payerStringWallet that paid the transaction fee (populated since 2024-11-15)
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_tablesStringDefault: '' (populated since 2024-11-15)
parent_programStringParent program that invoked this instruction (for CPI calls) (populated since 2024-11-15)
failedUInt8Default: 0 (populated since 2024-11-15)
pf_program_account_indexInt16Default: -1 (populated since 2024-11-15)
cu_price_ix_indexInt16Default: -1 (populated since 2024-11-15)
cu_limit_ix_indexInt16Default: -1 (populated since 2024-11-15)
tip_indexInt16Default: -1 (populated since 2024-11-15)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
block_date_utc2026-05-23
slot421,711,764
tx_idx1,223
ix_idx3
signing_walletBwWK17cbHxwWBKZkUYvzxLcNQ1YVyaFezduWbtm2de6s
fee_payerGygj9QQby4j2jryqyqBHvLP7ctv2SaANgh4sCb69BUpA
directionsell
Example Query:
ClickHouse (solana)

pumpswap_all_swaps

StatisticValue
Rows5,537,777,597
Size1591.48 GB
First Record2025-05-23
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalYear(1)
Columns:
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-05-23)
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)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
block_date_utc2026-05-23
slot421,711,764
tx_idx1,490
signing_wallet6swP6EWWFTaMnep6HS4FNcZRENZKq9JN3wCHpasmLmav
fee_payer6swP6EWWFTaMnep6HS4FNcZRENZKq9JN3wCHpasmLmav
directionS
base_tokenSo11111111111111111111111111111111111111112
Example Query:
ClickHouse (solana)

raydium_all_swaps

StatisticValue
Rows21,469,165
Size1.85 GB
First Record2024-11-15
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalDay(90)
Columns:
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-15)
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
block_date_utc2026-05-23
slot421,711,764
tx_idx1,254
signing_walletb'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa\x00\
directionS
base_coinb'63LfDmNb3MQ8mw9MtZ2To9bEA2M71kZUUGq5tiJxcqj9\x00
quote_coinb'So11111111111111111111111111111111111111112\x00\
Example Query:
ClickHouse (solana)

raydium_cpmm_swaps

StatisticValue
Rows28,520,617
Size5.84 GB
First Record2024-11-15
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalDay(90)
Columns:
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
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:59:22
block_date_utc2026-05-23
slot421,711,764
tx_idx50
swap_idx13
signature5rR47abX7Fx2xksrfh1Krc72yry78u7aRPJf7KhPaQK8aZm...
fee_payer3Wm5W6eAkZdxqPEC1raB2td74DXc8cchWSFfsVWDXRRK
provided_gas_fee4,608,144
Example Query:
ClickHouse (solana)

raydium_launchpad_cpmm_migrations

StatisticValue
Rows4,095
Size3.9 MB
First Record2025-07-01
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalYear(1)
Columns:
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
Latest Record Sample:

View on Solscan

ColumnValue
signatureK5MwogqQ9sTWrY8TLkWLLKgHaKy3EzBa5sJuTsn9NHkyA8o...
block_time2026-05-23 05:57:08
block_date_utc2026-05-23
slot421,639,294
tx_idx645
payerRAYpQbFNq9i3mu6cKpTKKRwwHFDeK5AuZz8xvxUrCgw
base_mintDGNjYDB8pAJ6VSotNjkfQkWLNoMfMxiuJzmm1GuV1Ron
quote_mintSo11111111111111111111111111111111111111112
Example Query:
ClickHouse (solana)

raydium_launchpad_migrations

StatisticValue
Rows364
Size1023.3 KB
First Record2025-05-25
Last Record2026-05-18
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalYear(1)
Columns:
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
Latest Record Sample:

View on Solscan

ColumnValue
signature2ANgoXEHhd7GXkJn61Vr9ZDzdwrcMMix8dyL8urp4Atzuib...
block_time2026-05-18 15:26:33
block_date_utc2026-05-18
slot420,643,167
tx_idx83
payerRAYzrepoBdjSFg7MZj2vy4XBSv2azKRXC72ztUMZMJB
base_coin9EtWvVcMwHKGTHtHGetvknbRYkN5oo7P6inroewibonk
quote_coinSo11111111111111111111111111111111111111112
Example Query:
ClickHouse (solana)

raydium_launchpad_swaps

StatisticValue
Rows81,219,761
Size13.39 GB
First Record2025-05-23
Last Record2026-05-23
Partition Keyblock_date_utc
TTLblock_date_utc + toIntervalYear(1)
Columns:
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
Latest Record Sample:

View on Solscan

ColumnValue
block_time2026-05-23 13:58:27
block_date_utc2026-05-23
slot421,711,626
tx_idx737
fee_payerAP25fSHL6QhuSzB8EGqtuRTs5gnusuZ4xE4kV1ifXRR4
directionB
pool_status0
pool_stateAjcYg36QKWVy4L5SE3g2x61TQ1bYT1RSmjw6u5iRubHM
Example Query:
ClickHouse (solana)

raydium_launchpad_token_creation

StatisticValue
Rows65,568
Size19.9 MB
First Record2025-04-16
Last Record2025-10-15
Columns:
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)
Latest Record Sample:
ColumnValue
block_time2025-10-15 17:36:42
slot373,641,138
tx_idx714
creatorb'CrjJT78c3WpSz4kz4x3bawjd8UACGPowMjuz5tKV8NJh\x00
nameb'Important Coin\x00\x00\x00\x00\x00\x00'
symbolb'IMPORTANT\x00\x00\x00\x00\x00\x00\x00'
urlb'https://ipfs.io/ipfs/bafkreif4q7un34ghowsetmgmx6
mintb'6JGaQcHA1ZoJ1C3RVVmnbK3S66Xvh7zRLN7piVjsbonk\x00
Example Query:
ClickHouse (solana)

solana_blocks

StatisticValue
Rows166,201,901
Size8.33 GB
First Record1969-12-31
Last Record2026-05-23
Columns:
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-15)
amount_of_transactionsUInt64Number of transactions in the block (populated since 1969-12-31)
Latest Record Sample:
ColumnValue
block_time2026-05-23 13:59:22
slot421,711,764
hashb'Ak82ch9kEWULHXgE4gskv8dxMv2gSZVhLp3S8XjFEDpc\x00
validatorb'1unarWPGGseFag2WfnoFv8o9P7vTPU8eHex9GinP3eY\x00\
rewards18,197,551
amount_of_transactions1,507
Example Query:
ClickHouse (solana)

tx_timestamps

StatisticValue
Rows1,856,043,186
Size165.26 GB
Partition KeytoYYYYMMDD(toDateTime(entry_timestamp))
TTLtoDateTime(entry_timestamp) + toIntervalDay(14)
Columns:
ColumnTypeDescription
slotUInt64Solana slot number (block height)
tx_idxUInt32Transaction index within the block
entry_timestampFloat64Entry timestamp (high-precision Unix timestamp)
signatureStringTransaction signature (base58 encoded)
Latest Record Sample:

View on Solscan

ColumnValue
slot421,712,081
tx_idx1,299
entry_timestamp1.77957e+09
signature3aDBDzSgx5zASxA2RonrYXjo8T9S2Jpv5YZoqMjqgFJn47p...
Example Query:
ClickHouse (solana)