freemartianمجموعهدارها
Updated 2024-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Canvas Set Holders @ https://flipsidecrypto.xyz/edit/queries/8dac22a0-8762-4cf9-a471-20f169a3dcec
with transfers AS (
select
nft_to_address AS owner,
count(distinct tokenid) as Number_of_tokens_owned
from base.nft.ez_nft_transfers
where nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
group by 1)
select
Number_of_tokens_owned,
count(owner) as number_of_holder,
(count(owner) * 100.0 / (select count(DISTINCT owner) from transfers)) AS percentage_of_holders
from transfers
group by 1
QueryRunArchived: QueryRun has been archived