提供一个指标数据库的示范脚本

好的，下面是一个简单的指标数据库示范脚本，用于记录和查询指标数据：

import sqlite3

# 创建指标数据库和表格
conn = sqlite3.connect('indicators.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS indicators
             (id INTEGER PRIMARY KEY,
              name TEXT,
              value REAL,
              date TEXT)''')

# 插入指标数据
def insert_indicator(name, value, date):
    c.execute("INSERT INTO indicators (name, value, date) VALUES (?, ?, ?)", (name, value, date))
    conn.commit()
    print("Inserted indicator data: {} {} {}".format(name, value, date))

# 查询指标数据
def query_indicator(name, start_date=None, end_date=None):
    if start_date and end_date:
        c.execute("SELECT value FROM indicators WHERE name=? AND date BETWEEN ? AND ?", (name, start_date, end_date))
    elif start_date:
        c.execute("SELECT value FROM indicators WHERE name=? AND date>=?", (name, start_date))
    elif end_date:
        c.execute("SELECT value FROM indicators WHERE name=? AND date<=?", (name, end_date))
    else:
        c.execute("SELECT value FROM indicators WHERE name=?", (name,))
    result = c.fetchall()
    if result:
        values = [row[0] for row in result]
        avg = sum(values) / len(values)
        print("Average value of {} between {} and {}: {}".format(name, start_date, end_date, avg))
    else:
        print("No data found for indicator {}".format(name))

# 测试插入和查询
insert_indicator("stock_price", 100.0, "2021-01-01")
insert_indicator("stock_price", 110.0, "2021-01-02")
insert_indicator("stock_price", 120.0, "2021-01-03")
query_indicator("stock_price", "2021-01-01", "2021-01-03")

这个脚本使用 SQLite 数据库来存储指标数据，并提供了插入和查询指标数据的功能。你可以根据需要修改表格结构和查询逻辑。