iboo-jbj2MVPrism Scavenger Hunt
Updated 2022-03-03
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
›
⌄
SELECT
block_id,
block_timestamp,
TX_ID,
TX_STATUS ,
'Refract LUNA into yLUNA and pLUNA' as Transaction_descrition
FROM terra.msgs
WHERE tx_id = 'D524BF0A1050E9890788AE6227AFFD7D77BD8D8FF20D9A116A418BEFACC63CDB'
AND block_timestamp >= CURRENT_DATE - 2
UNION
SELECT
block_id,
block_timestamp,
TX_ID,
TX_STATUS ,
'Swap yLUNA for PRISM' as Transaction_descrition
FROM terra.msgs
WHERE tx_id = '337B9FCE74A8725771000EF5D2B0A0FFFB136BD9FCE10EB2CF3E64DBB3A71609'
AND block_timestamp >= CURRENT_DATE - 2
UNION
SELECT
block_id,
block_timestamp,
TX_ID,
TX_STATUS ,
'Provide liquidity using pLUNA and PRISM' as Transaction_descrition
FROM terra.msgs
WHERE tx_id = '25DCA42DB953B1F867281FF4E27751333855ADC4C2BBDF76BF9B7AC092725523'
AND block_timestamp >= CURRENT_DATE - 2
ORDER BY block_timestamp ASC