Query editor
WITHTime AS (SELECTdayFROMUNNEST (SEQUENCE(TRY_CAST('2021-09-08' AS TIMESTAMP),CAST(CAST(CAST(DATE_TRUNC('day', CURRENT_TIMESTAMP) AS TIMESTAMP) AS TIMESTAMP) AS TIMESTAMP),INTERVAL '1' day)) AS _u (day)),SafetyRewards AS (SELECTDATE_TRUNC('day', "evt_block_time") AS day,SUM("claimedRewards" / CAST(POWER(10, 18) AS DOUBLE)) AS SafetyClaimedRewardsFROMdydx_perpetual_ethereum.stkDYDX_evt_ClaimedRewardsGROUP BY1),LiquidityRewards AS (SELECTDATE_TRUNC('day', "evt_block_time") AS day,SUM("claimedRewards" / CAST(POWER(10, 18) AS DOUBLE)) AS LiquidityClaimedRewardsFROMdydx_perpetual_ethereum.LiquidityStakingV1_evt_ClaimedRewardsGROUP BY1),MerkleAccount AS (SELECTDATE_TRUNC('day', "evt_block_time") AS day,"account" AS account,SUM("amount" / CAST(POWER(10, 18) AS DOUBLE)) AS MerkleClaimedRewardsFROMdydx_perpetual_ethereum.MerkleDistributorV1_evt_RewardsClaimedWHERE"account" <> 0x95eabb0248d013b9f59c5d5256ce11b0a8140b54 /* unearned retroactive rewards distributed to Community Treasury */GROUP BY1,2),MerkleRewards AS (SELECTday,SUM(MerkleClaimedRewards) AS MerkleClaimedRewardsFROMMerkleAccountGROUP BY1),ClaimedRewardsByTime AS (SELECTTime.day,