ArioUntitled Query
Updated 2022-11-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
with tab1 as (
select * from ethereum.core.ez_token_transfers
where --TO_ADDRESS = lower('0x5040935bD53bB089718E921271d477796284C45E')
origin_from_address = '0xc2f41b3a1ff28fd2a6eee76ee12e51482fcfd11f'
and to_address not in ('0x0000000000000000000000000000000000000000', '0xc2f41b3a1ff28fd2a6eee76ee12e51482fcfd11f')
and tx_hash not in (select Tx_hash from ethereum.core.ez_dex_swaps)
and from_address = '0xd152f549545093347a162dce210e7293f1452150'
)
select * from ethereum.core.ez_token_transfers b join tab1 a on b.ORIGIN_FROM_ADDRESS = a.to_address
where b.SYMBOL in ('USDC', 'SUSHI')
and b.to_address in (select to_address from tab1)
/*select * from ethereum.core.ez_token_transfers
where TO_ADDRESS = lower('0x5040935bD53bB089718E921271d477796284C45E')
--and origin_from_address = '0xc2f41b3a1ff28fd2a6eee76ee12e51482fcfd11f'
*/
Run a query to Download Data