Snowflake Specifications

This section describes how to access the J-Quants Pro dataset using Snowflake and its specifications.

Prerequisites

To use the J-Quants Pro dataset available on Snowflake, you will need to provide your Snowflake account identifier to us when signing the contract. For details on the Snowflake account identifier, please refer to the following official Snowflake documentation.

Contract Procedures

If you'd like to request a trial using five years of historical data provided by Snowflake, or discuss a subscription, please contact us here.

Data Retrieval Method

On Snowflake, the J-Quants Pro dataset tables you have contracted for are made available by sharing Secure Views. The names of the Secure Views for each dataset are as follows:

Dataset

Secure View Name

Listed Issue Information

JQ_INFO_VIEW

Listed Shares

JQ_SHARES_VIEW

Listed Shares Change Factors

JQ_SHARES_CHANGE_VIEW

Stock Prices (OHLC)

JQ_DAILY_QUOTES_VIEW

ToSTNeT Super Large Lot

JQ_TOSTNET_SUPER_LARGE_LOT_VIEW

Trading by Type of Investors

JQ_TRADES_SPEC_VALUE_VIEW and JQ_TRADES_SPEC_VOLUME_VIEW

Detail Breakdown Trading Data

JQ_BREAKDOWN_VIEW

Margin Trading Outstandings (Issues Subject to Daily Publication)

JQ_DAILY_MARGIN_INTEREST_VIEW

Margin Trading Outstandings (Weekly)

JQ_WEEKLY_MARGIN_INTEREST_VIEW

Outstanding Short Selling Positions Reported

JQ_SHORT_SELLING_POSITIONS_VIEW

Financial Data

JQ_STATEMENTS_VIEW

Financial Statement Data (BS/PL/CF)

JQ_FS_DETAILS_VIEW

Derivatives Trading Volume by Participant

JQ_VOLUME_BY_PARTICIPANT_VIEW

Open Interest by Trading Participant

JQ_OPEN_INTEREST_BY_PARTICIPANT_VIEW

Open Interest by Trading Issue

JQ_OPEN_INTEREST_BY_ISSUE_VIEW

Off-Auction Distribution

JQ_OFF_AUCTION_DISTRIBUTION_VIEW

Share Buyback Information (TDnet)

JQ_SHARE_BUYBACK_TDNET_VIEW

Share Buyback Information (EDINET)

JQ_SHARE_BUYBACK_EDINET_VIEW

Off-Auction Share Buyback (ToSTNeT-3)

JQ_OFF_AUCTION_SHARE_BUYBACK_VIEW

Cash Dividend

JQ_DIVIDEND_VIEW

Public Offering/Rights Issue

JQ_PUBLIC_OFFER_RIGHT_ISSUE_VIEW

Stock Split

JQ_STOCK_SPLIT_VIEW

Merger, Equity Swap, and Equity Transfer

JQ_MERGER_EQUITYSWAP_EQUITYTRANSFER_VIEW

Reverse Stock Split

JQ_REVERSE_STOCK_SPLIT_VIEW

Tender Offer

JQ_TOB_BUYBACK_VIEW

General Meeting

JQ_GENERAL_SHAREHOLDERS_MEETING_VIEW

Acquisition of Class Shares subject to Wholly Call/ Demand for Share Cash Out of Special Controlling Shareholders Information

JQ_ACQUISITION_OF_CLASS_SHARES_SUBJECT_TO_WHOLLY_CALL_VIEW

Company Name Change

JQ_COMPANY_NAME_CHANGE_VIEW

Trading Unit Change

JQ_TRADING_UNIT_CHANGE_VIEW

Other Record Dates and Ex-dates

JQ_OTHER_EVENTS_VIEW

Delisting

JQ_DELISTING_VIEW

Change in Securities Master

JQ_CHANGE_OF_STOCK_DETAIL_VIEW

TDnet on Snowflake

JQ_TDNET_VIEW

TDnet on Snowflake Index

JQ_TDNET_INDEX_VIEW

TDnet on Snowflake T+1

VIEW_TDNET_T1

For Trading by Type of Investors, the quantity-based and amount-based data are stored in separate views.

For specific data retrieval methods on Snowflake, please refer to the following official Snowflake documentation.

Available Datasets

The J-Quants Pro datasets available on Snowflake are as follows. For details on the data specifications, please refer to the API specification pages below.

Data Name

Data Period

Data Specifications

Listed Issue Information

May 7, 2008 to present

API Specification > Listed Issue Information > Data Items Overview

Stock Prices (OHLC)

May 7, 2008 to present

API Specification > Stock Prices (OHLC) > Data Items Overview

ToSTNeT Super Large Lot

February 15, 2008 to present

API Specification > ToSTNeT Super Large Lot > Data Items Overview