platform_name,

platform_address,

currency_symbol,

currency_address,

count(tx_hash) txns,

sum(platform_fee) marketplace_fees,

sum(platform_fee_usd) marketplace_fees_USD,

sum(creator_fee) creator_fees,

sum(creator_fee_usd) creator_fees_usd,

sum(tx_fee) txn_fees,

sum(tx_fee_usd) txn_fees_usd,

count(buyer_address) buyers,

count(seller_address) sellers,

sum(price) sales,

sum(price_usd) sales_usd

from polygon.core.ez_NFT_SALES

where block_timestamp::date >= CURRENT_DATE - 2

group by block_timestamp::date, platform_name, platform_address, currency_symbol, currency_address

order by date desc