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)

Table	Rows	Size
jito_tips	163,385,546	12.22 GB
max_caps	9,353,726	438.8 MB
meteora_dynamic_bonding_swaps	121,223,053	34.53 GB
meteora_swaps	63,970,580	11.16 GB
pfamm_migrations	75,425	15.2 MB
pumpfun_all_swaps	2,227,521,668	279.34 GB
pumpfun_amm_admin_set_coin_creator	342	65.3 KB
pumpfun_creator_fee_distributions	1,459,963	239.9 MB
pumpfun_token_creation	13,535,896	3.30 GB
pumpfun_v2_swaps	4,945,614	1.03 GB
pumpswap_all_swaps	5,537,777,597	1591.48 GB
raydium_all_swaps	21,469,165	1.85 GB
raydium_cpmm_swaps	28,520,617	5.84 GB
raydium_launchpad_cpmm_migrations	4,095	3.9 MB
raydium_launchpad_migrations	364	1023.3 KB
raydium_launchpad_swaps	81,219,761	13.39 GB
raydium_launchpad_token_creation	65,568	19.9 MB
solana_blocks	166,201,901	8.33 GB
tx_timestamps	1,856,043,186	165.26 GB

jito_tips

Statistic	Value
Rows	163,385,546
Size	12.22 GB
First Record	2024-11-15
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalDay(14)`

Columns:

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

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,764`
`tx_idx`	`1,503`
`signature`	`5NqJSzRpyARonAFfqdprKxhXNvGREDmKA7dxTuwVpYvoqPC...`
`signer`	`FVnv5qH7dsrBzEDwJ8dN2m9PFtKTBAQFtqWF3M9LpwMg`
`sender`	`FVnv5qH7dsrBzEDwJ8dN2m9PFtKTBAQFtqWF3M9LpwMg`
`tip_account`	`DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL`

Example Query:

ClickHouse (solana)

max_caps

Statistic	Value
Rows	9,353,726
Size	438.8 MB

Columns:

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

Latest Record Sample:

Column	Value
`token_mint`	`112BvbiE2nbCcsPCHutzCBJmtSdhY4EXYGKJQyPpump`
`max_mcap_sol`	`134.592`
`max_mcap_usdc`	`30780.7`
`max_slot`	`0`

Example Query:

ClickHouse (solana)

meteora_dynamic_bonding_swaps

Statistic	Value
Rows	121,223,053
Size	34.53 GB
First Record	2025-08-18
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalYear(1)`

Columns:

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)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:19`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,757`
`tx_idx`	`138`
`swap_idx`	`8`
`signature`	`45GTw2X23fmxyv4PrvjJNFfT8uuiL58FHtZS9BDPV3bwG2e...`
`fee_payer`	`AvdQRq82hfuTLAmFMkkPy2XsTdoNzGmU7mq54vGjGDEZ`
`provided_gas_fee`	`400,000`

Example Query:

ClickHouse (solana)

meteora_swaps

Statistic	Value
Rows	63,970,580
Size	11.16 GB
First Record	2026-02-22
Last Record	2026-05-23
Partition Key	`block_date`
TTL	`block_date + toIntervalDay(90)`

Columns:

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-02-22)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`block_date`	`2026-05-23`
`slot`	`421,711,764`
`tx_idx`	`1,484`
`signing_wallet`	`JD6rVaerbyz6wjQ433nrw6bFTgFrp46MiYmi8EtUAfsG`
`base_coin`	`4nyYwRTETgwa9pAUDxirve3FFUV1zSpsu9mvsPCupump`
`quote_coin`	`Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB`
`base_coin_amount`	`2,582,929`

Example Query:

ClickHouse (solana)

pfamm_migrations

Statistic	Value
Rows	75,425
Size	15.2 MB
First Record	2025-05-23
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalYear(1)`

Columns:

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 2026-01-21)
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls) (populated since 2026-01-22)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:54:15`
`block_date_utc`	`2026-05-23`
`slot`	`421,710,993`
`tx_idx`	`607`
`user`	`BnnNJJgy9w2MLQ9XBKJKG9FQa2r9qdW7u5VpzEkwUcc3`
`mint`	`8EEvvmDQRxQHWygwMAxUqXReBg9kmGzRfcf9XyHepump`
`mint_amount`	`206,900,000,000,000`
`sol_amount`	`84,990,359,064`

Example Query:

ClickHouse (solana)

pumpfun_all_swaps

Statistic	Value
Rows	2,227,521,668
Size	279.34 GB
First Record	2024-06-11
Last Record	2026-05-23

Columns:

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-15)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`slot`	`421,711,764`
`tx_idx`	`1,502`
`signing_wallet`	`b'BwWK17cbHxwWBKZkUYvzxLcNQ1YVyaFezduWbtm2de6s\x00`
`direction`	`buy`
`base_coin`	`b'CwyxXpdwFnvR2GrfK9Xvv5f96Nfcvfy1ygPcgL8Epump\x00`
`base_coin_amount`	`1,970,279,349,080`
`quote_coin_amount`	`23,294,377`

Example Query:

ClickHouse (solana)

pumpfun_amm_admin_set_coin_creator

Statistic	Value
Rows	342
Size	65.3 KB
First Record	2026-03-15
Last Record	2026-05-23
Partition Key	`toYYYYMM(block_time)`

Columns:

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

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 11:59:33`
`block_date_utc`	`2026-05-23`
`slot`	`421,693,716`
`tx_idx`	`997`
`swap_idx`	`15`
`signature`	`3JALGHVznb2dqjQzmE84FYej6BJCr1Rvrz4CskbSbCABheT...`
`fee_payer`	`Drmq6DFr6j63QgCewPDSVNoumpcgZ12VhaRoe1kMRwR7`
`provided_gas_fee`	`62,633`

Example Query:

ClickHouse (solana)

pumpfun_creator_fee_distributions

Statistic	Value
Rows	1,459,963
Size	239.9 MB
First Record	2026-02-15
Last Record	2026-05-23
Partition Key	`toYYYYMMDD(block_time)`

Columns:

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)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:58:42`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,664`
`tx_idx`	`484`
`ix_idx`	`2`
`signature`	`tVzdGkyvTJUpVJmr9tmrhNvSvdEnvzp1L3aYByFdhUZEYeS...`
`fee_payer`	`J7oeos72uyK15VRZk4sBp2M79bMsk1siQorz3keJVjHL`
`provided_gas_fee`	`100`

Example Query:

ClickHouse (solana)

pumpfun_token_creation

Statistic	Value
Rows	13,535,896
Size	3.30 GB
First Record	2024-11-15
Last Record	2026-05-23

Columns:

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-11-15)
`mayhem_mode`	`UInt8`	Whether mayhem mode was enabled (populated since 2025-11-23)
`token_program`	`String`	Token program used (SPL Token or Token-2022) (populated since 2024-11-15)
`signature`	`String`	Transaction signature (base58 encoded) (populated since 2024-11-15)
`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)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:21`
`slot`	`421,711,763`
`tx_idx`	`1,083`
`creator`	`b'HVwXuVnEey6r7qGH6nEJWPCu6rBTAxPaegoJh5H49rPQ\x00`
`name`	`b'10m pnl btw\x00\x00\x00\x00\x00\x00\x00\x00\x00'`
`symbol`	`b'ARYAN\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0`
`url`	`b'https://metadata.j7tracker.io/metadata/e9767f6bf`
`mint`	`b'6UAYtPdr1LsEVExMqqYM9ebDzpkvuhgncqc9kZ96pump\x00`

Example Query:

ClickHouse (solana)

pumpfun_v2_swaps

Statistic	Value
Rows	4,945,614
Size	1.03 GB
First Record	2024-11-15
Last Record	2026-05-23
Partition Key	`(block_date_utc, failed)`

Columns:

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-15)
`signing_wallet`	`String`	Wallet address that signed the transaction
`fee_payer`	`String`	Wallet that paid the transaction fee (populated since 2024-11-15)
`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`	Default: `''` (populated since 2024-11-15)
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls) (populated since 2024-11-15)
`failed`	`UInt8`	Default: `0` (populated since 2024-11-15)
`pf_program_account_index`	`Int16`	Default: `-1` (populated since 2024-11-15)
`cu_price_ix_index`	`Int16`	Default: `-1` (populated since 2024-11-15)
`cu_limit_ix_index`	`Int16`	Default: `-1` (populated since 2024-11-15)
`tip_index`	`Int16`	Default: `-1` (populated since 2024-11-15)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,764`
`tx_idx`	`1,223`
`ix_idx`	`3`
`signing_wallet`	`BwWK17cbHxwWBKZkUYvzxLcNQ1YVyaFezduWbtm2de6s`
`fee_payer`	`Gygj9QQby4j2jryqyqBHvLP7ctv2SaANgh4sCb69BUpA`
`direction`	`sell`

Example Query:

ClickHouse (solana)

pumpswap_all_swaps

Statistic	Value
Rows	5,537,777,597
Size	1591.48 GB
First Record	2025-05-23
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalYear(1)`

Columns:

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-05-23)
`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)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,764`
`tx_idx`	`1,490`
`signing_wallet`	`6swP6EWWFTaMnep6HS4FNcZRENZKq9JN3wCHpasmLmav`
`fee_payer`	`6swP6EWWFTaMnep6HS4FNcZRENZKq9JN3wCHpasmLmav`
`direction`	`S`
`base_token`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_all_swaps

Statistic	Value
Rows	21,469,165
Size	1.85 GB
First Record	2024-11-15
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalDay(90)`

Columns:

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 2024-11-15)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,764`
`tx_idx`	`1,254`
`signing_wallet`	`b'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa\x00\`
`direction`	`S`
`base_coin`	`b'63LfDmNb3MQ8mw9MtZ2To9bEA2M71kZUUGq5tiJxcqj9\x00`
`quote_coin`	`b'So11111111111111111111111111111111111111112\x00\`

Example Query:

ClickHouse (solana)

raydium_cpmm_swaps

Statistic	Value
Rows	28,520,617
Size	5.84 GB
First Record	2024-11-15
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalDay(90)`

Columns:

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

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:59:22`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,764`
`tx_idx`	`50`
`swap_idx`	`13`
`signature`	`5rR47abX7Fx2xksrfh1Krc72yry78u7aRPJf7KhPaQK8aZm...`
`fee_payer`	`3Wm5W6eAkZdxqPEC1raB2td74DXc8cchWSFfsVWDXRRK`
`provided_gas_fee`	`4,608,144`

Example Query:

ClickHouse (solana)

raydium_launchpad_cpmm_migrations

Statistic	Value
Rows	4,095
Size	3.9 MB
First Record	2025-07-01
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalYear(1)`

Columns:

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

Latest Record Sample:

View on Solscan

Column	Value
`signature`	`K5MwogqQ9sTWrY8TLkWLLKgHaKy3EzBa5sJuTsn9NHkyA8o...`
`block_time`	`2026-05-23 05:57:08`
`block_date_utc`	`2026-05-23`
`slot`	`421,639,294`
`tx_idx`	`645`
`payer`	`RAYpQbFNq9i3mu6cKpTKKRwwHFDeK5AuZz8xvxUrCgw`
`base_mint`	`DGNjYDB8pAJ6VSotNjkfQkWLNoMfMxiuJzmm1GuV1Ron`
`quote_mint`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_launchpad_migrations

Statistic	Value
Rows	364
Size	1023.3 KB
First Record	2025-05-25
Last Record	2026-05-18
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalYear(1)`

Columns:

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

Latest Record Sample:

View on Solscan

Column	Value
`signature`	`2ANgoXEHhd7GXkJn61Vr9ZDzdwrcMMix8dyL8urp4Atzuib...`
`block_time`	`2026-05-18 15:26:33`
`block_date_utc`	`2026-05-18`
`slot`	`420,643,167`
`tx_idx`	`83`
`payer`	`RAYzrepoBdjSFg7MZj2vy4XBSv2azKRXC72ztUMZMJB`
`base_coin`	`9EtWvVcMwHKGTHtHGetvknbRYkN5oo7P6inroewibonk`
`quote_coin`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_launchpad_swaps

Statistic	Value
Rows	81,219,761
Size	13.39 GB
First Record	2025-05-23
Last Record	2026-05-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalYear(1)`

Columns:

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

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-05-23 13:58:27`
`block_date_utc`	`2026-05-23`
`slot`	`421,711,626`
`tx_idx`	`737`
`fee_payer`	`AP25fSHL6QhuSzB8EGqtuRTs5gnusuZ4xE4kV1ifXRR4`
`direction`	`B`
`pool_status`	`0`
`pool_state`	`AjcYg36QKWVy4L5SE3g2x61TQ1bYT1RSmjw6u5iRubHM`

Example Query:

ClickHouse (solana)

raydium_launchpad_token_creation

Statistic	Value
Rows	65,568
Size	19.9 MB
First Record	2025-04-16
Last Record	2025-10-15

Columns:

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)

Latest Record Sample:

Column	Value
`block_time`	`2025-10-15 17:36:42`
`slot`	`373,641,138`
`tx_idx`	`714`
`creator`	`b'CrjJT78c3WpSz4kz4x3bawjd8UACGPowMjuz5tKV8NJh\x00`
`name`	`b'Important Coin\x00\x00\x00\x00\x00\x00'`
`symbol`	`b'IMPORTANT\x00\x00\x00\x00\x00\x00\x00'`
`url`	`b'https://ipfs.io/ipfs/bafkreif4q7un34ghowsetmgmx6`
`mint`	`b'6JGaQcHA1ZoJ1C3RVVmnbK3S66Xvh7zRLN7piVjsbonk\x00`

Example Query:

ClickHouse (solana)

solana_blocks

Statistic	Value
Rows	166,201,901
Size	8.33 GB
First Record	1969-12-31
Last Record	2026-05-23

Columns:

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-15)
`amount_of_transactions`	`UInt64`	Number of transactions in the block (populated since 1969-12-31)

Latest Record Sample:

Column	Value
`block_time`	`2026-05-23 13:59:22`
`slot`	`421,711,764`
`hash`	`b'Ak82ch9kEWULHXgE4gskv8dxMv2gSZVhLp3S8XjFEDpc\x00`
`validator`	`b'1unarWPGGseFag2WfnoFv8o9P7vTPU8eHex9GinP3eY\x00\`
`rewards`	`18,197,551`
`amount_of_transactions`	`1,507`

Example Query:

ClickHouse (solana)

tx_timestamps

Statistic	Value
Rows	1,856,043,186
Size	165.26 GB
Partition Key	`toYYYYMMDD(toDateTime(entry_timestamp))`
TTL	`toDateTime(entry_timestamp) + toIntervalDay(14)`

Columns:

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)

Latest Record Sample:

View on Solscan

Column	Value
`slot`	`421,712,081`
`tx_idx`	`1,299`
`entry_timestamp`	`1.77957e+09`
`signature`	`3aDBDzSgx5zASxA2RonrYXjo8T9S2Jpv5YZoqMjqgFJn47p...`

Example Query:

ClickHouse (solana)