date_trunc('day',block_timestamp::date) as "Date" ,count(distinct tx_id) as "Number of Daily Transactions",

("Number of Daily Transactions"/1440) as "Transactions per Minute"

from flow.core.fact_transactions

where block_timestamp >= '2022-05-09'

and TX_SUCCEEDED = true

group by 1

order by 1