WEEK | weekly total traders | weekly total trades | cumulative total traders | cumulative total trades | |
|---|---|---|---|---|---|
1 | 2024-12-23 00:00:00.000 | 217 | 451 | 217 | 451 |
2 | 2024-12-30 00:00:00.000 | 2189 | 4871 | 2406 | 5322 |
3 | 2025-01-06 00:00:00.000 | 2021 | 6571 | 4427 | 11893 |
4 | 2025-01-13 00:00:00.000 | 1435 | 5251 | 5862 | 17144 |
5 | 2025-01-20 00:00:00.000 | 12154 | 17079 | 18016 | 34223 |
6 | 2025-01-27 00:00:00.000 | 9850 | 31295 | 27866 | 65518 |
7 | 2025-02-03 00:00:00.000 | 2557 | 16099 | 30423 | 81617 |
8 | 2025-02-10 00:00:00.000 | 21040 | 97176 | 51463 | 178793 |
9 | 2025-02-17 00:00:00.000 | 12835 | 46637 | 64298 | 225430 |
10 | 2025-02-24 00:00:00.000 | 5795 | 26801 | 70093 | 252231 |
11 | 2025-03-03 00:00:00.000 | 5511 | 25039 | 75604 | 277270 |
12 | 2025-03-10 00:00:00.000 | 3063 | 14229 | 78667 | 291499 |
13 | 2025-03-17 00:00:00.000 | 5964 | 14553 | 84631 | 306052 |
14 | 2025-03-24 00:00:00.000 | 4855 | 14480 | 89486 | 320532 |
15 | 2025-03-31 00:00:00.000 | 10538 | 26933 | 100024 | 347465 |
16 | 2025-04-07 00:00:00.000 | 5027 | 23772 | 105051 | 371237 |
17 | 2025-04-14 00:00:00.000 | 2376 | 12243 | 107427 | 383480 |
18 | 2025-04-21 00:00:00.000 | 1934 | 12576 | 109361 | 396056 |
19 | 2025-04-28 00:00:00.000 | 38 | 73 | 109399 | 396129 |
datavortexweekly trades and traders
Updated 8 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
26
27
›
⌄
WITH SwapData AS (
SELECT
tx_hash,
origin_from_address,
block_timestamp,
DATE_TRUNC('week', block_timestamp) AS swap_week
FROM
ink.core.ez_decoded_event_logs
WHERE
event_name = 'Swap'
AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
AND block_timestamp IS NOT NULL
AND tx_succeeded = TRUE
)
SELECT
swap_week AS "WEEK",
COUNT(DISTINCT origin_from_address) AS "weekly total traders",
COUNT(DISTINCT tx_hash) AS "weekly total trades",
SUM(COUNT(DISTINCT origin_from_address)) OVER (ORDER BY swap_week) AS "cumulative total traders",
SUM(COUNT(DISTINCT tx_hash)) OVER (ORDER BY swap_week) AS "cumulative total trades"
FROM
SwapData
GROUP BY
swap_week
ORDER BY
swap_week;
Last run: 8 days ago
19
972B
4s