Updated 2022-07-10
    select BLOCK_TIMESTAMP::date as date,count(TX_ID)as tx_count,
    case
    when SUCCEEDED='TRUE' then 'TRUE'
    when SUCCEEDED='FALSE' then 'FALSE' end as tx_status
    from flipside_prod_db.solana.fact_transactions
    where date>=current_date-180
    group by 1,3
    Run a query to Download Data