AndyCoolUntitled Query
    Updated 2021-10-28
    SELECT
    block_id,
    block_timestamp,
    tx_id,
    msg_value:sender::string as sender,
    msg_value:execute_msg:send:amount / POW(10,6) as event_amount,
    msg_value:contract::string as token_address,
    t.address_name as token_address_name,
    msg_value:execute_msg:send:contract::string as contract_address,
    c.address_name as contract_address_name
    FROM terra.msgs

    LEFT OUTER JOIN terra.labels t
    ON msg_value:contract = t.address
    LEFT OUTER JOIN terra.labels c
    ON msg_value:execute_msg:send:contract = c.address
    WHERE msg_type = 'wasm/MsgExecuteContract'
    AND msg_value:contract = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' --mine Token Address
    AND msg_value:execute_msg:send:contract = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' --mine stak Contract
    AND tx_id = '5F140BF049D08B0E8601B5FD80D9C5A3BBC5CFA6C78BA6A98979B4CAD5D39DE4'
    AND block_timestamp >= CURRENT_DATE - 30
    ORDER BY block_timestamp DESC
    LIMIT 100
    Run a query to Download Data