select
CURRENCY_SYMBOL,
sum(PLATFORM_FEE) as total_platform_fee,
sum( PLATFORM_FEE_USD) as total_platform_fee_usd
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
ORDER BY 3 DESC;