date_trunc('minute',BLOCK_TIMESTAMP) as dt,

TX_SUCCEEDED,

count(TX_ID) as no_txn

from flow.core.fact_transactions

where BLOCK_TIMESTAMP>='2022-05-09'

group by 1,2