Query editor
WITH tt (tx_day, evt_block_time, amount_usd, fee_usd, action) AS (SELECTtx_day,evt_block_time,amount / pow(10, amount_prices.decimals) * amount_prices.price,CASE WHEN fee_asset = 0x99ec76235f8a5A52611b0DA5F0C6B09e1dCD2C9eTHEN fee_amount / pow(10, 18) * fee_prices.priceELSE 0END,actionFROM query_3705001 AS trades_with_feesLEFT JOIN prices.usd AS amount_pricesONamount_prices.contract_address = trades_with_fees.amount_assetAND amount_prices.blockchain = 'arbitrum'AND amount_prices.minute = DATE_TRUNC('minute', trades_with_fees.evt_block_time)LEFT JOIN prices.usd AS fee_pricesONfee_prices.symbol = 'ETH'AND fee_prices.blockchain IS NULLAND fee_prices.minute = DATE_TRUNC('minute', trades_with_fees.evt_block_time)),fee_events (tx_day, evt_block_time, amount_usd, fee_usd, action) AS (SELECTDATE_TRUNC('day', evt_block_time) AS tx_day,evt_block_time,0 AS amount_usd,fee_usd,'PaidFee' AS actionFROM query_4111104 AS paid_feeWHERE network = 'arbitrum'),data AS (SELECTtx_day AS "timestamp",SUM(amount_usd) AS volume_usd,SUM(fee_usd) AS fees_usdFROM (SELECT"day" AS tx_day,0 AS amount_usd,0 AS fee_usdFROM query_3093463 AS time_seriesUNIONSELECTtx_day,amount_usd,fee_usdFROM ttUNIONSELECTtx_day,amount_usd,fee_usdFROM fee_events)GROUP BY tx_day)SELECT * FROM dataWHERE timestamp > CAST('{{timestamp}}' AS TIMESTAMP)