with cte as (
select left(s.block_timestamp,10) as Date1, s.project_name as Project, m.creator_name, m.creator_address, m.commission_rate, s.creator_fee, s.creator_fee_usd, s.price_usd, m.token_name
from ethereum.core.dim_nft_metadata m
join ethereum.core.ez_nft_sales s on s.tokenid=m.token_id
)
select cte.Date1, cte.price_usd, cte.Project
from cte
where cte.Project like '%boredapeyachtclub'
limit 1000;