MONTH | PLATFORM | TOTAL_SWAPS | VOLUME_TRADED_USD | RANK_BY_VOLUME | |
|---|---|---|---|---|---|
1 | 2024-12-01 00:00:00.000 | thala | 669331 | 404240399.737404 | 1 |
2 | 2024-12-01 00:00:00.000 | hippo | 56546 | 7725713.71058136 | 6 |
3 | 2024-12-01 00:00:00.000 | liquidswap | 1487749 | 361714593.004467 | 2 |
4 | 2024-12-01 00:00:00.000 | auxexchange | 176353 | 199858.465596785 | 8 |
5 | 2024-12-01 00:00:00.000 | cetus | 146042 | 204115.995330856 | 7 |
6 | 2024-12-01 00:00:00.000 | batswap | 29987 | 46764.101454832 | 10 |
7 | 2024-12-01 00:00:00.000 | animeswap | 129030 | 82444.015023662 | 9 |
8 | 2024-12-01 00:00:00.000 | pancake | 585245 | 137729970.474001 | 3 |
9 | 2024-12-01 00:00:00.000 | sushi | 228354 | 94192289.0995101 | 5 |
10 | 2024-12-01 00:00:00.000 | cellana | 754012 | 134007557.041568 | 4 |
11 | 2024-11-01 00:00:00.000 | batswap | 36892 | 53287.68195897 | 10 |
12 | 2024-11-01 00:00:00.000 | thala | 814488 | 419870849.865871 | 1 |
13 | 2024-11-01 00:00:00.000 | pancake | 649215 | 158282075.468878 | 3 |
14 | 2024-11-01 00:00:00.000 | cellana | 743432 | 107208865.124564 | 4 |
15 | 2024-11-01 00:00:00.000 | auxexchange | 239115 | 205495.654365901 | 8 |
16 | 2024-11-01 00:00:00.000 | liquidswap | 921147 | 264733068.773989 | 2 |
17 | 2024-11-01 00:00:00.000 | animeswap | 159018 | 89976.253512694 | 9 |
18 | 2024-11-01 00:00:00.000 | cetus | 169893 | 209176.072340516 | 7 |
19 | 2024-11-01 00:00:00.000 | sushi | 230530 | 78245952.8169301 | 5 |
20 | 2024-11-01 00:00:00.000 | hippo | 54530 | 8797005.81359475 | 6 |
aureasarsanedesaptos in 2024 3
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
›
⌄
WITH swaps_data AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS month,
platform,
COUNT(DISTINCT tx_hash) AS total_swaps,
SUM(amount_out_usd) AS volume_traded_usd
FROM aptos.defi.ez_dex_swaps
where date_trunc('day',block_timestamp) between '2024-01-01' and '2024-12-31' and amount_out_usd is not null and amount_out_usd<1e6
GROUP BY 1, 2
)
SELECT
month,
platform,
total_swaps,
volume_traded_usd,
RANK() OVER (PARTITION BY month ORDER BY volume_traded_usd DESC) AS rank_by_volume
FROM swaps_data
order by 1 desc
Last run: 3 days ago
...
119
7KB
18s