Sbhn_NPTop 10 Most Sold NFT Collections on Optimism ~ USD Volume
    Updated 2023-01-15
    select
    project_name,
    count(DISTINCT tx_hash) as sales,
    sum(price_usd) as volume_usd
    from optimism.core.ez_nft_sales
    join optimism.core.dim_labels
    on nft_address=address
    where block_timestamp >= '2022-12-15'
    and event_type = 'sale'
    and price_usd is not null
    group by 1
    order by 3 DESC
    limit 10
    Run a query to Download Data