moshuiyungetTxFirst
    Updated 2023-02-09
    SELECT
    tx.*
    from
    ethereum.core.fact_transactions tx,
    (
    SELECT
    tx2.to_address,
    min(tx2.block_number) as block_number
    from
    ethereum.core.fact_transactions tx2
    where
    tx2.to_address IN (
    '0xa68dd8cb83097765263adad881af6eed479c4a33',
    '0x9010a15184da16e3a7c5b4aa50094dfe3bb36989',
    '0xd22a32c67a2dfa3a85a1ff69176f14a61fd8783a',
    '0x9ba60ba98413a60db4c651d4afe5c937bbd8044b',
    '0xa32eaeca2c34ab2521ab6aa3ddd37d3e0b644ded',
    '0xae7ab96520de3a18e5e111b5eaab095312d7fe84',
    '0xb00fddf6d66e332694e20d1a243df8fbc5e86615',
    '0xb7bb0e4bf96d9b3824456b06a13a050eaeb85d83',
    '0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7',
    '0xc5424b857f758e906013f3555dad202e4bdb4567',
    '0xde29d461591762e8b72914a142eaa0e611777656',
    '0xdef1c0ded9bec7f1a1670819833240f027b25eff',
    '0xe592427a0aece92de3edee1f18e0157c05861564',
    '0xeb7500d6fed95db09f5221638fe983d81c30ff5f',
    '0xf6b767dc6250b89b6cb557327114266223f3c37c',
    '0xfa9a30350048b2bf66865ee20363067c66f67e58',
    '0x99a58482bd75cbab83b27ec03ca68ff489b5788f',
    '0x0000000000cbba74c365869ae50225f5596ad59c',
    '0x93bab7b697c71dc71964da77eb9ece40abd8e01b',
    '0x4f073667ffb675b42305a9e4ca9d1494006c1998',
    '0x325337e85cda444c6474a08c835d7e05cc3c3ba5',
    '0x354c85a92721bac1aa0fa68f580eb86f2453df43',
    '0x399f70b65b41c6b2efbc799add1680d5b68a0f0b',
    '0x4dc8a00e578a5719d6441a2c89a0283ea9d15844',
    Run a query to Download Data