Query editor
--acknowledging some DEFI NFTs will showed up as paidwith nft_contracts as (SELECTblockchain,contract_address,block_time,"to" as address,tx_hash,COUNT(token_id) as total_nftsFROMnft.transfersWHERE"from" = 0x0000000000000000000000000000000000000000and block_time > DATE('2020-01-01')AND date_trunc('month',block_time) < date_trunc('month', now())AND blockchain in ('base','arbitrum','optimism','ethereum','zora','zksync')and contract_address not in (0x03a520b32C04BF3bEEf7BEb72E919cf822Ed34f1,0xe84f7a8ae66fb5db5fecc92a0c695c8bb336731d,0x2cdca0a5e8c0133dc8e3677b4022817c6c7dc40b,0xcfb05ab06d338fd85bbf4486e69809d96a906b77,0x9c889480b54643c419756b6f4d8e8cd673df9540,0x0d8127a01bdb311378ed32f5b81690dd917dba35,0xb3cc484a60bc300719aaefbd158a4e8e59d84555,0xc36442b4a4522e871399cd717abdd847ab11fe88,0xe222fbe074a436145b255442d919e4e3a6c6a480,0x126be6a9ec71a1fea19d2288ba2ce4cdc0facb68,0x1af415a1eba07a4986a52b6f2e7de7003d82231e,0xaec8318a9a59baeb39861d10ff6c7f7bf1f96c57,0xc36442b4a4522e871399cd717abdd847ab11fe88,0xe222fbe074a436145b255442d919e4e3a6c6a480,0x126be6a9ec71a1fea19d2288ba2ce4cdc0facb68,0x1af415a1eba07a4986a52b6f2e7de7003d82231e,0xaec8318a9a59baeb39861d10ff6c7f7bf1f96c57,0x80c7dd17b01855a6d2347444a0fcc36136a314de,0xc36442b4a4522e871399cd717abdd847ab11fe88,0xe222fbe074a436145b255442d919e4e3a6c6a480,0x126be6a9ec71a1fea19d2288ba2ce4cdc0facb68,0x1af415a1eba07a4986a52b6f2e7de7003d82231e,0xaec8318a9a59baeb39861d10ff6c7f7bf1f96c57,0xc36442b4a4522e871399cd717abdd847ab11fe88,0x46a15b0b27311cedf172ab29e4f4766fbe7f4364,0x4a3e49f77a2a5b60682a2d6b8899c7c5211eb646,0xe222fbe074a436145b255442d919e4e3a6c6a480,0x2214a42d8e2a1d20635c2cb0664422c528b6a432,0xc36442b4a4522e871399cd717abdd847ab11fe88,0x46a15b0b27311cedf172ab29e4f4766fbe7f4364,0x4a3e49f77a2a5b60682a2d6b8899c7c5211eb646,0xe222fbe074a436145b255442d919e4e3a6c6a480,0x2214a42d8e2a1d20635c2cb0664422c528b6a432)GROUP BY 1, 2, 3, 4,5),base_nfts as (SELECTdate_trunc('month',b.block_time) as date_time,CASE WHEN value/1e18 > 0 THEN 'Paid' ELSE 'Free' end as free_paid,value/1e18 as vol,tx_hash,