0x0D203C32bbd48653fcbf1898B7a8d757d391f7Bc[14] MDAO 101: SQL AVG MIN MAX MEDIAN
    Updated 2022-08-09

    select
    date_trunc('week', block_timestamp ) AS Date1 ,
    case
    when currency_symbol = 'ETH' then 'ETH'
    when currency_symbol = 'wETH' then 'wETH'
    when currency_symbol = 'USDC' then 'usdc'
    ELSE 'Other'
    end as currency_symbol,
    FROM ethereum.core.ez_nft_sales
    where block_timestamp::Date between '2022-06-01' and '2022-06-30'
    and platform_name = 'opensea'
    group by 1

    Run a query to Download Data