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

iff(BLOCK_TIMESTAMP::date ilike '2022%', '2022', '2023') as type,

count(TX_ID) AS txns,

count(distinct TX_SENDER) AS act_users,

sum(FEE) AS tot_fee,

tot_fee/txns as fee_per_tx,

txns/act_users as txs_per_user

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

BLOCK_TIMESTAMP::date >= '2022-01-01'

group by 1,2