discodolphinLexus Nexus Hunt
    Updated 2021-11-20
    select
    left(block_timestamp :: date, 10) as block_date,
    case
    when tx_id = 'E79CAB15B6408B6E8722D55D6C1C4F28328D2D296B5EE2557F541453E0F74440' then ' 0: Swap UST to PSI'
    when tx_id = '0259D7020E1E73B1516105BF29FFF7BCA20BFDAAED33A04962D6D21A5217833D' then ' 1: Provide liquidity to PSI-UST Pool'
    end as Nexus_event,
    tx_id
    from
    terra.msgs

    where
    block_timestamp::date >= '2021-10-01'
    and tx_status = 'SUCCEEDED'
    and msg_index = 0
    and tx_id in ('E79CAB15B6408B6E8722D55D6C1C4F28328D2D296B5EE2557F541453E0F74440',
    '0259D7020E1E73B1516105BF29FFF7BCA20BFDAAED33A04962D6D21A5217833D')

    order by
    Nexus_event
    Run a query to Download Data