ADDRESS | DEPLOYMENT_TIME | LAST_INTERACTION_TIME | TOTAL_INTERACTIONS | LIFECYCLE_DAYS | |
|---|---|---|---|---|---|
1 | 0x8462c247356d7deb7e26160dbfab16b351eef242 | 2025-02-19 15:00:19.000 | 2025-03-19 10:35:52.000 | 93239670 | 28 |
2 | 0x760afe86e5de5fa0ee542fc7b7b713e1c5425701 | 2025-02-19 15:00:00.000 | 2025-03-19 10:35:52.000 | 53828806 | 28 |
3 | 0xf817257fed379853cde0fa4f97ab987181b1e5ea | 2025-02-19 15:00:02.000 | 2025-03-19 10:35:52.000 | 13562399 | 28 |
4 | 0xbce2c725304e09cef4cd7639760b67f8a0af5bc4 | 2025-03-10 06:54:52.000 | 2025-03-19 10:35:52.000 | 10504823 | 9 |
5 | 0xd227d3bce59b91380b7bc4a61a045b528b509439 | 2025-02-19 15:07:48.000 | 2025-03-19 10:35:52.000 | 8666478 | 28 |
6 | 0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0 | 2025-02-19 15:00:02.000 | 2025-03-19 10:35:52.000 | 8562344 | 28 |
7 | 0xaeef2f6b429cb59c9b2d7bb2141ada993e8571c3 | 2025-02-19 15:23:52.000 | 2025-03-19 10:35:52.000 | 8281232 | 28 |
8 | 0xb2f82d0f38dc453d596ad40a37799446cc89274a | 2025-02-19 15:00:26.000 | 2025-03-19 10:35:52.000 | 8217823 | 28 |
9 | 0x2c9c959516e9aaedb2c748224a41249202ca8be7 | 2025-02-19 15:23:52.000 | 2025-03-19 10:35:52.000 | 8044055 | 28 |
10 | 0x0f0bdebf0f83cd1ee3974779bcb7315f9808c714 | 2025-02-19 15:00:00.000 | 2025-03-19 10:35:52.000 | 7887179 | 28 |
bobby_danielTop 10 Contracts Interacted With
Updated 2025-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH contract_lifecycle AS (
SELECT
c.address,
MIN(e.block_timestamp) AS deployment_time,
MAX(e.block_timestamp) AS last_interaction_time,
COUNT(DISTINCT e.tx_hash) AS total_interactions
FROM monad.testnet.dim_contracts c
JOIN monad.testnet.fact_event_logs e
ON c.address = e.contract_address
WHERE e.block_timestamp >= '2025-02-19 15:00'
GROUP BY 1
)
SELECT
address,
deployment_time,
last_interaction_time,
total_interactions,
DATEDIFF(day, deployment_time, last_interaction_time) AS lifecycle_days
FROM contract_lifecycle
ORDER BY total_interactions DESC
LIMIT 10
Last run: 2 months ago
10
1KB
40s