date(block_timestamp) as date,

count(distinct tx_id) as tx_count,

count(distinct tx_sender) as active_users

from

terra.core.fact_transactions

where

date(block_timestamp) between current_date()-365 and current_date()-1

group by date

order by date desc