NakedCollector2023-10-23 03:16 PM copy
    -- forked from 2023-10-23 03:16 PM @ https://flipsidecrypto.xyz/edit/queries/7ed6e096-0f0a-4687-8d07-c9ca8756fe65

    -- Find the earliest and latest sale transactions for each NFT project by address
    WITH EarliestAndLatestDates AS (
    SELECT
    nft_address,
    project_name,
    MIN(DATE(block_timestamp)) AS earliest_date,
    MAX(DATE(block_timestamp)) AS latest_date
    FROM
    ETHEREUM.core.ez_nft_sales
    WHERE
    event_type IN ('sale', 'bid_won')
    and nft_address in(
    '0x28472a58a490c5e09a238847f66a68a47cc76f0f',
    '0x455c732fee7b5c3b09531439b598ead4817d5274',
    '0xba0c9cf4da821dba98407cc4f9c11f6c7a5f9bbc',
    '0xd71b53fe1df51075c5a965956cdc87421c2ffed7',
    '0x68f4ba8018216542ac2ab8125166be66304dd71c',
    '0x57c4d987431a4582a5e3ce9a3a9a5f1e9f55757c',
    '0xeb6c5accafd8515c1b9e4c794bdc41532c5543ec',
    '0x4bd77619a75c8eda181e3587339e7011da75bf0e',
    '0x5d26060847445efb92c6f03d1382bcdd07b67280',
    '0xc216f9db5fe192406652b43ca7bbb969ecfd573e',
    '0xcd041f40d497038e2da65988b7d7e2c0d9244619',
    '0xd4190dd1da460fc7bc41a792e688604778820ac9',
    '0x0e220a4f3957c17a2e780922dbc13cb2c9aa4274',
    '0x78d61c684a992b0289bbfe58aaa2659f667907f8',
    '0xc3ae6e60a37a5f7d6d68e60c45b1ae50da233bd4',
    '0x572e33ffa523865791ab1c26b42a86ac244df784',
    '0xe8f88d16f24255fcfab25959705d724406d67d9d',
    '0xcd1f6be81f1dc58558f44bbc5ca4cc43cbb1ec05',
    '0x283c0bba69ebd4643cfce761b34b0206e75b2091',
    '0x76cf1fc9fcdabcb3a3c01409529eb1ba59b93add',
    --NIKE
    '0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1',
    Run a query to Download Data