DATE | NUMBER_OF_TRADERS | NUMBER_OF_SWAPS | |
|---|---|---|---|
1 | 2023-12-04 00:00:00.000 | 2788 | 51538 |
2 | 2023-12-06 00:00:00.000 | 2509 | 53108 |
3 | 2023-11-12 00:00:00.000 | 2472 | 70549 |
4 | 2023-10-24 00:00:00.000 | 2453 | 45019 |
5 | 2023-11-16 00:00:00.000 | 2439 | 62341 |
6 | 2023-12-02 00:00:00.000 | 2240 | 43969 |
7 | 2023-11-11 00:00:00.000 | 2234 | 63681 |
8 | 2023-11-15 00:00:00.000 | 2220 | 61011 |
9 | 2023-12-05 00:00:00.000 | 2199 | 41670 |
10 | 2023-11-29 00:00:00.000 | 2176 | 43558 |
11 | 2023-11-21 00:00:00.000 | 2169 | 63486 |
12 | 2023-11-22 00:00:00.000 | 2157 | 47503 |
13 | 2023-11-17 00:00:00.000 | 2108 | 59289 |
14 | 2023-11-10 00:00:00.000 | 2105 | 42867 |
15 | 2023-11-09 00:00:00.000 | 2068 | 58693 |
16 | 2023-12-03 00:00:00.000 | 2054 | 29985 |
17 | 2023-12-01 00:00:00.000 | 2050 | 34926 |
18 | 2023-10-23 00:00:00.000 | 2015 | 39757 |
19 | 2023-11-30 00:00:00.000 | 1997 | 42997 |
20 | 2023-11-13 00:00:00.000 | 1978 | 47494 |
Deebs-DeFi-j9fRbzRUNE Trader Count and Trades
Updated 2025-03-19
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day', block_timestamp) as date,
count(distinct(from_address)) as number_of_traders,
count(distinct(tx_id)) as number_of_swaps
from thorchain.defi.fact_swaps
where date BETWEEN {{start_date}} and {{end_date}}
and date != date_trunc('day', current_date)
group by 1
ORDER BY 2 DESC
Last run: 26 days ago
...
194
7KB
4s