rezarwz# of Tx
Updated 2024-05-20
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_makers as (
SELECT
tx_hash,
block_timestamp,
origin_from_address as ua,
decoded_log:maker as maker_ad,
decoded_log:gives as gives
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and event_name = 'OfferWrite'
),
all_takers as (
SELECT
tx_hash,
block_timestamp,
origin_from_address as ua,
decoded_log:taker as taker_Ad
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and event_name = 'OrderComplete'
),
takers_data as (
SELECT
date_trunc(
'{{Time_frame}}',
block_timestamp
) as date,
count(DISTINCT tx_hash) as "# of Trades",
sum(count(DISTINCT tx_hash)) over(
ORDER by
date_trunc(
'{{Time_frame}}',
QueryRunArchived: QueryRun has been archived