Skills
.Work. You
Rest

rice-data-query

Community

Query Rice Data Portal with DuckDB SQL.

Data & Analytics#SQL#financial data#API query#DuckDB#stock market#data portal#data retrieval
Authorkerryback
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Accessing and querying large financial databases can be complex, requiring specific SQL knowledge and careful handling of access tokens and data types. This skill simplifies querying the Rice Data Portal, ensuring correct data retrieval and local storage, so you can focus on analysis, not data wrangling.

Core Features & Use Cases

  • Simplified Data Access: Expertly construct DuckDB SQL queries for the Rice Data Portal (tickers, prices, fundamentals, insider trades, valuation metrics, etc.).
  • Secure Token Handling: Guides users on securely loading API access tokens using python-dotenv, protecting your credentials.
  • Automated Data Saving: Ensures all queried data is saved locally in Parquet format for future use, preventing repeated queries and saving time.
  • Use Case: Fetch daily adjusted closing prices for a list of tech stocks over the last 5 years, or retrieve quarterly fundamental data for a specific industry, and save it to a local file for offline analysis.

Quick Start

Query the Rice Data Portal for the most recent market capitalization of Apple (AAPL) and Microsoft (MSFT) and save the data to 'market_caps.parquet'.

Dependency Matrix

Required Modules

rice-data-clientpandaspython-dotenv

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: rice-data-query
Download link: https://github.com/kerryback/mgmt638/archive/main.zip#rice-data-query

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository