0xtoshi2023-09-09 12:03 AM copy
    Updated 2023-10-01
    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