SELECT
currency_symbol,
COUNT(tx_hash) AS sale_count,
SUM(price_usd) AS total_sales_usd
FROM
arbitrum.nft.ez_nft_sales
WHERE
block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'
AND currency_symbol IS NOT NULL
GROUP BY
currency_symbol
ORDER BY
total_sales_usd DESC;