as day, avg(tx_fee) as avg_gas_price,

avg(avg_gas_price) over (order by day) as avg_gas_price_over_time

from avalanche.core.fact_transactions

GROUP by 1

-- limit 10