date_trunc('week', block_timestamp) AS week

, COUNT(tx_hash) AS Transactions

, SUM(Transactions) OVER (ORDER BY week) AS Total_sales

, COUNT(DISTINCT origin_from_address) AS Traders

, SUM(price_usd) AS Volume

, SUM(Volume) OVER (ORDER BY week) AS Total_Volume

, SUM(creator_fee_usd) AS Creator_fees

, SUM(Creator_fees) OVER (ORDER BY week) AS Total_Creator_fees

, SUM(platform_fee_usd) AS Platform_fees

, SUM(Platform_fees) OVER (ORDER BY week) AS Total_Platform_fees

, SUM(total_fees_usd) AS Generated_fees

, SUM(Generated_fees) OVER (ORDER BY week) AS Total_generated_fees

, SUM(tx_fee_usd) AS Transaction_fees

, SUM(Transaction_fees) OVER (ORDER BY week) AS Total_Transaction_fees

FROM

base.nft.ez_nft_sales

nft_address = lower('0x217Ec1aC929a17481446A76Ff9B95B9a64F298cF')

GROUP BY 1

ORDER BY 1 DESC