SELECT BLOCK_TIMESTAMP::DATE AS DAYS, AVG(AMOUNT_USD/AMOUNT) AS "Matic price($)"

FROM polygon.core.ez_matic_transfers

WHERE DAYS BETWEEN '2022-07-01' AND CURRENT_DATE-1

GROUP BY DAYS

),

WALLETS AS (SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(DISTINCT(FROM_ADDRESS)) AS UNIQUE_WALLETS

FROM polygon.core.fact_transactions

WHERE DAYS BETWEEN '2022-07-01' AND CURRENT_DATE-1

GROUP BY DAYS)

SELECT MATIC.*, UNIQUE_WALLETS AS "Number of unique wallets"

FROM MATIC

JOIN WALLETS ON MATIC.DAYS = WALLETS.DAYS