MLDZMNTweet 1
Updated 2024-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
COUNT(tx_hash) AS transactions,
SUM(transactions) OVER (
ORDER BY
DATE_TRUNC('day', BLOCK_TIMESTAMP)
) AS cumulative_transactions,
AVG(transactions) OVER (
ORDER BY
DATE_TRUNC('day', BLOCK_TIMESTAMP) ROWS BETWEEN 6 PRECEDING
AND CURRENT ROW
) AS seven_day_trailing_avg
FROM
gnosis.core.fact_transactions
WHERE
TO_ADDRESS = lower('0x6B47A6a481dD717526Feaad358fF873f7760B074')
AND STATUS = 'SUCCESS'
GROUP BY
DATE_TRUNC('day', BLOCK_TIMESTAMP)
ORDER BY
day DESC;
QueryRunArchived: QueryRun has been archived