--need to at where statement that starts data on day of mint or first transaction of project
select
date_trunc('day',block_timestamp) as day,
sum(price),
sum(case when nft_address in (lower('{{Address}}')) then price else 0 end) as Project_Volume,
sum(case when nft_address in (lower('{{Address}}')) then price else 0 end)/sum(price)*100 as "% Market Share"
from
ethereum.core.ez_nft_sales
where currency_symbol in ('WETH','ETH')
and price_usd < 500000
and platform_name = 'opensea'
and block_timestamp >= '{{Min_Date}}'::timestamp
group by 1--, 2, 3
order by 1 desc