LTirrellPRISM hunt
Updated 2022-03-04
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 (
'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