DATE | TOTAL_FEES | AVG_FEE | |
|---|---|---|---|
1 | 2025-03-25 00:00:00.000 | 0.0100220085 | 0.0100220085 |
2 | 2025-03-24 00:00:00.000 | 0.9897358868 | 0.01030974882 |
3 | 2025-03-23 00:00:00.000 | 2.970206033 | 0.01800124868 |
4 | 2025-03-22 00:00:00.000 | 2.267778634 | 0.01585859185 |
5 | 2025-03-21 00:00:00.000 | 1.119818979 | 0.01230570307 |
6 | 2025-03-20 00:00:00.000 | 1.119957127 | 0.009911125022 |
7 | 2025-03-19 00:00:00.000 | 1.976463663 | 0.01275137847 |
8 | 2025-03-18 00:00:00.000 | 1.397289748 | 0.01074838268 |
9 | 2025-03-17 00:00:00.000 | 3.364690564 | 0.01625454379 |
10 | 2025-03-16 00:00:00.000 | 1.12070235 | 0.00933918625 |
11 | 2025-03-15 00:00:00.000 | 1.32671484 | 0.009087087945 |
12 | 2025-03-14 00:00:00.000 | 1.55406309 | 0.0101572751 |
13 | 2025-03-13 00:00:00.000 | 3.13050087 | 0.009289320089 |
14 | 2025-03-12 00:00:00.000 | 1.46985003 | 0.009734106159 |
15 | 2025-03-11 00:00:00.000 | 2.76543327 | 0.008949622233 |
16 | 2025-03-10 00:00:00.000 | 2.04124968 | 0.009194818378 |
17 | 2025-03-09 00:00:00.000 | 0.41915595 | 0.007621017273 |
18 | 2025-03-08 00:00:00.000 | 4.39452144 | 0.008667695148 |
19 | 2025-03-07 00:00:00.000 | 1.07702688 | 0.009127346441 |
20 | 2025-03-06 00:00:00.000 | 1.49078835 | 0.008667374128 |
datavortexDaily Fees
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
DATE_TRUNC('day', t.block_timestamp) AS date,
SUM(COALESCE(t.tx_fee, 0)) AS total_fees,
AVG(COALESCE(t.tx_fee, 0)) AS avg_fee
FROM
ronin.core.ez_decoded_event_logs e
LEFT JOIN ronin.core.fact_transactions t ON e.tx_hash = t.tx_hash
WHERE
e.event_name = 'OrderFilled'
AND e.decoded_log:"taker" <> '0x520fe655590e6fee13656590f1be3edf31fe099c'
AND e.origin_from_address = '0x8962cde7ac43de7d55e8b61c80ee8d148fc7a201'
AND e.origin_to_address = '0x520fe655590e6fee13656590f1be3edf31fe099c'
GROUP BY
1
ORDER BY
date DESC;
Last run: 2 months ago
38
2KB
13s