Query editor
WITH token_transfers AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx_hash,"from","to",value AS raw_amount,value / POWER(10, COALESCE(t.decimals, 18)) AS adjusted_amount,t.symbol AS token_symbol,e.contract_addressFROM erc20_arbitrum.evt_Transfer AS eLEFT JOIN tokens.erc20 AS tON e.contract_address = t.contract_addressWHERE"to" = 0x21568459854adcda462f6d9c11ce4f157dc70f93OR "from" = 0x21568459854adcda462f6d9c11ce4f157dc70f93),usd_converted_transfers AS (SELECTblock_time,tx_hash,"from","to",raw_amount,adjusted_amount,adjusted_amount * COALESCE(p.usd_price, 1) AS adjusted_amount_usd,token_symbol,contract_addressFROM token_transfersLEFT JOIN (SELECTsymbol,MAX(price) AS usd_priceFROM token_pricesWHERE date = CURRENT_DATEGROUP BY symbol) AS p ON token_transfers.token_symbol = p.symbol),cumulative_transfers AS (SELECTblock_time,tx_hash,"from","to",raw_amount,adjusted_amount_usd,token_symbol,contract_address,SUM(adjusted_amount_usd) OVER (ORDER BY block_time) AS cumulative_amount_usdFROM usd_converted_transfers)SELECTblock_time,tx_hash,"from","to",raw_amount,adjusted_amount_usd,cumulative_amount_usd,token_symbol,