flipside

    Untitled Query
    campUntitled Query
    Updated 2022-07-13
    select date_trunc('month',block_timestamp) as Month,
    COUNT(distinct tx_id) AS num_transactions
    from solana.core.fact_transactions
    where block_timestamp::date >= '2022-06-01' and block_timestamp::date <= '2022-06-30' and succeeded = '1'
    group by 1
    Run a query to Download Data