(SELECT *

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp::date >= CURRENT_DATE - INTERVAL '2 months'

),

blur_sales AS

(SELECT *, 'WETH' AS symbol

FROM nft_sales

WHERE platform_name = 'blur'),

opensea_sales AS

(SELECT *

FROM nft_sales

WHERE platform_name = 'opensea'),

eth_price AS

(SELECT hour, decimals, symbol

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol = 'WETH'

ORDER BY hour DESC

LIMIT 1),

daily_active AS

(SELECT DATE_TRUNC('day', block_timestamp) AS "Days",

COUNT(DISTINCT buyer_address) AS "Active Users Count"

FROM blur_sales

GROUP BY "Days")

SELECT (SELECT COUNT(DISTINCT (buyer_address)) FROM blur_sales) AS total_active_users,

(SELECT AVG("Active Users Count") FROM daily_active) AS avg_active_users,

(SELECT MAX("Active Users Count") FROM daily_active) AS max_active_users,

(SELECT MIN("Active Users Count") FROM daily_active) AS min_active_users