Updated 2022-07-03
    WITH opensea as (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_nft_sales
    WHERE date >= '2022-01-01' AND
    SUCCEEDED = 'TRUE' AND
    MARKETPLACE = 'opensea'
    GROUP BY date
    ORDER BY date ASC),
    me1 as (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_nft_sales
    WHERE date >= '2022-01-01' AND
    SUCCEEDED = 'TRUE' AND
    MARKETPLACE = 'magic eden v1'
    GROUP BY date
    ORDER BY date ASC),
    me2 as (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_nft_sales
    WHERE date >= '2022-01-01' AND
    SUCCEEDED = 'TRUE' AND
    MARKETPLACE = 'magic eden v2'
    GROUP BY date
    ORDER BY date ASC),
    solport as (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_nft_sales
    WHERE date >= '2022-01-01' AND
    SUCCEEDED = 'TRUE' AND
    MARKETPLACE = 'solport'
    GROUP BY date
    ORDER BY date ASC),
    Run a query to Download Data