SELECT date_trunc('day', block_timestamp) as day, MSG_TYPE, COUNT(DISTINCT tx_id) as events

FROM cosmos.core.fact_msgs

WHERE MSG_TYPE IN ('delegate', 'redelegate', 'unbond')

GROUP BY 1,2

SELECT msg_type, sum(events), avg(events)

FROM t1

GROUP BY 1