LTirrell30 day swap
Updated 2021-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
block_id,
block_timestamp,
tx_id,
tx_status,
msg_value:sender::string as sender,
msg_value:execute_msg:swap:offer_asset:amount as swap_amount,
msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as swap_currency,
msg_value:contract::string as contract_address,
c.address_name as contract_label
FROM terra.msgs
LEFT OUTER JOIN terra.labels c
ON msg_value:contract::string = c.address
-- WHERE msg_value:contract = 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6'
-- AND msg_value:execute_msg:swap IS NOT NULL
WHERE msg_value:execute_msg:swap IS NOT NULL
AND tx_status = 'SUCCEEDED'
AND block_timestamp >= CURRENT_DATE - 7
-- AND contract_label LIKE 'Terraswap%'
-- LIMIT 100
Run a query to Download Data