LTirrell2022-02-04_solana_tx_hourly
    Updated 2022-02-08
    select
    date_trunc('hour', block_timestamp) as datetime,
    -- count(distinct tx_id) as tx_count,
    sum(1) as tx_count,
    count(
    case
    when succeeded = 'TRUE' then succeeded
    else NULL
    end
    ) as successes,
    -- successes / tx_count as success_rate,
    sum(fee) / pow(10, 9) as tx_fees,
    count(distinct program_id) as programs
    from
    solana.transactions
    where
    datetime >= '2022-01-01'
    group by
    datetime
    Run a query to Download Data