NuveveCryptoArchivedProjects and The No. of Contracts Deployed
    Updated 2022-12-19
    with instantiate as (
    select
    attributes:instantiate:_contract_address as contract_address
    from terra.core.ez_messages
    where message_type = '/cosmwasm.wasm.v1.MsgInstantiateContract'
    )

    select
    labels.project_name,
    count(distinct instantiate.contract_address) as unique_count
    from terra.core.dim_address_labels as labels
    inner join instantiate on labels.address = instantiate.contract_address
    group by labels.project_name


    Run a query to Download Data