LTirrellPRISM hunt
    Updated 2022-03-04
    select
    date_trunc('day', block_timestamp ::date) as datetime,
    case
    when tx_id in (
    'F6038777E4B59E6A8A4C882D4D06E07A07D42D4F20926911305F51489A56EDCB'
    ) then 'Step 1: Refract LUNA into yLUNA and pLUNA'
    when tx_id in (
    'B841AD9DCE5E1D82D3E6BFA8B8E55B2A56F8B751B80670C59C472E1D727A135A'
    ) then 'Step 2: Swap some yLUNA for PRISM'
    when tx_id in (
    '5902DE1705CD0F0B8934E49445C821D49AA26CD348B46A5BDE7BDE245A5AA2C5'
    ) then 'Step 3: Provide liquidity using pLUNA and PRISM'
    else null
    end as Description,
    tx_id
    from
    terra.msgs
    where
    tx_id in (
    'F6038777E4B59E6A8A4C882D4D06E07A07D42D4F20926911305F51489A56EDCB',
    'B841AD9DCE5E1D82D3E6BFA8B8E55B2A56F8B751B80670C59C472E1D727A135A',
    '5902DE1705CD0F0B8934E49445C821D49AA26CD348B46A5BDE7BDE245A5AA2C5'
    )
    and datetime > '2022-03-01'
    group by
    datetime,
    Description,
    tx_id
    order by
    Description

    Run a query to Download Data