Alexaynew near users
Updated 2022-09-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with first_tx as ( select tx_signer, min(block_timestamp) as start_date
from near.core.fact_transactions
group by tx_signer ),
new_users as ( select tx_signer , start_date
from first_tx
where start_date >= CURRENT_DATE - 90)
select count(tx_signer)
from new_users
Run a query to Download Data