Updated 2022-10-19
    SELECT ADDRESS_NAME , sum(price) as price , count(tx_hash) as number
    FROM Ethereum.core.ez_nft_sales A
    left outer join ethereum.core.dim_labels B on A.nft_address= B.address
    where CURRENCY_SYMBOL ilike '%ETH%'
    and ADDRESS_NAME is not NULL
    and LABEL_TYPE ilike '%NFT%'
    GROUP BY 1
    order by 2 DESC
    Run a query to Download Data