piperFREEZERVERSE NFTs
Updated 2024-10-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
⌄
/*
FREEZERVERSE
-- https://www.freezerverse.com/
-- Paleto: 0x446b0Ba7504308fB13E6C4D9e636198F8d4Bd774
-- 3D Helado: 0xfdef1292b9d819f88f98B8B012974cb7DeA0599c
-- Pizza Buddies: 0xB8eC756f124A4C58F397fC88e40d79725b5A28Cd
-- Ranas Chidas: 0x2bDFA6Db300157Bba99A4D848a7dAcF234250143
*/
SELECT
PROJECT_NAME,
COUNT(TX_HASH) AS Number_of_mints,
COUNT(DISTINCT NFT_TO_ADDRESS) AS Number_of_minter
FROM
polygon.nft.ez_nft_mints
WHERE
NFT_ADDRESS = lower('0x446b0Ba7504308fB13E6C4D9e636198F8d4Bd774')
OR
NFT_ADDRESS = lower('0xfdef1292b9d819f88f98B8B012974cb7DeA0599c')
OR
NFT_ADDRESS = lower('0xB8eC756f124A4C58F397fC88e40d79725b5A28Cd')
OR
NFT_ADDRESS = lower('0x2bDFA6Db300157Bba99A4D848a7dAcF234250143')
GROUP BY 1
ORDER BY 2, 3 DESC
QueryRunArchived: QueryRun has been archived