Afonso_DiazGrouping holders ($USD)
    Updated 2025-03-30
    with

    pricet as (
    select
    price as token_price_usd
    from
    ronin.price.ez_prices_hourly
    where
    token_address = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
    order by hour desc
    limit 1
    ),

    deposits as (
    select
    to_address as receiver,
    sum(amount) as volume
    from
    ronin.core.ez_token_transfers
    where
    contract_address = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
    group by 1
    ),

    withdraws as (
    select
    from_address as sender,
    sum(amount) as volume
    from
    ronin.core.ez_token_transfers
    where
    contract_address = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
    group by 1
    ),

    main as (
    Last run: 11 days ago
    BALANCE_USD_RANGE
    HOLDER_COUNT
    TOTAL_BALANCE_USD
    1
    Less than $100227229373.532307813
    2
    $100 - $499411101148.440663236
    3
    $1,000 - $4,999213478481.741473965
    4
    $500 - $99912386796.54837049
    5
    $5,000 - $9,99942307002.570820892
    6
    $10,000 - $49,99941820936.667730352
    7
    $50,000 - $99,9995366393.90296179
    8
    $100,000 and above1109544.232977839
    8
    318B
    2s