Updated 2022-11-24
    WITH c1 AS (
    SELECT * FROM ethereum.core.ez_nft_sales
    WHERE event_type = 'sale'
    AND NFT_ADDRESS= lower('0xFDe881c7B76ad10B59a82247E1cD3CBAd0d739F3')
    AND buyer_address <> '0x0000000000000000000000000000000000000000'
    AND price <> '0'
    )

    SELECT tokenid, sum(price_usd)as total_volume_usd
    FROM c1
    where price_usd is not null
    group by 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data