hessTotal Users AURORA Vs. Near
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select 'Near' as chain, count(DISTINCT(signer_id)) as users, count(DISTINCT(tx_hash)) as total_tx
from near.core.fact_actions_events_function_call a join near.core.dim_address_labels b on a.receiver_id = b.address
where block_timestamp::date >= '{{Start_Date}}' and block_timestamp::date <= '{{End_Date}}'
group by 1
UNION
select 'Aurora' as chain, count(DISTINCT(from_address)) as users, count(DISTINCT(tx_hash)) as total_tx
from aurora.core.fact_transactions
where block_timestamp::date >= '{{Start_Date}}' and block_timestamp::date <= '{{End_Date}}'
group by 1
Run a query to Download Data