Query editor
with mints as (SELECTblockchain,contract_address,MIN(block_time) as first_timeFROMnft.transfersWHERE"from" = 0x0000000000000000000000000000000000000000and block_time > DATE('2021-01-01')AND block_time < date_trunc('day', now())AND blockchain in ('base','arbitrum','optimism','ethereum','zksync','zora','blast')GROUP BY 1,2HAVING COUNT(DISTINCT("to")) > 1)SELECTdate_trunc('month',first_time) as date_time,blockchain,COUNT(DISTINCT(contract_address)) as total_nft_collectionsFROM mintsGROUP BY 1,2