COUNT(DISTINCT tx_hash) AS unique_transaction_count,

COUNT(tx_hash) AS total_sales,

COUNT(DISTINCT CASE WHEN event_type = 'sale' THEN tx_hash END) AS sales_event_count,

COUNT(DISTINCT CASE WHEN event_type = 'bid_won' THEN tx_hash END) AS bid_won_event_count,

COUNT(DISTINCT CASE WHEN event_type = 'redeem' THEN tx_hash END) AS redeem_event_count,

(SELECT COUNT(DISTINCT trader_address)

FROM (

SELECT seller_address AS trader_address

FROM optimism.nft.ez_nft_sales

UNION

SELECT buyer_address AS trader_address

FROM optimism.nft.ez_nft_sales

) AS unique_traders) AS total_unique_traders

,

SUM(price_usd) as volume_usd,

SUM(tx_fee_usd) as gas_fees,

SUM(creator_fee_usd) as creator_fees,

COUNT(DISTINCT nft_address) AS total_unique_assets,

COUNT(DISTINCT platform_address) AS total_platform,

SUM(platform_fee_usd) AS platform_fees

FROM

optimism.nft.ez_nft_sales;