Query editor
SELECTDATE_TRUNC('month', from_unixtime(tx_timestamp)) AS date_time,SUM(CASE WHEN wash_trading_score = 0 then usd_price_decimal else 0 end) AS organic_volume,SUM(usd_price_decimal) as all_volume,COUNT(DISTINCT(to)) AS total_buyersFROM reservoir.salesWHERE order_kind != 'mint'AND wash_trading_score = 0AND date_trunc('month',from_unixtime(tx_timestamp)) < DATE_TRUNC('month', NOW())AND date_trunc('month',from_unixtime(tx_timestamp)) >= DATE('2021-03-01')GROUP BY 1ORDER BY 1 DESC