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)AND evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '90' day), usd_prices /* Get historical price data for accurate USD conversion */ AS (SELECTDATE_TRUNC('hour', minute) AS price_time,contract_address,symbol,AVG(price) AS usd_priceFROM prices.usdWHEREblockchain = 'arbitrum' AND minute >= CURRENT_TIMESTAMP - INTERVAL '90' dayGROUP BY1,2,3), usd_converted_transfers /* Convert token amounts to USD using historical prices */ AS (SELECTtt.block_time,tt.tx_hash,tt."from",tt."to",tt.adjusted_amount,tt.token_symbol,tt.contract_address,tt.adjusted_amount * COALESCE(p.usd_price,CASEWHEN tt.token_symbol = 'USDC'THEN 1.0WHEN tt.token_symbol = 'USDT'THEN 1.0WHEN tt.token_symbol = 'ARB'THEN 0.28 /* Fallback price if no price data */ELSE 0 /* Unknown tokens with no price data */END) AS adjusted_amount_usdFROM token_transfers AS ttLEFT JOIN usd_prices AS pON tt.contract_address = p.contract_addressAND DATE_TRUNC('hour', tt.block_time) = p.price_time)SELECTSUM(adjusted_amount_usd) AS total_adjusted_amount_usd,