alleriaLexus Nexus Hunt
    Updated 2021-11-19
    select
    case
    when tx_id = 'FDCFE8A4063E4C43EEBF20B0D780C96E4E799AA32696BD6FB052B19DEA15E1B9' then ' 1: Swap UST to PSI'
    when tx_id = '8D2C5B58D63CD028B3A5991C5BC8CB4CC7CA812741870686E44C32AB34D63292' then ' 2: Deposit in PSI/UST Liquidity Pool'
    end as nexus_event,
    tx_id
    from
    terra.msgs

    where
    block_timestamp::date >= '2021-11-18'
    and tx_status = 'SUCCEEDED'
    and msg_index = 0
    and tx_id in ('FDCFE8A4063E4C43EEBF20B0D780C96E4E799AA32696BD6FB052B19DEA15E1B9',
    '8D2C5B58D63CD028B3A5991C5BC8CB4CC7CA812741870686E44C32AB34D63292')

    order by
    nexus_event
    Run a query to Download Data