Total Addresses in Top 1% | Minimum Contracts Deployed for Top 1% | |
|---|---|---|
1 | 11655 | 37 |
Mrfticontracts
Updated 5 hours ago
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
›
⌄
-- forked from estimated-tomato copy @ https://flipsidecrypto.xyz/studio/queries/83cb642d-b9ef-4e00-b649-19477199b519
with contracts as (
SELECT
creator_address as "Address",
COUNT(*) as "Total Contracts Deployed",
RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
FROM monad.testnet.dim_contracts
GROUP BY 1
),
ranked_addresses AS (
SELECT
"Address",
"Total Contracts Deployed",
NTILE(100) OVER (ORDER BY "Total Contracts Deployed" DESC) AS percentile
FROM
contracts
),
top_1_percent AS (
SELECT
"Address",
"Total Contracts Deployed"
FROM
ranked_addresses
WHERE
percentile = 1 -- Top 1% by "Total Contracts Deployed"
)
SELECT
COUNT(DISTINCT "Address") AS "Total Addresses in Top 1%",
MIN("Total Contracts Deployed") AS "Minimum Contracts Deployed for Top 1%"
FROM
top_1_percent
Last run: about 5 hours agoAuto-refreshes every 12 hours
1
12B
28s