block_timestamp::date as date

,count(DISTINCT tx_id) as tx_count

,sum(FEE) as total_fee

from terra.core.fact_transactions

where block_timestamp::date>='2022-12-25' and block_timestamp::date<='2022-12-31'

and TX_SUCCEEDED=true

group by 1

order by 1