select

date_trunc('day', min_date) as date,

count(*) as total_count

from (select

proposal_id,

min(block_timestamp) as min_date

from terra.core.fact_governance_votes

group by proposal_id)

group by date

)

select * from final_data