DATE | MONTH | ACTIVE_ADDRESSES | DAY | |
|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | March | 3188411 | 1 |
2 | 2025-03-02 00:00:00.000 | March | 3165925 | 2 |
3 | 2025-03-03 00:00:00.000 | March | 3049975 | 3 |
4 | 2025-03-04 00:00:00.000 | March | 3291589 | 4 |
5 | 2025-03-05 00:00:00.000 | March | 3393798 | 5 |
6 | 2025-03-06 00:00:00.000 | March | 3470734 | 6 |
7 | 2025-03-07 00:00:00.000 | March | 2948773 | 7 |
8 | 2025-03-08 00:00:00.000 | March | 3393189 | 8 |
9 | 2025-03-09 00:00:00.000 | March | 3525239 | 9 |
10 | 2025-03-10 00:00:00.000 | March | 3426057 | 10 |
11 | 2025-03-11 00:00:00.000 | March | 3636499 | 11 |
12 | 2025-03-12 00:00:00.000 | March | 3620983 | 12 |
13 | 2025-03-13 00:00:00.000 | March | 3505277 | 13 |
14 | 2025-03-14 00:00:00.000 | March | 3685441 | 14 |
15 | 2025-03-15 00:00:00.000 | March | 2262151 | 15 |
16 | 2025-03-16 00:00:00.000 | March | 2028756 | 16 |
17 | 2025-03-17 00:00:00.000 | March | 2682207 | 17 |
18 | 2025-03-18 00:00:00.000 | March | 3139575 | 18 |
19 | 2025-03-19 00:00:00.000 | March | 3163566 | 19 |
20 | 2025-03-20 00:00:00.000 | March | 3337995 | 20 |
MasiDaily Addresses Jan
Updated 2025-04-01
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 tb0_0 AS (
SELECT
block_timestamp,
BLOCK_ID,
tx_hash,
ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)::string as receiver,
ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)::string AS user
FROM near.core.fact_transactions
where block_timestamp::Date >= '2025-02-01' and block_timestamp < '2025-04-01'
UNION
SELECT
block_timestamp,
BLOCK_ID,
tx_hash,
to_address::string as receiver,
from_address::string AS user
FROM near.core.ez_token_transfers
where block_timestamp::Date >= '2025-02-01' and block_timestamp < '2025-04-01'
UNION
SELECT
block_timestamp,
BLOCK_ID,
tx_hash,
receiver_id::string as receiver,
SIGNER_ID::string AS user
FROM near.core.fact_actions_events_function_call
where block_timestamp::Date >= '2025-02-01' and block_timestamp < '2025-04-01'
UNION
SELECT
block_timestamp,
BLOCK_ID,
Last run: 11 days ago
59
3KB
452s