NEW_ADDRESS | |
|---|---|
1 | 9474 |
SocioCryptonew users
Updated 2024-02-06
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
COUNT (DISTINCT from_address) as new_address
FROM
(
SELECT from_address,
min(block_timestamp) as f_txn
FROM avalanche.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP by from_address
)
WHERE date_trunc('day', f_txn) = current_date-1
Last run: over 1 year agoAuto-refreshes every 24 hours
1
8B
163s