Updated 2023-02-08
    SELECT
    nft_address
    , project_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-01-01' AND '2023-01-01'

    -- AND nft_address = '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a'
    -- AND tokenid >= 0 AND tokenid <= 1000000 -- Squiggles

    -- 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 (
    '0xd0a07a76746707f6d6d36d9d5897b14a8e9ed493' -- PVFD
    ,'0xc36cf0cfcb5d905b8b513860db0cfe63f6cf9f5c' --Legends Reborn
    ,'0x57a204aa1042f6e66dd7730813f4024114d74f37' --CyberKongz (Babies)
    , '0x4d928fada59f3446627c5bea707a81e006cf676f' --VeeCon Tickets
    , '0xd0a07a76746707f6d6d36d9d5897b14a8e9ed493' --Pixel Vault Founder's DAO
    , '0xbb869f884186c3cba0ffa89ab84980cb86f8744d' --Queens+Kings LAB by Hackatao
    , '0x7df64f69544c5bf71171dc5ab69b8602c2ff1e27' --Kitaro World Official
    , '0x13927739076014913a3a7c207ef84c5be4780014' --VeeFriends Gift Goat x Pop Wonder: The Gift Within The Goat
    , '0x80336ad7a747236ef41f47ed2c7641828a480baa' --Chimpers
    , '0x7f36182dee28c45de6072a34d29855bae76dbe2f' --Wolf Game
    , '0x75e95ba5997eb235f40ecf8347cdb11f18ff640b' --Psychedelics Anonymous Genesis
    , '0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7' --Meebits
    , '0x509a050f573be0d5e01a73c3726e17161729558b' --Where My Vans Go
    , '0xd0fabbba5fd95411a07bb2fdcf31295639376937' --Cel Mates Crime Reports
    , '0xba30e5f9bb24caa003e9f2f0497ad287fdf95623' --Bored Ape Kennel Club
    , '0xc73b17179bf0c59cd5860bb25247d1d1092c1088' --QQL Mint Pass
    , '0xc143bbfcdbdbed6d454803804752a064a622c1f3' --Async Blueprints
    , '0xdfde78d2baec499fe18f2be74b6c287eed9511d7' --DreamScapes by Xander Steenbrugge
    Run a query to Download Data