freemartianCanvas Set Holders
    Updated 2025-03-11

    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

    Last run: about 2 months ago
    NUMBER_OF_TOKENS_OWNED
    NUMBER_OF_HOLDER
    PERCENTAGE_OF_HOLDERS
    1
    9330.008813
    2
    26720.005875
    3
    26210.061689
    4
    39310.002938
    5
    37110.002938
    6
    39810.002938
    7
    50370.108689
    8
    53120.035251
    9
    17930.008813
    10
    38810.002938
    11
    8310.002938
    12
    21710.002938
    13
    9410.002938
    14
    18210.002938
    15
    44710.002938
    16
    5670.020563
    17
    58030.008813
    18
    35220.064626
    19
    11210.002938
    20
    10320.005875
    ...
    262
    4KB
    13s