alitaslimiARB Holders
    Updated 2025-02-07
    with
    -------------------- raw transfers --------------------
    raw as (
    select
    block_timestamp::date as date,
    to_address as address,
    amount as balance_change
    from arbitrum.core.ez_token_transfers
    where contract_address = lower('0x912ce59144191c1204e64559fe8253a0e49e6548')

    union all

    select
    block_timestamp::date as date,
    from_address as address,
    -amount as balance_change
    from arbitrum.core.ez_token_transfers
    where contract_address = lower('0x912ce59144191c1204e64559fe8253a0e49e6548')
    ),

    -------------------- cumulative balances --------------------
    balances as (
    select
    date,
    address,
    sum(balance_change) over (
    partition by address
    order by date
    rows between unbounded preceding and current row
    ) as balance
    from raw
    ),

    -------------------- filter holders --------------------
    holders as (
    select
    Last run: about 1 month ago
    DATE
    TOTAL_HOLDERS
    1
    2023-03-16 00:00:00.0009
    2
    2023-03-17 00:00:00.0009
    3
    2023-03-19 00:00:00.0001
    4
    2023-03-20 00:00:00.00012
    5
    2023-03-21 00:00:00.0006
    6
    2023-03-22 00:00:00.00019
    7
    2023-03-23 00:00:00.000606127
    8
    2023-03-24 00:00:00.000173220
    9
    2023-03-25 00:00:00.00066707
    10
    2023-03-26 00:00:00.00052227
    11
    2023-03-27 00:00:00.00051442
    12
    2023-03-28 00:00:00.00038709
    13
    2023-03-29 00:00:00.00038505
    14
    2023-03-30 00:00:00.00045397
    15
    2023-03-31 00:00:00.00032828
    16
    2023-04-01 00:00:00.00026656
    17
    2023-04-02 00:00:00.00033471
    18
    2023-04-03 00:00:00.00025489
    19
    2023-04-04 00:00:00.00024029
    20
    2023-04-05 00:00:00.00022041
    ...
    694
    23KB
    43s