MONTH | DEPLOYER | PROGRAMS | |
|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | 532 | 1145 |
2 | 2021-11-01 00:00:00.000 | 243 | 266 |
3 | 2024-11-01 00:00:00.000 | 816 | 1455 |
4 | 2021-12-01 00:00:00.000 | 292 | 324 |
5 | 2024-09-01 00:00:00.000 | 574 | 969 |
6 | 2023-04-01 00:00:00.000 | 284 | 279 |
7 | 2025-02-01 00:00:00.000 | 935 | 2014 |
8 | 2023-06-01 00:00:00.000 | 244 | 514 |
9 | 2023-08-01 00:00:00.000 | 246 | 342 |
10 | 2023-03-01 00:00:00.000 | 307 | 486 |
11 | 2021-02-01 00:00:00.000 | 13 | 18 |
12 | 2022-09-01 00:00:00.000 | 420 | 405 |
13 | 2023-05-01 00:00:00.000 | 304 | 311 |
14 | 2021-06-01 00:00:00.000 | 54 | 71 |
15 | 2023-11-01 00:00:00.000 | 226 | 190 |
16 | 2023-02-01 00:00:00.000 | 305 | 317 |
17 | 2021-01-01 00:00:00.000 | 5 | 8 |
18 | 2023-01-01 00:00:00.000 | 326 | 400 |
19 | 2021-04-01 00:00:00.000 | 14 | 19 |
20 | 2022-10-01 00:00:00.000 | 443 | 475 |
andurilSolana Monthly Deployers
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('month', block_timestamp) as month,
count(distinct signers[0]) as deployer,
count(distinct signers[1]) as programs
FROM solana.core.fact_events e
WHERE e.block_timestamp >= '2020-01-01'
AND e.program_id = 'BPFLoaderUpgradeab1e11111111111111111111111'
AND e.EVENT_TYPE IN ('deployWithMaxDataLen','upgrade')
and succeeded
and month < DATE_TRUNC('month', CURRENT_DATE)
group by 1
Last run: 2 months ago
50
2KB
10s