alirezazarei5bLUNA Supplied on Anchor
Updated 2021-11-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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,
msg_value:execute_msg:send:contract::string as contract_address
FROM terra.msgs
WHERE msg_type = 'wasm/MsgExecuteContract'
AND msg_value:contract = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' --bLUNA Token Address
AND msg_value:execute_msg:send:contract = 'terra1ptjp2vfjrwh0j0faj9r6katm640kgjxnwwq9kn' --Anchor bLUNA Custody Contract
AND tx_id = 'F926E4B39D8D8A76B465E6A871D133715571228BC34F6869E5BE4AC12A0D056F'
AND block_timestamp >= CURRENT_DATE - 30
ORDER BY block_timestamp DESC
LIMIT 100
Run a query to Download Data