datasovrunToken Holders before and after block X
    Updated 2024-02-12
    with filtered as (
    select *
    from ethereum.core.ez_balance_deltas
    where contract_address = lower('0x24fcFC492C1393274B6bcd568ac9e225BEc93584')
    and date_trunc('day', block_timestamp) < '2024-02-05'
    order by block_timestamp desc
    )

    , ordered as (
    select *
    , ROW_NUMBER() OVER (PARTITION BY user_address ORDER BY block_number DESC) AS rn

    from filtered
    )

    select count(*)
    from ordered
    where rn = 1
    and current_bal >= 0.1



    Last run: about 1 year ago
    COUNT(*)
    1
    11
    1
    6B
    1s