DAY | SYMBOL_IN | NEW_SWAPPERS | RETURNING_SWAPPERS | |
|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | BUSD | 9 | 25 |
2 | 2024-10-01 00:00:00.000 | DAI | 777 | 4097 |
3 | 2024-10-01 00:00:00.000 | EURS | 9 | 27 |
4 | 2024-10-01 00:00:00.000 | TUSD | 3 | 4 |
5 | 2024-10-01 00:00:00.000 | USDC | 1601 | 7469 |
6 | 2024-10-01 00:00:00.000 | USDT | 1566 | 7941 |
7 | 2024-10-01 00:00:00.000 | UST | 21 | 92 |
8 | 2024-10-02 00:00:00.000 | BUSD | 13 | 19 |
9 | 2024-10-02 00:00:00.000 | DAI | 862 | 5580 |
10 | 2024-10-02 00:00:00.000 | EURS | 6 | 7 |
11 | 2024-10-02 00:00:00.000 | TUSD | 0 | 1 |
12 | 2024-10-02 00:00:00.000 | USDC | 1478 | 14006 |
13 | 2024-10-02 00:00:00.000 | USDT | 1730 | 13549 |
14 | 2024-10-02 00:00:00.000 | UST | 12 | 72 |
15 | 2024-10-03 00:00:00.000 | BUSD | 7 | 19 |
16 | 2024-10-03 00:00:00.000 | DAI | 758 | 4039 |
17 | 2024-10-03 00:00:00.000 | EURS | 8 | 17 |
18 | 2024-10-03 00:00:00.000 | TUSD | 4 | 3 |
19 | 2024-10-03 00:00:00.000 | USDC | 1469 | 6049 |
20 | 2024-10-03 00:00:00.000 | USDT | 2008 | 7820 |
datavortexNew Vs Returning Traders
Updated 2025-04-18
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 previous_swappers AS (
SELECT DISTINCT origin_from_address, symbol_in
FROM polygon.defi.ez_dex_swaps
WHERE block_timestamp < '{{ start_date }}'
AND symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
),
current_swappers AS (
SELECT DISTINCT origin_from_address, symbol_in, DATE_TRUNC('day', block_timestamp) AS day
FROM polygon.defi.ez_dex_swaps
WHERE block_timestamp >= '{{ start_date }}'
AND block_timestamp < '{{ end_date }}'
AND symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
),
new_swappers AS (
SELECT origin_from_address, symbol_in, day
FROM current_swappers
WHERE origin_from_address NOT IN (
SELECT origin_from_address
FROM previous_swappers
WHERE previous_swappers.symbol_in = current_swappers.symbol_in
)
),
returning_swappers AS (
SELECT origin_from_address, symbol_in, day
FROM current_swappers
WHERE origin_from_address IN (
SELECT origin_from_address
FROM previous_swappers
WHERE previous_swappers.symbol_in = current_swappers.symbol_in
)
)
SELECT
Last run: about 1 month ago
...
209
9KB
10s