select

case

when '{{n_days}}' != 0 then current_date() - interval '{{n_days}} days'

else cast('{{start_date}}' as timestamp)

end as start_date,

case

when '{{n_days}}' != 0 then current_date()

else cast('{{end_date}}' as timestamp)

end as end_date

,tx_data as(

select

date_trunc('second', t.block_timestamp) as dt,

count(tx_id) as tps

from solana.core.fact_transactions t

join date_filter df

on t.block_timestamp between df.start_date and df.end_date

group by 1

,group_data as(

select

date_trunc('day',dt) as dt,

percentile_cont(0.25) within group (order by tps) as p25,

percentile_cont(0.5) within group (order by tps) as p50,

percentile_cont(0.95) within group (order by tps) as p95

from tx_data

where

date_trunc('day',dt) < (select max(date_trunc('day',dt)) from tx_data)