PLATFORM | AVG_SWAP_SPEED_SECONDS | |
|---|---|---|
1 | cellana | 2.720687597 |
2 | thala | 2.993820044 |
3 | liquidswap | 3.090540822 |
4 | pancake | 3.177333099 |
5 | animeswap | 3.25710402 |
6 | cetus | 3.262782253 |
7 | hippo | 3.296100325 |
8 | auxexchange | 3.346079403 |
9 | sushi | 3.508315059 |
10 | batswap | 3.833711207 |
aureasarsanedesswaps 8
Updated 8 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: 8 days ago
10
241B
1s