mrwildcatpyth sei daily contracts
Updated 2025-02-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from pyth ethereum daily contracts @ https://flipsidecrypto.xyz/edit/queries/c098e37e-1f21-45c8-8978-7b1a9e6cbe75
-- forked from pyth polygon daily contracts @ https://flipsidecrypto.xyz/edit/queries/5ef24d4d-6456-4cee-ae85-a5fd69c60434
WITH daily_contracts AS (
SELECT DATE_TRUNC('day', block_timestamp) as date,
COUNT(DISTINCT from_address) as daily_contracts
FROM sei.core_evm.fact_traces
WHERE to_address = LOWER('0x2880aB155794e7179c9eE2e38200202908C17B43')
AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
GROUP BY 1
)
SELECT
date,
daily_contracts,
AVG(daily_contracts) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as seven_day_avg,
SUM(daily_contracts) OVER (ORDER BY date) as cumulative_contracts
FROM daily_contracts
ORDER BY date
QueryRunArchived: QueryRun has been archived