Updated 2025-03-24
    with

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

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

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

    main as (
    Last run: 18 days ago
    HOLDERS
    TOTAL_VOLUME
    AVERAGE_BALANCE
    MEDIAN_BALANCE
    AVERAGE_BALANCE_USD
    TOTAL_VOLUME_USD
    MEDIAN_BALANCE_USD
    1
    16260247742362.22930315236.30764017937.45005125.9599265292048108.405362250.3096029339
    1
    95B
    6s