Query editor
-- This query used incompatible data types from Dune SQL alpha and may need to be updated.-- More details can be found on https://dune.com/docs/query/dunesql-changes/SELECTdt,CASE WHEN '{{currency}}' = 'ETH' THEN eth_volumeWHEN '{{currency}}' = 'USD' THEN usd_volumeEND AS volumeFROM (SELECTdate_trunc('week', n.block_time) AS dt,SUM(n.amount_usd) AS usd_volume,SUM(n.amount_usd / p.eth_price) AS eth_volumeFROM nft.trades nLEFT JOIN (SELECTDATE_TRUNC('day', minute) AS dt,AVG(price) AS eth_priceFROM prices.usdWHERE symbol = 'WETH'AND minute BETWEEN CAST('2021-01-01' AS TIMESTAMP) AND DATE_TRUNC('day',NOW())GROUP BY 1) p ON DATE_TRUNC('day',n.block_time) = DATE_TRUNC('day',p.dt)WHERE blockchain='ethereum'AND block_time BETWEEN CAST('2021-01-01' AS TIMESTAMP) AND date_trunc('week', NOW())GROUP BY 1)subORDER BY 1 DESC