select

block_timestamp::date as date,

tx_hash,

try_parse_json(replace(LOGS[0], 'EVENT_JSON:', '')) as log,

log:event as event,

log:standard as standard,

log:data[0]:offer:from as buyer,

log:data[0]:offer:price/1e24 as price_in_near,

log:data[0]:token_key as token_key,

right(token_key, len(token_key) - charindex(':', token_key)) as seller,

log:data[0]:offer_num as offer_num

from near.core.fact_receipts

where standard in ('mb_market')

and event = 'nft_make_offer'

select

seller,

sum(price_in_near) as total_price_nfts_sold,

max(price_in_near) as max_price,

min(price_in_near) as min_price,

avg(price_in_near) as avg_price,

count(distinct buyer) as unq_buyers,

count(distinct tx_hash) as total_nfts_sold

from offers

group by 1

order by max_price desc

limit 10