flipside

    New Year, Development 2
    mattkstewNew Year, Development 2
    Updated 2023-01-05
    with tab1 as (
    select
    message_value:contract,
    min(BLOCK_TIMESTAMP) as date1


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

    select
    count(*) as value
    from tab1
    where date1 > '2023-01-01'
    order by 1
    Run a query to Download Data