Query editor
SELECT date_trunc('day', nftt.block_time) AS time, CASE WHEN wt.is_wash_trade = TRUE THEN 'Wash'WHEN wt.is_wash_trade = FALSE THEN 'Organic'END AS category, SUM(nftt.amount_usd) AS volumeFROM nft.trades nfttINNER JOIN nft.wash_trades wt ON wt.block_number=nftt.block_numberAND wt.unique_trade_id=nftt.unique_trade_idWHERE nftt.blockchain='ethereum'AND wt.is_wash_trade IS NOT NULLAND nftt.project='looksrare'AND nftt.block_time > NOW() - interval '3' monthAND nftt.block_time < date_trunc('day', NOW())AND nftt.tx_hash NOT IN (SELECT tx_hash FROM query_1982559) -- https://dune.com/queries/1982559 (Remove occasional bad data)GROUP BY 1, 2