DATE | USER_TYPE | # of Users | |
|---|---|---|---|
1 | 2024-11-07 00:00:00.000 | Returning users | 223 |
2 | 2025-01-30 00:00:00.000 | Returning users | 27 |
3 | 2024-09-05 00:00:00.000 | Returning users | 215 |
4 | 2025-01-28 00:00:00.000 | New Users | 10 |
5 | 2024-09-22 00:00:00.000 | New Users | 2 |
6 | 2024-11-19 00:00:00.000 | Returning users | 134 |
7 | 2024-09-10 00:00:00.000 | Returning users | 179 |
8 | 2024-11-09 00:00:00.000 | Returning users | 242 |
9 | 2024-10-17 00:00:00.000 | Returning users | 194 |
10 | 2024-12-04 00:00:00.000 | New Users | 54 |
11 | 2025-01-21 00:00:00.000 | Returning users | 67 |
12 | 2025-01-20 00:00:00.000 | New Users | 82 |
13 | 2024-12-22 00:00:00.000 | New Users | 32 |
14 | 2024-09-06 00:00:00.000 | New Users | 12 |
15 | 2024-12-30 00:00:00.000 | New Users | 20 |
16 | 2024-12-30 00:00:00.000 | Returning users | 66 |
17 | 2024-11-27 00:00:00.000 | New Users | 54 |
18 | 2025-02-22 00:00:00.000 | Returning users | 10 |
19 | 2025-02-26 00:00:00.000 | New Users | 13 |
20 | 2024-11-11 00:00:00.000 | Returning users | 198 |
rezarwzActive Users
Updated 2025-02-26
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 all_users as (
SELECT
ev.tx_hash as tx_hash,
ev.block_Timestamp as block_Timestamp,
DECODED_LOG:taker as ua
FROM
blast.core.ez_decoded_event_logs ev
where
ev.contract_address in(
'0x739f0331594029064c252559436edce0e468e37a',
'0x6a3796c21e733a3016bc0ba41edf763016247e72'
)
and event_name = 'OrderFilled'
union
all
SELECT
ev.tx_hash as tx_hash,
ev.block_Timestamp as block_Timestamp,
DECODED_LOG:maker as ua
FROM
blast.core.ez_decoded_event_logs ev
where
ev.contract_address in(
'0x739f0331594029064c252559436edce0e468e37a',
'0x6a3796c21e733a3016bc0ba41edf763016247e72'
)
and event_name = 'OrderFilled'
)
SELECT
date_Trunc('{{time_frame}}', block_Timestamp) as date,
CASE
when (ua, block_Timestamp) in (
SELECT
ua,
max(block_timestamp)
from
Last run: about 2 months ago
...
355
16KB
5s