pedramyzNEAR Horizon 4
    Updated 2023-05-22
    with table1 as (
    select
    distinct signer_id
    from near.core.fact_actions_events_function_call
    where receiver_id like 'nearhorizon.near'
    )

    select
    label_type,
    count(distinct tx_signer) as users,
    count(distinct tx_hash) as transactions,
    sum(transaction_fee / power(10, 24)) as gas_usd,
    count(distinct tx_hash) / count(distinct tx_signer) as "Average Transactions Per User"
    from near.core.fact_transactions
    left outer join near.core.dim_address_labels
    on tx_receiver = address
    where tx_status like 'Success'
    and not blockchain is NULL
    and tx_signer in (select * from table1)
    group by 1
    Run a query to Download Data