USER | CURRENT_BALLANCE | CURRENT_BALLANCE_USD | |
|---|---|---|---|
1 | 0x7b040c0300374af7a3ca23c2f4de61b696b0472d | 245262964.757407 | 10063.139443996 |
2 | 0x0ebcee3165654d9c52dd6d438423be76f2df1b0e | 163661318.232499 | 6715.023887079 |
3 | 0x420512864cd1c9a51ed59a57e9fef5df2abbc061 | 82747139.1637616 | 3395.115119889 |
4 | 0x0169de4cfd1b9c1a078c3550709549905be38378 | 71077057.29355 | 2916.291660754 |
5 | 0x57e43bb2ac24b0592cbcd1aa9ed50cff61c4f147 | 48407685.20226 | 1986.167323849 |
6 | 0x0d0707963952f2fba59dd06f2b425ace40b492fe | 31001794.3319983 | 1272.003621442 |
7 | 0x767e095f6549050b4e9a3bcce18aadd28bef486f | 20000000 | 820.6 |
8 | 0x194e9bea4f46667ec86332b96e2be2247b164fa7 | 20000000 | 820.6 |
9 | 0xc4aeed54c0590188ca212f9c35885a528c1307b9 | 12483477.121146 | 512.197066281 |
10 | 0xd9e391abe558d10f7b9e5b99f3dd61cc37921782 | 11636181.4404832 | 477.432524503 |
11 | 0xaa7313e2c08aa49cf374a498502f3ff09a0d03b0 | 7072415.43375039 | 290.181205247 |
12 | 0x18b2a61d1a804fba6570ff186f05f5884194571b | 6412069.68661154 | 263.087219242 |
13 | 0x34cae1d9e2d014b7b9e6295c66c554d7e79713d3 | 6068816.66950047 | 249.00354795 |
14 | 0x9e33ad8444b8c5a7dce2a6a1f458a7390f167748 | 5854145.17570795 | 240.195576559 |
15 | 0x53e6338e494288e8170068b7f7ff610f976f4526 | 5473144.10200302 | 224.563102505 |
16 | 0x3aa2da0d4271f6aa19fd22449a2325968901d9e1 | 5406943.43968304 | 221.84688933 |
17 | 0x1af64d49346290f351d81163606398715ab47e0e | 5000000 | 205.15 |
18 | 0x2829354fab6a8c7915377a15e3d7209d28de4246 | 4243689.9362248 | 174.118598083 |
19 | 0x953126959767a1186690d4e1dd29c813c094a8d5 | 4228204.27808391 | 173.48322153 |
20 | 0x3b8d785c131ebda6118bbaca2066b0243a6728e8 | 4200000 | 172.326 |
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 = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
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 = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
GROUP BY 1
UNION ALL
SELECT
from_address AS user,
SUM(-amount) AS amount,
FROM base.core.ez_token_transfers
WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
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: 21 days agoAuto-refreshes every 1 hour
...
29152
2MB
1055s