select count(distinct tx_hash) , date_trunc('day', block_timestamp)

from near.core.fact_transactions where tx_receiver='aurora' and year(block_timestamp)=2022

group by 2