BLOCK_TIMESTAMP::date,

PLATFORM_NAME,

NFT_ADDRESS,

PROJECT_NAME,

sum(PRICE_USD) as TOTAL_PRICE_USD

FROM flipside_prod_db.ethereum_core.ez_nft_sales

WHERE PLATFORM_NAME ='nftx'

AND EVENT_TYPE = 'redeem'

AND BLOCK_TIMESTAMP >='2022-04-14'

GROUP BY 1,2,3,4

ORDER BY TOTAL_PRICE_USD desc