mattkstewOptimistic Bears 12
    Updated 2022-08-08
    select
    project_name,
    sum(price) as Sales_Volume_ETH

    from optimism.core.ez_nft_sales left outer join optimism.core.dim_labels
    on nft_address = address
    where price is not null
    and project_name is not null
    and block_timestamp between '2022-07-01' and '2022-08-01'
    group by 1
    order by 2 DESC
    limit 10
    Run a query to Download Data