USERS | TYPE | |
|---|---|---|
1 | 647 | differing |
2 | 632 | likely_fervient_user |
LittlerDataLRON holders and protocol users lookout copy
Updated 6 days ago
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
›
⌄
-- forked from LRON holders and protocol users lookout @ https://flipsidecrypto.xyz/studio/queries/0a5034a5-2ec6-4eef-a768-863da33a09dc
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
Last run: 6 days ago
2
48B
26s