DATE | UNIQUE_DEPOSITORS | UNIQUE_WITHDRAWERS | ALL_TIME_UNIQUE_DEPOSITORS | |
|---|---|---|---|---|
1 | 2025-04-17 00:00:00.000 | 2132 | 1699 | 442349 |
2 | 2025-04-16 00:00:00.000 | 3437 | 2606 | 442349 |
3 | 2025-04-15 00:00:00.000 | 2764 | 2162 | 442349 |
4 | 2025-04-14 00:00:00.000 | 2576 | 2142 | 442349 |
5 | 2025-04-13 00:00:00.000 | 2385 | 1958 | 442349 |
6 | 2025-04-12 00:00:00.000 | 2636 | 2006 | 442349 |
7 | 2025-04-11 00:00:00.000 | 2949 | 2245 | 442349 |
8 | 2025-04-10 00:00:00.000 | 2705 | 2115 | 442349 |
9 | 2025-04-09 00:00:00.000 | 3920 | 2834 | 442349 |
10 | 2025-04-08 00:00:00.000 | 3014 | 2299 | 442349 |
11 | 2025-04-07 00:00:00.000 | 5027 | 3454 | 442349 |
12 | 2025-04-06 00:00:00.000 | 3773 | 2351 | 442349 |
13 | 2025-04-05 00:00:00.000 | 1615 | 1506 | 442349 |
14 | 2025-04-04 00:00:00.000 | 2550 | 2081 | 442349 |
15 | 2025-04-03 00:00:00.000 | 3442 | 2519 | 442349 |
16 | 2025-04-02 00:00:00.000 | 2849 | 2205 | 442349 |
17 | 2025-04-01 00:00:00.000 | 2271 | 2184 | 442349 |
18 | 2025-03-31 00:00:00.000 | 2532 | 1944 | 442349 |
19 | 2025-03-30 00:00:00.000 | 1950 | 1540 | 442349 |
20 | 2025-03-29 00:00:00.000 | 2623 | 2019 | 442349 |
JhanlycnHyperliquid Users
Updated 7 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 7 hours agoAuto-refreshes every 12 hours
...
502
22KB
130s