select BLOCK_TIMESTAMP, gas_price, gas_used, gas_price * gas_used as gas_amount, TX_HASH

from avalanche.core.fact_transactions

select date_trunc('day', BLOCK_TIMESTAMP) as block_date,

count(DISTINCT TX_HASH) as transaction_count,

avg(gas_price) / 1e9 as average_gas_price,

sum(gas_used) / 1e9 as sum_gas_used,

avg(gas_used) as average_gas_used,

sum(gas_amount) / 1e18 as sum_gas_amount, -- Not reiliable

avg(gas_amount) / 1e18 as average_gas_amount -- Not reiliable

from transactionn_gas_used

group by 1

order by 1