fog-jMJCmTOpenseaPro NFT Rank copy
    Updated 2023-04-05
    -- forked from 0x33569c101562e1fAF5b24581057E5cEE4c8288D7 / OpenseaPro NFT Rank @ https://flipsidecrypto.xyz/0x33569c101562e1fAF5b24581057E5cEE4c8288D7/q/2023-04-04-11-14-am-ePOuzF
    WITH
    base AS (
    SELECT
    from_address,
    min(block_timestamp) as first_gem_txn_ts
    FROM
    ethereum.core.fact_transactions ft
    WHERE
    ft.to_address IN (
    '0x0000000035634b55f3d99b071b5a354f48e10bef',
    '0x4326275317acc0fae4aa5c68fce4c54c74dc08d3',
    '0x539ea5d6ec0093ff6401dbcd14d049c37a77151b',
    '0xeda0edeee797f579bdb0d055ae135ecb71709d28',
    '0xf2458bd228d8a39b64bd3b9f84890e957cac3bbc',
    '0x1cb16367b3a775e3d6d93906cd3e671e5ec3d07d',
    '0x9c049c5a973e9637cdf5f7c31b93ec074161d2fe',
    '0x094e654351cf152112e136923ad21508401d64d3',
    '0xf24629fbb477e10f2cf331c2b7452d8596b5c7a5',
    '0x83c8f28c26bf6aaca652df1dbbe0e1b56f8baba2',
    '0xae9c73fd0fd237c1c6f66fe009d24ce969e98704',
    '0xf22007700b8c443bcb36a39580f7804bffdb1169',
    '0x29ab6d8f7e3d815168d6b40ebb12625b4fe13998',
    '0x35ca26a7a7f3ca98f3e60bd94c139c892e45b6c3',
    '0x9e97195f937c9372fe5fda5e3b86e9b88cbefed7',
    '0x00000000a50bb64b4bbeceb18715748dface08af',
    '0x241b8e59e81455e66b9cd0e2ffb2506be1838144',
    '0x0000000031f7382a812c64b604da4fc520afef4b'
    )
    GROUP BY
    1
    ),
    ranked as (
    SELECT
    *,
    RANK() OVER (
    Run a query to Download Data