currency_symbol,

count(distinct tx_hash) as "Number of Transactions",

sum(platform_fee) as "Total platform fees, ETH",

sum(platform_fee_usd) as "Total platform fees, USD"

FROM ethereum.core.ez_nft_sales

WHERE

block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31'

AND platform_name = 'opensea'

GROUP BY currency_symbol

ORDER BY "Total platform fees, USD" DESC

;