discodolphinAnchor Mariner Hunt
    Updated 2021-11-10
    select
    case
    when tx_id = '5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60' then ' 1: Supply bETH as collateral'
    when tx_id = '36A606B6684404A5295BBCBE33CA3E598DB2D31928482E487F8189DDFBA69123' then ' 0: Stake ANC'
    when tx_id = 'DED51C4EF3ED3F1D03291BF274074E241CAD1CEDA339E6C7491FE0B4C730B663' then ' 2: Take out a loan'
    end as anchor_event,
    tx_id
    from
    terra.msgs

    where
    block_timestamp::date >= '2021-08-21'
    and tx_status = 'SUCCEEDED'
    and msg_index = 0
    and tx_id in ('5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60',
    '36A606B6684404A5295BBCBE33CA3E598DB2D31928482E487F8189DDFBA69123',
    'DED51C4EF3ED3F1D03291BF274074E241CAD1CEDA339E6C7491FE0B4C730B663')

    order by
    anchor_event
    Run a query to Download Data