mansaAverage Holdings
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
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with mint as (
select
case when lower(nft_address) = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') then 'PLawyer'
when lower(nft_address) = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed') then 'PSupporter'
when lower(nft_address) = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') then 'PJudge' end as Pooly_Type,
nft_from_address as address,
'-1' as flow
FROM ethereum.core.ez_nft_transfers
where nft_address in ( lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'), lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'), lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
union all
select
case when nft_address = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9') then 'PLawyer'
when nft_address = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed') then 'PSupporter'
when nft_address = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523') then 'PJudge' end as Pooly_Type,
nft_to_address as address,
'1' as flow
FROM ethereum.core.ez_nft_transfers
where nft_address in ( lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'), lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'), lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
),
req as(
select
address,
sum(flow) as holds,
Pooly_type
from mint
group by address,Pooly_type
having holds > 0
)
select
Pooly_Type,
sum(holds)/count(distinct(address)) as hold_average
from req
Run a query to Download Data