DATE_TRUNC ('week' ,BLOCK_TIMESTAMP ) AS date,

sum(TX_COUNT)/(7*24*3600) AS TPS,

round ( 100*(TPS-lag(TPS,1)over(order by date))/lag(TPS,1)over(order by date),2) as "TPS change %"

from axelar.core.fact_blocks

where

BLOCK_TIMESTAMP < current_date

GROUP BY 1

qualify row_number()over(order by date desc) > 1

order by 1 desc