flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
New Address Activated, Yearly
0xaiman
New Address Activated, Yearly
Updated 2024-02-15
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
*
,
SUM
(
n_address
)
OVER
(
ORDER
BY
year
ROWS
BETWEEN
UNBOUNDED
PRECEDING
AND
CURRENT
ROW
)
as
cumulative_count
from
(
SELECT
TO_VARCHAR
(
DATE_TRUNC
(
'YEAR'
,
first_tx_date
)
,
'YYYY'
)
AS
year
,
COUNT
(
DISTINCT
signer
)
as
n_address
FROM
solana
.
core
.
ez_signers
GROUP
BY
1
ORDER
BY
1
)
Results
Last run: about 1 year ago
YEAR
N_ADDRESS
CUMULATIVE_COUNT
1
2020
7147679
7147679
2
2021
215437232
222584911
3
2022
308850245
531435156
4
2023
89883633
621318789
5
2024
32929502
654248291
1
5
140B
61s