Query editor
WITH token_prices AS (SELECTDATE_TRUNC('day', timestamp) AS timestamp, blockchain, contract_address, decimals, AVG(price) AS priceFROMprices.hour pGROUP BYDATE_TRUNC('day', timestamp), blockchain, contract_address, decimals)SELECTDATE_TRUNC('day', evt_block_time) AS evt_date,w.chain,SUM((w.fromAmount / POWER(10, COALESCE(p.decimals, 18))) * p.price) AS swapVol_sumFROMwoofi_multichain.wooficrossrouterv5_evt_wooficrossswaponsrcchain AS wLEFT JOINtoken_prices pONw.fromToken = p.contract_addressANDw.chain = p.blockchainANDDATE(w.evt_block_time) = DATE(p.timestamp)WHEREw.evt_block_time >= DATE_TRUNC('day', CURRENT_DATE) - INTERVAL '1' month - INTERVAL '1' dayGROUP BYDATE_TRUNC('day', evt_block_time),w.chain