LTirrellUntitled Query
    Updated 2021-09-18
    select left(block_timestamp::date,10) as block_date
    ,tx_id
    ,block_id
    , case when tx_id in ('23B880698828A7A517C84B9687931D0E592F3563A35B5B77FB8CF893BA865F53') then 'Bond LUNA to mint bLUNA'
    when tx_id in ('A7BA407763D9D5504C04FE828E089B25F822FD1DAE54A5E67793D6D7281FBC04') then 'Provide bLuna as collateral for Anchor Borrow'
    when tx_id in ('E51F4D35B8CF5966E84E2FC31488C272DB3BD39769AC7E57091CC530F7692BF3') then 'Borrow UST on Anchor'
    when tx_id in ('091982D30723AAB627486BAA9168478BBED151CDFFDAF4A03F11F0965061CA32') then 'Deposit UST to Anchor Earn, minting aUST'
    when tx_id in ('C7FED600DE382139A3FFA91CB4A71904F5E7F737D287D54276BE83CD0D27B693') then 'Provide UST and ANC to create Terraswap ANC-UST Pair'
    when tx_id in ('097221762AD63F1494365CACD2AA57BCEDD63D902E5B9B6ED16BA905DF65E2C6') then 'Stake ANC-UST LP on Anchor'
    else null end as Tx_Description
    from terra.msgs
    where block_id > 4576
    order by 3
    Run a query to Download Data