NEW_CONTRACTS | CA_CREATION_TXN | CA_CREATORS | |
|---|---|---|---|
1 | 177284 | 176072 | 64863 |
m3jiytterbic-pink copy
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from ytterbic-pink @ https://flipsidecrypto.xyz/studio/queries/14f7b56a-12b5-4344-b30a-5b0515915895
SELECT
-- l.LABEL_TYPE,
COUNT(*) AS new_contracts,
COUNT(DISTINCT c.CREATED_TX_HASH) AS ca_creation_txn,
COUNT(DISTINCT c.CREATOR_ADDRESS) AS ca_creators
FROM ink.core.dim_contracts c
LEFT JOIN ink.core.dim_labels l
ON c.ADDRESS = l.ADDRESS
WHERE c.CREATED_BLOCK_TIMESTAMP::DATE >= '2024-12-09'
;
Last run: 8 days ago
1
23B
2s