freemartianUntitled Query
Updated 2021-11-19
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
›
⌄
SELECT
'Swpa UST for PSI' as action,
block_id,
block_timestamp,
tx_id,
msg_value:sender::string as sender,
msg_value:execute_msg:send:amount / POW(10,6) as event_amount,
msg_value:contract::string as token_address,
msg_value:execute_msg:send:contract::string as contract_address
FROM terra.msgs
WHERE tx_id = '31239389694F6568352027940668085BFD8197C7B639D283AC1BDA831D5B7C09'
UNION
SELECT
'Deposit into UST/PSI pool' as action,
block_id,
block_timestamp,
tx_id,
msg_value:sender::string as sender,
msg_value:execute_msg:send:amount / POW(10,6) as event_amount,
msg_value:contract::string as token_address,
msg_value:execute_msg:send:contract::string as contract_address
FROM terra.msgs
WHERE tx_id = '85355A00875A2F09A2FAA2CA0ED07D278275CAD9857F2913C0060C22A090A79D'
Run a query to Download Data