select

date_trunc('day', block_timestamp) as date,

tx_from as sender

from osmosis.core.fact_transactions

where tx_status = 'SUCCEEDED'

group by date