Query editor
WITH ClosestBlocks AS (SELECT *FROM (SELECTweek_start,COALESCE(next_week_start, CURRENT_TIMESTAMP) AS next_week_start,SUM(rewardPerBlock) AS rewardPerBlockFROM (SELECTevt_block_time AS week_start,LEAD(evt_block_time) OVER (ORDER BY evt_block_time) AS next_week_start,rewardPerBlockFROM woofi_staking_v2_arbitrum.SimpleRewarder_evt_SetRewardPerBlockOnRewarderWHERE evt_block_time > TIMESTAMP '2023-05-25 15:00'UNION ALLSELECTevt_block_time AS week_start,LEAD(evt_block_time) OVER (ORDER BY evt_block_time) AS next_week_start,rewardPerBlockFROM woofi_staking_v2_arbitrum.SimpleRewarder_USDC_evt_SetRewardPerBlockOnRewarderWHERE evt_block_time > TIMESTAMP '2023-05-25 15:00') tGROUP BY week_start, next_week_startUNION ALLSELECTweek_start + INTERVAL '7' DAY AS week_start,COALESCE(next_week_start, CURRENT_TIMESTAMP) AS next_week_start,SUM(rewardPerBlock) AS rewardPerBlockFROM (SELECTevt_block_time AS week_start,LEAD(evt_block_time) OVER (ORDER BY evt_block_time) AS next_week_start,rewardPerBlockFROM woofi_staking_v2_arbitrum.SimpleRewarder_evt_SetRewardPerBlockOnRewarderWHERE evt_block_time > TIMESTAMP '2023-05-25 15:00'UNION ALLSELECTevt_block_time AS week_start,LEAD(evt_block_time) OVER (ORDER BY evt_block_time) AS next_week_start,rewardPerBlockFROM woofi_staking_v2_arbitrum.SimpleRewarder_USDC_evt_SetRewardPerBlockOnRewarderWHERE evt_block_time > TIMESTAMP '2023-05-25 15:00') tWHERE next_week_start > week_start + INTERVAL '8' DAYOR next_week_start IS NULL AND CURRENT_TIMESTAMP > week_start + INTERVAL '8' DAYGROUP BY week_start, next_week_start) cteWHERE rewardPerBlock >= 10ORDER BY week_start DESC),DynamicWeekEnds AS (SELECTweek_start,CASEWHEN LEAD(week_start) OVER (ORDER BY week_start) IS NULL THEN next_week_startELSE COALESCE(LEAD(week_start) OVER (ORDER BY week_start), next_week_start)END AS week_endFROM ClosestBlocks),EthBlocksCount AS (