SUM(PRICE) as amount_paid_eth, -- I think

SUM(PRICE_USD) as amount_paid_usd,

SUM(TX_FEE_USD) as txn_fees_usd,

SUM(PLATFORM_FEE_USD) as platform_fees_usd,

COUNT(DISTINCT TX_HASH) as txn_count,

project_name as collection

FROM ethereum.core.ez_nft_sales

WHERE platform_name='nftx'

AND block_timestamp::date >= CURRENT_DATE -60

AND event_type = 'redeem'

GROUP BY collection