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,CASEWHEN token_symbol = 'USDC' THEN adjusted_amountWHEN token_symbol = 'ARB' THEN adjusted_amount * 0.28ELSE adjusted_amountEND AS adjusted_amount_usd,token_symbol,contract_addressFROM token_transfers),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),revenue_transfers AS (SELECTblock_time,tx_hash,"from","to",raw_amount,adjusted_amount_usd,token_symbol,contract_address,cumulative_amount_usd,adjusted_amount_usd * 0.05 AS revenue,SUM(adjusted_amount_usd * 0.05) OVER (ORDER BY block_time) AS cumulative_revenue