Solana Tables

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

Last updated: 2026-08-23 11:23 UTC

Tables (21)

Table	Rows	Size
jito_tips	146,537,609	10.99 GB
max_caps	9,353,726	438.8 MB
meteora_dynamic_bonding_swaps	156,162,209	42.83 GB
meteora_swaps	78,405,868	15.75 GB
pfamm_migrations	112,013	26.0 MB
pumpfun_all_swaps	2,470,965,390	326.90 GB
pumpfun_amm_admin_set_coin_creator	778	147.6 KB
pumpfun_creator_fee_distributions	1,902,499	308.3 MB
pumpfun_token_creation	16,414,312	4.20 GB
pumpfun_v2_swaps	1,500,050,093	206.44 GB
pumpswap_all_swaps	5,073,734,557	1681.38 GB
raydium_all_swaps	16,456,857	2.88 GB
raydium_cpmm_swaps	16,313,871	3.83 GB
raydium_launchpad_cpmm_migrations	3,602	3.9 MB
raydium_launchpad_migrations	91	466.6 KB
raydium_launchpad_swaps	22,320,399	3.78 GB
raydium_launchpad_token_creation	65,568	19.9 MB
sol_top_ups	204,468,872	33.79 GB
solana_blocks	186,130,744	9.55 GB
token_transfers	173,815,624	28.30 GB
tx_timestamps	1,056,880,645	93.87 GB

jito_tips

Statistic	Value
Rows	146,537,609
Size	10.99 GB
First Record	2024-11-02
Last Record	2026-08-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-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,456`
`signature`	`4CZck7kGqeaRycZJVXfCUQtTdN5VvQ4kCUnN6CtN6vsGGPc...`
`signer`	`sp1nLqqjVZ1kTusFjJmHp1xHDpH6M4F7KXCr1iJ3xpX`
`sender`	`sp1nLqqjVZ1kTusFjJmHp1xHDpH6M4F7KXCr1iJ3xpX`
`tip_account`	`ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt`

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	156,162,209
Size	42.83 GB
First Record	2025-08-23
Last Record	2026-08-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)
`blockhash_prefix`	`String`	Default: `''` (populated since 2026-08-19)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2026-08-19)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2026-08-19)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2026-08-19)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-19)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-19)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:19:54`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,410`
`tx_idx`	`641`
`swap_idx`	`9`
`signature`	`MucQie52xvjqg9hHBDdG5a7T452rUzY5cMFVLAYu6EbTuyH...`
`fee_payer`	`AqkfSXpe8VbX86vySru4wsorvFtVVRr1wfRCaLEPvoFv`
`provided_gas_fee`	`926,142`

Example Query:

ClickHouse (solana)

meteora_swaps

Statistic	Value
Rows	78,405,868
Size	15.75 GB
First Record	2024-11-02
Last Record	2026-08-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 2024-11-02)
`blockhash_prefix`	`String`	Default: `''` (populated since 2024-11-02)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction (populated since 2024-11-02)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2024-11-02)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2024-11-02)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-19)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`block_date`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,242`
`signing_wallet`	`6FK84kAruRrPrjDDGsWHSZwxXY5Bt1Yc6YyW6b2exNuv`
`base_coin`	`C8fU5GdfAt5mnw2RK7HE6XJGFNxHpaskZMkXxdm88888`
`quote_coin`	`So11111111111111111111111111111111111111112`
`base_coin_amount`	`157,905,599,757`

Example Query:

ClickHouse (solana)

pfamm_migrations

Statistic	Value
Rows	112,013
Size	26.0 MB
First Record	2025-08-23
Last Record	2026-08-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 2025-11-10)
`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-08-23 04:19:43`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,386`
`tx_idx`	`751`
`user`	`9C4nRvhhVquCKATjDCx5FKvNS9PNgNqgyWy9AcoDjYv5`
`mint`	`5nPfzkdzzrHF4mXagX76mPN6Lrm1Co1VcUKQNc7Npump`
`mint_amount`	`206,900,000,000,000`
`sol_amount`	`151,762,828`

Example Query:

ClickHouse (solana)

pumpfun_all_swaps

Statistic	Value
Rows	2,470,965,390
Size	326.90 GB
First Record	2024-06-11
Last Record	2026-08-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-02)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`slot`	`441,146,452`
`tx_idx`	`1,454`
`signing_wallet`	`b'2VRb1Ce3mS5CQJfyV5z1JMbE9JDqAyePjq6K79ojdq41\x00`
`direction`	`sell`
`base_coin`	`b'8vJ6T78sia8uEgmdCMMctBzMvKRx4aS4X6kEXw4Apump\x00`
`base_coin_amount`	`690,331,276,864`
`quote_coin_amount`	`19,965,279`

Example Query:

ClickHouse (solana)

pumpfun_amm_admin_set_coin_creator

Statistic	Value
Rows	778
Size	147.6 KB
First Record	2026-03-15
Last Record	2026-08-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-08-23 00:42:16`
`block_date_utc`	`2026-08-23`
`slot`	`441,110,648`
`tx_idx`	`214`
`swap_idx`	`15`
`signature`	`2NGDGDzXeeYTGwZeXnyGPyGE7vr2LhqCXvWtLDzUXhvK42D...`
`fee_payer`	`2nZ4jKpcGPsHi5rwEkcw8BMYEa4VQyUEXqSARdkSR7mo`
`provided_gas_fee`	`76,694`

Example Query:

ClickHouse (solana)

pumpfun_creator_fee_distributions

Statistic	Value
Rows	1,902,499
Size	308.3 MB
First Record	2026-02-15
Last Record	2026-08-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) (populated since 2026-05-29)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:02`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,432`
`tx_idx`	`1,210`
`ix_idx`	`0`
`signature`	`2GYNzVwL6PLUwTaDeM8v6hxaeRYrRNKY1VdvSCLoCyMe6wh...`
`fee_payer`	`BbowTnBx55c49jsvdkvHrAFj5hAoYDVZdaYSZjvU56cw`
`provided_gas_fee`	`0`

Example Query:

ClickHouse (solana)

pumpfun_token_creation

Statistic	Value
Rows	16,414,312
Size	4.20 GB
First Record	2024-01-17
Last Record	2026-08-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-01-17)
`mayhem_mode`	`UInt8`	Whether mayhem mode was enabled (populated since 2025-11-12)
`token_program`	`String`	Token program used (SPL Token or Token-2022) (populated since 2024-01-17)
`signature`	`String`	Transaction signature (base58 encoded) (populated since 2024-01-17)
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls) (populated since 2026-01-22)
`is_cashback_enabled`	`UInt8`	Whether cashback was enabled for creation (populated since 2026-02-18)
`fee_payer`	`String`	Wallet that paid the transaction fee (populated since 2024-11-02)
`provided_gas_fee`	`UInt64`	Gas fee provided for the transaction (lamports) (populated since 2024-11-02)
`provided_gas_limit`	`UInt64`	Compute unit limit requested (populated since 2024-11-02)
`fee`	`UInt64`	Transaction fee paid (lamports) (populated since 2024-11-02)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2024-11-02)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2024-11-02)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2024-11-02)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-19)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction (populated since 2024-11-02)
`blockhash_prefix`	`String`	Default: `''` (populated since 2024-11-02)
`quote_coin`	`String`	Quote token mint address (usually SOL or USDC) (populated since 2026-08-19)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:03`
`slot`	`441,146,435`
`tx_idx`	`503`
`creator`	`b'866SrsMfwKsErATZDCLAPbxH3NuqjKn7zQ1xXMqixoz1\x00`
`name`	`b'Rumah Kucen\x00\x00\x00\x00\x00\x00\x00\x00\x00'`
`symbol`	`b'Rumah\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0`
`url`	`b'https://metadata.j7tracker.io/metadata/OG7bPMrlS`
`mint`	`b'EQpQ4tVBRF2Za64Pi1fceZDSwca23JQQFsUKyrsRpump\x00`

Example Query:

ClickHouse (solana)

pumpfun_v2_swaps

Statistic	Value
Rows	1,500,050,093
Size	206.44 GB
First Record	2024-11-02
Last Record	2026-08-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-02)
`signing_wallet`	`String`	Wallet address that signed the transaction
`fee_payer`	`String`	Wallet that paid the transaction fee (populated since 2024-11-02)
`direction`	`LowCardinality(String)`	Trade direction (buy/sell)
`base_coin`	`String`	Base token mint address
`quote_coin`	`LowCardinality(String)`	Quote token mint address (usually SOL or USDC)
`instruction_type`	`LowCardinality(String)`	Pump.fun instruction variant: `buy`, `sell`, `buy_v2`, `sell_v2`, `buy_exact_sol_in`, or `buy_exact_quote_in_v2`
`base_coin_amount`	`UInt64`	Base token amount (raw units, needs decimal adjustment)
`quote_coin_amount`	`UInt64`	Quote token amount (raw units)
`virtual_token_balance_after`	`UInt64`	Virtual token reserves after trade (bonding curve state)
`virtual_sol_balance_after`	`UInt64`	Virtual SOL reserves after trade (bonding curve state)
`signature`	`String`	Transaction signature (base58 encoded)
`provided_gas_fee`	`UInt64`	Gas fee provided for the transaction (lamports)
`provided_gas_limit`	`UInt64`	Compute unit limit requested
`fee`	`UInt64`	Transaction fee paid (lamports)
`consumed_gas`	`UInt64`	Compute units actually consumed
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02)
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls) (populated since 2024-11-02)
`failed`	`UInt8`	Whether the transaction failed (1=yes, 0=no) (populated since 2024-11-02)
`pf_program_account_index`	`Int16`	Default: `-1` (populated since 2024-11-02)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2024-11-02)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
`tip_index`	`Int16`	Default: `-1` (populated since 2024-11-02)
`blockhash_prefix`	`String`	Default: `''` (populated since 2024-11-02)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2024-11-02)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2024-11-02)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,372`
`ix_idx`	`4`
`signing_wallet`	`Dd2nB2vD1XvDsdKqhtmCuh1q6tzWckkqLq3JubznKanL`
`fee_payer`	`Dd2nB2vD1XvDsdKqhtmCuh1q6tzWckkqLq3JubznKanL`
`direction`	`buy`

Example Query:

ClickHouse (solana)

pumpswap_all_swaps

Statistic	Value
Rows	5,073,734,557
Size	1681.38 GB
First Record	2025-08-23
Last Record	2026-08-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-08-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)
`coin_creator`	`String`	Default: `''` (populated since 2026-07-23)
`coin_creator_fees_basis_points`	`UInt64`	Default: `0` (populated since 2026-07-23)
`coin_creator_fees`	`UInt64`	Default: `0` (populated since 2026-07-23)
`cash_back_fees_basis_points`	`UInt64`	Default: `0` (populated since 2026-07-23)
`cash_back_fees`	`UInt64`	Default: `0` (populated since 2026-07-23)
`buy_back_fees_basis_points`	`UInt64`	Default: `0` (populated since 2026-07-23)
`buy_back_fees`	`UInt64`	Default: `0` (populated since 2026-07-23)
`virtual_quote_reserves`	`Int128`	Default: `0` (populated since 2026-07-23)
`can_boost`	`UInt8`	Default: `0` (populated since 2026-07-23)
`base_supply`	`UInt64`	Default: `0` (populated since 2026-07-23)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,473`
`signing_wallet`	`2RjQiAPX5L3RhRfC6Norqck9jhmpJDt79KoBbVHjne8Z`
`fee_payer`	`Cziz6aSQCKorxh3uj8d3eeDaGLm1C1bqVdP6ehuZhfZr`
`direction`	`B`
`base_token`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_all_swaps

Statistic	Value
Rows	16,456,857
Size	2.88 GB
First Record	2024-11-02
Last Record	2026-08-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-02)
`instruction_type`	`LowCardinality(String)`	Default: `''` (populated since 2024-11-02)
`blockhash_prefix`	`String`	Default: `''` (populated since 2024-11-02)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction (populated since 2024-11-02)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2024-11-02)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2024-11-02)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2024-11-02)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2024-11-02)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2024-11-02)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,336`
`signing_wallet`	`b'gMBEzCYwP8xNhWLZ11iByQJ5cyZgvPpVtTybqiPv2wi\x00\`
`direction`	`S`
`base_coin`	`b'So11111111111111111111111111111111111111112\x00\`
`quote_coin`	`b'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v\x00`

Example Query:

ClickHouse (solana)

raydium_cpmm_swaps

Statistic	Value
Rows	16,313,871
Size	3.83 GB
First Record	2026-05-25
Last Record	2026-08-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-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,463`
`swap_idx`	`17`
`signature`	`66u8VwATkrRnMcEYWAT3pLeogubZ4JaXJgpAZVk9iu1bWeE...`
`fee_payer`	`443a4zjsja37jq1D4xkGKhjQr7paAMUW8Foa6eTwBrv2`
`provided_gas_fee`	`559,669`

Example Query:

ClickHouse (solana)

raydium_launchpad_cpmm_migrations

Statistic	Value
Rows	3,602
Size	3.9 MB
First Record	2025-08-23
Last Record	2026-08-22
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`	`29x7Hw5sPkk7z12jm6H6PksAKXikTzH53B9PB445sw3Ywch...`
`block_time`	`2026-08-22 16:45:22`
`block_date_utc`	`2026-08-22`
`slot`	`441,032,515`
`tx_idx`	`156`
`payer`	`RAYpQbFNq9i3mu6cKpTKKRwwHFDeK5AuZz8xvxUrCgw`
`base_mint`	`Gfoz8A5j32iU34zVJGmUFKYywqodgU19sb14avAfbYA1`
`quote_mint`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_launchpad_migrations

Statistic	Value
Rows	91
Size	466.6 KB
First Record	2025-08-24
Last Record	2026-08-14
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`	`7FvuQT4sdqJPRWT9hmG8WfKagrtfYPWo8iiwrhYoRbfjfhu...`
`block_time`	`2026-08-14 13:05:04`
`block_date_utc`	`2026-08-14`
`slot`	`439,291,807`
`tx_idx`	`1,476`
`payer`	`RAYzrepoBdjSFg7MZj2vy4XBSv2azKRXC72ztUMZMJB`
`base_coin`	`5cWGJjnLJFLdnp8g7kqqdXf1Q7MLhzVw8HLbrotrench`
`quote_coin`	`So11111111111111111111111111111111111111112`

Example Query:

ClickHouse (solana)

raydium_launchpad_swaps

Statistic	Value
Rows	22,320,399
Size	3.78 GB
First Record	2025-08-23
Last Record	2026-08-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
`blockhash_prefix`	`String`	Default: `''` (populated since 2026-08-19)
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls) (populated since 2026-08-19)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-19)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2026-08-19)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2026-08-19)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2026-08-19)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-19)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-19)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:17:13`
`block_date_utc`	`2026-08-23`
`slot`	`441,145,976`
`tx_idx`	`1,151`
`fee_payer`	`3Z1t3WrSeR7bkhaUKhtCMagFJqfyrHzfz9DYpDKyVZVi`
`direction`	`S`
`pool_status`	`0`
`pool_state`	`DTqCoq9dJ9JmbSjsCRW4rvrqAft5wyGHK8KAM1U6PtQt`

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)

sol_top_ups

Statistic	Value
Rows	204,468,872
Size	33.79 GB
First Record	2024-11-02
Last Record	2026-08-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalDay(31)`

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
`failed`	`UInt8`	Whether the transaction failed (1=yes, 0=no)
`provided_gas_fee`	`UInt64`	Gas fee provided for the transaction (lamports)
`provided_gas_limit`	`UInt64`	Compute unit limit requested
`fee`	`UInt64`	Transaction fee paid (lamports)
`consumed_gas`	`UInt64`	Compute units actually consumed
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction
`num_signatures`	`UInt8`	Number of signatures on the transaction
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only)
`signature`	`String`	Transaction signature (base58 encoded)
`fee_payer`	`String`	Wallet that paid the transaction fee
`src_wallet`	`String`	Source wallet address
`dst_wallet`	`String`	Destination wallet address
`amount`	`UInt64`	Amount of SOL transferred, in lamports

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,411`
`failed`	`0`
`provided_gas_fee`	`1`
`provided_gas_limit`	`350,000`
`fee`	`5,001`

Example Query:

ClickHouse (solana)

solana_blocks

Statistic	Value
Rows	186,130,744
Size	9.55 GB
First Record	1969-12-31
Last Record	2026-08-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-02)
`amount_of_transactions`	`UInt64`	Number of transactions in the block (populated since 1969-12-31)

Latest Record Sample:

Column	Value
`block_time`	`2026-08-23 04:20:09`
`slot`	`441,146,452`
`hash`	`b'HajgCR58SGvF45TXFmU9ZFbEFjjFkeJPoWY9SbwgjZrf\x00`
`validator`	`b'E1r4Psq84tHfQ6aPTvvDka4U3u8zPVD7gEUrH25RdxHL\x00`
`rewards`	`14,033,939`
`amount_of_transactions`	`1,474`

Example Query:

ClickHouse (solana)

token_transfers

Statistic	Value
Rows	173,815,624
Size	28.30 GB
First Record	2024-11-02
Last Record	2026-08-23
Partition Key	`block_date_utc`
TTL	`block_date_utc + toIntervalDay(31)`

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
`failed`	`UInt8`	Whether the transaction failed (1=yes, 0=no)
`provided_gas_fee`	`UInt64`	Gas fee provided for the transaction (lamports)
`provided_gas_limit`	`UInt64`	Compute unit limit requested
`fee`	`UInt64`	Transaction fee paid (lamports)
`consumed_gas`	`UInt64`	Compute units actually consumed
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction
`num_signatures`	`UInt8`	Number of signatures on the transaction
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only)
`signature`	`String`	Transaction signature (base58 encoded)
`fee_payer`	`String`	Wallet that paid the transaction fee
`mint`	`String`	Token mint address
`src_wallet`	`String`	Source wallet address
`dst_wallet`	`String`	Destination wallet address
`amount`	`UInt64`	Token amount transferred in raw base units (apply the mint's decimals for display)
`flavour`	`UInt8`	Transfer encoding: add 16 for Token-2022; base values are 0=Transfer, 1=TransferChecked, 2=TransferCheckedWithFee, and 3=SetAuthority owner change
`ix_idx`	`Int16`	Instruction index within the transaction

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-08-23 04:20:09`
`block_date_utc`	`2026-08-23`
`slot`	`441,146,452`
`tx_idx`	`1,446`
`failed`	`0`
`provided_gas_fee`	`500`
`provided_gas_limit`	`100,000`
`fee`	`5,050`

Example Query:

ClickHouse (solana)

tx_timestamps

Statistic	Value
Rows	1,056,880,645
Size	93.87 GB
First Record	2026-08-09
Last Record	2026-08-13
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`	`438,983,103`
`tx_idx`	`595`
`entry_timestamp`	`1.78661e+09`
`signature`	`37RhVxMiCVypeaGoWzrePWDKs1VBE46hENPkSMdJvgScXJ4...`

Example Query:

ClickHouse (solana)