select count(tx_id), date_trunc('day', block_timestamp) as DATE

from osmosis.core.fact_transactions

where tx_status = 'FAILED'

and block_timestamp > '2022-02-01'

group by DATE