datavortextransaction fees by platform
Updated 2024-09-18
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 recent_swaps AS (
SELECT
block_timestamp AS swap_time,
tx_hash AS transaction_id,
platform AS trading_platform
FROM optimism.defi.ez_dex_swaps
WHERE block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '1 DAY'
),
transaction AS (
SELECT
r.trading_platform,
t.tx_fee_precise AS transaction_fee
FROM recent_swaps r
JOIN optimism.core.fact_transactions t
ON r.transaction_id = t.tx_hash
)
SELECT
trading_platform,
SUM(transaction_fee) AS total_tx_fee_precise
FROM transaction
GROUP BY trading_platform
ORDER BY total_tx_fee_precise DESC;
QueryRunArchived: QueryRun has been archived