date(block_timestamp) as date,

count(distinct tx_from) as "Distinct Wallets",

count(distinct tx_id) as NUMBER_OF_TRANSACTIONS

FROM osmosis.core.fact_transactions

WHERE tx_status = 'SUCCEEDED'

GROUP BY 1