LTirrell30 day swap
    Updated 2021-09-02
    SELECT
    block_id,
    block_timestamp,
    tx_id,
    tx_status,
    msg_value:sender::string as sender,
    msg_value:execute_msg:swap:offer_asset:amount as swap_amount,
    msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as swap_currency,
    msg_value:contract::string as contract_address,
    c.address_name as contract_label
    FROM terra.msgs

    LEFT OUTER JOIN terra.labels c
    ON msg_value:contract::string = c.address

    -- WHERE msg_value:contract = 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6'
    -- AND msg_value:execute_msg:swap IS NOT NULL
    WHERE msg_value:execute_msg:swap IS NOT NULL
    AND tx_status = 'SUCCEEDED'
    AND block_timestamp >= CURRENT_DATE - 7
    -- AND contract_label LIKE 'Terraswap%'
    -- LIMIT 100
    Run a query to Download Data