MLDZMNeth1
    Updated 2023-05-31
    -- forked from pol1 @ https://flipsidecrypto.xyz/edit/queries/f31c4620-f75b-4592-b843-e67d404b9463

    with Deposits AS(
    SELECT
    TO_ADDRESS AS whale,
    SYMBOL,
    sum(AMOUNT_USD) AS bought_amount
    FROM ethereum.core.ez_token_transfers
    WHERE BLOCK_TIMESTAMP>CURRENT_DATE-30
    AND whale IN (
    '0x4a4e859565d9b563afc8e63641542455cff0dfd2',
    '0xcca0cffbf97fb10b08c1703f1dddcf7b48c69d69',
    '0x46f80018211d5cbbc988e853a8683501fca4ee9b',
    '0xeb825b8c57b3169c35acf5721d89aa6946da4e9c',
    '0xb624219480543c54603fb6b07d5eb347e51bffe0',
    '0xe195b82df6a797551eb1acd506e892531824af27',
    '0x2297aebd383787a160dd0d9f71508148769342e3',
    '0xf62f75dcf3c73cafbcadda2236c3ce61a2b7c64a',
    '0x989536719a72cfd50348ccd5521256c7eb41a999',
    '0xeb97dee699b7a7237a30c52c5e2afa34cec7147d',
    '0xda14473cb67529c8a780c4d0c5c6eb2cf1a9fde7',
    '0xd275e5cb559d6dc236a5f8002a5f0b4c8e610701',
    '0xdbd08d75a614567ff03f50e75b2a72ff9af35700',
    '0xcc9b1f919282c255eb9ad2c0757e8036165e0cad',
    '0xe195b82df6a797551eb1acd506e892531824af27',
    '0x838d26b7324aefc725098111116d9732057aca26',
    '0x5e12fc70b97902ac19b9cb87f2ac5a8593769779',
    '0xe0028eb5ae51384418e07cad373dae8f396ad707',
    '0x42a178633240601d3485e1f51d8b62ea58c9b5ae',
    '0xc279fe84665582169a96cf5621361af086377a79'
    )
    GROUP BY 1,2
    HAVING bought_amount>0
    union all
    SELECT
    eth_TO_ADDRESS AS whale,
    Run a query to Download Data