with cte_1 as (

select

--count(DISTINCT tx_id) over ( partition by DATE_TRUNC('Second',block_timestamp) order by block_timestamp ) as TRANS,

count(DISTINCT tx_id) as trans,

DATE_TRUNC('Second',block_timestamp) as S

from

solana.transactions

where succeeded = 'TRUE' and

block_timestamp::date >= '2022-2-01' AND block_timestamp::date <= '2022-2-14'

-- and fee > 0

group by 2

limit 100

select

avg(trans ) AVERAGE_TPS,

min(Trans ) LOWEST_TPS,

max(TRANS) HIGHEST_TPS,

DATE_TRUNC('hour',s) as Hour,

DATE_TRUNC('DAY',s) as day

from cte_1

group by

hour,