DATE_TRUNC('hour', block_timestamp) as "Hour",

currency_symbol as "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 = '2022-10-01'

AND platform_name = 'opensea'

GROUP BY "Hour", "Currency symbol"

HAVING "Total platform fees, USD" > 1000

ORDER BY "Hour"

;