day | total traders | new traders | returning traders | |
|---|---|---|---|---|
1 | 2025-06-13 00:00:00.000 | 85 | 0 | 85 |
2 | 2025-06-12 00:00:00.000 | 81 | 0 | 81 |
3 | 2025-06-11 00:00:00.000 | 82 | 0 | 82 |
4 | 2025-06-10 00:00:00.000 | 88 | 0 | 88 |
5 | 2025-06-09 00:00:00.000 | 75 | 0 | 75 |
6 | 2025-06-08 00:00:00.000 | 82 | 0 | 82 |
7 | 2025-06-07 00:00:00.000 | 80 | 0 | 80 |
8 | 2025-06-06 00:00:00.000 | 80 | 0 | 80 |
9 | 2025-06-05 00:00:00.000 | 82 | 0 | 82 |
10 | 2025-06-04 00:00:00.000 | 78 | 0 | 78 |
11 | 2025-06-03 00:00:00.000 | 74 | 0 | 74 |
12 | 2025-06-02 00:00:00.000 | 81 | 0 | 81 |
13 | 2025-06-01 00:00:00.000 | 93 | 0 | 93 |
14 | 2025-05-31 00:00:00.000 | 88 | 0 | 88 |
15 | 2025-05-30 00:00:00.000 | 94 | 0 | 94 |
16 | 2025-05-29 00:00:00.000 | 103 | 6 | 97 |
17 | 2025-05-28 00:00:00.000 | 90 | 0 | 90 |
18 | 2025-05-27 00:00:00.000 | 81 | 0 | 81 |
19 | 2025-05-26 00:00:00.000 | 84 | 0 | 84 |
20 | 2025-05-25 00:00:00.000 | 89 | 0 | 89 |
defi__joshnew vs returning traders
Updated 3 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
›
⌄
WITH first_trades AS (
SELECT
from_address,
MIN(DATE_TRUNC('day', block_timestamp)) as first_trade_date
FROM ronin.core.ez_token_transfers
WHERE origin_to_address = '0x7d0556d55ca1a92708681e2e231733ebd922597d'
GROUP BY 1
)
SELECT
DATE_TRUNC('day', t.block_timestamp) as "day",
COUNT(DISTINCT t.from_address) as "total traders",
COUNT(DISTINCT CASE
WHEN f.first_trade_date = DATE_TRUNC('day', t.block_timestamp)
THEN t.from_address
END) as "new traders",
COUNT(DISTINCT CASE
WHEN f.first_trade_date < DATE_TRUNC('day', t.block_timestamp)
THEN t.from_address
END) as "returning traders"
FROM ronin.core.ez_token_transfers t
JOIN first_trades f ON t.from_address = f.from_address
WHERE t.block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP)
AND t.origin_to_address = '0x7d0556d55ca1a92708681e2e231733ebd922597d'
GROUP BY 1
ORDER BY 1 DESC;
Last run: 3 days ago
31
1KB
4s