date_trunc(day, pr.block_timestamp) AS timespan,

COUNT (DISTINCT proposal_id) AS proposals,

COUNT (DISTINCT proposer) AS proposers,

COUNT (DISTINCT proposal_type) AS proposal_type,

sum (tx:body:messages[0]:initial_deposit[0]:amount::int / pow(10,6)) AS deposited_luna,

sum (fee) AS tx_fees

FROM terra.core.fact_governance_submit_proposal pr JOIN terra.core.fact_transactions tr ON pr.tx_id = tr.tx_id

WHERE pr.tx_succeeded = 'TRUE'

GROUP BY 1

ORDER BY 1