select min(tx_hash_count) as min_transfers_count,

max(tx_hash_count) as max_transfers_count,

avg(tx_hash_count) as avg_transfers_count,

median(tx_hash_count) as med_transfers_count

from (

select to_date(block_timestamp) as date,

count(distinct tx_hash) as tx_hash_count,

count(distinct tx_signer) as tx_users_count,

sum(deposit/1e18) as volume_transfer

from near.core.fact_transfers

group by date) where date>= '2022-01-01'

and date <= '2022-12-31'

)

select * from final_data