Query editor
WITH wash_trading AS (SELECT wash_trading_filterFROM (VALUES('ON', false), ('ON', NULL), ('OFF', true), ('OFF', false), ('OFF', NULL)) AS x (switch, wash_trading_filter)WHERE '{{Wash Trading Filter}}' = switch), all_trades AS (SELECT CASE WHEN LENGTH(aggregator_name) > 1 THEN aggregator_name ELSE project END AS project, buyer, seller, is_wash_tradeFROM (SELECT COALESCE(names.name, t.project) AS project, COALESCE(names_agg.name, t.aggregator_name) AS aggregator_name, t.buyer, t.seller, wt.is_wash_tradeFROM nft.trades tINNER JOIN nft.wash_trades wt ON wt.block_number=t.block_numberAND wt.unique_trade_id=t.unique_trade_idLEFT JOIN query_1933124 names ON names.codename=t.project -- https://dune.com/queries/1933124 For proper project name capitalisationsLEFT JOIN query_1933124 names_agg ON names_agg.codename=t.aggregator_name -- https://dune.com/queries/1933124 For proper project name capitalisationsLEFT JOIN prices.usd pu ON pu.blockchain='ethereum'AND pu.contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND pu.minute = date_trunc('minute', t.block_time)AND pu.minute >= NOW() - interval '7' dayWHERE t.blockchain = 'ethereum'AND t.block_time >= NOW() - interval '7' dayAND t.tx_hash NOT IN (SELECT tx_hash FROM query_1982559) -- https://dune.com/queries/1982559 (Remove ocasional bad data)/*UNION ALLSELECT 'Blur' AS project, aggregator_name, buyer, seller, false AS is_wash_tradeFROM query_2704200 -- Blur v2--LEFT JOIN query_1933124 names_agg ON names_agg.codename=t.aggregator_name -- https://dune.com/queries/1933124 For proper project name capitalisationsWHERE block_time >= NOW() - interval '7' day*/))SELECT project, COUNT(DISTINCT trader) AS traders, project AS for_grouping_for_colorsFROM (SELECT DISTINCT t.project, t.buyer AS traderFROM all_trades tWHERE is_wash_trade IN (SELECT wash_trading_filter FROM wash_trading)