TX_DATE | TOTAL_FEE_WRON | AVG_FEE_WRON | TOTAL_FEE_USD | AVG_FEE_USD | |
|---|---|---|---|---|---|
1 | 2025-02-13 00:00:00.000 | 3987.81692221 | 0.01206400424 | 4939.575894311 | 0.01494327992 |
2 | 2025-02-12 00:00:00.000 | 10821.024755941 | 0.01180860174 | 12669.61648508 | 0.01382590453 |
3 | 2025-02-11 00:00:00.000 | 8241.13191635 | 0.01197866799 | 9600.918682547 | 0.0139551482 |
4 | 2025-02-10 00:00:00.000 | 7172.407400014 | 0.01154530842 | 7928.199829791 | 0.01276189529 |
5 | 2025-02-09 00:00:00.000 | 4983.663495774 | 0.01242238847 | 5450.674295857 | 0.01358646979 |
6 | 2025-02-08 00:00:00.000 | 10478.437853844 | 0.0231754115 | 11095.792484066 | 0.02454082949 |
7 | 2025-02-07 00:00:00.000 | 7863.453737096 | 0.01564380757 | 8230.7425554 | 0.01637450375 |
8 | 2025-02-06 00:00:00.000 | 2530.063899355 | 0.01293965007 | 2616.613168579 | 0.01338229394 |
datavortex1:6
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
WITH tx_data AS (
SELECT
l.tx_hash,
DATE_TRUNC('day', l.block_timestamp) AS tx_date,
t.tx_fee
FROM ronin.core.ez_decoded_event_logs l
JOIN ronin.core.fact_transactions t
ON l.tx_hash = t.tx_hash
WHERE l.event_name = 'Swap'
AND l.block_timestamp >= current_timestamp - INTERVAL '7 days'
)
SELECT
tx.tx_date,
SUM(tx.tx_fee) AS total_fee_wron,
AVG(tx.tx_fee) AS avg_fee_wron,
SUM(tx.tx_fee * p.price) AS total_fee_usd,
AVG(tx.tx_fee * p.price) AS avg_fee_usd
FROM tx_data tx
LEFT JOIN ronin.price.ez_prices_hourly p
ON tx.tx_date = DATE_TRUNC('day', p.hour)
WHERE p.symbol = 'WRON'
GROUP BY tx.tx_date
ORDER BY tx.tx_date DESC;
Last run: 3 months ago
8
686B
2s