AVG_DAILY_USERS_2024 | |
|---|---|
1 | 1207558.149123 |
feyikemiNear Avg Users
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH August_Daily AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,
COUNT(DISTINCT TX_SIGNER) AS Daily_users_2024
FROM near.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE >= '2024-01-01'
AND TX_SUCCEEDED = 'true'
GROUP BY Date
)
SELECT
AVG(Daily_users_2024) AS Avg_Daily_Users_2024
FROM August_Daily
Last run: 2 months ago
1
18B
165s