'Osmosis' as blockchain,

proposal_id,

sum(amount) / pow(10,6) as deposit_amount,

min(block_timestamp) as min_deposit_date,

max(block_timestamp) as max_deposit_date,

count(*) as no_of_deposit_txs

from osmosis.core.fact_governance_proposal_deposits

where tx_succeeded

group by 1,2

order by 1,2