superflyUntitled Query
Updated 2023-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select date(date_trunc('quarter', block_timestamp)) as quarter,
count(address) as new_addresses
from (
select block_timestamp,
address,
row_number() over (partition by address order by block_timestamp) as rnk
from (
select block_timestamp,
TX_RECEIVER as address
from near.core.fact_transactions
union all
select block_timestamp,
tx_signer as address
from near.core.fact_transactions
)
)
where rnk = 1
group by 1
Run a query to Download Data