OVERALL_TOTAL_FEE_WRON | OVERALL_AVG_FEE_WRON | OVERALL_TOTAL_FEE_USD | OVERALL_AVG_FEE_USD | |
|---|---|---|---|---|
1 | 56081.945206724 | 0.01365137031 | 62536.213581382 | 0.01522245718 |
datavortex1:9
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
›
⌄
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
SUM(tx.tx_fee) AS overall_total_fee_wron,
AVG(tx.tx_fee) AS overall_avg_fee_wron,
SUM(tx.tx_fee * p.price) AS overall_total_fee_usd,
AVG(tx.tx_fee * p.price) AS overall_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';
Last run: about 1 month ago
1
63B
6s