DATE | NEW_SWAPPERS | |
---|---|---|
1 | 2024-08-17 00:00:00.000 | 1287 |
2 | 2024-08-18 00:00:00.000 | 950 |
3 | 2024-08-19 00:00:00.000 | 925 |
4 | 2024-08-20 00:00:00.000 | 888 |
5 | 2024-08-21 00:00:00.000 | 832 |
6 | 2024-08-22 00:00:00.000 | 1459 |
7 | 2024-08-23 00:00:00.000 | 855 |
8 | 2024-08-24 00:00:00.000 | 747 |
9 | 2024-08-25 00:00:00.000 | 708 |
10 | 2024-08-26 00:00:00.000 | 885 |
11 | 2024-08-27 00:00:00.000 | 641 |
12 | 2024-08-28 00:00:00.000 | 685 |
13 | 2024-08-29 00:00:00.000 | 602 |
14 | 2024-08-30 00:00:00.000 | 530 |
15 | 2024-08-31 00:00:00.000 | 737 |
16 | 2024-09-01 00:00:00.000 | 484 |
17 | 2024-09-02 00:00:00.000 | 578 |
18 | 2024-09-03 00:00:00.000 | 514 |
19 | 2024-09-04 00:00:00.000 | 604 |
20 | 2024-09-05 00:00:00.000 | 509 |
AmiRNew swappers
Updated 2024-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with t1 as
(SELECT ORIGIN_FROM_ADDRESS as swapper,
min(block_timestamp::date) as date
from blast.defi.ez_dex_swaps
where BLOCK_TIMESTAMP>=current_date-60 and platform='thruster-v3'
GROUP by 1)
SELECT date,
count(DISTINCT swapper) as New_swappers
from t1
where date >= current_date - 60
group by 1 ORDER by 1
Last run: 3 months ago
61
2KB
10s