SELECT

block_timestamp,

tx_hash

FROM near.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

),

weekly_transactions AS (

SELECT

DATE_TRUNC('week', block_timestamp) AS "Week Start Date",

COUNT(DISTINCT tx_hash) AS "Total Transactions"

FROM yearly_transactions

GROUP BY 1

),

growth_rate AS (

SELECT

"Week Start Date",

"Total Transactions",

LAG("Total Transactions") OVER (ORDER BY "Week Start Date") AS "Previous Week Transactions",

ROUND(

("Total Transactions" - LAG("Total Transactions") OVER (ORDER BY "Week Start Date")) * 100.0

/ NULLIF(LAG("Total Transactions") OVER (ORDER BY "Week Start Date"), 0), 2

) AS "Weekly Growth Rate (%)"

FROM weekly_transactions

SELECT * FROM growth_rate;