SELECT

buyer_address AS trader_address,

SUM(price_usd) AS total_volume

FROM

optimism.nft.ez_nft_sales

GROUP BY

buyer_address

UNION ALL

SELECT

seller_address AS trader_address,

SUM(price_usd) AS total_volume

FROM

optimism.nft.ez_nft_sales

GROUP BY

seller_address

),

combined_volumes AS (

SELECT

trader_address,

SUM(total_volume) AS combined_volume

FROM

transaction_volumes

GROUP BY

trader_address

),

ranked_traders AS (

SELECT

trader_address,

combined_volume,

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

FROM

combined_volumes