feyikemiNEAR Addresses
Updated 2024-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH transactions AS (
SELECT
block_timestamp,
tx_signer AS address
FROM near.core.fact_transactions
WHERE TX_SUCCEEDED = TRUE
UNION
SELECT
block_timestamp,
tx_receiver AS address
FROM near.core.fact_transactions
WHERE TX_SUCCEEDED = TRUE
),
new_addresses AS (
SELECT
MIN(block_timestamp) AS first_tx_time,
address
FROM transactions
GROUP BY address
HAVING MIN(block_timestamp) >= '2024-01-01'
),
existing_addresses AS (
SELECT
address,
block_timestamp
FROM transactions
WHERE address NOT IN (SELECT address FROM new_addresses)
AND block_timestamp::date >= '2024-01-01'
)
SELECT
DATE_TRUNC('day', first_tx_time) AS date,
QueryRunArchived: QueryRun has been archived