discodolphinLido Raindrop Hunt
    Updated 2021-11-11
    select
    left(block_timestamp :: date, 10) as block_date,
    case
    when tx_id = '8CEE4B43E68A929167D70AC9F8BB5BCDCF74310BAD53161B8B25407501A9656C' then ' 0: Minting bETH'
    when tx_id = '5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60' then ' 1: Deposit bETH on Anchor'
    when tx_id = '712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F' then ' 2: Borrow UST on Anchor'
    when tx_id = '3E4680493B81241991D4ED8590584F2266C9C7A6AB82891A5F96837F1418BE66' then ' 3: Deposit UST on Anchor Earn'
    end as Lido_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 ('8CEE4B43E68A929167D70AC9F8BB5BCDCF74310BAD53161B8B25407501A9656C',
    '5625787DFB6831AA030A76E4A137CA6F2EEA98ABE25E1D9266BB354AFCE17C60',
    '712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F',
    '3E4680493B81241991D4ED8590584F2266C9C7A6AB82891A5F96837F1418BE66')

    order by
    Lido_event
    Run a query to Download Data