Query editor
WITH redeemed AS (SELECTBYTEARRAY_SUBSTRING(topic1, 13, 20) AS wallet,VARBINARY_TO_UINT256(data) / 1e18 AS reward_amount,tx_hash AS reward_tx_hash,block_time AS timestampFROM ethereum.logsWHEREcontract_address = 0x70236b36f86ab4bd557fe9934e1246537b472918AND topic0 = 0xe2403640ba68fed3a2f88b7557551d1993f84b99bb10ff833f0cf8db0c5e0486),ctx_price AS (SELECTday,priceFROM prices.usd_dailyWHERE symbol = 'CTX')SELECTr.wallet,r.timestamp,r.reward_tx_hash,r.reward_amount,p.price AS reward_price,(r.reward_amount * p.price) AS reward_usd,-- cumulative reward sums over timeSUM(r.reward_amount) OVER (ORDER BY r.timestamp) AS cumulative_rewards,SUM(r.reward_amount * p.price) OVER (ORDER BY r.timestamp)AS cumulative_rewards_usdFROM redeemed rLEFT JOIN ctx_price pON DATE(r.timestamp) = p.dayORDER BY r.timestamp DESC