DATE | Total Contracts Deployed | Cumulative Deployed Contracts | |
|---|---|---|---|
1 | 2024-06-07 00:00:00.000 | 217 | 217 |
2 | 2024-06-08 00:00:00.000 | 3332 | 3549 |
3 | 2024-06-09 00:00:00.000 | 35 | 3584 |
4 | 2024-06-10 00:00:00.000 | 521 | 4105 |
5 | 2024-06-11 00:00:00.000 | 381 | 4486 |
6 | 2024-06-12 00:00:00.000 | 412 | 4898 |
7 | 2024-06-13 00:00:00.000 | 453 | 5351 |
8 | 2024-06-14 00:00:00.000 | 1467 | 6818 |
9 | 2024-06-15 00:00:00.000 | 1443 | 8261 |
10 | 2024-06-16 00:00:00.000 | 1957 | 10218 |
11 | 2024-06-17 00:00:00.000 | 3875 | 14093 |
12 | 2024-06-18 00:00:00.000 | 5663 | 19756 |
13 | 2024-06-19 00:00:00.000 | 1069 | 20825 |
14 | 2024-06-20 00:00:00.000 | 1137 | 21962 |
15 | 2024-06-21 00:00:00.000 | 1561 | 23523 |
16 | 2024-06-22 00:00:00.000 | 1947 | 25470 |
17 | 2024-06-23 00:00:00.000 | 1815 | 27285 |
18 | 2024-06-24 00:00:00.000 | 2256 | 29541 |
19 | 2024-06-25 00:00:00.000 | 2764 | 32305 |
20 | 2024-06-26 00:00:00.000 | 2606 | 34911 |
Mrftiinquisitive-crimson copy
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from inquisitive-crimson @ https://flipsidecrypto.xyz/studio/queries/a0241ef3-6933-4870-a674-dc824315d75b
WITH tbl AS (
SELECT
CREATED_BLOCK_TIMESTAMP,
creator_address AS "Address",
COUNT(*) as "Total Contracts deployed"
FROM berachain.testnet.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 2 months agoAuto-refreshes every 12 hours
...
247
10KB
1s