Updated 2022-04-09
    SELECT
    date_trunc('month', block_timestamp) as date,
    -- project_name,
    -- contract_address,
    sum(price_usd) AS total_sales,
    count(tx_id) AS n_sales

    FROM
    ethereum.nft_events
    WHERE event_type = 'sale'
    AND event_platform = 'opensea'

    -- WHERE
    -- event_platform = 'opensea' AND event_type = 'sale'

    GROUP BY 1
    ORDER BY 1 DESC
    -- GROUP BY
    -- project_name, contract_address, tx_currency

    -- ORDER BY total_sales DESC
    Run a query to Download Data