jp12Spindl Sandbox - NFT Royalties Totals
    Updated 2022-10-02
    -- SELECT block_timestamp::date as date, SUM(CREATOR_FEE_USD) as cfee_usd
    -- FROM ethereum.core.ez_nft_sales
    -- WHERE 1=1
    -- and nft_address = '0xa342f5d851e866e18ff98f351f2c6637f4478db5'
    -- GROUP BY 1


    SELECT '1. LAND Royalties' as type, SUM(CREATOR_FEE_USD) as cfee_usd
    FROM ethereum.core.ez_nft_sales
    WHERE 1=1
    and NFT_ADDRESS = '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
    UNION

    SELECT '2. ASSET Royalties' as type, SUM(CREATOR_FEE_USD) as cfee_usd
    FROM ethereum.core.ez_nft_sales
    WHERE 1=1
    and NFT_ADDRESS IN ('0xa342f5d851e866e18ff98f351f2c6637f4478db5', '0x067a1eb5e383ed24b66d72aaf80d8d7db3d299a8')
    ORDER BY 1 ASC
    Run a query to Download Data