with proposal as (select proposal_id,min(proposal_start_time) as transactionn from ethereum.core.ez_snapshot group by 1),
proposal1 as (select proposal_id, date_trunc('day', transactionn) as day, 1 as counts from proposal)
select day,sum(counts) as Number_of_Proposals from proposal1 group by 1