denze-e7j2NU2022 CE (Art Blocks)
    Updated 2023-02-08
    SELECT
    CASE
    WHEN nft_address = '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a' AND (tokenid BETWEEN 0 AND 1000000) THEN 'Chromie Squiggle by Snowfro'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 78000000 AND 79000000) THEN 'Fidenza by Tyler Hobbs'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 215000000 AND 216000000) THEN 'Gazers by Matt Kane'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 163000000 AND 164000000) THEN 'Meridian by Matt DesLauriers'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 13000000 AND 14000000) THEN 'Ringers by Dmitri Cherniak'
    WHEN nft_address = '0x64780ce53f6e966e18a22af13a2f97369580ec11' AND (tokenid BETWEEN 0 AND 1000000) THEN 'Petro National by John Gerrard'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 227000000 AND 228000000) THEN 'Kai-Gen by Takeshi Murata, Christopher Rutledge, J. Krispy'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 150000000 AND 160000000) THEN 'Fragments of an Infinite Field by Monica Rizzolli'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 23000000 AND 24000000) THEN 'Archetype by Kjetil Golid'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 225000000 AND 226000000) THEN 'Vortex by Jen Stark'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 53000000 AND 54000000) THEN 'Subscapes by Matt DesLauriers'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 228000000 AND 229000000) THEN 'Incomplete Control by Tyler Hobbs'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 226000000 AND 227000000) THEN 'Getijde by Bart Simons'
    WHEN nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' AND (tokenid BETWEEN 7000000 AND 8000000) THEN 'Elevated Deconstructions by luxpris'
    ELSE 'Other'
    END AS name
    , SUM(price) AS vol_eth
    , SUM(creator_fee) AS CE_eth
    FROM ethereum.core.ez_nft_sales
    WHERE true
    AND block_timestamp BETWEEN '2022-06-15' AND '2023-01-01'
    -- AND nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
    -- -- AND tokenid BETWEEN 78000000 AND 79000000 -- Fidenzas
    -- -- AND tokenid BETWEEN 215000000 AND 216000000 -- Gazers
    -- AND tokenid BETWEEN 189000000 AND 190000000 -- CryptoNewYorkers

    AND nft_address IN (
    '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a'
    , '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
    , '0x64780ce53f6e966e18a22af13a2f97369580ec11'
    )
    AND currency_symbol IN ('ETH', 'WETH')
    AND platform_name = 'opensea'
    GROUP BY 1
    Run a query to Download Data