Solana Tables

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

Last updated: 2026-09-01 12:33 UTC

Tables (21)

Table	Rows	Size
jito_tips	155,598,249	11.82 GB
max_caps	9,353,726	438.8 MB
meteora_dynamic_bonding_swaps	158,429,221	43.50 GB
meteora_swaps	82,946,241	20.49 GB
pfamm_migrations	121,902	28.6 MB
pumpfun_all_swaps	2,508,366,154	334.22 GB
pumpfun_amm_admin_set_coin_creator	806	150.5 KB
pumpfun_creator_fee_distributions	1,977,025	320.2 MB
pumpfun_token_creation	16,796,343	4.36 GB
pumpfun_v2_swaps	1,641,917,804	227.81 GB
pumpswap_all_swaps	5,158,207,781	1737.77 GB
raydium_all_swaps	20,278,300	4.73 GB
raydium_cpmm_swaps	16,641,287	3.91 GB
raydium_launchpad_cpmm_migrations	4,215	4.3 MB
raydium_launchpad_migrations	85	431.5 KB
raydium_launchpad_swaps	21,165,666	3.60 GB
raydium_launchpad_token_creation	66,099	20.2 MB
sol_top_ups	218,557,061	36.55 GB
solana_blocks	188,410,636	9.70 GB
token_transfers	201,556,680	34.91 GB
tx_timestamps	0	0 B

jito_tips

Statistic	Value
Rows	155,598,249
Size	11.82 GB
First Record	2026-08-18
Last Record	2026-09-01
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-09-01 05:28:54`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,600`
`tx_idx`	`1,549`
`signature`	`574mrGcBUhnVYJRwf3Ajh5rvraK8SHaQbZYHpLpY8C8xA17...`
`signer`	`ADkd3swkmsRRpExYHHQJkoRnk7u6egegUEUVkJSxzze3`
`sender`	`ADkd3swkmsRRpExYHHQJkoRnk7u6egegUEUVkJSxzze3`
`tip_account`	`HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe`

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	158,429,221
Size	43.50 GB
First Record	2025-09-01
Last Record	2026-09-01
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)
`curve_complete`	`UInt8`	Default: `0` (populated since 2026-08-30)
`base_reserve_after`	`UInt64`	Default: `0` (populated since 2026-08-30)
`quote_reserve_after`	`UInt64`	Default: `0` (populated since 2026-08-30)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-09-01 05:28:54`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,600`
`tx_idx`	`1,450`
`swap_idx`	`7`
`signature`	`22wpBGK9Q8uA4PKpXmmL5aQKeXbPQczYe1ddfJnZNx5hHpK...`
`fee_payer`	`8vCE1a4NL4vdUfUG6RszmgtwLeRYt49wng7z33fzmMxw`
`provided_gas_fee`	`510`

Example Query:

ClickHouse (solana)

meteora_swaps

Statistic	Value
Rows	82,946,241
Size	20.49 GB
First Record	2026-06-03
Last Record	2026-09-01
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-06-03)
`blockhash_prefix`	`String`	Default: `''` (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-09-01 05:28:54`
`block_date`	`2026-09-01`
`slot`	`443,423,600`
`tx_idx`	`1,525`
`signing_wallet`	`9TjYvVREwqkE8BXk3BPfpsC5DsXMWeud5dLXZP22fgKp`
`base_coin`	`CWZ6BsdnjkDVTGkmL6bGbJXXig6ceef12KvyGQW14cMt`
`quote_coin`	`Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB`
`base_coin_amount`	`3,561,484,147`

Example Query:

ClickHouse (solana)

pfamm_migrations

Statistic	Value
Rows	121,902
Size	28.6 MB
First Record	2025-09-01
Last Record	2026-09-01
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-09-01 05:28:51`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,591`
`tx_idx`	`902`
`user`	`3md7JQz8GWmrT9wvHvCPnBKusHEnkWKM5Uw4RN11tXyB`
`mint`	`fpmmW8jx6qA54JeaEsjShUXagCPNw6kwuUu7sVJpump`
`mint_amount`	`206,900,000,000,000`
`sol_amount`	`84,990,359,056`

Example Query:

ClickHouse (solana)

pumpfun_all_swaps

Statistic	Value
Rows	2,508,366,154
Size	334.22 GB
First Record	2024-06-11
Last Record	2026-09-01

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-09-01 05:28:54`
`slot`	`443,423,600`
`tx_idx`	`1,549`
`signing_wallet`	`b'ADkd3swkmsRRpExYHHQJkoRnk7u6egegUEUVkJSxzze3\x00`
`direction`	`sell`
`base_coin`	`b'8gtDXr775cfiLUe589xPgfEBEqJhDBgaYsAsF3KFKdQ7\x00`
`base_coin_amount`	`20,861,596,712`
`quote_coin_amount`	`999,460`

Example Query:

ClickHouse (solana)

pumpfun_amm_admin_set_coin_creator

Statistic	Value
Rows	806
Size	150.5 KB
First Record	2026-03-15
Last Record	2026-08-31
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-31 17:56:32`
`block_date_utc`	`2026-09-01`
`slot`	`443,292,805`
`tx_idx`	`1,086`
`swap_idx`	`15`
`signature`	`4hcFedTazXtqdh9TY7sS6djbGs8j5SYuHwBrkeRuAM2GXUo...`
`fee_payer`	`F2fRg5Etr3tW58rcNezPJcT9iZ5AedmE1SWPFTAZR9tk`
`provided_gas_fee`	`53,000`

Example Query:

ClickHouse (solana)

pumpfun_creator_fee_distributions

Statistic	Value
Rows	1,977,025
Size	320.2 MB
First Record	2026-02-15
Last Record	2026-09-01
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-09-01 05:28:49`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,583`
`tx_idx`	`1,151`
`ix_idx`	`8`
`signature`	`5DLp8JNaFYKg6CGHPrsVNQNYmBgDW7RGZnH5Mf1Dzv32iXj...`
`fee_payer`	`2k5hrzuykwyTbUe8L7UriYAQhr5hijNLgBvEB4B9pP5y`
`provided_gas_fee`	`0`

Example Query:

ClickHouse (solana)

pumpfun_token_creation

Statistic	Value
Rows	16,796,343
Size	4.36 GB
First Record	2024-01-17
Last Record	2026-09-01

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 2024-11-02)
`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-09-01 05:28:53`
`slot`	`443,423,598`
`tx_idx`	`487`
`creator`	`b'7VG8A7F6srieGaL34ZDFbsuqXm9EdGFQ1Pxbds2uRkJh\x00`
`name`	`b'NO MONEY \x00\x00\x00\x00\x00\x00\x00\x00\x00\x0`
`symbol`	`b'$NOMONEY\x00\x00\x00\x00\x00\x00\x00\x00'`
`url`	`b'https://ipfs.io/ipfs/bafkreibkxlp4245tskowvvkd5j`
`mint`	`b'EtiRdNdjqhsWkjW4t3fJ5whzSTebBWotTqF4pzAspump\x00`

Example Query:

ClickHouse (solana)

pumpfun_v2_swaps

Statistic	Value
Rows	1,641,917,804
Size	227.81 GB
First Record	2024-11-02
Last Record	2026-09-01
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-09-01 05:28:54`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,600`
`tx_idx`	`1,637`
`ix_idx`	`8`
`signing_wallet`	`sssssDdMNAWKingjpEojkTNdVuZrBe7FsJLaGtexe7d`
`fee_payer`	`sssssDdMNAWKingjpEojkTNdVuZrBe7FsJLaGtexe7d`
`direction`	`buy`

Example Query:

ClickHouse (solana)

pumpswap_all_swaps

Statistic	Value
Rows	5,158,207,781
Size	1737.77 GB
First Record	2025-09-01
Last Record	2026-09-01
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-09-01)
`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-09-01 05:28:54`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,600`
`tx_idx`	`1,650`
`signing_wallet`	`3LRyunoXAKyTviMPrqQtR8QExytKwAQ6wMrwv7BGBGtH`
`fee_payer`	`3LRyunoXAKyTviMPrqQtR8QExytKwAQ6wMrwv7BGBGtH`
`direction`	`B`
`base_token`	`Gwm8FQg33FyeWRZtsirCGmGjnAv3Qu79NGLrdJNFpump`

Example Query:

ClickHouse (solana)

raydium_all_swaps

Statistic	Value
Rows	20,278,300
Size	4.73 GB
First Record	2024-11-02
Last Record	2026-09-01
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-09-01 05:29:27`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,705`
`tx_idx`	`261`
`signing_wallet`	`b'34SvhyW9NQY8cjAjeV16Gk6dv5ayCBJwwVU5UmASUSCZ\x00`
`direction`	`B`
`base_coin`	`b'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v\x00`
`quote_coin`	`b'8ojmc6Bf3oQ3dKxA8SzdSDpWy2FrGDVoyVyei6HD5Fyc\x00`

Example Query:

ClickHouse (solana)

raydium_cpmm_swaps

Statistic	Value
Rows	16,641,287
Size	3.91 GB
First Record	2024-11-02
Last Record	2026-09-01
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-09-01 05:30:04`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,821`
`tx_idx`	`538`
`swap_idx`	`31`
`signature`	`GXaWsesEnkPaH3x1zL94U7aTweZUXhrd6GYoJ3QqzJ1fjwQ...`
`fee_payer`	`9kkzZDzS91EDF796TQS9gXoNb5LozkS9jY9CNynuSWr5`
`provided_gas_fee`	`120,832`

Example Query:

ClickHouse (solana)

raydium_launchpad_cpmm_migrations

Statistic	Value
Rows	4,215
Size	4.3 MB
First Record	2025-09-01
Last Record	2026-08-31
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
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls)
`failed`	`Bool`	Whether the transaction failed (1=yes, 0=no)
`fee_payer`	`String`	Wallet that paid the transaction fee (populated since 2026-08-30)
`provided_gas_fee`	`UInt64`	Gas fee provided for the transaction (lamports) (populated since 2026-08-30)
`provided_gas_limit`	`UInt64`	Compute unit limit requested (populated since 2026-08-30)
`fee`	`UInt64`	Transaction fee paid (lamports) (populated since 2026-08-30)
`consumed_gas`	`UInt64`	Compute units actually consumed (populated since 2026-08-30)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2026-08-30)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2026-08-30)
`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) (populated since 2026-08-30)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-30)
`blockhash_prefix`	`String`	Default: `''` (populated since 2026-08-30)

Latest Record Sample:

View on Solscan

Column	Value
`signature`	`3SvogxG7fZFsBNE69b9r6gTqNKyd5nazV8wJyvfPn9kbdPw...`
`block_time`	`2026-08-31 16:59:40`
`block_date_utc`	`2026-08-31`
`slot`	`443,282,036`
`tx_idx`	`771`
`payer`	`RAYpQbFNq9i3mu6cKpTKKRwwHFDeK5AuZz8xvxUrCgw`
`base_mint`	`CABXyW4J983v4sUKUJQ84q2cUWYNEEKfMA1Q9GxJ9HCy`
`quote_mint`	`6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN`

Example Query:

ClickHouse (solana)

raydium_launchpad_migrations

Statistic	Value
Rows	85
Size	431.5 KB
First Record	2025-09-02
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
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls)
`failed`	`Bool`	Whether the transaction failed (1=yes, 0=no)
`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
`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
`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)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction
`blockhash_prefix`	`String`	Default: `''`

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	21,165,666
Size	3.60 GB
First Record	2025-09-01
Last Record	2026-09-01
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)
`instruction_type`	`LowCardinality(String)`	Default: `''` (populated since 2026-08-30)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-09-01 05:29:28`
`block_date_utc`	`2026-09-01`
`slot`	`443,423,706`
`tx_idx`	`102`
`fee_payer`	`4783tYb4JWWbhTk8ZGY6EjjFi1icAoZVNX2N1396Bpvz`
`direction`	`B`
`pool_status`	`0`
`pool_state`	`G5WBxuD4cEjRSVvbxodNtJ7ruDatqwSQwNCMxdFdozZY`

Example Query:

ClickHouse (solana)

raydium_launchpad_token_creation

Statistic	Value
Rows	66,099
Size	20.2 MB
First Record	2025-04-16
Last Record	2026-09-01

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)
`instruction_type`	`LowCardinality(String)`	Default: `''` (populated since 2026-08-30)
`amm_fee_on`	`UInt8`	Default: `0`
`transfer_fee_basis_points`	`UInt16`	Default: `0`
`transfer_fee_max`	`UInt64`	Default: `0`
`signature`	`String`	Transaction signature (base58 encoded) (populated since 2026-08-30)
`parent_program`	`String`	Parent program that invoked this instruction (for CPI calls)
`fee_payer`	`String`	Wallet that paid the transaction fee (populated since 2026-08-30)
`provided_gas_fee`	`UInt64`	Gas fee provided for the transaction (lamports) (populated since 2026-08-30)
`provided_gas_limit`	`UInt64`	Compute unit limit requested (populated since 2026-08-30)
`fee`	`UInt64`	Transaction fee paid (lamports) (populated since 2026-08-30)
`consumed_gas`	`UInt64`	Compute units actually consumed (populated since 2026-08-30)
`cu_price_ix_index`	`Int16`	Instruction index of the compute-unit price instruction (populated since 2026-08-30)
`cu_limit_ix_index`	`Int16`	Instruction index of the compute-unit limit instruction (populated since 2026-08-30)
`num_signatures`	`UInt8`	Number of signatures on the transaction (populated since 2026-08-30)
`transaction_version`	`Int8`	Transaction message version (-1=legacy, 0=v0, -2=unknown) (populated since 2026-08-30)
`lookup_tables`	`String`	Pipe-delimited account addresses loaded through address lookup tables (writable first, then read-only) (populated since 2026-08-30)
`top_level_transfers_json`	`String`	JSON array of top-level SOL/token transfers in the transaction (populated since 2026-08-30)
`blockhash_prefix`	`String`	Default: `''` (populated since 2026-08-30)

Latest Record Sample:

View on Solscan

Column	Value
`block_time`	`2026-09-01 04:59:55`
`slot`	`443,418,126`
`tx_idx`	`533`
`creator`	`b'EnxDvyygvyK4F8a9TP2Vt85bRR2vyzMQYj7Ja9CUAfJC\x00`
`name`	`b'Reverse Spin\x00\x00\x00\x00\x00\x00\x00\x00'`
`symbol`	`b'RSPIN\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x0`
`url`	`b'https://gateway.pinata.cloud/ipfs/QmWUCJdzt13eQH`
`mint`	`b'CatFSUMutP6pqSRcMxjuatTPffHikF7kEd8tbHS1TRiX\x00`

Example Query:

ClickHouse (solana)

sol_top_ups

Statistic	Value
Rows	218,557,061
Size	36.55 GB
First Record	2024-11-02
Last Record	2026-09-01
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-09-01 05:32:03`
`block_date_utc`	`2026-09-01`
`slot`	`443,424,190`
`tx_idx`	`729`
`failed`	`0`
`provided_gas_fee`	`50,000`
`provided_gas_limit`	`200,000`
`fee`	`15,000`

Example Query:

ClickHouse (solana)

solana_blocks

Statistic	Value
Rows	188,410,636
Size	9.70 GB
First Record	1969-12-31
Last Record	2026-09-01

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-09-01 05:32:23`
`slot`	`443,424,252`
`hash`	`b'AKRgpHhJ42hWiN77NvPucNimh7XFmTGH6V8hHAAdApoN\x00`
`validator`	`b'3psxMyr7rQzywVp1MXKd1XFmFz33NjydzCoJx9t2sMQW\x00`
`rewards`	`20,669,497`
`amount_of_transactions`	`1,129`

Example Query:

ClickHouse (solana)

token_transfers

Statistic	Value
Rows	201,556,680
Size	34.91 GB
First Record	2026-08-01
Last Record	2026-09-01
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-09-01 05:32:26`
`block_date_utc`	`2026-09-01`
`slot`	`443,424,262`
`tx_idx`	`1,099`
`failed`	`0`
`provided_gas_fee`	`50,000`
`provided_gas_limit`	`195,000`
`fee`	`14,750`

Example Query:

ClickHouse (solana)

tx_timestamps

Statistic	Value
Rows	0
Size	0 B
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)

Example Query:

ClickHouse (solana)