SELECT trunc(a.CREATED_AT,'day') AS date,

count(distinct concat(a.VALIDATOR,'<->',b.VALIDATOR)) AS validator_pairs,

COUNT(*) AS votes_together

FROM osmosis.core.fact_governance_validator_votes a

JOIN osmosis.core.fact_governance_validator_votes b ON a.PROPOSAL_ID = b.PROPOSAL_ID AND a.VALIDATOR < b.VALIDATOR

WHERE a.VOTE = b.VOTE

GROUP BY 1