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", case when label_subtype is not null then label_subtype else 'Unlabeled Contracts' end as "Contract Subtype"
from terra.core.ez_messages left join terra.core.dim_address_labels on Address=message_value:contract where message_type like '%Contract%' group by 1,3) SELECT trunc("debut",'week') as "time", "Contract Subtype",
--from terra.core.ez_messages left join terra.core.dim_address_labels on Address=message_value:contract where message_type like '%Contract%' group by 1,3) SELECT trunc("debut",'week') as "time", "Contract Subtype",
count (distinct "Contract Address") as "New Contract", sum("New Contract") over (order by "time") as "Cumulative New Contracts" from ramishoow group by 1,2 order by 1 asc
Run a query to Download Data