Solana Indexer Schema conventions

The Solana database holds 21 tables and 557 columns of decoded DEX activity. This page covers what is true across all of them; the per-table column lists live in the Table reference.

Shared columns

Almost every table carries the same transaction envelope. Use it for joins, time-series aggregation, and wallet-level work.

(slot, tx_idx) identifies a transaction inside a block, and together with signature it is what you join on across tables.

Four gotchas

1. Fixed-width columns are null-padded

Older tables store mints, wallets, and signatures as FixedString(48) or FixedString(128). ClickHouse pads the unused bytes with \0, so a raw value will not compare equal to a plain base58 string, and grouping by it produces keys with invisible trailing bytes.

Strip the padding on both sides of any comparison or join:

SELECT replaceAll(toString(mint), '\0', '') AS mint_clean,
       count() AS launches
FROM pumpfun_token_creation
WHERE block_time >= now() - INTERVAL 1 DAY
GROUP BY mint_clean

Newer tables use plain String and need no cleanup. The Table reference shows the exact type per column.

2. Every amount is a raw base unit

Token and SOL amounts are integers in the smallest unit - lamports for SOL, and the mint's own base unit for SPL tokens. Nothing is pre-divided by decimals, and nothing is converted to USD. Divide by 1e9 for SOL; for a token, apply that mint's decimals.

Fee-rate columns follow the same rule: lp_fee_basis_points and protocol_fee_basis_points are basis points, not fractions.

3. The partition key is not the same on every table

Most tables partition on block_date_utc, but not all:

4. Some columns only carry data from a certain date

Columns added after a table went live are marked (populated since ...) in the Table reference. The column exists on every row, but rows older than that date hold the type default - an empty string or a zero, not a NULL. Filter on the date range as well as the column value, or old rows will quietly look like real zeros.

Transaction metadata added to the schema

The published schema includes transaction context on Pump.fun launches and v2 swaps, Raydium swaps and Launchpad events, and Meteora swaps. Depending on the table, this includes fee_payer, blockhash_prefix, compute-budget instruction indexes, num_signatures, transaction_version, lookup_tables, and top_level_transfers_json. Check the exact column list and its populated-since date before joining older records.

Meteora Dynamic Bonding Curve swaps also expose curve_complete, base_reserve_after, and quote_reserve_after. Raydium Launchpad token creation includes amm_fee_on, transfer_fee_basis_points, and transfer_fee_max; its swap and creation tables include instruction_type.

Retention

Retention is per table. Nothing is a single global window.

Coverage and latency

Storage engine

See also