SELECT block_timestamp::date as date,

CASE

WHEN date < '2023-01-14' THEN '1.Before the Station Announcement'

ELSE '2.After the Station Announcement' END as time_label,

COUNT(DISTINCT tx_sender) as wallets,

COUNT(DISTINCT tx_id) as txs

FROM terra.core.fact_transactions

WHERE date BETWEEN '2023-01-07' and '2023-01-21'

GROUP BY 1

SELECT time_label,

avg(wallets) as avg_daily_wallet,

avg(txs) as avg_daily_transactions,

(avg_daily_wallet - lag(avg(wallets),1) over (order by time_label)) / lag(avg(wallets),1) over (order by time_label) * 100 as wallets_avg_growth,

(avg_daily_transactions - lag(avg(txs),1) over (order by time_label)) / lag(avg(txs),1) over (order by time_label) * 100 as trasnactions_avg_growth

FROM daily

GROUP BY 1