Query editor
WITH staked AS (SELECT'Staked' AS status1,BYTEARRAY_SUBSTRING(topic1, 13, 20) AS wallet,BYTEARRAY_SUBSTRING(topic2, 13, 20) AS delegatee,-- change this to whatever numeric conversion you need:VARBINARY_TO_UINT256(data) / 1e18 AS staked_amount,block_time AS timestamp,tx_hash AS staked_tx_hash,block_number,block_hash,contract_address,topic0,"index",tx_from,tx_toFROM ethereum.logsWHEREcontract_address = 0x70236b36f86ab4bd557fe9934e1246537b472918AND topic0 = 0x5dac0c1b1112564a045ba943c9d50270893e8e826c49be8e7073adc713ab7bd7),ctx_price AS (SELECTday,priceFROM prices.usd_dailyWHERE symbol = 'CTX')SELECTs.wallet,s.timestamp,s.staked_tx_hash,s.staked_amount,p.price AS staked_price,(s.staked_amount * p.price) AS staked_usd,-- cumulative staked sums over timeSUM(s.staked_amount) OVER (ORDER BY s.timestamp) AS cumulative_staked_ctx,SUM(s.staked_amount * p.price) OVER (ORDER BY s.timestamp) AS cumulative_staked_usdFROM staked sLEFT JOIN ctx_price pON DATE(s.timestamp) = p.dayORDER BY s.timestamp DESC;