gayatridodmaniQuery2:Sales in Time Series
    Updated 2022-12-24
    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;
    Run a query to Download Data