Query editor
WITH volume AS (SELECT date_trunc('month', block_time) AS time, platform, SUM(usd_amount) AS volumeFROM nft.tradesWHERE buyer != sellerAND block_time < date_trunc('day', NOW())GROUP BY time, platform), to_exclude AS (SELECT date_trunc('month', block_time) AS time, platform, -SUM(usd_amount) AS volumeFROM 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)GROUP BY time, platform), lr_high_prices AS (SELECT nft_contract_address, MAX(usd_amount) AS wash_filter_priceFROM nft.tradesWHERE nft_contract_address IN ('\xff9c1b15b16263c61d017ee9f65c50e4ae0113d7', -- Loot'\x7bd29408f11d2bfc23c34f18275bbf23bb716bc7', -- Meebits'\x4e1f41613c9084fdb9e34e11fae9412427480e56', -- Terraforms'\xce25e60a89f200b1fa40f6c313047ffe386992c3', -- dotdotdot'\x05a46f1E545526FB803FF974C790aCeA34D1f2D6' -- The n project)AND platform='OpenSea'AND block_time >= '2021-01-01' AND block_time <= '2022-01-31'GROUP BY nft_contract_address), lr_filtered AS (SELECT date_trunc('month', block_time) AS time, 'LooksRare' AS platform, SUM(usd_amount) AS wt_lr_volumeFROM nft.trades nfttLEFT JOIN lr_high_prices hp ON hp.nft_contract_address=nftt.nft_contract_addressWHERE platform = 'LooksRare'AND block_time < date_trunc('day', NOW())AND (((SELECT COUNT(*) FROM nft.trades nftt2WHERE nftt2.seller=nftt.buyerAND nftt2.buyer=nftt.sellerAND nftt2.nft_contract_address=nftt.nft_contract_addressAND nftt2.nft_token_id=nftt.nft_token_id