DAY | DAILY_CONTRACT_DEPLOYS | CUMULATIVE_CONTRACT_DEPLOYS | |
|---|---|---|---|
1 | 2025-03-02 00:00:00.000 | 1 | 1739 |
2 | 2025-02-28 00:00:00.000 | 1 | 1738 |
3 | 2025-02-27 00:00:00.000 | 1 | 1737 |
4 | 2025-02-26 00:00:00.000 | 4 | 1736 |
5 | 2025-02-25 00:00:00.000 | 1 | 1732 |
6 | 2025-02-22 00:00:00.000 | 2 | 1731 |
7 | 2025-02-20 00:00:00.000 | 3 | 1729 |
8 | 2025-02-19 00:00:00.000 | 1 | 1726 |
9 | 2025-02-18 00:00:00.000 | 48 | 1725 |
10 | 2025-02-17 00:00:00.000 | 3 | 1677 |
11 | 2025-02-16 00:00:00.000 | 6 | 1674 |
12 | 2025-02-14 00:00:00.000 | 3 | 1668 |
13 | 2025-02-13 00:00:00.000 | 2 | 1665 |
14 | 2025-02-12 00:00:00.000 | 12 | 1663 |
15 | 2025-02-11 00:00:00.000 | 35 | 1651 |
16 | 2025-02-10 00:00:00.000 | 6 | 1616 |
17 | 2025-02-07 00:00:00.000 | 5 | 1610 |
18 | 2025-02-06 00:00:00.000 | 6 | 1605 |
19 | 2025-02-05 00:00:00.000 | 17 | 1599 |
20 | 2025-02-04 00:00:00.000 | 2 | 1582 |
picasoDaily Contract Deployments 1
Updated 2025-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH daily_contracts AS (
SELECT
DATE_TRUNC('day', a.BLOCK_TIMESTAMP) AS day,
COUNT(DISTINCT a.TO_ADDRESS) AS daily_contract_deploys
FROM boba.core.fact_traces a
WHERE
a.BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)
AND a.type LIKE '%CREATE%'
AND a.to_address IS NOT NULL
AND a.input IS NOT NULL
AND a.input != '0x'
GROUP BY 1
)
SELECT
day,
daily_contract_deploys,
SUM(daily_contract_deploys) OVER (ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
AS cumulative_contract_deploys
FROM daily_contracts
ORDER BY day DESC;
Last run: 18 days ago
...
171
6KB
6s