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
QueryRunArchived: QueryRun has been archived