DAY | CONTRACTS | PERIOD | |
|---|---|---|---|
1 | 2021-02-01 00:00:00.000 | 71 | Pre-upgrade |
2 | 2021-02-08 00:00:00.000 | 99 | Pre-upgrade |
3 | 2021-02-15 00:00:00.000 | 32 | Pre-upgrade |
4 | 2021-02-22 00:00:00.000 | 43 | Pre-upgrade |
5 | 2021-03-01 00:00:00.000 | 68 | Pre-upgrade |
6 | 2021-03-08 00:00:00.000 | 59 | Pre-upgrade |
7 | 2021-03-15 00:00:00.000 | 157 | Pre-upgrade |
8 | 2021-03-22 00:00:00.000 | 126 | Pre-upgrade |
9 | 2021-03-29 00:00:00.000 | 177 | Pre-upgrade |
10 | 2021-04-05 00:00:00.000 | 163 | Pre-upgrade |
11 | 2021-04-12 00:00:00.000 | 235 | Pre-upgrade |
12 | 2021-04-19 00:00:00.000 | 169 | Pre-upgrade |
13 | 2021-04-26 00:00:00.000 | 188 | Pre-upgrade |
14 | 2021-05-03 00:00:00.000 | 194 | Pre-upgrade |
15 | 2021-05-10 00:00:00.000 | 453 | Pre-upgrade |
16 | 2021-05-17 00:00:00.000 | 395 | Pre-upgrade |
17 | 2021-05-24 00:00:00.000 | 262 | Pre-upgrade |
18 | 2021-05-31 00:00:00.000 | 319 | Pre-upgrade |
19 | 2021-06-07 00:00:00.000 | 143 | Pre-upgrade |
20 | 2021-06-14 00:00:00.000 | 721 | Pre-upgrade |
yasminDEPLOY CONTRACT 4
Updated 2025-03-11
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
›
⌄
WITH deploy AS (
SELECT
DATE_TRUNC('week', created_block_timestamp) AS day,
COUNT(DISTINCT address) AS Contracts
FROM
avalanche.core.dim_contracts
WHERE
created_block_timestamp >= '2021-02-01'
GROUP BY
1
)
SELECT
day,
Contracts,
CASE
WHEN day < '2024-12-16' THEN 'Pre-upgrade'
ELSE 'Post-upgrade'
END AS period
FROM
deploy
ORDER BY
day ASC;
Last run: 18 days ago
...
215
10KB
4s