USER | BALANCES_THROUGH_TRANSFER | BALANCE_THROUGH_CONTRACT_INTERACTIONS | TYPE | |
|---|---|---|---|---|
1 | 0x58935a1e2c1bd67ae2f12b2fd30642db4eb3fdb2 | 2498686.58146817 | 2498686.581468 | differing |
2 | 0x0fbe1a7f0f006a4a4d817b2aa922889612758ce8 | 209693.270092067 | 0 | differing |
3 | 0x048de4485191a040096bd03e9995f0d34d8c0d8e | 154142.655814524 | 154142.655815 | differing |
4 | 0x33f40f7e366d9c9d712d6464c8c8752ce90582e9 | 114922.182571074 | 114922.182571 | differing |
5 | 0x0d176981c09c0520c3698fb14a55b840c443b9db | 75669.31305503 | 0 | differing |
6 | 0x629759cbffdc5850f070add31af3e2b4c53f684c | 69963.224281109 | 0 | differing |
7 | 0xf8509453648cc7d9cc88065ae9e38ebd2ce5a49a | 49768.329050297 | 49768.32905 | differing |
8 | 0x3e112270cde41d90c4a6b9e1b09626d8bbc6709c | 40000 | 49919.581231 | differing |
9 | 0x96304a96c760900699ebc8bca9cfb75f2a2adfd2 | 32600.010212387 | 32600.010212 | differing |
10 | 0xddb23aa29003a73991289bc6594c24af601b24c4 | 25886.83290503 | 25886.832905 | differing |
11 | 0x56422dde17fa311e2a9a0147e65171fc943e4430 | 18942.841947039 | 8937.905 | differing |
12 | 0x7ee9f6419d0cadd7b30865bf56808191fc19fadb | 15496.425752793 | 15496.425753 | differing |
13 | 0x2a034843a995f532f5390447f43bcac6c24ad777 | 15395.202992366 | 86424.366014 | differing |
14 | 0x664e050f472166c3bb78903ac2bda09146388cbf | 14285.694742805 | 6913.334307 | differing |
15 | 0xe358a9065280b490620c7dd8475e7f4c9b85084d | 10293.449582692 | 10293.449583 | differing |
16 | 0xaa9cd865e89db949692a8b3a4d2d8f98f9ab4aaa | 10186.517630716 | 10186.517631 | differing |
17 | 0xd896760fbda3e3e5c01a09b4b983fd709aaaa19c | 10000.635919806 | 10000.63592 | differing |
18 | 0xef6643845e5229431465959a3ec60def2f5a357c | 9993.640371545 | 9993.640372 | differing |
19 | 0xec9add7e48adda4e976f80a8f7a13059d0de13ba | 9993.640371545 | 9993.640372 | differing |
20 | 0xd53000053e91597add02e491536628c40c9072d8 | 9993.33006504 | 0 | differing |
LittlerDataLRON holders and protocol users lookout
Updated 2025-04-02
999
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 holders as (
with base as (
select
from_address
,to_address
,amount_precise
from ronin.core.ez_token_transfers
where 1=1
and block_timestamp > '2025-03-19'
--and tx_hash = '0x67dac46a1c1ad81bf77958a46cc8f35ec90f7f04efad84ec98ef9f78310bb687' --first deposit
and contract_address = '0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2' --LRON contract
),
transfers_in as (
select
to_address as user
,sum(amount_precise) as received
from base
where 1=1
group by user
),
transfers_out as (
select
from_address as user
,sum(amount_precise) as sent
from base
where 1=1
group by user
),
balance as (
select
user
,coalesce(sent, 0) sentt
Last run: 25 days ago
...
647
48KB
27s