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