date_trunc('hour',BLOCK_TIMESTAMP) as date,

count(distinct tx_id) as tx_count,

count(distinct tx_sender) as uniqe_user

from terra.core.fact_transactions

where TX_SUCCEEDED = 'TRUE'

and date >= '2023-01-09'

group by 1

order by 1

limit 24