Query editor
selectorder_source,--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,count(*) as sales,round(sum(price/1e18), 2) as volume,round(sum(case when contract = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then price else 0 end)/1e18,1) as Gobblers,round(sum(case when contract = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 0 else price end)/1e18,1) as noGobblers,count(distinct to) as usersfrom reservoir.saleswhere timestamp(tx_timestamp) >= now() - interval '1 days'--and fill_source ='blur.io'and order_kind != 'mint'and fill_source != 'cryptopunks.app'and wash_trading_score = 0group by 1order by 3 desc