AndyCoolUntitled Query
Updated 2021-10-28
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
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,
t.address_name as token_address_name,
msg_value:execute_msg:send:contract::string as contract_address,
c.address_name as contract_address_name
FROM terra.msgs
LEFT OUTER JOIN terra.labels t
ON msg_value:contract = t.address
LEFT OUTER JOIN terra.labels c
ON msg_value:execute_msg:send:contract = c.address
WHERE msg_type = 'wasm/MsgExecuteContract'
AND msg_value:contract = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' --mine Token Address
AND msg_value:execute_msg:send:contract = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' --mine stak Contract
AND tx_id = '5F140BF049D08B0E8601B5FD80D9C5A3BBC5CFA6C78BA6A98979B4CAD5D39DE4'
AND block_timestamp >= CURRENT_DATE - 30
ORDER BY block_timestamp DESC
LIMIT 100
Run a query to Download Data