DAY | YEAR | NEW_SWAPPER | TOTAL_SWAPPERS | |
|---|---|---|---|---|
1 | 2025-06-26 00:00:00.000 | 2022 | 566 | 307078 |
2 | 2025-06-25 00:00:00.000 | 2022 | 804 | 306512 |
3 | 2025-06-24 00:00:00.000 | 2022 | 559 | 305708 |
4 | 2025-06-23 00:00:00.000 | 2022 | 1066 | 305149 |
5 | 2025-06-22 00:00:00.000 | 2022 | 636 | 304083 |
6 | 2025-06-21 00:00:00.000 | 2022 | 378 | 303447 |
7 | 2025-06-20 00:00:00.000 | 2022 | 260 | 303069 |
8 | 2025-06-19 00:00:00.000 | 2022 | 467 | 302809 |
9 | 2025-06-18 00:00:00.000 | 2022 | 413 | 302342 |
10 | 2025-06-17 00:00:00.000 | 2022 | 404 | 301929 |
11 | 2025-06-16 00:00:00.000 | 2022 | 1332 | 301525 |
12 | 2025-06-15 00:00:00.000 | 2022 | 462 | 300193 |
13 | 2025-06-14 00:00:00.000 | 2022 | 1169 | 299731 |
14 | 2025-06-13 00:00:00.000 | 2022 | 1613 | 298562 |
15 | 2025-06-12 00:00:00.000 | 2022 | 2276 | 296949 |
16 | 2025-06-11 00:00:00.000 | 2022 | 690 | 294673 |
17 | 2025-06-10 00:00:00.000 | 2022 | 385 | 293983 |
18 | 2025-06-09 00:00:00.000 | 2022 | 399 | 293598 |
19 | 2025-06-08 00:00:00.000 | 2022 | 337 | 293199 |
20 | 2025-06-07 00:00:00.000 | 2022 | 453 | 292862 |
adriaparcerisasAptos Dex 3.4
Updated 2 days ago
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
›
⌄
with
news as (
select distinct swapper, min(trunc(block_timestamp,'day')) as debut
FROM
aptos.defi.ez_dex_swaps
where AMOUNT_IN_USD<1e6 and amount_in_usd is not null
GROUP BY
1
)
SELECT
debut as day, case when trunc(debut,'year') ilike '%2024%' then 2024 when trunc(debut,'year') ilike '%2023%' then 2023 else 2022 end as year, count(distinct swapper) as new_swapper, sum(new_swapper) over (partition by year order by day) as total_swappers
FROM
news
GROUP BY
year, day
ORDER BY
day DESC, year
Last run: 1 day ago
...
982
43KB
26s