DATE | # of New Takers | # of Total Takers | |
|---|---|---|---|
1 | 2024-04-02 00:00:00.000 | 369 | 2871 |
2 | 2024-03-24 00:00:00.000 | 141 | 1534 |
3 | 2024-05-03 00:00:00.000 | 165 | 5563 |
4 | 2024-05-28 00:00:00.000 | 36 | 6982 |
5 | 2024-05-08 00:00:00.000 | 80 | 6093 |
6 | 2024-04-04 00:00:00.000 | 144 | 3185 |
7 | 2024-05-19 00:00:00.000 | 16 | 6802 |
8 | 2024-05-06 00:00:00.000 | 138 | 5938 |
9 | 2024-03-23 00:00:00.000 | 106 | 1393 |
10 | 2024-12-07 00:00:00.000 | 1 | 7860 |
11 | 2024-08-10 00:00:00.000 | 1 | 7845 |
12 | 2024-03-02 00:00:00.000 | 108 | 295 |
13 | 2024-05-16 00:00:00.000 | 78 | 6683 |
14 | 2024-06-16 00:00:00.000 | 74 | 7638 |
15 | 2024-06-07 00:00:00.000 | 34 | 7175 |
16 | 2024-06-22 00:00:00.000 | 10 | 7769 |
17 | 2024-03-15 00:00:00.000 | 24 | 786 |
18 | 2024-07-18 00:00:00.000 | 13 | 7840 |
19 | 2024-07-01 00:00:00.000 | 1 | 7809 |
20 | 2024-06-03 00:00:00.000 | 14 | 7076 |
rezarwz# of Total Takers
Updated 2024-09-07
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_takers as (
SELECT
tx_hash,
block_timestamp,
decoded_log:taker as Taker_Ad,
case
when (decoded_log:taker, block_timestamp) in (
SELECT
decoded_log:taker,
min(block_timestamp)
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and event_name = 'OrderComplete'
group by
1
) then 'New User'
else 'Returning User'
end as user_type
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
and event_name = 'OrderComplete'
)
SELECT
date_trunc('{{Time_frame}}', block_timestamp) as date,
count(DISTINCT taker_ad) as "# of New Takers",
sum(count(DISTINCT taker_Ad)) over (
order by
date_trunc('{{Time_frame}}', block_timestamp) asc
) as "# of Total Takers"
FROM
all_takers
WHERE
Last run: about 20 hours ago
...
152
5KB
1s