LTirrellsolana_tps
    Updated 2022-07-13
    with flattened_transactions as (
    select
    t.block_timestamp,
    t.tx_id,
    t.fee,
    t.succeeded,
    s.value as address
    from
    solana.core.fact_transactions t,
    lateral flatten(input => t.signers) s
    where
    t.block_timestamp :: date >= '2022-01-01'
    and succeeded = '{status}'
    )
    select
    t.address,
    t.succeeded,
    l.address_name,
    l.creator,
    l.label,
    l.label_subtype,
    l.label_type,
    sum(t.fee) as total_fee,
    avg(t.fee) as average_fee,
    count(distinct t.tx_id) as total_tx
    from
    flattened_transactions t
    inner join solana.core.dim_labels l using(address)
    group by
    datetime,
    t.address,
    t.succeeded,
    l.address_name,
    l.creator,
    l.label,
    l.label_subtype,
    Run a query to Download Data