ADDRESS | TOKEN_BALANCE | ADDRESS_NAME | LABEL_TYPE | LABEL_SUBTYPE | PROJECT_NAME | |
|---|---|---|---|---|---|---|
1 | 0x06c7c71fca1aea63b8fbe5d6438ca6c681124711 | 15529591.0016702 | ||||
2 | 0x496b40804f6b63e84454437b177baa73fdf3fafc | 508644.981385631 | ||||
3 | 0x9ee66703fad9b1315a8c9117914857c6e5d9273d | 1074369.75334692 | ||||
4 | 0x5bd508d2c27e94031a81966d6a82bc093851c368 | 3241665.116071 | ||||
5 | 0xaca50a3a37d6f2ba49a9f9e3be949c342ac4b8a7 | 1976243.42 | ||||
6 | 0xa24ab62128776f82651a00b4ad65c720b9816d2e | 1807452.5645 | ||||
7 | 0xb7333d779c6ecdfc4507a53706b0e173bd086a18 | 5292360.77071631 | ||||
8 | 0x1d4dab3f27c7f656b6323c1d6ef713b48a8f72f1 | 837937.876091838 | uniswap: virtual-weth 3000 60 uni-v3 lp | dex | pool | uniswap |
9 | 0x37e769d2dcf3e3e8dfc37c0df83eeb56edfc0fd2 | 722986.786904357 | aerodrome: virtual-wai | dex | pool | aerodrome |
10 | 0xb909f567c5c2bb1a4271349708cc4637d7318b4a | 4423940.44106197 | aerodrome: virtual-cbbtc | dex | pool | aerodrome |
11 | 0x9eff73832a3e69c0425b7352d84e4818a7e0201f | 505842.724487029 | ||||
12 | 0x36ccdef4decfa6ae89707b1737e8fc56d275414f | 961987.630786578 | ||||
13 | 0x0235ffde3d40e0224617e201499d508751edfb8d | 956435.294319998 | ||||
14 | 0x95391250644b3d3ddc46cb566d65db549008edc7 | 708999.92138586 | ||||
15 | 0x7987a77c38a58383ead08aeec56830c780990d9e | 2284240.23703849 | ||||
16 | 0xac04753928961a06af540078410802cc443f5176 | 618773.079103623 | ||||
17 | 0xe97988364284ac6a56220aef30b46f55e1520f30 | 1284802.22841868 | ||||
18 | 0x4fba13ba676bca8bbba5e539d0480d5756472f9a | 2053141.45922452 | ||||
19 | 0xfc6d3f69b4c8924fcbfa9fe582b73a50a8a09771 | 10031844.5380998 | ||||
20 | 0xab1357f3768035ab316419efb34867e7002a3d58 | 593133.908226699 |
sofiatfilthy-indigo
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 erc20_aggregated as (
SELECT
to_address as address,
contract_address as token_address,
symbol as token_symbol,
SUM(amount) as amount
FROM
base.core.ez_token_transfers
WHERE contract_address = lower('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b')
GROUP BY 1, 2, 3
UNION ALL
SELECT
from_address as address,
contract_address as token_address,
symbol as token_symbol,
-SUM(amount) as amount
FROM
base.core.ez_token_transfers er
WHERE contract_address = lower('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b')
GROUP BY 1, 2, 3
),
all_balances as (
SELECT
address,
token_address,
token_symbol,
SUM(amount) as token_balance
FROM
erc20_aggregated
GROUP BY 1, 2, 3
HAVING SUM(amount) > 0.0001
order by 4 desc
limit 100
Last run: 27 days ago
100
9KB
25s