Hussain93Untitled Query
Updated 2021-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
with
txs as
(
select
block_timestamp,
tx_id,
CASE tx_id
WHEN '3B8693A9D74E200B8763278C5AF59117E7EDAAD835BE0607B897F56CAA2896FF' THEN 'Swap UST MIR'
WHEN '20946A28024FDC3309B1FBC6F7EDE0B5A5AFCF407D08A09BC71D15D5B0F5E9F2' THEN 'borrow on anchor'
END as tx_action
from terra.transactions
WHERE tx_id in
('3B8693A9D74E200B8763278C5AF59117E7EDAAD835BE0607B897F56CAA2896FF',
'20946A28024FDC3309B1FBC6F7EDE0B5A5AFCF407D08A09BC71D15D5B0F5E9F2'));
select
tx_action,
tx_id,
block_timestamp
from txs
Run a query to Download Data