binhachonUntitled Query
Updated 2022-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- with tx_id_list as (
-- select
-- tx_id
-- from
-- ethereum.udm_events
-- where from_address = '0xd96f48665a1410c0cd669a88898eca36b9fc2cce' --Degenbox
-- and to_address = '0xe6191aa754f9a881e0a73f2028edf324242f39e2' --aUST address
-- and symbol = 'UST'
-- )
-- select distinct from_address from ethereum.udm_events
-- where tx_id in (select tx_id from tx_id_list)
-- and to_address = '0x0000000000000000000000000000000000000000'
select distinct contract_address from ethereum.erc20_balances
where user_address = '0xe6191aa754f9a881e0a73f2028edf324242f39e2'
Run a query to Download Data