CONTRACT_TYPE | TOTAL_CONTRACTS | UNIQUE_CREATORS | AVG_CONTRACTS_PER_CREATOR | |
---|---|---|---|---|
1 | OTHER | 6827463 | 1203543 | 5.67 |
bobby_danielContract Types and Creators
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
›
⌄
WITH contract_info AS (
SELECT
CASE
WHEN LOWER(name) LIKE '%erc20%' OR decimals IS NOT NULL THEN 'TOKEN'
WHEN LOWER(name) LIKE '%nft%' OR LOWER(name) LIKE '%erc721%' THEN 'NFT'
WHEN LOWER(name) LIKE '%swap%' OR LOWER(name) LIKE '%dex%' THEN 'DEX'
WHEN LOWER(name) LIKE '%bridge%' THEN 'BRIDGE'
WHEN LOWER(name) LIKE '%game%' OR LOWER(name) LIKE '%play%' THEN 'GAME'
WHEN LOWER(name) LIKE '%dao%' OR LOWER(name) LIKE '%gov%' THEN 'DAO'
WHEN LOWER(name) LIKE '%lend%' OR LOWER(name) LIKE '%borrow%' THEN 'LENDING'
ELSE 'OTHER'
END as contract_type,
address,
creator_address
FROM monad.testnet.dim_contracts
WHERE created_block_timestamp >= '2025-02-19 15:00'
)
SELECT
contract_type,
COUNT(DISTINCT address) AS total_contracts,
COUNT(DISTINCT creator_address) AS unique_creators,
ROUND(COUNT(DISTINCT address)::FLOAT / NULLIF(COUNT(DISTINCT creator_address), 0), 2) as avg_contracts_per_creator
FROM contract_info
GROUP BY 1
ORDER BY total_contracts DESC;
Last run: 2 months ago
1
32B
2s