shreexVolume USD
    Updated 2022-09-02
    select
    case
    when nft_address='0xb8df6cc3050cc02f967db1ee48330ba23276a492' then 'optipunks'
    when nft_address='0x51e5426ede4e2d4c2586371372313b5782387222' then 'apetimism'
    else nft_address end as nft_collection,
    sum(price_usd) as volume_usd
    from optimism.core.ez_nft_sales where nft_address in ('0x51e5426ede4e2d4c2586371372313b5782387222','0xb8df6cc3050cc02f967db1ee48330ba23276a492')
    GROUP BY nft_collection
    ORDER BY volume_usd
    Run a query to Download Data