dammyzuks2023-10-25 07:24 PM
    Updated 2023-10-25
    SELECT
    DATE_TRUNC('month', block_timestamp) AS _date,
    currency_symbol,
    SUM(platform_fee) AS total_platform_fee,
    SUM(platform_fee_usd) AS total_platform_fee
    FROM
    ethereum.nft.ez_nft_mints
    WHERE
    block_timestamp :: DATE BETWEEN '2022-04-01'
    AND '2022-08-30'
    AND platform_name = 'opensea'
    and currency_symbol = 'ENS'
    GROUP BY
    1;
    Run a query to Download Data