Query editor
with dydx_bridged AS(SELECTevt_block_time AS time,cast(value/1e18 AS DOUBLE) AS dydx_bridgedFROM evms.erc20_transfersWHERE contract_address = 0x92D6C1e31e14520e676a687F0a93788B716BEff5 AND to = 0x46b2DeAe6eFf3011008EA27EA36b7c27255ddFA9 AND evt_block_time >= cast('2023-09-30' AS TIMESTAMP)),dydx_bought AS(SELECTblock_time AS time,cast(token_bought_amount AS DOUBLE) AS dydx_boughtFROM dex.tradesWHERE token_bought_address = 0x92D6C1e31e14520e676a687F0a93788B716BEff5 AND block_time >= cast('2023-09-30' AS TIMESTAMP))SELECTdydx_bridged.time,SUM(dydx_bridged) over (ORDER BY dydx_bridged.time) AS total_dydx_bridged,SUM(dydx_bought) over (ORDER BY dydx_bridged.time) AS total_dydx_boughtFROM dydx_bridgedLEFT JOIN dydx_bought ON dydx_bridged.dydx_bridged = dydx_bought.dydx_boughtORDER BY time DESC