Query editor
select block_date, daily_avg_transaction_fee, avg(daily_avg_transaction_fee) over (order by block_date rows between 14 preceding and current row) as two_weeks_moving_avg_transaction_feefrom (select block_date, avg(gas_used * eth_gas_price) as daily_avg_transaction_feefrom (select block_date, gas_price / cast(1e18 as double) as eth_gas_price, gas_usedfrom ethereum.transactionswhere hash in (select tx_hashfrom ethereum.logswhere block_time >= CURRENT_TIMESTAMP - INTERVAL '3' monthand contract_address = 0x1A3496C18d558bd9C6C8f609E1B129f67AB08163) and varbinary_starts_with(data, 0xa9059cbb))group by block_dateorder by block_date) daily_summaryorder by block_date desc;