MONTH | ACQUIRED_USERS | |
|---|---|---|
1 | 2023-01-01 00:00:00.000 | 1223987 |
2 | 2023-02-01 00:00:00.000 | 948621 |
3 | 2023-03-01 00:00:00.000 | 1249943 |
4 | 2023-04-01 00:00:00.000 | 1258125 |
5 | 2023-05-01 00:00:00.000 | 1222843 |
6 | 2023-06-01 00:00:00.000 | 1520337 |
7 | 2023-07-01 00:00:00.000 | 1211968 |
8 | 2023-08-01 00:00:00.000 | 1261597 |
9 | 2023-09-01 00:00:00.000 | 1685532 |
10 | 2023-10-01 00:00:00.000 | 1225013 |
11 | 2023-11-01 00:00:00.000 | 1082472 |
12 | 2023-12-01 00:00:00.000 | 1518098 |
Flipside Community01.A) creation stats monthly - ETH
Updated 2025-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with acquired_transaction as
(
select
from_address,
(block_timestamp) as acquired_time
from ethereum.core.fact_transactions
where block_timestamp between '2023-01-01' and '2024-01-01'
and nonce=1
)
select date_trunc('month',acquired_time) as month, count(distinct from_address) as acquired_users
from acquired_transaction
group by month
order by month asc
Last run: 3 months ago
12
432B
35s