LTirrell2022-02-04_solana_fees_per_tx_unused
    Updated 2022-02-08
    select
    date_trunc('day', block_timestamp) as datetime,
    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,
    tx_fees / tx_count as fees_per_tx,
    sum(
    case
    when succeeded = 'TRUE' then fee
    else NULL
    end
    ) / pow(10, 9) as fees_per_success
    from
    solana.transactions
    where
    datetime >= '2022-01-01'
    group by
    datetime
    Run a query to Download Data