TIMESPAN | CONTRACTS | CUMUL_CONTRACTS | CREATORS | CUMUL_CREATORS | |
|---|---|---|---|---|---|
1 | 2020-10-01 00:00:00.000 | 19 | 19 | 9 | 9 |
2 | 2020-11-01 00:00:00.000 | 63 | 82 | 11 | 20 |
3 | 2020-12-01 00:00:00.000 | 66 | 148 | 10 | 30 |
4 | 2021-01-01 00:00:00.000 | 23 | 171 | 10 | 40 |
5 | 2021-02-01 00:00:00.000 | 65 | 236 | 21 | 61 |
6 | 2021-03-01 00:00:00.000 | 36 | 272 | 10 | 71 |
7 | 2021-04-01 00:00:00.000 | 26 | 298 | 15 | 86 |
8 | 2021-05-01 00:00:00.000 | 67 | 365 | 42 | 128 |
9 | 2021-06-01 00:00:00.000 | 74 | 439 | 47 | 175 |
10 | 2021-07-01 00:00:00.000 | 78 | 517 | 44 | 219 |
11 | 2021-08-01 00:00:00.000 | 84 | 601 | 53 | 272 |
12 | 2021-09-01 00:00:00.000 | 113 | 714 | 82 | 354 |
13 | 2021-10-01 00:00:00.000 | 208 | 922 | 133 | 487 |
14 | 2021-11-01 00:00:00.000 | 275 | 1197 | 182 | 669 |
15 | 2021-12-01 00:00:00.000 | 330 | 1527 | 219 | 888 |
16 | 2022-01-01 00:00:00.000 | 351 | 1878 | 230 | 1118 |
17 | 2022-02-01 00:00:00.000 | 486 | 2364 | 301 | 1419 |
18 | 2022-03-01 00:00:00.000 | 519 | 2883 | 328 | 1747 |
19 | 2022-04-01 00:00:00.000 | 498 | 3381 | 295 | 2042 |
20 | 2022-05-01 00:00:00.000 | 479 | 3860 | 302 | 2344 |
zackmendelContract deployed on Solana copy
Updated 2025-04-15
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 first_tx AS (
SELECT
program_id,
MIN(block_timestamp) AS min_date
FROM solana.core.fact_events
GROUP BY 1
),
bpf_1 AS (
SELECT
MIN(block_timestamp) AS block_timestamp,
instruction:accounts[0]::string AS program,
signers[0] AS deployer
FROM solana.core.fact_events
WHERE program_id = 'BPFLoader1111111111111111111111111111111111'
AND block_timestamp::date >= '2020-10-15' AND block_timestamp::date <= '2024-11-11'
AND succeeded = TRUE
GROUP BY 2,3
),
bpf_2 AS (
SELECT
block_timestamp,
instruction:parsed:info:account::string AS program,
signers[0] AS deployer
FROM solana.core.fact_events
WHERE program_id = 'BPFLoader2111111111111111111111111111111111'
AND succeeded = TRUE
AND event_type = 'finalize' --'write'
),
bpf_3 AS (
SELECT
block_timestamp,
instruction:parsed:info:programDataAccount::string AS program,
signers[0] AS deployer
Last run: 3 months ago
55
2KB
39s