sashimiboiCats Project NFT sales
    Updated 2022-09-03
    SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) as DATE
    ,EVENT_TYPE
    ,AVG(PRICE) AS avg_price_eth
    ,AVG(PRICE_USD) AS avg_price_usd
    ,SUM(TOTAL_FEES_USD) AS TOTAL_FEES_USD
    ,SUM(PLATFORM_FEE_USD) AS TOTAL_PLATFORM_FEE_USD
    ,SUM(CREATOR_FEE_USD) AS TOTAL_CREATOR_FEE_USD
    ,SUM(TX_FEE_USD) AS TOTAL_TX_FEE_USD
    FROM ethereum.core.ez_nft_sales
    WHERE NFT_ADDRESS = '0x78d67f130e80aaa0aad5d786585d36b130fd45dc'
    GROUP BY 1,2
    Run a query to Download Data