HOLDERS | AVG_BALANCE | MEDIAN_BALANCE | TOKENS_CIRCULATING | AVG_VALUE | MEDIAN_VALUE | SUM_VALUE | |
|---|---|---|---|---|---|---|---|
1 | 1277 | 3667.381369293 | 61.5 | 4683246.00858743 | 2611.223210895 | 43.7887995 | 3334532.04031236 |
LittlerDataLRON holds value
Updated 2025-04-02
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 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
,coalesce(received, 0) receivedd
Last run: 26 days ago
1
88B
4s