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