with trader as (

select wallet,

count(distinct tx_hash) as sales_count,

sum(price_usd) as sales_volume

from (

select -- to_date(date_trunc('day', block_timestamp)) as block_date,

buyer_address as wallet,

tx_hash,

price_usd

from ethereum.core.ez_nft_sales

where platform_name = 'blur'

union all

select -- to_date(date_trunc('day', block_timestamp)) as block_date,

seller_address as wallet,

tx_hash,

price_usd

from ethereum.core.ez_nft_sales

where platform_name = 'blur'

)

group by 1

select wallet,

sales_count

from trader

order by sales_count desc

limit 15