Solana Tables

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

Last updated: 2026-04-05 12:44 UTC

Tables (18)

Table	Rows	Size
jito_tips	134,478,570	10.53 GB
max_caps	9,105,622	429.1 MB
meteora_dynamic_bonding_swaps	113,111,181	32.62 GB
meteora_swaps	69,880,924	12.18 GB
pfamm_migrations	78,809	14.4 MB
pumpfun_all_swaps	2,110,203,289	257.13 GB
pumpfun_amm_admin_set_coin_creator	98	20.2 KB
pumpfun_creator_fee_distributions	809,980	134.0 MB
pumpfun_token_creation	12,124,116	2.89 GB
pumpswap_all_swaps	5,265,672,904	1464.85 GB
raydium_all_swaps	6,679,838,452	877.81 GB
raydium_cpmm_swaps	36,879,218	8.20 GB
raydium_launchpad_cpmm_migrations	3,878	3.6 MB
raydium_launchpad_migrations	401	1.1 MB
raydium_launchpad_swaps	87,054,325	14.27 GB
raydium_launchpad_token_creation	65,568	19.9 MB
solana_blocks	155,306,448	7.67 GB
tx_timestamps	2,158,393,182	192.30 GB

jito_tips

Statistic	Value
Rows	134,478,570
Size	10.53 GB
First Record	2026-03-22
Last Record	2026-04-05
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-04-05 05:43:59`
`block_date_utc`	`2026-04-05`
`slot`	`411,193,843`
`tx_idx`	`1,107`
`signature`	`5Gc1Tr9D8Gj1U4e5VCA67r5qc9RYjo8uvRCbzhmi73dDTf5...`
`signer`	`roUteHjDohtkatXTb79PJ99bbxkTipgo3GJ4EJZ1YpB`
`sender`	`roUteHjDohtkatXTb79PJ99bbxkTipgo3GJ4EJZ1YpB`
`tip_account`	`ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt`

Example Query:

ClickHouse (solana)

max_caps

Statistic	Value
Rows	9,105,622
Size	429.1 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`	`1138V342nCcQoa5f5AG2wFo8nSkXCMTEPNNnsCi2ou5`
`max_mcap_sol`	`58.9725`
`max_mcap_usdc`	`9616.72`
`max_slot`	`0`

Example Query:

ClickHouse (solana)

meteora_dynamic_bonding_swaps

Statistic	Value
Rows	113,111,181
Size	32.62 GB
First Record	2025-08-18
Last Record	2026-04-05
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-04-05 05:43:58`
`block_date_utc`	`2026-04-05`
`slot`	`411,193,839`
`tx_idx`	`803`
`swap_idx`	`3`
`signature`	`29CrWGws3vxCN6JDFwx7XnkRVxhsNLacfDgfkEhuv1vTh6f...`
`fee_payer`	`7rtiKSUDLBm59b1SBmD9oajcP8xE64vAGSMbAN5CXy1q`
`provided_gas_fee`	`1,000,000`

Example Query:

ClickHouse (solana)

meteora_swaps

Statistic	Value
Rows	69,880,924
Size	12.18 GB
First Record	2024-11-23
Last Record	2026-04-05
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 2024-11-23)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-04-05 05:43:59`
`block_date`	`2026-04-05`
`slot`	`411,193,843`
`tx_idx`	`616`
`signing_wallet`	`CtmGbBkqaRED1LtcoYfu24Xxj6fCpsSFDQaUCJCrYuKP`
`base_coin`	`So11111111111111111111111111111111111111112`
`quote_coin`	`J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn`
`base_coin_amount`	`180,219`

Example Query:

ClickHouse (solana)

pfamm_migrations

Statistic	Value
Rows	78,809
Size	14.4 MB
First Record	2025-04-05
Last Record	2026-04-05
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-04-05 05:35:51`
`block_date_utc`	`2026-04-05`
`slot`	`411,192,601`
`tx_idx`	`635`
`user`	`BnnNJJgy9w2MLQ9XBKJKG9FQa2r9qdW7u5VpzEkwUcc3`
`mint`	`GAN1b2ztJzvmR5YJnrTzQ1g4X1Z5Qk27frvaQg7Ypump`
`mint_amount`	`206,900,000,000,000`
`sol_amount`	`84,990,359,263`

Example Query:

ClickHouse (solana)

pumpfun_all_swaps

Statistic	Value
Rows	2,110,203,289
Size	257.13 GB
First Record	2024-06-11
Last Record	2026-04-05

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

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-04-05 05:43:59`
`slot`	`411,193,843`
`tx_idx`	`1,111`
`signing_wallet`	`b'BS5MAbSPpN7eCiV6KcCnsvt8jS3eKzvHwx25FTFDsLgc\x00`
`direction`	`sell`
`base_coin`	`b'H6AcqduqSWosU3TYfVaY2aNYDx2L7xpaWxDzXwTVsUu4\x00`
`base_coin_amount`	`1,323,165,994,645`
`quote_coin_amount`	`40,576,992`

Example Query:

ClickHouse (solana)

pumpfun_amm_admin_set_coin_creator

Statistic	Value
Rows	98
Size	20.2 KB
First Record	2026-03-15
Last Record	2026-04-05
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-04-05 02:12:06`
`block_date_utc`	`2026-04-05`
`slot`	`411,161,460`
`tx_idx`	`834`
`swap_idx`	`17`
`signature`	`5quQMTxYcs3PTsjzdLH2T9imndcGgCVmyinA5HV1EB6VkrQ...`
`fee_payer`	`2pwWqhzXeH3gJ3qgmsK2NsddkehF5f2fH8uzF9RUyzCX`
`provided_gas_fee`	`55,271`

Example Query:

ClickHouse (solana)

pumpfun_creator_fee_distributions

Statistic	Value
Rows	809,980
Size	134.0 MB
First Record	2026-02-15
Last Record	2026-04-05
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-04-05 05:43:55`
`block_date_utc`	`2026-04-05`
`slot`	`411,193,832`
`tx_idx`	`25`
`ix_idx`	`0`
`signature`	`2bGuH4vibxvR7o91zty3hqDjCJHNXSaXCuPdR7zDakTz55w...`
`fee_payer`	`Fipwqxg3B5yHqr5v6NafS7jPenJB9LLaDBCf71aqSXho`
`provided_gas_fee`	`0`

Example Query:

ClickHouse (solana)

pumpfun_token_creation

Statistic	Value
Rows	12,124,116
Size	2.89 GB
First Record	2024-11-23
Last Record	2026-04-05

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-23)
`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-23)
`signature`	`String`	Transaction signature (base58 encoded) (populated since 2024-11-23)
`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-04-05 05:43:59`
`slot`	`411,193,843`
`tx_idx`	`12`
`creator`	`b'CSR7CWmGRepNJhp3h63ZAxqix2j6o5eGUgPsCUwzdxFv\x00`
`name`	`b'Professor Friat\x00\x00\x00\x00\x00'`
`symbol`	`b'Friat\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0`
`url`	`b'https://ipfs.io/ipfs/QmX9tHkLK2wfA3FLUumwzWhEMzo`
`mint`	`b'DPEmLJY31yA696HczoUUV75j3LbKbMWQjcjv9qZDpump\x00`

Example Query:

ClickHouse (solana)

pumpswap_all_swaps

Statistic	Value
Rows	5,265,672,904
Size	1464.85 GB
First Record	2025-04-05
Last Record	2026-04-05
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-04-05)
`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-04-05 05:44:05`
`block_date_utc`	`2026-04-05`
`slot`	`411,193,857`
`tx_idx`	`1,093`
`signing_wallet`	`Gh6UARh1vYL57LeESCbarnyyNu7XRaiYRBCir51JsSbh`
`fee_payer`	`Gh6UARh1vYL57LeESCbarnyyNu7XRaiYRBCir51JsSbh`
`direction`	`S`
`base_token`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_all_swaps

Statistic	Value
Rows	6,679,838,452
Size	877.81 GB
First Record	2024-05-09
Last Record	2026-04-05

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

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-04-05 05:44:56`
`slot`	`411,193,989`
`tx_idx`	`758`
`signing_wallet`	`b'4muHSktcbRhShTzU5c39J7yiwP9EK4oCZTt6fjSzrvb8\x00`
`direction`	`S`
`base_coin`	`b'So11111111111111111111111111111111111111112\x00\`
`quote_coin`	`b'GyhUtVfYdYsnaTHmTguwHbsjHp83iEe4dQskJbmDpump\x00`
`base_coin_amount`	`44,679`

Example Query:

ClickHouse (solana)

raydium_cpmm_swaps

Statistic	Value
Rows	36,879,218
Size	8.20 GB
First Record	2024-11-23
Last Record	2026-04-05
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-04-05 05:44:56`
`block_date_utc`	`2026-04-05`
`slot`	`411,193,989`
`tx_idx`	`746`
`swap_idx`	`9`
`signature`	`4wyDD6PhpiEZfnay1kcZ79VTSUvPFGKFutzYP3CiBRm5xr5...`
`fee_payer`	`GimWfnQt2zBaadDDSBdg52hSLbtjyapP4SRBMs3GRuS5`
`provided_gas_fee`	`993,601`

Example Query:

ClickHouse (solana)

raydium_launchpad_cpmm_migrations

Statistic	Value
Rows	3,878
Size	3.6 MB
First Record	2025-04-26
Last Record	2026-04-05
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`	`5beKPUNcbAgD3kHcyVVgFYLApCeyb62E9SDjyMzwRri7F6b...`
`block_time`	`2026-04-05 05:05:27`
`block_date_utc`	`2026-04-05`
`slot`	`411,187,970`
`tx_idx`	`150`
`payer`	`RAYpQbFNq9i3mu6cKpTKKRwwHFDeK5AuZz8xvxUrCgw`
`base_mint`	`97AmStYeCa9WZKpRPG8XwskGBQFxjkhTMoTNHYxtbonk`
`quote_mint`	`USD1ttGY1N17NEEHLmELoaybftRBUSErhqYiQzvEmuB`

Example Query:

ClickHouse (solana)

raydium_launchpad_migrations

Statistic	Value
Rows	401
Size	1.1 MB
First Record	2025-04-25
Last Record	2026-03-30
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`	`3NGK9PBXSVzaKJjMCuuTndmyHixKNWhBQuudLg17TG2wrc6...`
`block_time`	`2026-03-30 06:40:24`
`block_date_utc`	`2026-03-30`
`slot`	`409,880,568`
`tx_idx`	`506`
`payer`	`RAYzrepoBdjSFg7MZj2vy4XBSv2azKRXC72ztUMZMJB`
`base_coin`	`5HTxobDNyShbncWFqB7fJgtuVjMwg96H6Tx4jJ8XAray`
`quote_coin`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_launchpad_swaps

Statistic	Value
Rows	87,054,325
Size	14.27 GB
First Record	2025-04-15
Last Record	2026-04-05
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-04-05 05:44:39`
`block_date_utc`	`2026-04-05`
`slot`	`411,193,945`
`tx_idx`	`1,379`
`fee_payer`	`CCBwYH6fzaSfs4N7tkXQb5zXGSZ19WYGsdoBaLPXJhov`
`direction`	`S`
`pool_status`	`0`
`pool_state`	`AW2qknHKUJP3oarVmGjEnbQVCsChmRkq1fXBKfG7c44f`

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	155,306,448
Size	7.67 GB
First Record	2024-07-22
Last Record	2026-04-05

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-23)
`amount_of_transactions`	`UInt64`	Number of transactions in the block (populated since 2024-11-23)

Latest Record Sample:

Column	Value
`block_time`	`2026-04-05 05:44:56`
`slot`	`411,193,989`
`hash`	`b'AH6b3J83Nr4cyyYgWsMY627jtd4L1iAhWqdj5Mx2nS17\x00`
`validator`	`b'q9XWcZ7T1wP4bW9SB4XgNNwjnFEJ982nE8aVbbNuwot\x00\`
`rewards`	`22,802,914`
`amount_of_transactions`	`1,110`

Example Query:

ClickHouse (solana)

tx_timestamps

Statistic	Value
Rows	2,158,393,182
Size	192.30 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`	`411,194,014`
`tx_idx`	`1,325`
`entry_timestamp`	`1.77539e+09`
`signature`	`9cx2JSgGqQggHUvLTqZzZH9QJk4Yruwu6Fx56LUNkoxE76P...`

Example Query:

ClickHouse (solana)