BlockTrackerHolders Distribution Over Time
    Updated 2025-04-24
    with calender as (
    with dates as (
    select
    to_date ('2023-01-01') as date
    union all
    select
    date + 1
    from dates
    where date <= current_date
    )
    select *
    -- date_trunc('day', date) as date
    from dates
    )
    ,
    users as (
    SELECT
    block_timestamp,
    to_address as owner,
    amount
    FROM
    avalanche.core.ez_token_transfers
    where contract_address = '{{Token_Address}}'
    union all
    select
    block_timestamp,
    from_address as owner,
    -amount
    FROM
    avalanche.core.ez_token_transfers
    where contract_address = '{{Token_Address}}'
    )
    ,
    unique_holders as (
    select
    DISTINCT owner
    Last run: about 8 hours ago
    DATE
    BALANCE_CATEGORY
    N_HOLDERS
    1
    2025-04-12 00:00:00.00010K-99K275
    2
    2025-02-07 00:00:00.000<1013545
    3
    2025-01-22 00:00:00.000100K+580
    4
    2025-05-22 00:00:00.000<1027052
    5
    2025-04-17 00:00:00.000<1026345
    6
    2025-05-23 00:00:00.000100K+306
    7
    2025-05-11 00:00:00.000100K+305
    8
    2025-03-24 00:00:00.000100-9991414
    9
    2025-02-14 00:00:00.000100-9991141
    10
    2025-04-06 00:00:00.000100-9991380
    11
    2025-04-20 00:00:00.000<1026332
    12
    2025-05-02 00:00:00.000100-9991273
    13
    2025-02-22 00:00:00.000100-9991216
    14
    2025-04-02 00:00:00.00010-991972
    15
    2025-03-15 00:00:00.00010-992000
    16
    2025-04-07 00:00:00.000100-9991375
    17
    2025-03-14 00:00:00.00010-992009
    18
    2025-05-11 00:00:00.0001K-9K448
    19
    2025-05-09 00:00:00.0001K-9K457
    20
    2025-05-28 00:00:00.00010K-99K266
    ...
    804
    32KB
    12s