Updated 2023-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE,
CASE
WHEN DATE_TRUNC('day', BLOCK_TIMESTAMP) >= '2023-01-17' THEN 'A month after Hard Fork'
--WHEN DATE_TRUNC('day', BLOCK_TIMESTAMP) = '2023-01-17' THEN 'Hard Fork'
ELSE 'A month before Hard Fork'
END AS "period",
SUM(AMOUNT) AS "Matic volume",
AVG("Matic volume") OVER (ORDER BY DATE ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS "7MA volume"
FROM
POLYGON.CORE.EZ_MATIC_TRANSFERS
WHERE
DATE_TRUNC('day', BLOCK_TIMESTAMP) >= '2022-12-18'
AND DATE_TRUNC('day', BLOCK_TIMESTAMP) <= '2023-02-15'
GROUP BY
1,
2
Run a query to Download Data