flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
No. of Deployed Contracts and Contract Creators
defi__josh
No. of Deployed Contracts and Contract Creators
Updated 6 days ago
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
count
(
distinct
address
)
as
"No. of deployed contracts"
,
count
(
distinct
creator_address
)
as
"No. of contract creators"
FROM
mezo
.
testnet
.
dim_contracts
WHERE
created_block_timestamp
>=
(
SELECT
MIN
(
block_timestamp
)
FROM
mezo
.
testnet
.
fact_transactions
)
Results
Last run: 6 days ago
No. of deployed contracts
No. of contract creators
1
59208
3186
1
1
14B
438s