case when succeeded = 'TRUE' then 'Succeeded' else 'Failed' end as status,

count(distinct tx_id) as unique_transactions

from flipside_prod_db.solana.fact_transactions where

date(block_timestamp) between '2022-05-01' and '2022-05-31'

group by 1