LTirrellSpectrum Hunt
    Updated 2022-01-25
    select
    date_trunc(dat, 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 (
    'B841AD9DCE5E1D82D3E6BFA8B8E55B2A56F8B751B80670C59C472E1D727A135A'
    ) 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',
    'B841AD9DCE5E1D82D3E6BFA8B8E55B2A56F8B751B80670C59C472E1D727A135A'
    )
    and datetime > '2022-03-01'
    group by
    datetime,
    Description,
    tx_id
    order by
    Description

    Run a query to Download Data