Query editor
WITH tx_counts AS (SELECT date_trunc('day', block_time) AS time, platform, COUNT(*) AS tx_countFROM nft.tradesWHERE block_time > (date_trunc('day', now()) - interval '{{Daily Charts Interval}}')AND block_time < (date_trunc('day', now()))AND buyer != sellerGROUP BY time, platform), to_exclude AS (SELECT date_trunc('day', block_time) AS time, platform, -COUNT(*) AS tx_countFROM 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()) - interval '{{Daily Charts Interval}}')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)GROUP BY time, platform)SELECT time, platform, SUM(tx_count) AS tx_countFROM (SELECT *FROM tx_countsUNIONSELECT *FROM to_exclude) ungroupedGROUP BY time, platformORDER BY time, tx_count DESC