PROJECT_NAME as NFT_collections,

min(BLOCK_TIMESTAMP),

count(tx_hash) as no_sale,

count(distinct BUYER_ADDRESS) as buyer_no,

sum(price) as ETH_value,

sum(price_usd) as volume,

sum(CREATOR_FEE_USD) as Royalty_fee,

sum(PLATFORM_FEE_USD) as plat_fee,

avg(price_usd) as avg_volume,

Royalty_fee/volume*100 as percentage_royalty_fee,

buyer_no/count(distinct date_trunc(day, block_timestamp)) as average_buyer_day,

volume/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,

Royalty_fee/count(distinct date_trunc(day, block_timestamp)) as average_volume_day

from ethereum.core.ez_nft_sales

where price_usd is not NULL

and CREATOR_FEE_USD is not null

and PROJECT_NAME='art blocks'

group by 1 having NFT_collections is not null

order by 5 desc limit 10