elsinaHow many Pooly NFTs does the average collector hold?
Updated 2022-06-23
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
›
⌄
with transfer as (
select nft_to_address as address, '+1' as "count"
from ethereum.core.ez_nft_transfers
where NFT_ADDRESS = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
or NFT_ADDRESS = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')
or NFT_ADDRESS = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
union all
select nft_from_address as address, '-1' as "count"
from ethereum.core.ez_nft_transfers
where NFT_ADDRESS = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
or NFT_ADDRESS = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')
or NFT_ADDRESS = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
),
holders as (
select address, sum("count") as "hold"
from transfer
group by 1 having "hold" > 0
)
select avg("hold")
from holders
Run a query to Download Data