binhachonCopy of Query 1
Updated 2021-10-09
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
26
27
28
29
30
31
32
33
34
35
36
›
-- with address_list as(
-- select
-- address
-- from(
-- select
-- distinct msg_value:sender::string as address
-- from terra.msgs
-- where msg_value:contract = 'terra1dhrc7y9n8yvjvp5cp7caftqv5jxe0vqykldeq9'
-- and msg_value:execute_msg:deposit is not null
-- and tx_status = 'SUCCEEDED'
-- minus
-- SELECT
-- distinct address
-- from terra.daily_balances
-- where address in (
-- select
-- distinct msg_value:sender::string as address
-- from terra.msgs
-- where msg_value:contract = 'terra1dhrc7y9n8yvjvp5cp7caftqv5jxe0vqykldeq9'
-- and msg_value:execute_msg:deposit is not null
-- and tx_status = 'SUCCEEDED'
-- ))
-- )
-- select
-- tx_id,
-- block_timestamp,
-- address
-- from terra.msgs RIGHT JOIN address_list ON msg_value:sender::string = address_list.address
-- where msg_value:contract = 'terra1dhrc7y9n8yvjvp5cp7caftqv5jxe0vqykldeq9'
-- and msg_value:execute_msg:deposit is not null
-- and tx_status = 'SUCCEEDED'
-- SELECT DISTINCT FROM ethereum.events_emitted
-- WHERE EVENT_NAME = 'Created'
-- AND TX_TO_ADDRESS = '0x4678f0a6958e4d2bc4f1baf7bc52e8f3564f3fe4'
-- AND TX_SUCCEEDED = 'TRUE'
Run a query to Download Data