SELECT
avg(tps) as avg,max(tps) as max,min(tps) as min
from(
select
block_timestamp::date as date, count( tx_hash )/ 86400 as tps
from optimism.core.fact_transactions
where date between current_date - 90 and current_date - 1
group by 1
order by 1 asc)