PREVIEW / stock_5min / 2016-07-27
file: by_date/stock_5min/2016/2016-07-27.parquet size: 5.4 MB rows: 355,588 symbols: 3,275
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 |
|---|---|---|---|---|---|---|---|
| 2016-07-27 04:00:00 | AAPL | Stock | 25.465 | 25.7975 | 25.465 | 25.7475 | 143220.0 |
| 2016-07-27 04:05:00 | AAPL | Stock | 25.7125 | 25.7925 | 25.71 | 25.7525 | 24424.0 |
| 2016-07-27 04:10:00 | AAPL | Stock | 25.75 | 25.77 | 25.725 | 25.7375 | 5084.0 |
| 2016-07-27 04:15:00 | AAPL | Stock | 25.7375 | 25.7625 | 25.7375 | 25.7625 | 12272.0 |
| 2016-07-27 04:20:00 | AAPL | Stock | 25.75 | 25.755 | 25.72 | 25.72 | 4280.0 |
| 2016-07-27 04:25:00 | AAPL | Stock | 25.72 | 25.7225 | 25.69 | 25.7175 | 15160.0 |
| 2016-07-27 04:30:00 | AAPL | Stock | 25.71 | 25.71 | 25.7 | 25.7 | 6028.0 |
| 2016-07-27 04:35:00 | AAPL | Stock | 25.69 | 25.69 | 25.665 | 25.665 | 7676.0 |
| 2016-07-27 04:40:00 | AAPL | Stock | 25.68 | 25.68 | 25.6375 | 25.6375 | 16528.0 |
| 2016-07-27 04:45:00 | AAPL | Stock | 25.64 | 25.665 | 25.64 | 25.6625 | 14652.0 |
| 2016-07-27 04:50:00 | AAPL | Stock | 25.6625 | 25.6625 | 25.66 | 25.6625 | 6000.0 |
| 2016-07-27 04:55:00 | AAPL | Stock | 25.6325 | 25.6325 | 25.62 | 25.62 | 24212.0 |
| 2016-07-27 05:00:00 | AAPL | Stock | 25.625 | 25.625 | 25.5625 | 25.565 | 11928.0 |
| 2016-07-27 05:05:00 | AAPL | Stock | 25.57 | 25.5925 | 25.56 | 25.59 | 25080.0 |
| 2016-07-27 05:10:00 | AAPL | Stock | 25.615 | 25.65 | 25.615 | 25.62 | 50896.0 |
| 2016-07-27 05:15:00 | AAPL | Stock | 25.625 | 25.625 | 25.6025 | 25.615 | 14632.0 |
| 2016-07-27 05:20:00 | AAPL | Stock | 25.615 | 25.615 | 25.6 | 25.6 | 5524.0 |
| 2016-07-27 05:25:00 | AAPL | Stock | 25.6 | 25.6 | 25.575 | 25.575 | 1600.0 |
| 2016-07-27 05:30:00 | AAPL | Stock | 25.6075 | 25.6075 | 25.575 | 25.575 | 2156.0 |
| 2016-07-27 05:35:00 | AAPL | Stock | 25.57 | 25.57 | 25.57 | 25.57 | 540.0 |
| 2016-07-27 05:40:00 | AAPL | Stock | 25.5725 | 25.61 | 25.57 | 25.61 | 26928.0 |
| 2016-07-27 05:45:00 | AAPL | Stock | 25.61 | 25.6225 | 25.5925 | 25.5925 | 15940.0 |
| 2016-07-27 05:50:00 | AAPL | Stock | 25.6175 | 25.62 | 25.6125 | 25.6125 | 9556.0 |
| 2016-07-27 05:55:00 | AAPL | Stock | 25.61 | 25.6375 | 25.605 | 25.6375 | 31556.0 |
| 2016-07-27 06:00:00 | AAPL | Stock | 25.6375 | 25.68 | 25.6375 | 25.675 | 44044.0 |
| 2016-07-27 06:05:00 | AAPL | Stock | 25.68 | 25.745 | 25.67 | 25.74 | 134132.0 |
| 2016-07-27 06:10:00 | AAPL | Stock | 25.745 | 25.78 | 25.745 | 25.75 | 88144.0 |
| 2016-07-27 06:15:00 | AAPL | Stock | 25.76 | 25.8375 | 25.75 | 25.8125 | 156060.0 |
| 2016-07-27 06:20:00 | AAPL | Stock | 25.825 | 25.8375 | 25.8 | 25.8175 | 65844.0 |
| 2016-07-27 06:25:00 | AAPL | Stock | 25.8125 | 25.8325 | 25.8 | 25.8275 | 95980.0 |
| 2016-07-27 06:30:00 | AAPL | Stock | 25.8125 | 25.8125 | 25.8 | 25.8125 | 42160.0 |
| 2016-07-27 06:35:00 | AAPL | Stock | 25.8125 | 25.825 | 25.8 | 25.8025 | 50912.0 |
| 2016-07-27 06:40:00 | AAPL | Stock | 25.8075 | 25.8075 | 25.8075 | 25.8075 | 400.0 |
| 2016-07-27 06:45:00 | AAPL | Stock | 25.8 | 25.8025 | 25.8 | 25.8025 | 3276.0 |
| 2016-07-27 06:50:00 | AAPL | Stock | 25.8 | 25.8025 | 25.775 | 25.8 | 26748.0 |
| 2016-07-27 06:55:00 | AAPL | Stock | 25.7875 | 25.8 | 25.7875 | 25.7975 | 3600.0 |
| 2016-07-27 07:00:00 | AAPL | Stock | 25.8 | 25.825 | 25.7875 | 25.805 | 102232.0 |
| 2016-07-27 07:05:00 | AAPL | Stock | 25.805 | 25.8325 | 25.8 | 25.8125 | 83104.0 |
| 2016-07-27 07:10:00 | AAPL | Stock | 25.8225 | 25.8225 | 25.8 | 25.8175 | 39784.0 |
| 2016-07-27 07:15:00 | AAPL | Stock | 25.8125 | 25.8925 | 25.81 | 25.8925 | 204260.0 |
| 2016-07-27 07:20:00 | AAPL | Stock | 25.8975 | 25.9175 | 25.875 | 25.91 | 124992.0 |
| 2016-07-27 07:25:00 | AAPL | Stock | 25.9 | 25.9125 | 25.8525 | 25.8525 | 45712.0 |
| 2016-07-27 07:30:00 | AAPL | Stock | 25.8675 | 25.8725 | 25.785 | 25.835 | 413516.0 |
| 2016-07-27 07:35:00 | AAPL | Stock | 25.835 | 25.875 | 25.8125 | 25.8125 | 211672.0 |
| 2016-07-27 07:40:00 | AAPL | Stock | 25.8225 | 25.8625 | 25.815 | 25.8625 | 188824.0 |
| 2016-07-27 07:45:00 | AAPL | Stock | 25.86 | 25.93 | 25.845 | 25.9025 | 220240.0 |
| 2016-07-27 07:50:00 | AAPL | Stock | 25.91 | 25.9425 | 25.9 | 25.9425 | 316508.0 |
| 2016-07-27 07:55:00 | AAPL | Stock | 25.9375 | 25.9875 | 25.9125 | 25.9375 | 617524.0 |
| 2016-07-27 08:00:00 | AAPL | Stock | 25.9375 | 25.975 | 25.6125 | 25.91 | 1022360.0 |
| 2016-07-27 08:05:00 | AAPL | Stock | 25.9 | 25.9475 | 25.8625 | 25.9475 | 526584.0 |
> showing 50 of 355,588 rows — these rows as CSV