pedramyzNEAR Horizon 4
Updated 2023-05-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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