date_trunc('day', BLOCK_TIMESTAMP)::date AS DAY,

iff(BLOCK_TIMESTAMP::date >= '2023-01-14', 'After Announce', ' Before Announce') as type ,

count(TX_ID) AS txns,

100*(txns-lag(txns,1)over(order by day))/lag(txns,1)over(order by day) "txns change %",

count(distinct TX_SENDER) AS act_users,

100*(act_users-lag(act_users,1)over(order by day))/lag(act_users,1)over(order by day) "act_users change %",

sum(FEE) AS tot_fee,

100*(tot_fee-lag(tot_fee,1)over(order by day))/lag(tot_fee,1)over(order by day) "tot_fee change %",

tot_fee/txns as fee_per_tx,

100*(fee_per_tx-lag(fee_per_tx,1)over(order by day))/lag(fee_per_tx,1)over(order by day) "fee_per_tx change %",

txns/act_users as txs_per_user,

100*(txs_per_user-lag(txs_per_user,1)over(order by day))/lag(txs_per_user,1)over(order by day) "txs_per_user change %"

from terra.core.fact_transactions where TX_SUCCEEDED='TRUE' and

BLOCK_TIMESTAMP::date ilike '2023%'

group by 1,2