Query editor
selectdate_trunc('day', block_time) as day,case when (array_contains(account_keys, 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')or array_contains(account_keys, 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')) then 'Magic Eden'when (array_contains(account_keys, 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ')or array_contains(account_keys, 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ')) then 'Metaplex NFT Candy Machine'when array_contains(account_keys, 'CJsLwbP1iu5DuUikHEJnLfANgKy6stB2uFgvBBHoyxwz') then 'Solanart'when (array_contains(account_keys, 'A7p8451ktDCHq5yYaHczeLMYsjRsAkzc3hCXcSrwYHU7')or array_contains(account_keys, '7t8zVJtPCFAqog1DcnB6Ku1AVKtWfHkCiPi1cAvcJyVF')) then 'DigitalEyes'when array_contains(account_keys, '617jbWo616ggkDxvW1Le8pV38XLbVSyWY8ae6QUmGBAU') then 'Solsea'else null end as nft_project,count(distinct account_keys[0]) as daufrom solana.transactionswhere (array_contains(account_keys, 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8') -- Magic Eden NFT Marketplaceor array_contains(account_keys, 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K') -- Magic Eden NFT Marketplace v2or array_contains(account_keys, 'cndyAnrLdpjq1Ssp1z8xxDsB8dxe7u4HL5Nxi2K5WXZ') -- Metaplex NFT Candy Machine v1or array_contains(account_keys, 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ') -- Metaplex NFT Candy Machine v2or array_contains(account_keys, 'CJsLwbP1iu5DuUikHEJnLfANgKy6stB2uFgvBBHoyxwz') -- Solanart NFT Marketplaceor array_contains(account_keys, 'A7p8451ktDCHq5yYaHczeLMYsjRsAkzc3hCXcSrwYHU7') -- DigitalEyes NFT Marketplaceor array_contains(account_keys, '7t8zVJtPCFAqog1DcnB6Ku1AVKtWfHkCiPi1cAvcJyVF') -- DigitalEyes Direct Sellor array_contains(account_keys, '617jbWo616ggkDxvW1Le8pV38XLbVSyWY8ae6QUmGBAU') -- Solsea NFT Marketplace)and block_time >= date_trunc('day', now() - interval '30 days')and block_time < date_trunc('day', now())group by 1, 2