discodolphinPylon Hunt
    Updated 2021-10-29
    select
    left(block_timestamp :: date, 10) as block_date,
    case
    when tx_id = '0C3C2901293E772FAEEA35B49057B250E1A4BF95E124C0F0EA6B45E98FAEFE4C' then ' 0: Swap UST for MINE'
    when tx_id = '1EAA441A2EEAF35114AF628CCFF9A331EACEA641D7C271EAA5594942E3A8968B' then ' 1: Stake MINE on Pylon'
    end as Pylon_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 ('0C3C2901293E772FAEEA35B49057B250E1A4BF95E124C0F0EA6B45E98FAEFE4C',
    '1EAA441A2EEAF35114AF628CCFF9A331EACEA641D7C271EAA5594942E3A8968B')

    order by
    Pylon_event
    Run a query to Download Data