(SELECT date_trunc('Day', BLOCK_TIMESTAMP) AS Day, COUNT(DISTINCT(FROM_ADDRESS)) AS "Number of daily users",

COUNT(DISTINCT(TX_HASH)) AS "Number of daily transactions",

SUM(TX_FEE) AS "Fees spent for transactions",

"Fees spent for transactions" / "Number of daily transactions" AS "Average fee spent per transaction",

SUM(MATIC_VALUE) AS "Volume of transaction",

CASE

WHEN BLOCK_NUMBER >= 38189056 THEN 'After hard fork'

WHEN BLOCK_NUMBER < 38189056 THEN 'Before hard fork'

END AS TYPE

FROM polygon.core.fact_transactions

WHERE BLOCK_TIMESTAMP::DATE BETWEEN '2022-12-17' AND '2023-02-17'

GROUP BY Day, TYPE)

SELECT * FROM AVERAGE_GAS_PRICE