Query editor
WITH traders AS (SELECT date_trunc('month', block_time) AS time, COUNT(distinct trader) AS tradersFROM(SELECT block_time, buyer AS traderFROM nft.tradesWHERE buyer != sellerAND block_time < date_trunc('day', NOW())UNIONSELECT block_time, seller AS traderFROM nft.tradesWHERE buyer != sellerAND block_time < date_trunc('day', NOW())) ungroupedGROUP BY time), to_exclude AS (SELECT date_trunc('month', block_time) AS time, -COUNT(distinct trader) AS tradersFROM(SELECT block_time, buyer AS traderFROM nft.tradesWHERE tx_hash IN (SELECT '\x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0' AS txsUNIONSELECT call_tx_hash AS txsFROM opensea."WyvernExchange_call_atomicMatch_"WHERE (addrs[4] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073'OR addrs[11] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073')AND call_successAND call_block_time > '2022-01-21'AND call_block_time < date_trunc('day', NOW())GROUP BY 1HAVING count(DISTINCT CASE WHEN addrs[7] = '\x0000000000000000000000000000000000000000'THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' ELSE addrs[7]END) > 1)UNIONSELECT block_time, seller AS traderFROM nft.tradesWHERE tx_hash IN (SELECT '\x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0' AS txsUNIONSELECT call_tx_hash AS txsFROM opensea."WyvernExchange_call_atomicMatch_"WHERE (addrs[4] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073'OR addrs[11] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073')AND call_successAND call_block_time > '2022-01-21'AND call_block_time < date_trunc('day', NOW())GROUP BY 1HAVING count(DISTINCT CASE WHEN addrs[7] = '\x0000000000000000000000000000000000000000'THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' ELSE addrs[7]END) > 1)) ungroupedGROUP BY time)