Query editor
withl1fee as (selectsum(value) / 1e18 as fee,date_trunc('day', evt_block_time) as dayfromerc20_ethereum.evt_Transferwhereto = (0xfeEFEEfeefEeFeefEEFEEfEeFeefEEFeeFEEFEeF)and contract_address = (0x57Ab1ec28D129707052df4dF418D58a2D46d5f51)group by2),l2fee as (selectsum(value) / 1e18 as fee,date_trunc('day', evt_block_time) as dayfromerc20_optimism.evt_Transferwherecontract_address = (0x8c6f28f2F1A3C87F0f938b96d27520d9751ec8d9)and to = (0xfeEFEEfeefEeFeefEEFEEfEeFeefEEFeeFEEFEeF)group by2)selectl2.day,l1.fee as l1fee,l2.fee as l2fee,l1.fee + l2.fee as combined,AVG(l1.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as _7_day_L1,AVG(l1.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as _30_day_L1,AVG(l2.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as _7_day_L2,AVG(l2.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as _30_day_L2,AVG(l2.fee+l1.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as _7_day_combined,AVG(l2.fee+l1.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as _30_day_combined,sum(l2.fee+l1.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 6 PRECEDING AND CURRENT ROW)as _7_day_cumulative,sum(l2.fee+l1.fee) OVER (ORDER BY l2.day ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW)as _30_day_cumulativefroml2fee l2left join l1fee l1 on l1.day = l2.daywherel2.day >= now() - INTERVAL '{{Interval}}' dayorder by l2.day desc