SELECT BLOCK_TIMESTAMP::DATE AS DAYS, AVG(AMOUNT_USD/AMOUNT) AS MATIC_PRICE

FROM polygon.core.ez_matic_transfers

WHERE DAYS >= '2022-07-01'

GROUP BY DAYS

),

TRANSACTIONS AS (SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(DISTINCT(FROM_ADDRESS)) AS UNIQUE_WALLETS, COUNT(DISTINCT(TX_HASH)) AS NUMBER_OF_TRANSACTIONS

FROM polygon.core.fact_transactions

WHERE DAYS >= '2022-07-01'

GROUP BY DAYS)

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

FROM MATIC

JOIN TRANSACTIONS ON MATIC.DAYS = TRANSACTIONS.DAYS