freemartianCurrent Holders Details
    Updated 2025-03-05
    WITH
    current_price AS (
    SELECT
    hour, symbol, price, rank() over(ORDER BY hour DESC) AS rank
    FROM base.price.ez_prices_hourly
    WHERE token_address = '0x2b0772bea2757624287ffc7feb92d03aeae6f12d'
    qualify rank = 1
    ),
    token_in_out AS(
    SELECT
    to_address AS user,
    SUM(amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x2b0772bea2757624287ffc7feb92d03aeae6f12d'
    GROUP BY 1
    UNION ALL
    SELECT
    from_address AS user,
    SUM(-amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x2b0772bea2757624287ffc7feb92d03aeae6f12d'
    GROUP BY 1
    ),

    final as (
    SELECT
    user,
    sum(amount) AS current_ballance
    FROM token_in_out
    GROUP BY 1
    )


    SELECT user, current_ballance, current_ballance * price AS current_ballance_usd
    from final
    INNER JOIN current_price
    Last run: 30 days agoAuto-refreshes every 1 hour
    USER
    CURRENT_BALLANCE
    CURRENT_BALLANCE_USD
    1
    0xde486d367f2a5061402f83dd205f0c09424c1c06254400789.46362117011.780791432
    2
    0xf5677b22454dee978b2eb908d6a17923f5658a79163692100.61364610946.090768034
    3
    0xde229a5b55f0a0f6e7b5fa7839aa23287a93695b89209619.93287795965.447284912
    4
    0xfcc19ec4ddbc135606c8fbbb196ac0e78833b37d81929929.47431715478.654383948
    5
    0xa059df8dca1dc6ffcc2e5e7e914ae2dc0428d95748828096.79769953265.134832862
    6
    0x1dfab2c23426393bfef2e8dfdedfb8176a2e897e23255411.36310391555.089357851
    7
    0xfc4b4898a1678ded3046b64ea9c7dca81aee0b51200000001337.4
    8
    0x767e095f6549050b4e9a3bcce18aadd28bef486f198499711327.36756077
    9
    0x136928947f9abaf68262f31102b32d75c25e0a69190180001271.73366
    10
    0x92092fbca11e8f28d459e78f78e27f013b7798c5169600001134.1152
    11
    0xc4aeed54c0590188ca212f9c35885a528c1307b910566615.7492811706.589595154
    12
    0x3348d349f9d63f80260af283bd4144d9b7ccbd449954746.85205091665.673921997
    13
    0x30f89f5f4cf25f457b4d9cbfb64a64a97f00bed08582804.13060438573.932112214
    14
    0xfbc3692deeb263f39c3a30d6d0c0496d976860118208809.2585824548.923075121
    15
    0x45bd53d2f7219390d2f0b21b573cf075812433ca7605744.79645537508.596154539
    16
    0xed7539146bc521fe512dfce5deb326912979a2e97525904.19484569503.257213509
    17
    0x5c6b7f4da1ce35bb8fcbbe61de382898d8ff10167090695.16792476474.154785879
    18
    0xcc826e25a5edd2d51634edfe05ea14dce919701c6374449.61403128426.25944569
    19
    0xef7c257c94eb894621d72ba3152b180fa9a3ab795998973.66043506401.151368673
    20
    0x6dbdec03dcdf27b41ca9cc7a4d38b790db3fbc855623798.21962122376.063386946
    ...
    26453
    2MB
    568s