LTirrellkujira_hunt
Updated 2022-04-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
select
date_trunc('day', block_timestamp ::date) as datetime,
case
when tx_id in (
'86F63B1BC9E07FA6825F8AEAD5E7296F4868FFCB53DCD3B8398C21A2F9DD4183'
) then 'Step 1: Swap UST for Kuji!'
when tx_id in (
'7613211AFF2AF98B5398EB5BACCAC3C7A9AB7F71E5FE0E8544B0D9A7F48C2BE6'
) then 'Step 2: Bond Kuji for sKUJI'
when tx_id in (
'D21A6F9E8659F2A5827C996D860F03165E27A3A5E3237505DB13CF86174D33F1'
) then 'Step 3: Bid for bLUNA liquidations at 3%'
else null
end as Description,
tx_id
from
terra.msgs
where
tx_id in (
'86F63B1BC9E07FA6825F8AEAD5E7296F4868FFCB53DCD3B8398C21A2F9DD4183',
'7613211AFF2AF98B5398EB5BACCAC3C7A9AB7F71E5FE0E8544B0D9A7F48C2BE6',
'D21A6F9E8659F2A5827C996D860F03165E27A3A5E3237505DB13CF86174D33F1'
)
and datetime > '2022-04-01'
group by
datetime,
Description,
tx_id
order by
Description
Run a query to Download Data