flipside

    Solana Total users in the last month
    khanhSolana Total users in the last month
    select 'Solana Success Txns' as type, count(distinct(tx_hash)) as tx_num from solana.core.fact_transactions
    where succeeded = true
    and block_timestamp::date >= current_date - interval '{{ months}} months'

    union

    select 'Solana Fail Txns' as type, count(distinct(tx_hash)) as tx_num from solana.core.fact_transactions
    where succeeded = false
    and block_timestamp::date >= current_date - interval '{{ months}} months'
    Run a query to Download Data