WITH all_sales AS (
SELECT *,
CREATOR_FEE/PRICE as royalty_percentage
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp > CURRENT_DATE - 90
AND platform_name = 'opensea'
AND price > 0
)
SELECT
block_timestamp::date as date,
min(royalty_percentage) as "Minimum",
max(royalty_percentage) as "Maximum",
avg(royalty_percentage) as "Average",
median(royalty_percentage) as "Median"
FROM all_sales
GROUP BY date