ramishoowUntitled Query
Updated 2023-01-05
9
1
2
3
4
›
⌄
with ramishoow as ( select distinct message_value:contract as "Contract Address", min(block_timestamp) as "debut" from terra.core.ez_messages
where message_type like '%Contract%' group by 1) SELECT trunc("debut",'week') as "time", count (distinct "Contract Address") as "New Contract",
--where message_type like '%Contract%' group by 1) SELECT trunc("debut",'week') as "time", count (distinct "Contract Address") as "New Contract",
sum("New Contract") over (order by "time") as "Cumulative New Contracts" from ramishoow group by 1 order by 1 asc
Run a query to Download Data