platform_name,

COUNT(DISTINCT tx_hash) AS transaction_count,

COUNT(DISTINCT buyer_address) AS unique_buyer,

COUNT(DISTINCT seller_address) AS unique_seller,

SUM(total_price) AS transaction_volume,

sum(platform_fee) as protocol_fee,

sum(creator_fee) as creator_fees,

sum(total_fees) as total_fee,

transaction_count / unique_buyer AS average_transactions_per_user,

transaction_volume / unique_buyer AS average_volume_per_user,

transaction_volume / transaction_count AS average_volume_per_transaction,

protocol_fee / transaction_count AS average_protocl_fee,

creator_fees / transaction_count AS average_creator_fee,

total_fee / transaction_count AS average_total_fee,

total_fee / unique_buyer AS average_total_fee_per_user

FROM

aptos.nft.ez_nft_sales

WHERE

block_timestamp::date >= current_date - interval '30 days'

group by platform_name