with a as (select dc.symbol, dc.name, count(distinct ens.tokenid) as n_nft,

avg(price_usd) as avg_price

from optimism.core.ez_nft_sales ens

inner join optimism.core.dim_contracts dc

on ens.nft_address = dc.address

group by 1,2),

b as (select name, n_nft, avg_price, n_nft*avg_price as market_cap

from a ),

c as (select sum(market_cap) from b),

f_sales as (select date(block_timestamp) as day, NFT_COLLECTION, currency, sum(price) as sales, avg(price_usd) as avp

from flow.core.ez_nft_sales ens

inner join flow.core.fact_prices fp

on fp.token_contract=ens.currency

group by 1,2,3)

select * from f_sales

limit 100