Kruys-CollinsAcross Protocol Transaction Fees copy
Updated 2024-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Across Protocol Transaction Fees @ https://flipsidecrypto.xyz/edit/queries/b83580b0-4006-4602-8d45-fa7789131b4f
SELECT
sum(t.tx_fee) as "Total Fees in ETH"
, count (*) as "Number of Transactions"
, avg(t.tx_fee) as "Average Txn Fee ETH"
, median(t.tx_fee)as "median Txn Fee in ETH"
FROM
ethereum.defi.ez_bridge_activity b
LEFT JOIN ethereum.core.fact_transactions t
ON b.tx_hash = t.tx_hash
WHERE 1=1
AND bridge_address = lower('0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5')
--AND t.block_timestamp >= current_date - 90
-- group by 1,2,3
-- order by 1 DESC
QueryRunArchived: QueryRun has been archived