h4wkPooly 2
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets?
-- How many Pooly NFTs does the average collector hold?
with pooly as (
select
from_address as minter,
case when to_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'Pooly-Supporter'
when to_address = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') then 'Pooly-Lawyer'
when to_address = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') then 'Pooly-Judge' end as type
from ethereum.core.fact_transactions
where block_timestamp::date >= '2022-05-20' and
to_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', -- pooly1
lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'), -- pooly2
lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')) -- pooly3
and origin_function_signature = '0x92642744'
)
select type, count(minter) as total_mint
from pooly group by 1
Run a query to Download Data