Query editor
WITH Prices AS (SELECTDATE_TRUNC('day', minute) AS Day, symbol, AVG(price) AS PriceFROM prices.usdWHERE blockchain = 'ethereum'GROUP BY 1,2),Volumes AS (SELECTDay, CASE WHEN Market = 'ID105' THEN '[105] weETH-ETH' WHEN Market = 'ID144' THEN '[144] sUSDf-USDC' WHEN Market = 'ID145' THEN '[145] PT-sUSDf(25 Sep)-USDC'WHEN Market = 'ID118' THEN '[118] LP-eUSDe(14 Aug 25)-USDC' WHEN Market = 'ID123' THEN '[123] PT-eUSDE(14 Aug)-USDC' WHEN Market = 'ID117' THEN '[117] LP-sUSDe(31 Jul 25)-USDC'WHEN Market = 'ID124' THEN '[124] PT-sUSDE(25 Sep)-USDC' WHEN Market = 'ID127' THEN '[127] RLP-USDC' WHEN Market = 'ID135' THEN '[135] PT-USR(4 Sep)-USDC'WHEN Market = 'ID138' THEN '[138] PT-wstUSR(25 Sep)-USDC' WHEN Market = 'ID104' THEN '[104] ezETH-ETH' WHEN Market = 'ID113' THEN '[113] LP-sUSDe(25 Sep 25)-USDC'WHEN Market = 'ID150' THEN '[150] wsrUSD-USDC' WHEN Market = 'ID140' THEN '[140] PT-RLP(4 Sep)-USDC'WHEN Market = 'ID146' THEN '[146] PT-cUSDO(20 Nov)-USDC' WHEN Market = 'ID149' THEN '[149] PT-USDS(14 Aug)-USDC' WHEN Market = 'ID137' THEN '[137] PT-USDe(25 Sep)-USDC'WHEN Market = 'ID142' THEN '[142] mMEV-USDC' WHEN Market = 'ID131' THEN '[131] WBTC-USDC' WHEN Market = 'ID125' THEN '[125] PT-eUSDE(14 Aug)-USDf'WHEN Market = 'ID148' THEN '[148] USR-USDC' WHEN Market = 'ID147' THEN '[147] wstUSR-USDC' WHEN Market = 'ID151' THEN '[151] USDf-USDC' WHEN Market = 'ID152' THEN '[152] tETH-ETH'WHEN Market = 'ID153' THEN '[153] PT-tETH-8JAN2026/ETH' WHEN Market = 'ID154' THEN '[154] RLP-USDC' WHEN Market = 'ID155' THEN '[155] xUSD-USDC' WHEN Market = 'ID158' THEN '[158] slvlUSD-USDC'WHEN Market = 'ID159' THEN '[159] PT-slvlUSD-25SEP2025/USDC' WHEN Market = 'ID162' THEN '[162] wstETH-ETH' WHEN Market = 'ID163' THEN '[163] weETH-ETH'WHEN Market = 'ID164' THEN '[164] ARM-WETH-stETH/ETH' WHEN Market = 'ID165' THEN '[165] PT-tUSDe-25SEP2025/USDC' WHEN Market = 'ID166' THEN '[166] ETH+/ETH'WHEN Market = 'ID168' THEN '[168] siUSD-USDC' WHEN Market = 'ID169' THEN '[169] PT-siUSD(9 Oct)/USDC'WHEN Market = 'ID170' THEN '[170] PT-sUSDf(29 Jan)/USDC' WHEN Market = 'ID171' THEN '[171] PT-USDf(29 Jan)/USDC' WHEN Market = 'ID172' THEN '[172] savETH-ETH'WHEN Market = 'ID173' THEN '[173] PT-iUSD(4 Dec)/USDC' WHEN Market = 'ID175' THEN '[175] PT-wstUSR(29 Jan)/USDC' WHEN Market = 'ID178' THEN '[178] PT-iUSD(19 Feb)/USDC'WHEN Market = 'ID181' THEN '[181] siUSD-USDC' WHEN Market = 'ID182' THEN '[182] PT-reUSD(25 Jun)/USDC'ELSE Market END AS Market, CASEWHEN asset = 'ETH' THEN 'WETH' WHEN asset = 'sUSDf' THEN 'USDC' WHEN asset = 'PT-sUSDf (25 Sep)' THEN 'USDC' WHEN asset = 'LP-eUSDe (14 Aug 25)' THEN 'USDe'WHEN asset = 'PT-eUSDE (14 Aug)' THEN 'USDe' WHEN asset = 'LP-sUSDe (31 Jul 25)' THEN 'SUSDE' WHEN asset = 'PT-sUSDE (25 Sep)' THEN 'SUSDE'WHEN asset = 'PT-USR (4 Sep)' THEN 'USR' WHEN asset = 'PT-wstUSR (25 Sep)' THEN 'USR' WHEN asset = 'LP-sUSDe (25 Sep 25)' THEN 'SUSDE' WHEN asset = 'wsrUSD' THEN 'USDC'WHEN asset = 'PT-RLP (4 Sep)' THEN 'RLP' WHEN asset = 'USDf' THEN 'USDC' WHEN asset ='PT-cUSDO (20 Nov)' THEN 'USDC'WHEN asset = 'PT-USDS (14 Aug)' THEN 'USDS'WHEN asset = 'PT-USDe (25 Sep)' THEN 'USDe' WHEN asset = 'mMEV' THEN 'USDC' WHEN asset = 'wstUSR' THEN 'USR' --WHEN asset = 'weETH' THEN 'WEETH'WHEN asset = 'tETH' THEN 'WETH' WHEN asset = 'PT-tETH-8JAN2026' THEN 'WETH' WHEN asset = 'xUSD' THEN 'USDC' WHEN asset = 'ezETH' THEN 'EZETH' WHEN asset = 'slvlUSD' THEN 'USDC'WHEN asset = 'PT-slvlUSD-25SEP2025' THEN 'USDC' WHEN asset = 'ARM-WETH-stETH' THEN 'WETH' WHEN asset = 'PT-tUSDe-25SEP2025' THEN 'USDC' WHEN asset = 'ETH+' THEN 'WETH'WHEN asset = 'siUSD' THEN 'USDC' WHEN asset = 'PT-siUSD (9 Oct)' THEN 'USDC'WHEN asset = 'PT-sUSDf (29 Jan)' THEN 'USDC' WHEN asset = 'PT-USDf (29 Jan)' THEN 'USDC' WHEN asset = 'savETH' THEN 'WETH' WHEN asset = 'PT-iUSD (4 Dec)' THEN 'USDC' WHEN asset = 'PT-wstUSR (29 Jan)' THEN 'USDC'WHEN asset = 'PT-iUSD (19 Feb)' THEN 'USDC' WHEN asset = 'siUSD' THEN 'USDC' WHEN asset = 'PT-reUSD (25 Jun)' THEN 'USDC'ELSE asset END AS Symbol, VolumeFROM (SELECTDATE_TRUNC('day', Date) AS Day, Market, Asset AS asset, SUM(Amount) AS VolumeFROM query_5494012GROUP BY 1,2,3))SELECTDay, Market, SUM(Volume_USD) AS Volume_USDFROM (SELECTa.Day, a.Market, a.Symbol, a.Volume