select

*

from ethereum.core.ez_nft_sales

where buyer_address != '0x0000000000000000000000000000000000000000'

and seller_address != '0x0000000000000000000000000000000000000000'

and event_type= 'sale'

and price_usd != 0

and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0'

and nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

),

sell as (

select

seller_address as user_address,

sum(price_usd) as sales_volume,

count(distinct tx_hash) as number_of_sales

from cryptopunks_total_transactions

group by user_address

),

buy as (

select

buyer_address as user_address,

sum(price_usd) as purchases_volume,

count(distinct tx_hash) as number_of_sales

from cryptopunks_total_transactions

group by user_address

),

user_profit as (

select

user_address,

sales_volume - purchases_volume as profit

from sell

full join buy using(user_address)

),

top_10_trader as (

select