LTirrellwita_2
    Updated 2023-05-04
    select
    date_trunc('hour', block_timestamp) as datetime,
    succeeded,
    count(DISTINCT tx_id) as tx_count
    from
    solana.core.fact_events
    where
    program_id = 'DpqbTera2sSAjwjJewqrXof5hzUzMdKUd4hsUvgxEMm8'
    and block_timestamp::date >= '2023-04-21'
    group by
    datetime,
    succeeded
    Run a query to Download Data