Updated 2025-05-02




    with tbl1 as (
    with general as (
    with tbl3 as (
    with tbl as (
    select
    to_address as "Address",
    sum(RAW_AMOUNT/pow(10,18)) as "Input"
    from
    base.core.ez_token_transfers
    where
    contract_address = lower ('0x98d0baa52b2d063e780de12f615f963fe8537553')
    group by
    1
    ),
    tbl2 as (
    select
    from_address as "Address",
    sum(RAW_AMOUNT/pow(10,18)) as "Output"
    from
    base.core.ez_token_transfers
    where
    contract_address = lower ('0x98d0baa52b2d063e780de12f615f963fe8537553')
    group by 1
    )
    select
    tbl."Address",
    case
    when "Input" is null then 0
    else "Input"
    end as "Input tokens",
    case
    when "Output" is null then 0
    Last run: about 2 months ago
    Tier
    Tokens Balance
    Tokens Balance (USD)
    Total wallets
    Token Balance
    Tokens Balance(USD)
    Total wallet
    1
    Tier1: More than $10M957.58 M846.42 M13957582779.465649846424655.25971713
    2
    Tier2: $1M- $10M26.16 M23.12 M726155751.206855723119539.29526157
    3
    Tier3: $100K- $1M13.21 M11.68 M3313212957.008371611679170.532925833
    4
    Tier4: $50K- $100K1.77 M1.56 M221770183.208315291564696.8011276322
    5
    Tier5: $10K- $50K1.39 M1.23 M611389585.997713761228280.0759271561
    6
    Tier6: $1k- $10K1.26 M1.12 M3121264917.083655311118082.97875044312
    7
    Tier7: $1k- $100395.8 K349.9 K1.2 K395823.243092645349875.2893879641223
    8
    Tier8: $100- $1556 K491.4 K28.2 K555978.983807991491439.83140959228221
    9
    Tier9: less than $13.1 K2.7 K67.2 K3065.8473645212709.95767075367211
    9
    764B
    20s