jackguyAurora Contract Users 6
Updated 2023-04-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with a_users as (
SELECT
DISTINCT TX_SIGNER
FROM near.core.fact_transactions
WHERE tx_receiver LIKE 'aurora'
)
SELECT
median(active_weeks),
median(transactions)
FROM (
SELECT
tx_signer,
count(DISTINCT tx_hash) as transactions,
count(DISTINCT date_trunc('month', block_timestamp)) as active_weeks
FROM near.core.fact_transactions
WHERE tx_signer in (SELECT * from a_users)
GROUP BY 1
)
--GROUP BY 1
Run a query to Download Data