TOTAL_USERS | CONTRACT_INTERACTING_USERS | CONTRACT_INTERACTION_RATE | |
|---|---|---|---|
1 | 35596303 | 8045640 | 0.2260245959 |
m3jiContract interaction analysis
Updated 2025-03-21
9
1
2
3
4
5
6
›
⌄
-- Contract interaction analysis
SELECT
COUNT(DISTINCT FROM_ADDRESS) as total_users,
COUNT(DISTINCT CASE WHEN INPUT_DATA != '0x' THEN FROM_ADDRESS END) as contract_interacting_users,
COUNT(DISTINCT CASE WHEN INPUT_DATA != '0x' THEN FROM_ADDRESS END) / COUNT(DISTINCT FROM_ADDRESS)::float as contract_interaction_rate
FROM monad.testnet.fact_transactions;
Last run: about 1 month ago
1
33B
38s