theericstoneAverage hourly fees
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select * from (
select
date_trunc('hour',block_timestamp) as hour,
function_name,
count(*) as n_txns,
avg(fee_usd) as mean_fee
from
ethereum.transactions
where
block_timestamp >= getdate() - interval '8 hours'
and (
LOWER(function_name) like 'swap%'
OR LOWER(function_name) like '%liquidity%'
OR LOWER(function_name) like '%claim%'
OR LOWER(function_name) like '%deposit%'
)
group by 1,2
order by 1 desc)
allofit where n_txns >= 100 and mean_fee > 0;
Run a query to Download Data