DATE | Total Contracts Deployed | Cumulative Deployed Contracts | |
|---|---|---|---|
1 | 2024-11-28 00:00:00.000 | 314 | 314 |
2 | 2024-12-02 00:00:00.000 | 111 | 425 |
3 | 2024-12-03 00:00:00.000 | 156 | 581 |
4 | 2024-12-04 00:00:00.000 | 41 | 622 |
5 | 2024-12-05 00:00:00.000 | 7 | 629 |
6 | 2024-12-06 00:00:00.000 | 78 | 707 |
7 | 2024-12-07 00:00:00.000 | 1 | 708 |
8 | 2024-12-08 00:00:00.000 | 44 | 752 |
9 | 2024-12-09 00:00:00.000 | 169 | 921 |
10 | 2024-12-10 00:00:00.000 | 96 | 1017 |
11 | 2024-12-11 00:00:00.000 | 88 | 1105 |
12 | 2024-12-12 00:00:00.000 | 21 | 1126 |
13 | 2024-12-13 00:00:00.000 | 23 | 1149 |
14 | 2024-12-16 00:00:00.000 | 34 | 1183 |
15 | 2024-12-17 00:00:00.000 | 81 | 1264 |
16 | 2024-12-18 00:00:00.000 | 74 | 1338 |
17 | 2024-12-19 00:00:00.000 | 72 | 1410 |
18 | 2024-12-20 00:00:00.000 | 84 | 1494 |
19 | 2024-12-21 00:00:00.000 | 46 | 1540 |
20 | 2024-12-22 00:00:00.000 | 24 | 1564 |
Mrftiinquisitive-crimson copy copy
Updated 4 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from inquisitive-crimson copy @ https://flipsidecrypto.xyz/studio/queries/17c9418f-71ab-4cd7-af43-5e8e5d57f5f4
WITH tbl AS (
SELECT
CREATED_BLOCK_TIMESTAMP,
creator_address AS "Address",
COUNT(*) as "Total Contracts deployed"
FROM swell.core.dim_contracts
GROUP BY 1,2
)
SELECT
date_trunc (day, CREATED_BLOCK_TIMESTAMP) as date,
sum ("Total Contracts deployed") as "Total Contracts Deployed",
sum ("Total Contracts Deployed") over (order by date) as "Cumulative Deployed Contracts"
from tbl
group by 1
order by 1
Last run: about 4 hours agoAuto-refreshes every 12 hours
...
105
4KB
2s