piperTreats
Updated 2024-11-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
PROJECT_NAME,
COUNT(DISTINCT TX_HASH) AS "Number of Treats (NFTs)",
COUNT(DISTINCT NFT_TO_ADDRESS) AS "Number of Holders"
FROM
polygon.nft.ez_nft_transfers
WHERE
(
NFT_FROM_ADDRESS = lower('0x324e9b92eA628E7c06741fC75D4A0F58a652A840')
OR
NFT_FROM_ADDRESS = lower('0xD25A945Cf021cD2748eeD53e18CFF50EB8bcFeB0')
)
AND PROJECT_NAME != '$2000 USDC NFT Voucher'
GROUP BY 1
ORDER BY 2 DESC
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived