discodolphinApollo Sunchaser Hunt
Updated 2021-11-11
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 = '712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F' then ' 0: Borrow UST from Anchor'
when tx_id = '15210E926B92DCC8DF92B28BC012243FE0E19929FE04FB42CE8D8683B6BF22E4' then ' 1: Deposit UST into Apollo LP vault'
end as Apollo_event,
tx_id
from
terra.msgs
where
block_timestamp::date >= '2021-09-01'
and tx_status = 'SUCCEEDED'
and msg_index = 0
and tx_id in ('712D0D550B530E13B5BE8015142DE34B4F05138583F3957AB13E084BA5A51C1F',
'15210E926B92DCC8DF92B28BC012243FE0E19929FE04FB42CE8D8683B6BF22E4')
order by
Apollo_event
Run a query to Download Data