恐惧与贪婪指数数据获取及可视化

原创已于 2025-06-12 21:59:36 修改 · 494 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#投研

于 2025-03-30 16:23:29 首次发布

精选实践专栏收录该内容

49 篇文章

订阅专栏

1. 效果图

在这里插入图片描述

2. ES索引创建

PUT fear_greed
{
  "mappings": {
    "dynamic": "strict",
    "properties": {
      "c_date": {
        "type": "date",
        "format": "yyyy-MM-dd"
      },
      "val": {
        "type": "integer"
      },
      "tag": {
        "type": "keyword"
      }
    }
  }
}

3. 数据定时获取

# 设置API密钥
api_key = "****"  # 替换为您的实际密钥
url = "https://pro-api.coinmarketcap.com/v3/fear-and-greed/historical"
headers = {
    "X-CMC_PRO_API_KEY": api_key,
    "Accept": "application/json"
}
proxies = {
    "http": "http://127.0.0.1:7890",
    "https": "http://127.0.0.1:7890"
}

# 发送请求
params = {"limit": 1}  # 获取最新一天数据
response = requests.get(url, headers=headers, params=params, proxies=proxies)

# 检查响应
if response.status_code == 200:
    data = response.json()
    actions = list()
    processed_count = 0
    for latest in data['data']:
        date = datetime.fromtimestamp(int(latest["timestamp"])).strftime("%Y-%m-%d")
        value = latest["value"]
        classification = latest["value_classification"]

        info = {
            "c_date": date,
            "val": value,
            "tag": classification
        }

        action = {
            "_op_type": "index",
            "_index": "fear_greed",
            "_id": get_unique_id(date),
            "_source": info
        }
        actions.append(action)
        processed_count += 1

        if len(actions) >= 100:
            helpers.bulk(es_client, actions)
            actions.clear()
            print(f"已处理 {processed_count} 条数据")
    if len(actions) > 0:
        helpers.bulk(es_client, actions)
        actions.clear()
        print(f"已处理 {processed_count} 条数据")

else:
    print(f"请求失败: {response.status_code}")