gas.fees

Transaction-level gas fee data across EVM chains — base fee, priority fee, L1/L2 breakdowns, and gas consumption.

The gas.fees table provides transaction-level gas fee data across 55 EVM chains, including fee breakdowns via the tx_fee_breakdown MAP column.

Table Schema

Column	Type	Description
blockchain	VARCHAR	Blockchain name
block_month	DATE	Block month (partition key)
block_date	DATE	Block date
block_time	TIMESTAMP	Block timestamp in UTC
block_number	BIGINT	Block number
tx_hash	VARBINARY	Transaction hash
tx_from	VARBINARY	Address that initiated the transaction
tx_to	VARBINARY	Address that received the transaction
gas_price	UINT256	Gas price per unit in gwei
gas_used	BIGINT	Gas units consumed by the transaction
currency_symbol	VARCHAR	Native token symbol for the blockchain
tx_fee	DOUBLE	Total gas fee in native tokens
tx_fee_usd	DOUBLE	Total gas fee in USD
tx_fee_raw	UINT256	Raw transaction fee
tx_fee_breakdown	MAP(VARCHAR,DOUBLE)	Fee breakdown in native tokens
tx_fee_breakdown_usd	MAP(VARCHAR,DOUBLE)	Fee breakdown in USD
tx_fee_breakdown_raw	MAP(VARCHAR,UINT256)	Raw fee breakdown
tx_fee_currency	VARBINARY	Fee currency address
block_proposer	VARBINARY	Block validator/proposer address
gas_limit	UINT256	Maximum gas units allowed
gas_limit_usage	DOUBLE	Percentage of gas used relative to gas limit

Table sample

Query performance

Partition keys: blockchain, block_month, block_date. Always include blockchain and a date filter.

-- ✅ Good: chain + date filter
SELECT * FROM gas.fees
WHERE blockchain = 'ethereum'
  AND block_date = CURRENT_DATE