Moeflow_cont tot 0
Updated 2023-03-25
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
›
⌄
with raw as (select
EVENT_CONTRACT ,
min (block_timestamp)::date as first_use
from
flow.core.fact_events
group by 1)
SELECT
date_trunc('week', first_use)::date as week,
count(distinct EVENT_CONTRACT) new_contracts,
sum(new_contracts)over(order by week) as cum_deployment
from
raw
group by
1
Run a query to Download Data