select

tx_sender,

min(block_timestamp) as min_date

from terra.core.fact_transactions

group by 1

)

select

date_trunc('day', min_date) as date1,

tx_sender as value

from tab1

where date_trunc('day', min_date) > current_date - 7