mohammadhHighest Sales Volume 2
    Updated 2022-06-12
    select sum(PRICE_USD) as volume ,PROJECT_NAME,date_trunc('day', block_timestamp) as block_day
    from ethereum.core.ez_nft_sales
    where PLATFORM_NAME= 'nftx'
    and block_timestamp >= current_date -60
    and EVENT_TYPE ='redeem'
    and (PROJECT_NAME = 'milady' or PROJECT_NAME = 'doodles' or PROJECT_NAME = 'boredapeyachtclub')
    group by block_day,PROJECT_NAME