hessAurora Vs. Near monthly
9
1
2
3
4
5
6
7
8
9
›
⌄
select trunc(block_timestamp,'month') as monthly,'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,2
UNION
select trunc(block_timestamp,'month') as monthly, '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,2
Run a query to Download Data