PREVIEW / stock_5min / 2015-09-14
file: by_date/stock_5min/2015/2015-09-14.parquet size: 5.2 MB rows: 350,080 symbols: 3,435
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2015-09-14 04:00:00 | AAPL | Stock | 28.5725 | 28.75 | 28.5725 | 28.6625 | 10584.0 |
| 2015-09-14 04:05:00 | AAPL | Stock | 28.675 | 28.69 | 28.675 | 28.69 | 4720.0 |
| 2015-09-14 04:20:00 | AAPL | Stock | 28.675 | 28.675 | 28.67 | 28.67 | 3200.0 |
| 2015-09-14 04:30:00 | AAPL | Stock | 28.6675 | 28.6675 | 28.6675 | 28.6675 | 3600.0 |
| 2015-09-14 04:50:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 3524.0 |
| 2015-09-14 04:55:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 1600.0 |
| 2015-09-14 05:00:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 1200.0 |
| 2015-09-14 05:15:00 | AAPL | Stock | 28.7 | 28.7125 | 28.7 | 28.7125 | 3748.0 |
| 2015-09-14 05:20:00 | AAPL | Stock | 28.6975 | 28.7 | 28.6975 | 28.7 | 3600.0 |
| 2015-09-14 05:30:00 | AAPL | Stock | 28.68 | 28.68 | 28.68 | 28.68 | 400.0 |
| 2015-09-14 05:40:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 2000.0 |
| 2015-09-14 05:45:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6625 | 28.6625 | 1292.0 |
| 2015-09-14 05:55:00 | AAPL | Stock | 28.6875 | 28.6875 | 28.6875 | 28.6875 | 1200.0 |
| 2015-09-14 06:00:00 | AAPL | Stock | 28.685 | 28.7125 | 28.685 | 28.71 | 15256.0 |
| 2015-09-14 06:05:00 | AAPL | Stock | 28.705 | 28.7225 | 28.6925 | 28.7225 | 6480.0 |
| 2015-09-14 06:10:00 | AAPL | Stock | 28.7025 | 28.725 | 28.7 | 28.7125 | 14320.0 |
| 2015-09-14 06:15:00 | AAPL | Stock | 28.7125 | 28.7475 | 28.7 | 28.7 | 19016.0 |
| 2015-09-14 06:20:00 | AAPL | Stock | 28.7175 | 28.73 | 28.705 | 28.73 | 2800.0 |
| 2015-09-14 06:25:00 | AAPL | Stock | 28.7225 | 28.74 | 28.7125 | 28.7375 | 16096.0 |
| 2015-09-14 06:30:00 | AAPL | Stock | 28.725 | 28.75 | 28.725 | 28.745 | 20344.0 |
| 2015-09-14 06:35:00 | AAPL | Stock | 28.755 | 28.8 | 28.755 | 28.7975 | 67080.0 |
| 2015-09-14 06:40:00 | AAPL | Stock | 28.805 | 28.8375 | 28.795 | 28.8375 | 78176.0 |
| 2015-09-14 06:45:00 | AAPL | Stock | 28.8425 | 28.8475 | 28.8175 | 28.8425 | 42536.0 |
| 2015-09-14 06:50:00 | AAPL | Stock | 28.845 | 28.8475 | 28.8125 | 28.8475 | 37008.0 |
| 2015-09-14 06:55:00 | AAPL | Stock | 28.8275 | 28.8425 | 28.825 | 28.8425 | 9600.0 |
| 2015-09-14 07:00:00 | AAPL | Stock | 28.83 | 28.8475 | 28.825 | 28.8475 | 52724.0 |
| 2015-09-14 07:05:00 | AAPL | Stock | 28.845 | 28.8875 | 28.845 | 28.885 | 76948.0 |
| 2015-09-14 07:10:00 | AAPL | Stock | 28.8775 | 28.895 | 28.8675 | 28.885 | 93868.0 |
| 2015-09-14 07:15:00 | AAPL | Stock | 28.885 | 28.9175 | 28.875 | 28.9125 | 36132.0 |
| 2015-09-14 07:20:00 | AAPL | Stock | 28.9125 | 28.95 | 28.8975 | 28.95 | 107076.0 |
| 2015-09-14 07:25:00 | AAPL | Stock | 28.95 | 28.985 | 28.95 | 28.96 | 50748.0 |
| 2015-09-14 07:30:00 | AAPL | Stock | 28.96 | 28.9875 | 28.9275 | 28.9525 | 76236.0 |
| 2015-09-14 07:35:00 | AAPL | Stock | 28.9475 | 28.9625 | 28.9325 | 28.9625 | 58800.0 |
| 2015-09-14 07:40:00 | AAPL | Stock | 28.955 | 28.975 | 28.9425 | 28.9425 | 142508.0 |
| 2015-09-14 07:45:00 | AAPL | Stock | 28.95 | 28.95 | 28.925 | 28.945 | 34552.0 |
| 2015-09-14 07:50:00 | AAPL | Stock | 28.95 | 29.03 | 28.95 | 29.025 | 103856.0 |
| 2015-09-14 07:55:00 | AAPL | Stock | 29.005 | 29.0275 | 28.9375 | 28.9375 | 121972.0 |
| 2015-09-14 08:00:00 | AAPL | Stock | 28.9325 | 29.0275 | 28.6875 | 28.955 | 594932.0 |
| 2015-09-14 08:05:00 | AAPL | Stock | 28.955 | 28.96 | 28.91 | 28.91 | 150340.0 |
| 2015-09-14 08:10:00 | AAPL | Stock | 28.9025 | 28.9075 | 28.8575 | 28.8975 | 151288.0 |
| 2015-09-14 08:15:00 | AAPL | Stock | 28.895 | 28.93 | 28.8875 | 28.93 | 97868.0 |
| 2015-09-14 08:20:00 | AAPL | Stock | 28.93 | 28.965 | 28.93 | 28.955 | 121324.0 |
| 2015-09-14 08:25:00 | AAPL | Stock | 28.95 | 28.9575 | 28.915 | 28.9325 | 78852.0 |
| 2015-09-14 08:30:00 | AAPL | Stock | 28.9275 | 28.9275 | 28.845 | 28.8675 | 150792.0 |
| 2015-09-14 08:35:00 | AAPL | Stock | 28.8675 | 29.0725 | 28.8675 | 29.065 | 660600.0 |
| 2015-09-14 08:40:00 | AAPL | Stock | 29.075 | 29.2675 | 29.075 | 29.25 | 1435932.0 |
| 2015-09-14 08:45:00 | AAPL | Stock | 29.25 | 29.2525 | 29.105 | 29.13 | 813576.0 |
| 2015-09-14 08:50:00 | AAPL | Stock | 29.125 | 29.1975 | 29.1 | 29.18 | 421932.0 |
| 2015-09-14 08:55:00 | AAPL | Stock | 29.1725 | 29.2575 | 29.13 | 29.2025 | 613512.0 |
| 2015-09-14 09:00:00 | AAPL | Stock | 29.2075 | 29.2375 | 29.175 | 29.2225 | 377732.0 |
> showing 50 of 350,080 rows — these rows as CSV