flipside

    Untitled Query
    MahrooUntitled Query
    select 'July transactions' as status , block_timestamp::date as day, count(DISTINCT tx_id) as trans
    from solana.core.fact_transactions
    where block_timestamp::date >= '2022-07-01' and SUCCEEDED = 'TRUE'
    group by status , day
    UNION
    select 'Other Transactions' as status , block_timestamp::date as day , count(DISTINCT tx_id) as trans
    from solana.core.fact_transactions
    where block_timestamp::date < '2022-07-01' and block_timestamp >= '2022-06-01' and SUCCEEDED = 'TRUE'
    group by status , day
    Run a query to Download Data