CUBE3number of deployed contracts per day
Updated 2025-03-27
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
35
36
›
⌄
SELECT
base_q.day as day,
base_q.count as base_count,
optimism_q.count as optimism_count,
ethereum_q.count as ethereum_count,
bsc_q.count as bsc_count,
polygon_q.count as polygon_count,
avalanche_q.count as avalanche_count,
arbitrum_q.count as arbitrum_count
FROM (
SELECT date(CREATED_BLOCK_TIMESTAMP) as day, COUNT(*) AS count
FROM base.core.dim_contracts
WHERE CREATED_BLOCK_TIMESTAMP BETWEEN '2025-01-01' AND '2025-03-26'
GROUP BY day
ORDER BY day
) as base_q,
(
SELECT date(CREATED_BLOCK_TIMESTAMP) as day, COUNT(*) AS count
FROM optimism.core.dim_contracts
WHERE CREATED_BLOCK_TIMESTAMP BETWEEN '2025-01-01' AND '2025-03-26'
GROUP BY day
ORDER BY day
) as optimism_q,
(
SELECT date(CREATED_BLOCK_TIMESTAMP) as day, COUNT(*) AS count
FROM ethereum.core.dim_contracts
WHERE CREATED_BLOCK_TIMESTAMP BETWEEN '2025-01-01' AND '2025-03-26'
GROUP BY day
ORDER BY day
) as ethereum_q,
(
SELECT date(CREATED_BLOCK_TIMESTAMP) as day, COUNT(*) AS count
FROM bsc.core.dim_contracts
WHERE CREATED_BLOCK_TIMESTAMP BETWEEN '2025-01-01' AND '2025-03-26'
GROUP BY day
ORDER BY day
QueryRunArchived: QueryRun has been archived