flipside

    New contracts deployed each week
    mattkstewNew contracts deployed each week
    Updated 2022-12-28
    with tab1 as (
    select
    message_value:contract as contract,
    min(BLOCK_TIMESTAMP) as date1


    from terra.core.ez_messages
    where message_type like '%Contract%'
    group by 1
    )

    select
    date_trunc('week', date1),
    contract

    from tab1
    order by 1
    Run a query to Download Data