PS0G1Collections generating the most volume USD from trades
    Updated 2023-01-06
    --SQL by https://app.flipsidecrypto.com/velocity/queries/97e7e035-6aaf-48b4-9278-01a890e2a506
    select address, label, sum(price_usd) as usd_volume , rank() over (order by usd_volume desc) as rank
    from ethereum.core.ez_nft_sales a join ethereum.core.dim_labels b on a.nft_address = b.address
    where block_timestamp >= '2022-01-01'
    and (EVENT_TYPE = 'sale'
    or event_type = 'bid_won')
    and label <> 'uniswap'
    and label <> 'curve finance'
    and price_usd > 0
    group by 1,2
    order by 3 desc
    limit 30
    Run a query to Download Data