select DISTINCT

m.token_name,

e.token_id,

m.token_metadata:curation_status::string AS collection,

e.price,

e.platform_fee,

e.creator_fee

from ethereum.nft_events E, ethereum.nft_metadata M

where e.block_timestamp between '2021-07-01' and '2021-08-01'

AND e.event_platform = 'art_blocks'

AND e.event_type = 'sale'

AND e.token_id = m.token_id

select replace(regexp_substr(token_name, '(.*) #'),' #','') AS ProjectName,

count(distinct token_name) AS TotalSold,

round(avg(price),3) AS AvgPriceETH,

sum(price) AS totalETHspent,

sum(platform_fee) AS ArtBlocksFeesCollectedETH,

sum(creator_fee) AS CreatorFeesCollectedETH

from ABsales

group by 1

order by 3 desc