TOTAL_TX_FEE_NATIVE | TOTAL_TX_FEE_USD | AVG_TX_FEE_NATIVE | AVG_TX_FEE_USD | |
|---|---|---|---|---|
1 | 0.2022221634 | 461.150822456 | 0.0001011616625 | 0.2306907566 |
datavortextx_fees
Updated 2025-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH disbursement AS (
SELECT
block_timestamp,
tx_hash
FROM boba.core.ez_decoded_event_logs
WHERE event_name = 'DisbursementSuccess'
AND origin_function_signature = '0x92c3ec48'
AND tx_succeeded = TRUE
)
SELECT
SUM(t.tx_fee) AS total_tx_fee_native,
SUM(t.tx_fee * p.price) AS total_tx_fee_usd,
AVG(t.tx_fee) AS avg_tx_fee_native,
AVG(t.tx_fee * p.price) AS avg_tx_fee_usd
FROM disbursement d
LEFT JOIN boba.core.fact_transactions t
ON d.tx_hash = t.tx_hash
LEFT JOIN boba.price.ez_prices_hourly p
ON DATE_TRUNC('hour', d.block_timestamp) = p.hour
AND p.symbol = 'ETH';
Last run: about 1 month ago
1
59B
2s