dariustay_0512Daily unique contracts deployed
Updated 2023-04-13
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
›
⌄
WITH contracts AS (
SELECT
address,
address_name,
label_type,
label_subtype,
project_name
FROM avalanche.core.dim_labels
WHERE label_subtype LIKE '%contract' -- filter for general_contract, token_contract and swap_contract
),
tx_daily AS (
SELECT
date(block_timestamp) AS date,
contract_address AS contract
FROM avalanche.core.fact_event_logs
WHERE tx_status = 'SUCCESS'
)
SELECT
t.date AS "Date",
COUNT(DISTINCT t.contract) AS "Contracts"
FROM tx_daily t
JOIN contracts c ON t.contract = c.address
GROUP BY 1
ORDER by 1
Run a query to Download Data