LTirrell2022-02-04_solana_tx
    Updated 2022-02-08
    select
    date_trunc('day', 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,
    sum(
    case
    when fee != 5000 then 1
    else NULL
    end
    ) as higher_fee_tx,
    count(distinct program_id) as programs
    from
    solana.transactions
    where
    datetime >= '2022-01-01'
    group by
    datetime
    Run a query to Download Data