with final_data as (
select
to_date(block_timestamp) as date,
TX_SIGNER,
count( distinct TX_HASH) as tx_hash_count,
sum(deposit/pow(10,24)) as volume
from near.core.fact_transfers
where TX_SIGNER='binancecold3.near' and
status = 1
group by date, tx_signer
)
select * from final_data