Elprognerd6-daily New contracts
Updated 2023-01-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('day', dt) as date,
case when date <= '2023-01-01' then 'Before 2023' else '2023' END as "Time",
count(DISTINCT (cnt)) as counter,
sum(counter) over (order by date) as "Cumulative Number of Daily New Contracts"
from
(select
attributes:instantiate:_contract_address as cnt,
min(BLOCK_TIMESTAMP) as dt
from terra.core.ez_messages
where message_type like '/cosmwasm.wasm.v1.MsgInstantiateContract'
group by 1 )
where date >= CURRENT_DATE - INTERVAL '60 days'
group by 1
order by 1
Run a query to Download Data