currency_symbol as "currency symbol",

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

sum(platform_fee) as "Total platform fees, transaction token",

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

FROM ethereum.core.ez_nft_sales

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

AND platform_name = 'opensea'

AND currency_symbol = 'ETH'

GROUP BY "currency symbol"

ORDER BY "Total platform fees, USD" DESC