tps_feb as (

select

date_trunc('second', block_timestamp) as tx_time,

count(tx_hash) as tps

from

arbitrum.core.fact_transactions

where

block_timestamp::date >= '2022-02-01'

-- and succeeded = True

group by

1

order by

1

),

tps_daily as (

select

tx_time::date as date,

min(tps) as minimum,

avg(tps) as average,

median(tps) as median,

max(tps) as maximum

from

tps_feb

group by

1

order by

1

)

*

tps_daily