Updated 2024-07-26
    WITH address_list AS (
    SELECT '0x17b153aa3abe80655b558e52e478f0b3968bff16' AS address UNION ALL SELECT '0x5d48ae24e96ca893e7de05a277d6a90c35588e5f' UNION ALL SELECT '0xf404806324dec457a0c5a8fb49302c8707b48386' UNION ALL SELECT '0x099206266a54d4d7a41fb5eb5b687ebf7ac153b6' UNION ALL SELECT '0x8f1ef2c70a61cae8dd54d25be7b44c2e581c6b33' UNION ALL SELECT '0x12b42bcbf7d017e6fc811896ac35546f7c00a3bd' UNION ALL SELECT '0xe2defbbd57b9a81ff9dee266e45492348fc8b2f8' UNION ALL SELECT '0xb08a93741a2f4f3897f2d9db6caf0f6212c7a5d4' UNION ALL SELECT '0xca95b7f44c35dbedf586ae05f165779eea23db36' UNION ALL SELECT '0xf820502be44549169a4bc136afafd714d1d25708' UNION ALL SELECT '0x3dc12115d9d30be692a169ae75deada74eeacd69' UNION ALL SELECT '0xfdfb48a407d436530e2732df52d39c9c63995e42' UNION ALL SELECT '0x7e87c3ea18097bb096f9d7a1a5cf4521207c0fa6' UNION ALL SELECT '0xdfc3653588183f0d5c79a42776830106486b8a34' UNION ALL SELECT '0xd0d50bd6933668d962f8b601b155a5a6a2d2d178' UNION ALL SELECT '0xb9f1a414cd3e820968fd51840b26cc149a4f24bd' UNION ALL SELECT '0x90875d559db224225ac6d63507fa7b370b70dd26' UNION ALL SELECT '0x278ad2617a315a184dec06b7d57d9fa84034cadb' UNION ALL SELECT '0xa43b3a7fc3be6fea9c605f7cedc73d4d8f928e4b' UNION ALL SELECT '0x5acf811f58ae94c8a049fc977cfa4949e43d5264' UNION ALL SELECT '0xe6dd0608f6f9bf589470a7be991e25e3d76e62ee' UNION ALL SELECT '0xe156e01502fda3a467e713f3b49ce72c726d06af' UNION ALL SELECT '0x1531b0467896ade3b46a111999da55a83922c7fc' UNION ALL SELECT '0x1fe729426df3d04c033cd59771d2ac4e1e5e046a' UNION ALL SELECT '0x4597306b1ccfa70af7c2b479c3d7c6246566d5f7' UNION ALL SELECT '0x11fb06e3ed9a12ebbb1345326448aa01d78731d6' UNION ALL SELECT '0x684bf2573a3fbb92f656787c6ec5b5e7844f29b2' UNION ALL SELECT '0xebbbe02e2b41c17870152a27e8bee518211854d9' UNION ALL SELECT '0x4daf24cb5ac80f56df1c342f77fe3f5a364645ed' UNION ALL SELECT '0x9f8aba64beacb170cebfa0d1366d040051e51215' UNION ALL SELECT '0xdcf57a5b6a8a41231858b242c163a77d1579edec' UNION ALL SELECT '0x6c3200e8b067ec14e737da32fae6d902116ab50d' UNION ALL SELECT '0x2d14297b7ebc1c16ce9d09247c2287afa454046f' UNION ALL SELECT '0xea481d5f0015d67f32854e45fe8f3af7b54c5575' UNION ALL SELECT '0x95631d64b8825cec13956b7afeb8d797f103c372' UNION ALL
    ),

    combined_transfers AS (
    SELECT
    TX_HASH,
    BLOCK_TIMESTAMP,
    FROM_ADDRESS,
    TO_ADDRESS,
    AMOUNT,
    AMOUNT_USD,
    'ETH' AS SYMBOL,
    'native' AS TRANSFER_TYPE
    FROM
    ethereum.core.ez_native_transfers
    WHERE
    (LOWER(FROM_ADDRESS) IN (SELECT LOWER(address) FROM address_list)
    OR LOWER(TO_ADDRESS) IN (SELECT LOWER(address) FROM address_list))
    AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '1 day'
    AND AMOUNT_USD >= 100

    UNION ALL

    SELECT
    TX_HASH,
    BLOCK_TIMESTAMP,
    FROM_ADDRESS,
    TO_ADDRESS,
    AMOUNT,
    AMOUNT_USD,
    SYMBOL,
    'token' AS TRANSFER_TYPE
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    QueryRunArchived: QueryRun has been archived