mattkstewLAAF Development 4
    Updated 2023-01-25
    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(*)/11 as Average_daily
    from tab1
    where date1 > '2023-01-14'
    order by 1
    Run a query to Download Data