DATE | TIMESPAN | FEES | AVERAGE_FEES | |
|---|---|---|---|---|
1 | 2025-01-31 00:00:00.000 | After Upgrade | 112.906523311 | 0.00225339833 |
2 | 2025-01-30 00:00:00.000 | After Upgrade | 125.443464152 | 0.002354065909 |
3 | 2025-01-29 00:00:00.000 | After Upgrade | 189.461221908 | 0.003057108173 |
4 | 2025-01-28 00:00:00.000 | After Upgrade | 274.94141709 | 0.004784085907 |
5 | 2025-01-27 00:00:00.000 | After Upgrade | 619.401674322 | 0.007197825485 |
6 | 2025-01-26 00:00:00.000 | After Upgrade | 150.141802543 | 0.002001890701 |
7 | 2025-01-25 00:00:00.000 | After Upgrade | 138.884419497 | 0.001981458933 |
8 | 2025-01-24 00:00:00.000 | After Upgrade | 177.318258762 | 0.001348345795 |
9 | 2025-01-23 00:00:00.000 | After Upgrade | 223.486962031 | 0.003162267939 |
10 | 2025-01-22 00:00:00.000 | After Upgrade | 138.957982436 | 0.002298041649 |
11 | 2025-01-21 00:00:00.000 | After Upgrade | 216.177274592 | 0.003002378748 |
12 | 2025-01-20 00:00:00.000 | After Upgrade | 728.437817723 | 0.006594047359 |
13 | 2025-01-19 00:00:00.000 | After Upgrade | 764.35240595 | 0.007617244566 |
14 | 2025-01-18 00:00:00.000 | After Upgrade | 161.117315937 | 0.002585862197 |
15 | 2025-01-17 00:00:00.000 | After Upgrade | 128.359387325 | 0.001940722518 |
16 | 2025-01-16 00:00:00.000 | After Upgrade | 173.939963563 | 0.002774560361 |
17 | 2025-01-15 00:00:00.000 | After Upgrade | 234.898250858 | 0.003653899713 |
18 | 2025-01-14 00:00:00.000 | After Upgrade | 81.172915808 | 0.001714715474 |
19 | 2025-01-13 00:00:00.000 | After Upgrade | 347.226876299 | 0.004560433895 |
20 | 2025-01-12 00:00:00.000 | After Upgrade | 160.141392948 | 0.003092368458 |
Ali3N[LFJ] Daily Fees Stats (Before & After Avalanche 9000 Etna Upgrade)
Updated 2025-01-31
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc (day,t1.block_timestamp) as date,
case when t1.block_timestamp < '2024-12-16 17:00:00.000' then 'Before Upgrade'
else 'After Upgrade' end as timespan,
sum (tx_fee) as Fees,
avg (tx_fee) as Average_Fees
from avalanche.defi.ez_dex_swaps t1 join avalanche.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash
where t1.block_Timestamp >= '2024-11-10'
and platform ilike '%trader-joe%'
group by 1,2
order by 1 desc
Last run: 3 months ago
84
6KB
25s