Unique contract deployer | Contract deployed | |
|---|---|---|
1 | 635 | 5391 |
Mrftiinquisitive-crimson copy
Updated 5 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from inquisitive-crimson @ https://flipsidecrypto.xyz/studio/queries/a0241ef3-6933-4870-a674-dc824315d75b
with tbl AS
(
SELECT
creator_address AS "Address",
COUNT(*) as "Contract deployed",
RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
FROM swell.core.dim_contracts
GROUP BY 1
)
SELECT
count (DISTINCT "Address") as "Unique contract deployer",
sum ("Contract deployed") as "Contract deployed"
from tbl
Last run: about 5 hours agoAuto-refreshes every 12 hours
1
12B
2s