select

date_trunc('second', block_timestamp) as TIME,

count(tx_id) as tcount

from terra.core.fact_transactions

where TX_SUCCEEDED = 'TRUE'

and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}

group by TIME)

select

date_trunc('week', TIME) as week,

avg(tcount) as Weekly_TPS

from source

group by week