discodolphinApollo Sunchaser Hunt
    Updated 2021-11-11
    select
    left(block_timestamp :: date, 10) as block_date,
    case
    when tx_id = '712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F' then ' 0: Borrow UST from Anchor'
    when tx_id = '15210E926B92DCC8DF92B28BC012243FE0E19929FE04FB42CE8D8683B6BF22E4' then ' 1: Deposit UST into Apollo LP vault'
    end as Apollo_event,
    tx_id
    from
    terra.msgs

    where
    block_timestamp::date >= '2021-09-01'
    and tx_status = 'SUCCEEDED'
    and msg_index = 0
    and tx_id in ('712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F',
    '15210E926B92DCC8DF92B28BC012243FE0E19929FE04FB42CE8D8683B6BF22E4')

    order by
    Apollo_event
    Run a query to Download Data