0xtoshi2023-09-09 12:03 AM copy
Updated 2023-10-01
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
›
⌄
WITH INDODAX_OUTFLOW as(
SELECT
ETH_FROM_ADDRESS,
ETH_TO_ADDRESS,
SUM(AMOUNT) as TotalOut
FROM
ethereum.core.ez_eth_transfers
WHERE
ETH_FROM_ADDRESS = LOWER('0x51836A753E344257B361519E948ffCAF5fb8d521')
AND
BLOCK_NUMBER >= 11054791
GROUP BY 1,2
ORDER BY TotalOut DESC
LIMIT 1000
), UNISWAPTX AS (
SELECT ETH_FROM_ADDRESS FROM ethereum.core.ez_eth_transfers
WHERE ETH_FROM_ADDRESS IN (SELECT ETH_TO_ADDRESS FROM INDODAX_OUTFLOW)
AND ETH_TO_ADDRESS = LOWER('0x7a250d5630B4cF539739dF2C5dAcb4c659F2488D')
OR ETH_TO_ADDRESS = LOWER('0xEf1c6E67703c7BD7107eed8303Fbe6EC2554BF6B')
OR ETH_TO_ADDRESS = LOWER('0x3fC91A3afd70395Cd496C647d5a6CC9D4B2b7FAD')
OR ETH_TO_ADDRESS = LOWER('0x11111112542D85B3EF69AE05771c2dCCff4fAa26')
)
SELECT ETH_FROM_ADDRESS,ETH_TO_ADDRESS,TotalOut
FROM INDODAX_OUTFLOW
WHERE ETH_TO_ADDRESS IN (SELECT ETH_FROM_ADDRESS FROM UNISWAPTX)
ORDER BY TotalOut DESC
Run a query to Download Data