Updated 3 hours ago
    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: about 3 hours ago
    HOLDERS
    TOTAL_VOLUME
    AVERAGE_BALANCE
    MEDIAN_BALANCE
    AVERAGE_BALANCE_USD
    TOTAL_VOLUME_USD
    MEDIAN_BALANCE_USD
    1
    18477271236982.79789314679.70897861642.70813495593.559363611728696.361424440.2721951732
    1
    97B
    8s