(select TX_SENDER, min(BLOCK_TIMESTAMP) as ddd

from

terra.core.fact_transactions

group by 1

)

select

count(*) as number ,

date_trunc('day',ddd) as date

from t1 a left join terra.core.dim_address_labels b

on a.TX_SENDER=b.ADDRESS

group by date