LTirrellUntitled Query
Updated 2021-09-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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