DAY | DAILY_NEW_ACCOUNTS | TOTAL_NEW_ACCOUNTS | ROLLING_AVG_NEW_ACCOUNTS | |
|---|---|---|---|---|
1 | 2025-05-05 00:00:00.000 | 56478 | 1796624 | 63908.5 |
2 | 2025-04-28 00:00:00.000 | 78489 | 1740146 | 60186.5 |
3 | 2025-04-21 00:00:00.000 | 72181 | 1661657 | 51021.5 |
4 | 2025-04-14 00:00:00.000 | 48486 | 1589476 | 47899.75 |
5 | 2025-04-07 00:00:00.000 | 41590 | 1540990 | 46921.5 |
6 | 2025-03-31 00:00:00.000 | 41829 | 1499400 | 154646.75 |
7 | 2025-03-24 00:00:00.000 | 59694 | 1457571 | 285175.25 |
8 | 2025-03-17 00:00:00.000 | 44573 | 1397877 | 305347.75 |
9 | 2025-03-10 00:00:00.000 | 472491 | 1353304 | 307249.75 |
10 | 2025-03-03 00:00:00.000 | 563943 | 880813 | 220203.25 |
11 | 2025-02-24 00:00:00.000 | 140384 | 316870 | 105623.333 |
12 | 2025-02-17 00:00:00.000 | 52181 | 176486 | 88243 |
13 | 2025-02-10 00:00:00.000 | 124305 | 124305 | 124305 |
Flow AmbassadorsCreated Accounts Over Time - Chart
Updated 2025-05-12
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: about 1 month ago
13
662B
38s