DAY | DAILY_NEW_ACCOUNTS | TOTAL_NEW_ACCOUNTS | ROLLING_AVG_NEW_ACCOUNTS | |
|---|---|---|---|---|
1 | 2025-04-07 00:00:00.000 | 39370 | 5363032 | 43702.75 |
2 | 2025-03-31 00:00:00.000 | 38949 | 5323662 | 150034 |
3 | 2025-03-24 00:00:00.000 | 55972 | 5284713 | 277322.5 |
4 | 2025-03-17 00:00:00.000 | 40520 | 5228741 | 279898.25 |
5 | 2025-03-10 00:00:00.000 | 464695 | 5188221 | 277402.75 |
6 | 2025-03-03 00:00:00.000 | 548103 | 4723526 | 360023.5 |
7 | 2025-02-24 00:00:00.000 | 66275 | 4175423 | 803675.5 |
8 | 2025-02-17 00:00:00.000 | 30538 | 4109148 | 915115.5 |
9 | 2025-02-10 00:00:00.000 | 795178 | 4078610 | 1005875 |
10 | 2025-02-03 00:00:00.000 | 2322711 | 3283432 | 820858 |
11 | 2025-01-27 00:00:00.000 | 512035 | 960721 | 320240.333 |
12 | 2025-01-20 00:00:00.000 | 393576 | 448686 | 224343 |
13 | 2025-01-13 00:00:00.000 | 55110 | 55110 | 55110 |
Flow AmbassadorsCreated Accounts Over Time - Chart
Updated 4 days ago
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 base_data AS (
SELECT
CASE '{{Period}}'
WHEN 'all_time' THEN DATE_TRUNC('month', block_timestamp)
WHEN 'last_year' THEN DATE_TRUNC('week', block_timestamp)
WHEN 'last_3_months' THEN DATE_TRUNC('week', block_timestamp)
WHEN 'last_month' THEN DATE_TRUNC('day', block_timestamp)
WHEN 'last_week' THEN DATE_TRUNC('day', block_timestamp)
WHEN 'last_24h' THEN DATE_TRUNC('hour', block_timestamp)
END as time_stamp,
actor_address
FROM (
-- Flow Core accounts
SELECT
b.block_timestamp,
CAST(a.value AS VARCHAR) as actor_address
FROM flow.core.ez_transaction_actors AS b,
LATERAL FLATTEN(INPUT => b.actors) AS a
WHERE b.block_timestamp >= CASE '{{Period}}'
WHEN 'all_time' THEN '2020-01-01'::DATE
WHEN 'last_year' THEN CURRENT_DATE - INTERVAL '1 YEAR'
WHEN 'last_3_months' THEN CURRENT_DATE - INTERVAL '3 MONTHS'
WHEN 'last_month' THEN CURRENT_DATE - INTERVAL '1 MONTH'
WHEN 'last_week' THEN CURRENT_DATE - INTERVAL '1 WEEK'
WHEN 'last_24h' THEN CURRENT_DATE - INTERVAL '1 DAY'
END
UNION ALL
-- EVM accounts
SELECT
block_timestamp,
from_address as actor_address
FROM flow.core_evm.fact_transactions
WHERE block_timestamp >= CASE '{{Period}}'
WHEN 'all_time' THEN '2020-01-01'::DATE
Last run: 4 days ago
13
661B
24s