discodolphinLexus Nexus Hunt
Updated 2021-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
left(block_timestamp :: date, 10) as block_date,
case
when tx_id = 'E79CAB15B6408B6E8722D55D6C1C4F28328D2D296B5EE2557F541453E0F74440' then ' 0: Swap UST to PSI'
when tx_id = '0259D7020E1E73B1516105BF29FFF7BCA20BFDAAED33A04962D6D21A5217833D' then ' 1: Provide liquidity to PSI-UST Pool'
end as Nexus_event,
tx_id
from
terra.msgs
where
block_timestamp::date >= '2021-10-01'
and tx_status = 'SUCCEEDED'
and msg_index = 0
and tx_id in ('E79CAB15B6408B6E8722D55D6C1C4F28328D2D296B5EE2557F541453E0F74440',
'0259D7020E1E73B1516105BF29FFF7BCA20BFDAAED33A04962D6D21A5217833D')
order by
Nexus_event
Run a query to Download Data