buyer_address as purchaser,

count(distinct(tx_hash)) as txn_number,

count(distinct(tokenid)) as lands_number,

count(distinct seller_address) as sellers_number,

txn_number/sellers_number as tx_per_seller,

sum(price_usd) as volume_usd,

avg(price_usd) as volume_avg,

median(price_usd) as volume_median,

max(price_usd) as volume_max

from ethereum.core.ez_nft_sales

where block_timestamp::date >= current_date - interval '3 months'

and nft_address = '0xf87e31492faf9a91b02ee0deaad50d51d56d5d4d'

group by 1

order by volume_usd desc

limit 20