TOTAL_TX_FEE_USD | AVG_TX_FEE_USD | TRANSACTION_COUNT | |
|---|---|---|---|
1 | 14661.457543404 | 0.1297037947 | 113038 |
datavortextx_fee
Updated 4 days ago
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH decoded_logs AS (
SELECT
l.tx_hash AS transaction_hash,
t.block_timestamp
FROM boba.core.fact_event_logs l
JOIN boba.core.fact_transactions t ON l.tx_hash = t.tx_hash
WHERE l.contract_address IN (
'0xaf3da220bc03bdbf9b0280d6e2813ea0ffe03f69',
'0x78c6db2b6073e762f89a23eb3da71d2feeb18315',
'0x4f059f8d45230cd5b37544e87eebba033a5f1b17',
'0x6398a59ca706c11d02de1ea3d921742771bcd06f',
'0xce4956c398ba118f4eacabca1b32ae97bd31df2a',
'0x247442181b8baa03b3c7dc0d8e971bd4686db27c',
'0x48643395833882729032170078bf7791a0999f8c',
'0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038',
'0x2e014fe08247a080f2ed6d230b2594911f9f9a69',
'0x0ec9d6d21358221cccfc933530a8026038cedc12'
)
AND l.topics[0] = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
),
daily_prices AS (
SELECT
DATE_TRUNC('day', HOUR) AS price_date,
SYMBOL,
AVG(PRICE) AS avg_price
FROM boba.price.ez_prices_hourly
WHERE SYMBOL = 'ETH'
GROUP BY DATE_TRUNC('day', HOUR), SYMBOL
),
tx_fees AS (
SELECT DISTINCT
d.transaction_hash,
t.tx_fee,
(t.tx_fee) * p.avg_price AS tx_fee_usd
FROM decoded_logs d
JOIN boba.core.fact_transactions t ON d.transaction_hash = t.tx_hash
Last run: 4 days ago
1
39B
8s