Query editor
WITH res_nft AS (SELECTDATE_TRUNC('{{Mode}}', FROM_UNIXTIME(tx_timestamp)) AS "Date",CASE WHEN order_source <> '' THEN order_source ELSE 'others' END AS order_source,CASE WHEN fill_source <> '' THEN fill_source ELSE 'others' END AS fill_source,COUNT(*) AS sales,SUM(price / TRY_CAST(1e18 AS DOUBLE)) AS volume,COUNT(DISTINCT to) AS usersFROM reservoir.sales AS rsWHEREDATE_TRUNC('{{Mode}}', FROM_UNIXTIME(tx_timestamp)) >= TRY_CAST(CAST('{{Start_Date}}' AS TIMESTAMP) AS TIMESTAMP)AND order_kind <> 'mint'AND wash_trading_score <> 1GROUP BY1,2,3ORDER BY1 DESC), weth_prices AS (SELECTDATE_TRUNC('{{Mode}}', minute) AS "Date",AVG(price) AS "price"FROM prices.usdWHEREsymbol = 'WETH'AND minute IN (SELECTMIN(minute)FROM prices.usdWHEREsymbol = 'WETH'GROUP BYDATE_TRUNC('{{Mode}}', minute))GROUP BY1ORDER BY1 DESC), usd_price AS (SELECT*FROM res_nftINNER JOIN weth_pricesUSING ("date")ORDER BY1 NULLS FIRST)SELECT"date",CASE WHEN volume > 500 THEN fill_source ELSE 'others' END AS fill_source,sales,users,volume,volume * price AS "USD"FROM usd_priceGROUP BY1,2,3,