keshanNFTx Highest Sales Volume
    Updated 2022-06-10
    with top_3 as (select project_name, sum(price_usd) as vol
    from ethereum.core.ez_nft_sales where block_timestamp::date >= CURRENT_DATE - 60 and platform_name='nftx'
    group by project_name
    order by vol desc limit 3)
    select block_timestamp::date as date, count(seller_address) as num_sellers, count(buyer_address) as num_buyers,
    project_name, sum(price_usd) as price_usd, avg(price_usd) as avg_price
    from ethereum.core.ez_nft_sales
    where block_timestamp::date >= CURRENT_DATE - 60 and platform_name='nftx' and project_name in (select project_name from top_3)
    group by date, project_name
    Run a query to Download Data