DAY | LABEL_TYPE | NEW_CONTRACTS | CA_CREATION_TXN | CA_CREATORS | |
|---|---|---|---|---|---|
1 | 2025-01-21 00:00:00.000 | dex | 2 | 2 | 1 |
2 | 2025-01-20 00:00:00.000 | dex | 2 | 2 | 2 |
3 | 2025-01-19 00:00:00.000 | dex | 8 | 8 | 4 |
4 | 2025-01-18 00:00:00.000 | dex | 12 | 12 | 2 |
5 | 2025-01-17 00:00:00.000 | dex | 13 | 13 | 4 |
6 | 2025-01-16 00:00:00.000 | dex | 10 | 10 | 4 |
7 | 2025-01-15 00:00:00.000 | dex | 11 | 11 | 2 |
8 | 2025-01-15 00:00:00.000 | token | 43 | 43 | 20 |
9 | 2025-01-14 00:00:00.000 | dex | 4 | 4 | 2 |
10 | 2025-01-14 00:00:00.000 | token | 92 | 92 | 59 |
11 | 2025-01-13 00:00:00.000 | dex | 4 | 4 | 1 |
12 | 2025-01-13 00:00:00.000 | token | 55 | 55 | 12 |
13 | 2025-01-12 00:00:00.000 | dex | 7 | 7 | 2 |
14 | 2025-01-12 00:00:00.000 | token | 101 | 101 | 66 |
15 | 2025-01-11 00:00:00.000 | dex | 6 | 6 | 1 |
16 | 2025-01-11 00:00:00.000 | token | 205 | 205 | 124 |
17 | 2025-01-10 00:00:00.000 | dex | 5 | 5 | 2 |
18 | 2025-01-10 00:00:00.000 | token | 133 | 133 | 95 |
19 | 2025-01-09 00:00:00.000 | dex | 4 | 4 | 2 |
20 | 2025-01-09 00:00:00.000 | token | 133 | 133 | 87 |
m3jiytterbic-pink
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', c.CREATED_BLOCK_TIMESTAMP) AS day,
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'
AND l.LABEL_TYPE != 'nft'
GROUP BY 1, 2
ORDER BY 1 DESC, 2;
Last run: 6 days ago
63
3KB
2s