NFT_ADDRESS as mnt

from flipside_prod_db.ethereum_core.ez_nft_mints

where block_timestamp>='2022-01-01'

select

date_trunc('day',block_timestamp) as dt,

count (distinct NFT_ADDRESS) as daily_mint,

count (distinct PROJECT_NAME) as daily_project,

sum (PRICE_USD) as daily_sale,

sum(daily_mint) over (order by dt asc) as mint_growth,

sum(daily_project) over (order by dt asc) as project_growth,

sum(daily_sale) over (order by dt asc) as sale_growth

from flipside_prod_db.ethereum_core.ez_nft_sales

where PLATFORM_NAME= 'opensea'

and NFT_ADDRESS in (select mnt from t1)

and PROJECT_NAME is not null

and dt>='2022-01-01'

group by 1

order by 1