jonome[13] MDAO 101: SQL SUM copy
    -- forked from metricsdao / [13] MDAO 101: SQL SUM @ https://flipsidecrypto.xyz/metricsdao/q/12-mdao-101-sql-count-GmQEFk

    -- MetricsDAO Blockchain Analytics 101
    -- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101

    WITH
    dex_sales AS(
    SELECT *
    FROM ethereum.core.ez_nft_sales
    WHERE block_timestamp > current_date - 30;
    AND platform_name = 'opensea'
    order by 1;
    )
    SELECT
    DATE_TRUNC('day', block_timestamp) AS _DATE,
    CASE
    WHEN currency_symbol = 'ETH' THEN 'ETH'
    WHEN currency_symbol = 'WETH' THEN 'WETH'
    WHEN currency_symbol = 'USDC' THEN 'USDC'
    ELSE 'OTHERS'
    END AS currency_symbol,
    SUM(platform_fee) AS total_platform_fee,
    SUM(platform_fee_usd) AS total_platform_fee_usd
    FROM dex_sales
    GROUP BY 1, 3
    ORDER BY 1,4 DESC;

    Run a query to Download Data