PREVIEW / stock_5min / 2013-07-26
file: by_date/stock_5min/2013/2013-07-26.parquet size: 5.0 MB rows: 331,480 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-26 04:00:00 | AAPL | Stock | 15.665 | 15.6946 | 15.665 | 15.6946 | 14000.0 |
| 2013-07-26 04:10:00 | AAPL | Stock | 15.6857 | 15.6857 | 15.6857 | 15.6857 | 2800.0 |
| 2013-07-26 05:45:00 | AAPL | Stock | 15.6571 | 15.6571 | 15.6432 | 15.6432 | 8792.0 |
| 2013-07-26 06:05:00 | AAPL | Stock | 15.6071 | 15.6071 | 15.6071 | 15.6071 | 7560.0 |
| 2013-07-26 06:10:00 | AAPL | Stock | 15.6732 | 15.6732 | 15.6732 | 15.6732 | 4060.0 |
| 2013-07-26 06:35:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 9856.0 |
| 2013-07-26 06:45:00 | AAPL | Stock | 15.6146 | 15.6146 | 15.6146 | 15.6146 | 8400.0 |
| 2013-07-26 07:20:00 | AAPL | Stock | 15.6232 | 15.6232 | 15.6146 | 15.6175 | 19600.0 |
| 2013-07-26 07:30:00 | AAPL | Stock | 15.6143 | 15.6143 | 15.6143 | 15.6143 | 2800.0 |
| 2013-07-26 07:50:00 | AAPL | Stock | 15.6371 | 15.6393 | 15.6371 | 15.6393 | 5600.0 |
| 2013-07-26 07:55:00 | AAPL | Stock | 15.6357 | 15.6357 | 15.6268 | 15.6268 | 11200.0 |
| 2013-07-26 08:00:00 | AAPL | Stock | 15.64 | 15.6429 | 15.63 | 15.6311 | 21000.0 |
| 2013-07-26 08:05:00 | AAPL | Stock | 15.6243 | 15.6243 | 15.6079 | 15.6086 | 52220.0 |
| 2013-07-26 08:10:00 | AAPL | Stock | 15.6129 | 15.6239 | 15.6129 | 15.6136 | 17080.0 |
| 2013-07-26 08:15:00 | AAPL | Stock | 15.62 | 15.6243 | 15.6139 | 15.6243 | 23800.0 |
| 2013-07-26 08:20:00 | AAPL | Stock | 15.6293 | 15.6296 | 15.6293 | 15.6296 | 5600.0 |
| 2013-07-26 08:25:00 | AAPL | Stock | 15.6279 | 15.6286 | 15.6268 | 15.6268 | 81200.0 |
| 2013-07-26 08:30:00 | AAPL | Stock | 15.6268 | 15.6268 | 15.6168 | 15.6193 | 28000.0 |
| 2013-07-26 08:35:00 | AAPL | Stock | 15.6218 | 15.6218 | 15.6129 | 15.615 | 50400.0 |
| 2013-07-26 08:40:00 | AAPL | Stock | 15.6129 | 15.6129 | 15.6071 | 15.6071 | 44240.0 |
| 2013-07-26 08:45:00 | AAPL | Stock | 15.6 | 15.6 | 15.5929 | 15.5968 | 81508.0 |
| 2013-07-26 08:50:00 | AAPL | Stock | 15.6 | 15.6 | 15.6 | 15.6 | 2800.0 |
| 2013-07-26 08:55:00 | AAPL | Stock | 15.5964 | 15.6068 | 15.5964 | 15.6068 | 35784.0 |
| 2013-07-26 09:00:00 | AAPL | Stock | 15.6064 | 15.6143 | 15.6036 | 15.6064 | 203616.0 |
| 2013-07-26 09:05:00 | AAPL | Stock | 15.5975 | 15.5982 | 15.5904 | 15.5982 | 84000.0 |
| 2013-07-26 09:10:00 | AAPL | Stock | 15.5946 | 15.5993 | 15.5893 | 15.5918 | 151900.0 |
| 2013-07-26 09:15:00 | AAPL | Stock | 15.5918 | 15.6 | 15.5918 | 15.5918 | 52024.0 |
| 2013-07-26 09:20:00 | AAPL | Stock | 15.5961 | 15.5961 | 15.5961 | 15.5961 | 5600.0 |
| 2013-07-26 09:25:00 | AAPL | Stock | 15.5929 | 15.5929 | 15.5375 | 15.55 | 460236.0 |
| 2013-07-26 09:30:00 | AAPL | Stock | 15.5536 | 15.5975 | 15.5121 | 15.5869 | 11188044.0 |
| 2013-07-26 09:35:00 | AAPL | Stock | 15.5964 | 15.6311 | 15.5868 | 15.6239 | 5720260.0 |
| 2013-07-26 09:40:00 | AAPL | Stock | 15.6239 | 15.635 | 15.5964 | 15.6029 | 4097380.0 |
| 2013-07-26 09:45:00 | AAPL | Stock | 15.5965 | 15.6032 | 15.5754 | 15.5804 | 3130428.0 |
| 2013-07-26 09:50:00 | AAPL | Stock | 15.583 | 15.6375 | 15.5768 | 15.6371 | 3775016.0 |
| 2013-07-26 09:55:00 | AAPL | Stock | 15.6346 | 15.6736 | 15.6311 | 15.6607 | 6531196.0 |
| 2013-07-26 10:00:00 | AAPL | Stock | 15.6636 | 15.6714 | 15.6486 | 15.6689 | 3772804.0 |
| 2013-07-26 10:05:00 | AAPL | Stock | 15.6689 | 15.7032 | 15.6661 | 15.6944 | 4218648.0 |
| 2013-07-26 10:10:00 | AAPL | Stock | 15.6943 | 15.6943 | 15.6564 | 15.6602 | 2999528.0 |
| 2013-07-26 10:15:00 | AAPL | Stock | 15.66 | 15.6782 | 15.6414 | 15.675 | 2978864.0 |
| 2013-07-26 10:20:00 | AAPL | Stock | 15.6764 | 15.69 | 15.6679 | 15.6852 | 2931824.0 |
| 2013-07-26 10:25:00 | AAPL | Stock | 15.6854 | 15.69 | 15.6432 | 15.665 | 2918272.0 |
| 2013-07-26 10:30:00 | AAPL | Stock | 15.6614 | 15.7136 | 15.6589 | 15.7136 | 2754332.0 |
| 2013-07-26 10:35:00 | AAPL | Stock | 15.7121 | 15.7136 | 15.6721 | 15.6986 | 3232544.0 |
| 2013-07-26 10:40:00 | AAPL | Stock | 15.6989 | 15.7207 | 15.6939 | 15.7046 | 4321548.0 |
| 2013-07-26 10:45:00 | AAPL | Stock | 15.7054 | 15.7093 | 15.6554 | 15.6657 | 4374804.0 |
| 2013-07-26 10:50:00 | AAPL | Stock | 15.6654 | 15.6841 | 15.6518 | 15.66 | 3177216.0 |
| 2013-07-26 10:55:00 | AAPL | Stock | 15.6625 | 15.6757 | 15.6368 | 15.6664 | 5202484.0 |
| 2013-07-26 11:00:00 | AAPL | Stock | 15.6664 | 15.6796 | 15.6618 | 15.6771 | 3789184.0 |
| 2013-07-26 11:05:00 | AAPL | Stock | 15.6693 | 15.6975 | 15.6693 | 15.6821 | 4164160.0 |
| 2013-07-26 11:10:00 | AAPL | Stock | 15.6818 | 15.6964 | 15.6714 | 15.6882 | 1044344.0 |
> showing 50 of 331,480 rows — these rows as CSV