LTirrellSpectrum Hunt
Updated 2022-01-25
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(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