select block_timestamp, gas_price, gas_used, gas_price * gas_used as gas_amount, tx_hash

from ethereum.core.fact_transactions

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

count(*) 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,

avg(gas_amount) / 1e18 as average_gas_amount

from transactionn_gas_used

group by block_date

order by block_date