BLOCK_TIMESTAMP::date as date ,

event_type,

count(distinct tx_id)

from flow.core.fact_events

where TX_SUCCEEDED = true

group by 1,2