DAY | UNIQUE_DEPLOYERS | |
|---|---|---|
1 | 2025-03-29 00:00:00.000 | 15 |
2 | 2025-03-30 00:00:00.000 | 62 |
3 | 2025-03-31 00:00:00.000 | 112 |
4 | 2025-04-01 00:00:00.000 | 159 |
5 | 2025-04-02 00:00:00.000 | 146 |
6 | 2025-04-03 00:00:00.000 | 61 |
7 | 2025-04-04 00:00:00.000 | 4 |
8 | 2025-04-05 00:00:00.000 | 1 |
9 | 2025-04-06 00:00:00.000 | 4 |
10 | 2025-04-07 00:00:00.000 | 7 |
11 | 2025-04-08 00:00:00.000 | 22 |
12 | 2025-04-09 00:00:00.000 | 22 |
13 | 2025-04-10 00:00:00.000 | 28 |
cryptodatadiveUnique Deployers Over Time
Updated 2025-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH contracts AS (
SELECT
CREATED_BLOCK_TIMESTAMP,
ADDRESS AS CONTRACT_ADDRESS,
CREATOR_ADDRESS
FROM mezo.testnet.dim_contracts
)
SELECT
DATE_TRUNC('day', CREATED_BLOCK_TIMESTAMP) AS DAY,
COUNT(DISTINCT CREATOR_ADDRESS) AS UNIQUE_DEPLOYERS
FROM contracts
GROUP BY 1
ORDER BY 1;
Last run: about 1 month ago
13
403B
1s