transactions as (

select

date_trunc('second', block_timestamp) as date,

count(distinct tx_hash) as tps

from

avalanche.core.fact_transactions

where

block_timestamp::date between '2021-09-21' and current_date - 1

group by

date

)

date_trunc('day', date) as "Date",

avg(tps) as "Average TPS",

median(tps) as "Median TPS",

max(tps) as "Max TPS",

min(tps) as "Min TPS"

transactions

group by

"Date"

order by

"Date" desc