skills.rest
kerryback
kerrybackCOMMUNITY
Explore all skills by this author →
GitHub

rice-data-query

Query the Rice Data Portal with DuckDB SQL and save results as Parquet files.

Updated Jun 20, 2025
Search Tags:#SQL#financial data#API query#DuckDB#stock market#data portal#data retrieval
One-click install
npx skills add https://github.com/kerryback/mgmt638 --skill rice-data-query
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: rice-data-query
Source: https://github.com/kerryback/mgmt638/tree/main/.claude/skills/rice-data-query
Command: npx skills add https://github.com/kerryback/mgmt638 --skill rice-data-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires rice-data-client, pandas, python-dotenv.

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'.