date_trunc('day', block_timestamp),

count(*) as transactions,

count(case WHEN tx_succeeded LIKE TRUE THEN 1 END) as good_tx,

count(case WHEN tx_succeeded LIKE FALSE THEN 1 END) as bad_tx

FROM flow.core.fact_transactions

GROUP BY 1