ZSaed1. Pooly total
Updated 2022-06-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select
count(DISTINCT tx_hash) as txs,
count(DISTINCT NFT_TO_ADDRESS) as minter,
count(DISTINCT TOKENID) as nfts,
sum(MINT_PRICE_USD) as volumeu_usd,
sum(MINT_PRICE_ETH) as volumeu_eth,
case
when NFT_ADDRESS = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'Pooly Supporter'
when NFT_ADDRESS = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' then 'Pooly Lawyer'
when NFT_ADDRESS = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'Pooly Judge'
end as group_
from ethereum.core.ez_nft_mints
where
NFT_ADDRESS in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed'-- Pooly - Supporter 3,650 remaining of 10,000
, '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' -- Pooly - Lawyer 712 remaining of 1,000
, '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523'--Pooly - Judge 9 remaining of 10
)
and EVENT_TYPE ='nft_mint'
group by group_
Run a query to Download Data