gas.fees

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

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