nickpayiatis_Terra Messages Investigation
    Updated 2021-09-13
    SELECT
    date_trunc('day',block_timestamp) as block_day,
    tx_id as tx_hash,
    msg_value:sender as sender,
    msg_value as luna_unbonded
    FROM terra.msgs
    WHERE
    msg_value:contract = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' -- Contract for BLUNA
    AND
    msg_value:execute_msg:send:contract = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'
    AND
    msg_value:execute_msg:send:msg::string='{"unbond":{}}' -- msg emitted during unbonding
    And
    block_day >= CURRENT_DATE - 1
    AND
    tx_status = 'SUCCEEDED'
    GROUP BY 1,2,3,4
    ORDER BY 4 DESC
    LIMIT 10
    Run a query to Download Data