Query editor
WITH grouped AS(SELECT date_trunc('week', block_time) AS time,buyer,seller,buyer AS tradersFROM nft.tradesWHERE block_time > (date_trunc('week', now()) - interval '1 year')--AND block_time < (date_trunc('week', now()))AND buyer != sellerUNIONSELECT date_trunc('week', block_time) AS time,NULL AS buyer,NULL AS seller,seller AS tradersFROM nft.tradesWHERE block_time > (date_trunc('week', now() - interval '1 year'))AND block_time < (date_trunc('week', now()))AND buyer != seller)SELECT time AS "Date",COUNT(distinct buyer) AS "Buyers",COUNT(distinct seller) AS "Sellers",COUNT(distinct traders) AS "Unique Traders"FROM groupedGROUP BY 1ORDER BY 1