HOUR | NEW_CONTRACTS | |
|---|---|---|
1 | 2025-02-22 02:00:00.000 | 1222 |
2 | 2025-02-22 01:00:00.000 | 1450 |
3 | 2025-02-22 00:00:00.000 | 1478 |
4 | 2025-02-21 23:00:00.000 | 1627 |
5 | 2025-02-21 22:00:00.000 | 1718 |
6 | 2025-02-21 21:00:00.000 | 2920 |
7 | 2025-02-21 20:00:00.000 | 4645 |
8 | 2025-02-21 19:00:00.000 | 3041 |
9 | 2025-02-21 18:00:00.000 | 3445 |
10 | 2025-02-21 17:00:00.000 | 3684 |
11 | 2025-02-21 16:00:00.000 | 3663 |
12 | 2025-02-21 15:00:00.000 | 4623 |
13 | 2025-02-21 14:00:00.000 | 5013 |
14 | 2025-02-21 13:00:00.000 | 5401 |
15 | 2025-02-21 12:00:00.000 | 5344 |
16 | 2025-02-21 11:00:00.000 | 5309 |
17 | 2025-02-21 10:00:00.000 | 5386 |
18 | 2025-02-21 09:00:00.000 | 5010 |
19 | 2025-02-21 08:00:00.000 | 4834 |
20 | 2025-02-21 07:00:00.000 | 4275 |
datavortexactive contracts after launch
Updated 2025-02-22
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
›
⌄
⌄
WITH first_seen_contracts AS (
SELECT
contract_address,
MIN(block_timestamp) AS first_seen
FROM monad.testnet.fact_event_logs
WHERE contract_address IS NOT NULL
AND tx_succeeded = TRUE
GROUP BY contract_address
)
SELECT
DATE_TRUNC('hour', e.block_timestamp) AS hour,
COUNT(DISTINCT e.contract_address) AS new_contracts
FROM monad.testnet.fact_event_logs e
JOIN first_seen_contracts fsc
ON e.contract_address = fsc.contract_address
WHERE e.block_timestamp >= '2025-02-19'
AND fsc.first_seen >= '2025-02-19'
AND e.tx_succeeded = TRUE
GROUP BY 1
ORDER BY hour DESC;
/*
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour,
COUNT(DISTINCT contract_address) AS active_contracts
FROM
monad.testnet.fact_event_logs
WHERE
contract_address IS NOT NULL
Last run: 2 months ago
75
2KB
1s