Query editor
WITH token AS(SELECT DISTINCT call_tx_hash AS tx_hash,CASEWHEN addrs[7] = '\x0000000000000000000000000000000000000000' THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'ELSE addrs[7]END AS token_addressFROM opensea."WyvernExchange_call_atomicMatch_"WHERE (addrs[4] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073'OR addrs[11] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073')AND call_successand call_block_time >= current_date - '90 day'::intervaland addrs[7] in ('\x0000000000000000000000000000000000000000','\x14580a45324d0d35dc08edf982007a44325e3730','\x55370c60fca4929867f8e0e59acfc6198bdca274','\x65558b5b48dca1ed00dbd677c02faba8a6eb270f','\xa0158a5b778e792e861bb44ae663ff9dba1eb427','\xc0829421c1d260bd3cb3e0f06cfe2d52db2ce315','\xd76b5c2a23ef78368d8e34288b5b65d616b746ae','\xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee','\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')),excluded_txns AS(SELECT call_tx_hashFROM opensea."WyvernExchange_call_atomicMatch_"WHERE (addrs[4] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073'OR addrs[11] = '\x5b3256965e7c3cf26e11fcaf296dfc8807c01073')AND call_successAND call_block_time >= current_date - '90 day'::intervalGROUP BY 1HAVING count(DISTINCT CASEWHEN addrs[7] = '\x0000000000000000000000000000000000000000' THEN '\xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'ELSE addrs[7]END) > 1)select day,sum(eth)from (SELECTdate_trunc('day', evt_block_time) AS day,SUM((om.price / 10^18) ) AS ethFROM opensea."WyvernExchange_evt_OrdersMatched" omINNER JOIN token ON token.tx_hash = om.evt_tx_hashWHERE maker != takerAND evt_tx_hash not in (select * from dune_user_generated.kq_washtrading_txns)AND evt_tx_hash not in(SELECT *FROM excluded_txns)and evt_block_time >= current_date - '90 day'::intervalGROUP BY 1union allselectdate_trunc('day', block_time) AS day,SUM(original_amount) AS ethfrom seaport.view_transactionswhere original_currency in ('ETH', 'WETH')and block_time >= current_date - '90 day'::intervalgroup by 1) agroup by 1order by 1