SELECT

buyer_address AS trader_address,

SUM(price_usd) AS buyer_volume,

'buyer' AS role

FROM

optimism.nft.ez_nft_sales

GROUP BY

buyer_address

),

seller_volumes AS (

SELECT

seller_address AS trader_address,

SUM(price_usd) AS seller_volume,

'seller' AS role

FROM

optimism.nft.ez_nft_sales

GROUP BY

seller_address

),

top_buyers AS (

SELECT

trader_address,

buyer_volume AS total_volume,

role,

ROW_NUMBER() OVER (ORDER BY buyer_volume DESC) AS rank

FROM

buyer_volumes

),

top_sellers AS (

SELECT

trader_address,

seller_volume AS total_volume,

role,

ROW_NUMBER() OVER (ORDER BY seller_volume DESC) AS rank

FROM