Rocky_sTotal ETH mint based on sales
    Updated 2023-05-24
    with sales AS (
    SELECT date_trunc('day', block_timestamp) AS date,
    nft_address, sum(price) AS total_eth_sales
    FROM ethereum.core.ez_nft_sales
    WHERE date > current_date() - 30
    GROUP BY 1,2),

    mints AS (
    SELECT date_trunc('day', block_timestamp) AS date,
    nft_address, sum(mint_price_eth) AS total_eth_mint
    FROM ethereum.core.ez_nft_mints
    WHERE date > current_date() - 30
    GROUP BY 1,2)

    SELECT s.date, s.nft_address, s.total_eth_sales, m.total_eth_mint
    FROM sales AS s LEFT JOIN mints AS m
    on s.date = m.date AND s.nft_address = m.nft_address
    WHERE total_eth_sales > 0 AND total_eth_mint > 0
    ORDER BY 1,3
    Run a query to Download Data