Select
block_timestamp::date as date,
count(tx_id) as "failed transactions a day",
count(tx_id)/1440 as "failed transactions a hour",
count(tx_id)/86400 as "failed transactions per second"
From solana.transactions
Where block_timestamp::date >='2022-02-01' AND succeeded = FALSE
Group by date
ORDER BY date;