NEW_CONTRACTS | TOTAL_INTERACTIONS | UNIQUE_CONTRACTS_INTERACTED | UNIQUE_USERS | |
|---|---|---|---|---|
1 | 6120067 | 312103373 | 1773537 | 7513363 |
bobby_danielSmart Contracts Interactions
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
22
23
24
25
26
27
›
⌄
WITH successful_contract_deployments AS (
SELECT
COUNT(DISTINCT tx_hash) as total_deployments,
COUNT(DISTINCT to_address) AS new_contracts
FROM monad.testnet.fact_traces
WHERE type = 'CREATE'
AND trace_succeeded = TRUE
AND block_timestamp >= '2025-02-19 15:00'
),
contract_interactions AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_interactions,
COUNT(DISTINCT contract_address) AS unique_contracts_interacted,
COUNT(DISTINCT origin_from_address) AS unique_users
FROM monad.testnet.fact_event_logs
WHERE block_timestamp >= '2025-02-19 15:00'
AND tx_succeeded = TRUE -- Only successful transactions
AND contract_address IS NOT NULL -- Looking at contract interactions
)
SELECT
d.new_contracts,
i.total_interactions,
i.unique_contracts_interacted,
i.unique_users
FROM successful_contract_deployments d
CROSS JOIN contract_interactions i;
Last run: 2 months ago
1
37B
47s