Query editor
with priority_fee as (SELECTdate_trunc('week', block_time) as week,SUM(cast(a.gas_used as double)*(cast(a.gas_price as double)-cast(base_fee_per_gas as double))/1e18) as priority_fee,0 as mev_rewardsFROM ethereum.transactions aleft join ethereum.blocks b on block_number = "number"where date(time) >= date('2021-08-05')and miner=0xe3c44d4d25172ef2e0cdb9e09189a8ca4ed878f4group by 1),mev_fee as (select date_trunc('week', block_time) as week,0 as priority_fee,cast(value as double)/1e18 as mev_rewardsFROM ethereum.tracesWHERE"to" = 0xe3c44d4d25172ef2e0cdb9e09189a8ca4ed878f4and "from" in (0x4838b106fce9647bdf1e7877bf73ce8b0bad5f97, --titan0x95222290dd7278aa3ddd389cc1e1d165cc4bafe5, --beaver0x1f9090aae28b8a3dceadf281b0f12828e676c326, --resyn0xa83114a443da1cecefc50368531cace9f37fcccb --beaver)),all_fee as (select sum(staking_rewards) as staking_reward,sum(priority_fee) as priority_fee,sum(mev_rewards) as mev_fee,week from (select *,0 as staking_rewards from priority_feeunion allselect *,0 as staking_rewards from mev_feeunion allselect week,0 as priority_fee, 0 as mev_rewards, eth_rewards_weekly as staking_rewards from query_4770331)group by 4)SELECTpriority_fee,mev_fee,staking_reward,SUM(priority_fee + mev_fee+staking_reward) OVER (ORDER BY week) AS total_rewards_accumulated,weekFROM all_feeorder by week desc