count(tx_hash) as no_sale,

count(distinct BUYER_ADDRESS) as no_buyer,

sum(price_usd) as volume,

sum(CREATOR_FEE_USD) as Royalty_fee,

sum(PLATFORM_FEE_USD) as plat_usd,

(Royalty_fee/volume)*100 as percentage_royalty,

(plat_usd/volume)*100 as percentage_platform,

volume/count(date_trunc('day',BLOCK_TIMESTAMP)) as volumeperday,

Royalty_fee/count(date_trunc('day',BLOCK_TIMESTAMP)) as average_royalty,

plat_usd/count(date_trunc('day',BLOCK_TIMESTAMP)) as average_platorm_fee

from ethereum.core.ez_nft_sales

where PLATFORM_NAME='rarible'