rajsTerra 2.0 Number of Executions and Senders
    Updated 2022-12-21
    SELECT
    message_value:contract as contract,
    count(*),
    count(distinct tx_id) as no_of_executions,
    count(distinct message_value:sender) as no_of_senders
    from terra.core.ez_messages
    where message_type = '/cosmwasm.wasm.v1.MsgExecuteContract'
    -- and contract = 'terra1y3wr927vujk5037768w43mfm5g8wyp7e5nqyswvmyxkdkr94zpeqtnltvq'
    and block_timestamp >= CURRENT_DATE - interval '90 days'
    group by 1
    order by 2 desc
    Run a query to Download Data