# Japan Consolidated Equities

Consolidated data from all Japanese equities exchanges.

* Country: Japan [JP]
* Mkt Hours: 08:00-17:00
* Time Zone: Asia/Tokyo
* Start Date: 20081001
* Real Time Available: No
* Bars Available: Yes
* Book Depth Available: No



Details are provided below

* `Table Schemas for JP_COMP`
* `Field Enumerations for JP_COMP`
* `Trading Hours for JP_COMP`
* `Recent Holidays for JP_COMP`



Includes the following coverage:

#### JP_COMP -  Coverage

| Security Type   |   # of Symbols | % of Total   |
|-----------------|----------------|--------------|
| ETF             |            484 | 10.63%       |
| Equity          |           3998 | 87.79%       |
| Preferred Stock |              9 | 0.2%         |
| REIT            |             63 | 1.38%        |
| Total           |           4554 | 100%         |


Consists of 3 Databases

* `JP_COMP`  - Tick Data
* `JP_COMP_BARS`  - 1 Minute Bars
* `JP_COMP_DAILY`  - End of Day Metrics




## JP_COMP

Database includes the following tick types:

* DAY - Daily price and statistical data, e.g. closing price, settlement price, open interest
* NBBO - National Best Bid / Offer quotes
* QTE - Best bid / offer quotes
* STAT - Static data, e.g. ISIN, description, security type
* TRD - Trades





## JP_COMP_BARS

Database includes the following tick types:

* DAY - Daily price and statistical data, e.g. closing price, settlement price, open interest
* QTE_1M - 1-minute quote bars
* TRD_1D - Daily trade bars
* TRD_1M - 1-minute trade bars
* VWAP_1H - 1-hour VWAP bars





## JP_COMP_DAILY

Database includes the following tick types:

* DAY - Daily price and statistical data, e.g. closing price, settlement price, open interest
* STAT - Static data, e.g. ISIN, description, security type