jkhuhnke11Total Contracts Deployed
Updated 2023-03-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH date_range AS(
SELECT
DISTINCT date_trunc('day', date)::date AS metric_date
FROM gold.near_daily_balances LIMIT 365)
SELECT metric_date,
sum(address) OVER (ORDER BY metric_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS metric_value
FROM
(
SELECT date_trunc('day', start_date) AS date,
count(distinct event_to) AS address
FROM
(SELECT event_to,
min(block_timestamp) AS start_date
FROM gold.near_events
WHERE event_type = 'DeployContract'
GROUP BY 1)si
GROUP BY 1)se
RIGHT OUTER JOIN date_range on
date = metric_date
ORDER BY 1 DESC
Run a query to Download Data