LTirrellsolana_wallets_per_month_tx_fees
    Updated 2022-07-14

    --sql @name: all_tps_info@
    with consumption_tx as (
    select
    t.block_timestamp,
    t.tx_id,
    t.fee,
    t.succeeded,
    sum(
    split(
    regexp_substr(s.value, '[0-9]* of [0-9]*'),
    ' of '
    ) [0] :: int
    ) as compute_units_used,
    avg(
    split(
    regexp_substr(s.value, '[0-9]* of [0-9]*'),
    ' of '
    ) [1] :: int
    ) as avg_compute_units_requested,
    avg(
    split(
    regexp_substr(s.value, '[0-9]* of [0-9]*'),
    ' of '
    ) [0] :: int / split(
    regexp_substr(s.value, '[0-9]* of [0-9]*'),
    ' of '
    ) [1] :: int
    ) as avg_compute_units_proportion
    from
    solana.core.fact_transactions t,
    lateral flatten(input => t.log_messages) s
    where
    block_timestamp :: date = '2022-01-06'
    and s.value like '% consumed %'
    group by
    Run a query to Download Data