SandeshNew addresses ref finance
Updated 2022-11-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH active_addresses AS (
SELECT block_timestamp, TX_SIGNER as address
FROM near.core.fact_transactions
WHERE 1=1
and tx_receiver = ('v2.ref-finance.near')
AND tx_status = 'Success'
UNION ALL
SELECT block_timestamp, TX_RECEIVER as address
FROM near.core.fact_transactions
WHERE 1=1
and tx_receiver = ('v2.ref-finance.near')
AND tx_status = 'Success'
)
SELECT date, count (distinct address)
FROM (
SELECT min(block_timestamp::date) AS date, address
FROM active_addresses
GROUP BY address
)
WHERE date > CURRENT_DATE - interval ' 1 month'
GROUP BY date
ORDER BY date desc
Run a query to Download Data