select SELLER_ADDRESS ,

sum(PRICE_USD) as sale_vol,

max (BLOCK_TIMESTAMP) as last_TX

from ethereum.core.ez_nft_sales

where NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

and PRICE_USD is not null

group by SELLER_ADDRESS

order by sale_vol desc

),

buyer as (

select BUYER_ADDRESS ,

sum(PRICE_USD) as buy_vol,

min (BLOCK_TIMESTAMP) as first_TX

from ethereum.core.ez_nft_sales

where NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

and PRICE_USD is not null

and PRICE_USD != '0'

group by BUYER_ADDRESS

order by buy_vol desc

select seller.SELLER_ADDRESS as trader ,

((seller.sale_vol-buyer.buy_vol)/buyer.buy_vol)*100 as advantage_precent ,

DATEDIFF(day,buyer.first_TX , seller.last_TX) as benefit_time,

advantage_precent/benefit_time as percent_profit_per_Day

from seller join buyer on seller.SELLER_ADDRESS = buyer.BUYER_ADDRESS

order by advantage_precent desc

limit 10