alleriaLexus Nexus Hunt
Updated 2021-11-19Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
case
when tx_id = 'FDCFE8A4063E4C43EEBF20B0D780C96E4E799AA32696BD6FB052B19DEA15E1B9' then ' 1: Swap UST to PSI'
when tx_id = '8D2C5B58D63CD028B3A5991C5BC8CB4CC7CA812741870686E44C32AB34D63292' then ' 2: Deposit in PSI/UST Liquidity Pool'
end as nexus_event,
tx_id
from
terra.msgs
where
block_timestamp::date >= '2021-11-18'
and tx_status = 'SUCCEEDED'
and msg_index = 0
and tx_id in ('FDCFE8A4063E4C43EEBF20B0D780C96E4E799AA32696BD6FB052B19DEA15E1B9',
'8D2C5B58D63CD028B3A5991C5BC8CB4CC7CA812741870686E44C32AB34D63292')
order by
nexus_event
Run a query to Download Data