select

block_timestamp,

tx_hash,

seller_address,

buyer_address,

nft_address,

currency_symbol,

price_usd

from optimism.core.ez_nft_sales

where event_type = 'sale'

and block_timestamp::date <= current_date - 1

and price_usd is not null

select

seller_address,

count(distinct tx_hash) as "Number of NFT Sales",

sum(price_usd) as "Total Sales Volume (USD)"

from quixotic_base_sales

group by seller_address

order by "Total Sales Volume (USD)" desc

limit 10