jkhuhnke11Active Contracts
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT metric_date,
count(distinct event_to) as metric_value
FROM
(SELECT date_trunc('day', block_timestamp) AS metric_date,
event_to,
count(distinct event_from) AS event_from
FROM gold.near_events
WHERE event_to IN
(SELECT event_to
FROM gold.near_events
WHERE event_type = 'DeployContract')
AND metric_date >= getdate() - interval '6 months'
GROUP BY 1,2)se
WHERE event_from >= 2
GROUP BY 1
ORDER BY 1 DESC
Run a query to Download Data