dbrgBS-Maxfee
Updated 2023-05-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('day',block_timestamp) as day,
-- from_address as deployer,
max(tx_fee)
from
base.goerli.fact_transactions
where
to_address is null
and block_timestamp >= to_date('{{start_date}}')
and block_timestamp <= add_months(
to_date('{{start_date}}'),
{{duration_in_months}}
)
and status = 'SUCCESS'
GROUP by 1
ORDER by 2 DESC
limit 1
Run a query to Download Data