PLATFORM | AVG_SWAP_SPEED_SECONDS | |
|---|---|---|
1 | hippo | 1.668153333 |
2 | thala | 1.677714401 |
3 | auxexchange | 1.682939651 |
4 | pancake | 1.688520752 |
5 | cetus | 1.689685712 |
6 | animeswap | 1.689692997 |
7 | liquidswap | 1.696521994 |
8 | batswap | 1.698445833 |
9 | sushi | 1.702228077 |
10 | cellana | 1.710521921 |
aureasarsanedesswaps 8
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
PLATFORM,
AVG(DATEDIFF(second, BLOCK_TIMESTAMP, INSERTED_TIMESTAMP))/pow(10,3) AS avg_swap_speed_seconds
FROM
aptos.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
PLATFORM
ORDER BY
avg_swap_speed_seconds ASC
Last run: 5 days ago
10
242B
1s