SocioCryptoPooly nfts
Updated 2022-06-20
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date_trunc('day', block_timestamp) as date,
CASE WHEN nft_address = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') THEN 'Pooly - Lawyer'
WHEN nft_address = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed') THEN 'Pooly - Supporter'
WHEN nft_address = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') THEN 'Pooly - Judge'
END as Pooly_type,
count(*) as n_nfts,
count(DISTINCT nft_to_address) as n_minters
FROM ethereum.core.ez_nft_mints
WHERE nft_address = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') OR nft_address = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
or nft_address = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
GROUP BY pooly_type,date
Run a query to Download Data