Tobi_12024-06-09 12:21 PM
Updated 2024-08-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
⌄
SELECT
TRUNC(BLOCK_TIMESTAMP, 'day') AS transaction_day,
SUM(VALUE) AS total_transaction_volume
FROM
polygon.core.fact_transactions;
WHERE
BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())
AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP()
GROUP BY
TRUNC(BLOCK_TIMESTAMP, 'day')
ORDER BY
transaction_day;
QueryRunArchived: QueryRun has been archived