ArashhUntitled Query
    Updated 2023-02-19
    select
    ATTRIBUTES['coin_received']['amount']/1e6,
    ATTRIBUTES['coin_received']['receiver'],
    *
    from
    terra.core.ez_messages

    where
    --MESSAGE_TYPE='/cosmwasm.wasm.v1.MsgExecuteContract' and substr(MESSAGE_VALUE['msg']['execute'],3,11 )='proposal_id'
    --TX_ID='6328CE1E11E0938A7040A5BABA51C9224823AABD8FEF18957A61A3BBDF35285B'
    MESSAGE_TYPE='/cosmwasm.wasm.v1.MsgExecuteContract' and substr(MESSAGE_VALUE['msg']['execute'],3,11 )='proposal_id'
    limit 10

    Run a query to Download Data