Date | Total Contracts Deployed | LAG_CONTRACTS_DEPLOYED | Total Contracts Deployed Change % | Total Unique Contract Deployers | LAG_DEPLOYERS | Total Unique Contract Deployers Change % | |
|---|---|---|---|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | 191366 | 1948352 | -90.18 | 66732 | 388435 | -82.82 |
2 | 2025-03-10 00:00:00.000 | 1948352 | 1448923 | 34.47 | 388435 | 416537 | -6.75 |
3 | 2025-03-03 00:00:00.000 | 1448923 | 2192141 | -33.9 | 416537 | 611461 | -31.88 |
4 | 2025-02-24 00:00:00.000 | 2192141 | 444929 | 392.69 | 611461 | 102981 | 493.76 |
5 | 2025-02-17 00:00:00.000 | 444929 | 102981 |
Mrftileft-tan copy
Updated 7 hours ago
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
›
⌄
-- forked from left-tan @ https://flipsidecrypto.xyz/studio/queries/6482e6cb-c72b-4878-9e75-0f895b898b17
WITH tbl AS (
SELECT
CREATED_BLOCK_TIMESTAMP,
creator_address AS "Address",
COUNT(*) as "Total Contracts deployed",
RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
FROM monad.testnet.dim_contracts
GROUP BY 1,2
)
SELECT
date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP) as "Date",
-- Total Contracts Deployed
SUM("Total Contracts deployed") as "Total Contracts Deployed",
LAG(SUM("Total Contracts deployed")) OVER (ORDER BY date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP)) as lag_contracts_deployed,
ROUND(100*(SUM("Total Contracts deployed") - LAG(SUM("Total Contracts deployed")) OVER (ORDER BY date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP))) / LAG(SUM("Total Contracts deployed")) OVER (ORDER BY date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP)), 2) as "Total Contracts Deployed Change %",
-- Total Unique Contract Deployers
COUNT(DISTINCT "Address") as "Total Unique Contract Deployers",
LAG(COUNT(DISTINCT "Address")) OVER (ORDER BY date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP)) as lag_deployers,
ROUND(100*(COUNT(DISTINCT "Address") - LAG(COUNT(DISTINCT "Address")) OVER (ORDER BY date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP))) / LAG(COUNT(DISTINCT "Address")) OVER (ORDER BY date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP)), 2) as "Total Unique Contract Deployers Change %"
FROM
tbl
WHERE
CREATED_BLOCK_TIMESTAMP::date >= '{{start_day}}'
AND date_trunc({{period_type}}, CREATED_BLOCK_TIMESTAMP) <= '{{target_day}}'
GROUP BY 1
ORDER BY 1 DESC;
Last run: about 7 hours agoAuto-refreshes every 12 hours
5
345B
74s