gas_solana.fees

The gas_solana.fees table provides transaction-level fee data on Solana, including compute unit pricing and vote/non-vote transaction classification.

Table Schema

Column	Type	Description
`blockchain`	`VARCHAR`	Blockchain (always solana)
`block_month`	`DATE`	Block month
`block_date`	`DATE`	Block date
`block_time`	`TIMESTAMP`	Block timestamp
`block_slot`	`BIGINT`	Block slot number
`tx_index`	`INTEGER`	Transaction index
`tx_hash`	`VARCHAR`	Transaction hash
`signer`	`VARCHAR`	Transaction signer address
`compute_unit_price`	`DOUBLE`	Compute unit price in lamports
`compute_limit`	`BIGINT`	Compute units used or limit set
`currency_symbol`	`VARCHAR`	Currency symbol (SOL)
`tx_fee_raw`	`BIGINT`	Raw transaction fee in lamports
`tx_fee`	`DOUBLE`	Transaction fee in SOL
`tx_fee_usd`	`DOUBLE`	Transaction fee in USD
`tx_fee_breakdown_raw`	`MAP(VARCHAR,DOUBLE)`	Fee breakdown (base_fee, prioritization_fee) in raw
`tx_fee_breakdown`	`MAP(VARCHAR,DOUBLE)`	Fee breakdown in SOL
`tx_fee_breakdown_usd`	`MAP(VARCHAR,DOUBLE)`	Fee breakdown in USD
`tx_fee_currency`	`VARCHAR`	Fee currency address
`leader`	`VARCHAR`	Validator that proposed the block
`tx_type`	`VARCHAR`	Transaction type (vote or normal)

Table sample

Query performance

Filter on block_date. Use tx_type = 'normal' to exclude validator vote transactions from analysis.

-- ✅ Good: date filter, non-vote only
SELECT * FROM gas_solana.fees
WHERE block_date = CURRENT_DATE
  AND tx_type = 'normal'

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Table Schema

Table sample

Query performance

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

​Table Schema

​Table sample

​Query performance

Table Schema

Table sample

Query performance