DATE | UNIQUE_DEPOSITORS | UNIQUE_WITHDRAWERS | ALL_TIME_UNIQUE_DEPOSITORS | |
|---|---|---|---|---|
1 | 2025-04-12 00:00:00.000 | 2130 | 1597 | 439165 |
2 | 2025-04-11 00:00:00.000 | 2949 | 2245 | 439165 |
3 | 2025-04-10 00:00:00.000 | 2705 | 2115 | 439165 |
4 | 2025-04-09 00:00:00.000 | 3920 | 2834 | 439165 |
5 | 2025-04-08 00:00:00.000 | 3014 | 2299 | 439165 |
6 | 2025-04-07 00:00:00.000 | 5027 | 3454 | 439165 |
7 | 2025-04-06 00:00:00.000 | 3773 | 2351 | 439165 |
8 | 2025-04-05 00:00:00.000 | 1615 | 1506 | 439165 |
9 | 2025-04-04 00:00:00.000 | 2550 | 2081 | 439165 |
10 | 2025-04-03 00:00:00.000 | 3442 | 2519 | 439165 |
11 | 2025-04-02 00:00:00.000 | 2849 | 2205 | 439165 |
12 | 2025-04-01 00:00:00.000 | 2271 | 2184 | 439165 |
13 | 2025-03-31 00:00:00.000 | 2532 | 1944 | 439165 |
14 | 2025-03-30 00:00:00.000 | 1950 | 1540 | 439165 |
15 | 2025-03-29 00:00:00.000 | 2623 | 2019 | 439165 |
16 | 2025-03-28 00:00:00.000 | 2798 | 2350 | 439165 |
17 | 2025-03-27 00:00:00.000 | 2531 | 2905 | 439165 |
18 | 2025-03-26 00:00:00.000 | 4060 | 6173 | 439165 |
19 | 2025-03-25 00:00:00.000 | 2613 | 2308 | 439165 |
20 | 2025-03-24 00:00:00.000 | 3329 | 2912 | 439165 |
JhanlycnHyperliquid Users
Updated 13 hours ago
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 daily_users as (
select
date_trunc('day', block_timestamp) as date,
count(distinct case
when to_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7' then from_address
end) as unique_depositors,
count(distinct case
when from_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7' then to_address
end) as unique_withdrawers
from
arbitrum.core.ez_token_transfers
where
contract_address = '0xaf88d065e77c8cc2239327c5edb3a432268e5831'
and (
to_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7'
or from_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7'
)
group by
date
),
all_time_depositors as (
select
count(distinct from_address) as total_unique_depositors
from
arbitrum.core.ez_token_transfers
where
contract_address = '0xaf88d065e77c8cc2239327c5edb3a432268e5831'
and to_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7'
)
select
du.date,
du.unique_depositors,
du.unique_withdrawers,
atd.total_unique_depositors as all_time_unique_depositors
from
daily_users du
Last run: about 13 hours agoAuto-refreshes every 12 hours
...
497
21KB
104s