mariyaPrismهانت
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 = '61275A2BB2191B1D4BA85F5EC28BD8F2052A9533F4A1BD8D6963677CD5E5BA7C'
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 = '9448A45A627E4B75ABECFF3041B7952AD370F2AC1873E88B3BB61DC783EF0808'
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 = '11142431B5A093754AAECD67D3CD8543974641DDC17EA9D777A272C528D12BCE'
AND block_timestamp >= CURRENT_DATE - 2
ORDER BY block_timestamp ASC
Run a query to Download Data