USER | CURRENT_BALLANCE | CURRENT_BALLANCE_USD | |
|---|---|---|---|
1 | 0xde486d367f2a5061402f83dd205f0c09424c1c06 | 254400789.463621 | 17011.780791432 |
2 | 0xf5677b22454dee978b2eb908d6a17923f5658a79 | 163692100.613646 | 10946.090768034 |
3 | 0xde229a5b55f0a0f6e7b5fa7839aa23287a93695b | 89209619.9328779 | 5965.447284912 |
4 | 0xfcc19ec4ddbc135606c8fbbb196ac0e78833b37d | 81929929.4743171 | 5478.654383948 |
5 | 0xa059df8dca1dc6ffcc2e5e7e914ae2dc0428d957 | 48828096.7976995 | 3265.134832862 |
6 | 0x1dfab2c23426393bfef2e8dfdedfb8176a2e897e | 23255411.3631039 | 1555.089357851 |
7 | 0xfc4b4898a1678ded3046b64ea9c7dca81aee0b51 | 20000000 | 1337.4 |
8 | 0x767e095f6549050b4e9a3bcce18aadd28bef486f | 19849971 | 1327.36756077 |
9 | 0x136928947f9abaf68262f31102b32d75c25e0a69 | 19018000 | 1271.73366 |
10 | 0x92092fbca11e8f28d459e78f78e27f013b7798c5 | 16960000 | 1134.1152 |
11 | 0xc4aeed54c0590188ca212f9c35885a528c1307b9 | 10566615.7492811 | 706.589595154 |
12 | 0x3348d349f9d63f80260af283bd4144d9b7ccbd44 | 9954746.85205091 | 665.673921997 |
13 | 0x30f89f5f4cf25f457b4d9cbfb64a64a97f00bed0 | 8582804.13060438 | 573.932112214 |
14 | 0xfbc3692deeb263f39c3a30d6d0c0496d97686011 | 8208809.2585824 | 548.923075121 |
15 | 0x45bd53d2f7219390d2f0b21b573cf075812433ca | 7605744.79645537 | 508.596154539 |
16 | 0xed7539146bc521fe512dfce5deb326912979a2e9 | 7525904.19484569 | 503.257213509 |
17 | 0x5c6b7f4da1ce35bb8fcbbe61de382898d8ff1016 | 7090695.16792476 | 474.154785879 |
18 | 0xcc826e25a5edd2d51634edfe05ea14dce919701c | 6374449.61403128 | 426.25944569 |
19 | 0xef7c257c94eb894621d72ba3152b180fa9a3ab79 | 5998973.66043506 | 401.151368673 |
20 | 0x6dbdec03dcdf27b41ca9cc7a4d38b790db3fbc85 | 5623798.21962122 | 376.063386946 |
freemartianCurrent Holders Details
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
...
26453
2MB
568s