DAY | TIMESPAN | AVG(ABS(SLIPPAGE)) | AVG(AMOUNT_IN_USD) | |
|---|---|---|---|---|
1 | 2025-02-01 00:00:00.000 | After Upgrade | 1.292770078 | 3400.740370185 |
2 | 2025-01-31 00:00:00.000 | After Upgrade | 3.204063595 | 3926.62291693 |
3 | 2025-01-30 00:00:00.000 | After Upgrade | 1.507568 | 3550.210853976 |
4 | 2025-01-29 00:00:00.000 | After Upgrade | 1.706506226 | 3631.59837449 |
5 | 2025-01-28 00:00:00.000 | After Upgrade | 1.45735881 | 3707.817254141 |
6 | 2025-01-27 00:00:00.000 | After Upgrade | 1.735111757 | 4713.67448326 |
7 | 2025-01-26 00:00:00.000 | After Upgrade | 2.56800635 | 2694.440838136 |
8 | 2025-01-25 00:00:00.000 | After Upgrade | 2.12880993 | 3240.512771218 |
9 | 2025-01-24 00:00:00.000 | After Upgrade | 3.519215637 | 3349.441530458 |
10 | 2025-01-23 00:00:00.000 | After Upgrade | 1.024012846 | 4482.909012539 |
11 | 2025-01-22 00:00:00.000 | After Upgrade | 0.9029295238 | 3450.529781001 |
12 | 2025-01-21 00:00:00.000 | After Upgrade | 1.219215177 | 3308.750737815 |
13 | 2025-01-20 00:00:00.000 | After Upgrade | 1.651243114 | 5490.340751292 |
14 | 2025-01-19 00:00:00.000 | After Upgrade | 2.186718172 | 7003.736967133 |
15 | 2025-01-18 00:00:00.000 | After Upgrade | 1.097487755 | 4996.587655167 |
16 | 2025-01-17 00:00:00.000 | After Upgrade | 1.545199706 | 4123.897718473 |
17 | 2025-01-16 00:00:00.000 | After Upgrade | 1.338440938 | 4766.194723724 |
18 | 2025-01-15 00:00:00.000 | After Upgrade | 1.586357608 | 4348.725860884 |
19 | 2025-01-14 00:00:00.000 | After Upgrade | 1.151161678 | 5039.121643603 |
20 | 2025-01-13 00:00:00.000 | After Upgrade | 1.691019086 | 5400.854650591 |
Ali3N[LFJ] Daily Slippage Over Time (Before & After Avalanche 9000 Etna Upgrade) copy
Updated 2025-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select day,
case when day < '2024-12-16 17:00:00.000' then 'Before Upgrade'
else 'After Upgrade' end as timespan,
avg(abs(slippage)),
avg(amount_in_usd)
from
(select
date(block_timestamp) as day,
div0((100*(amount_in_usd-amount_out_usd)),amount_in_usd) as slippage,
amount_in_usd, amount_out_usd,
platform, pool_name
from
avalanche.defi.ez_dex_swaps
where
platform ilike '%trader-joe%'
and amount_in_usd>=100
)
where day >= '2024-11-16'
group by 1,2
order by 1 desc
Last run: 3 months ago
78
5KB
2s