select avg(tx) from
(
select count(*) as tx, date_trunc(day,block_timestamp) as dt,
sum(tx) over (order by dt) as cumulative
from
(
select distinct tx_hash, block_timestamp
from ethereum.core.fact_transactions
where block_number < 15537393
and block_number >= 12965000 -- london hard fork
)
group by 2
order by 1 desc
)