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(TX_HASH)) AS NUMBER_OF_TRANSACTIONS

FROM polygon.core.fact_transactions

WHERE DAYS >= '2022-07-01'

GROUP BY DAYS)

SELECT MATIC.*, NUMBER_OF_TRANSACTIONS AS "Number of transactions"

FROM MATIC

JOIN TRANSACTIONS ON MATIC.DAYS = TRANSACTIONS.DAYS