, status

, count(tx_hash) as tx_count

, avg(gas_price) as avg_gas_price

, percentile_cont(0.5) within group (order by gas_price) as median_gas_price

, avg(gas_used) as avg_gas_used

, percentile_cont(0.5) within group (order by gas_used) as median_gas_used

, avg(tx_fee) as avg_tx_fee

, percentile_cont(0.5) within group (order by tx_fee) as median_tx_fee

from avalanche.core.fact_transactions

where block_number >= 16425749

group by 1,2

order by block_number asc