Query editor
selectorder_source,sum(case when wash_trading_score = 0 then price/1e18 end) as clean,sum(case when wash_trading_score > 0 then price/1e18 end) as washed--CASE when fill_source in ('looksrare.org', 'opensea.io', 'genie.xyz', 'gem.xyz', 'x2y2.io', 'blur.io' ) then fill_source else 'other' end as fill_source,from reservoir.saleswhere timestamp(tx_timestamp) >= now() - interval '3 day'and order_kind != 'mint'group by 1order by 2 desc