date_trunc(day, block_timestamp) as date,

sum(case when STATUS = 'SUCCESS' then 1 else 0 end) as "# Success TXs",

sum(case when STATUS = 'SUCCESS' then 0 else 1 end) as "# Fail TXs"

from blast.core.fact_transactions

where block_timestamp > '2024-02-29'

group by 1