PREVIEW / stock_5min / 2013-11-22
file: by_date/stock_5min/2013/2013-11-22.parquet size: 5.3 MB rows: 350,617 symbols: 3,569
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-11-22 04:10:00 | AAPL | Stock | 18.67 | 18.6786 | 18.6689 | 18.6689 | 11200.0 |
| 2013-11-22 04:45:00 | AAPL | Stock | 18.66 | 18.66 | 18.66 | 18.66 | 4200.0 |
| 2013-11-22 04:50:00 | AAPL | Stock | 18.6539 | 18.6539 | 18.6539 | 18.6539 | 2800.0 |
| 2013-11-22 05:15:00 | AAPL | Stock | 18.6479 | 18.6479 | 18.6479 | 18.6479 | 2800.0 |
| 2013-11-22 06:40:00 | AAPL | Stock | 18.6286 | 18.6286 | 18.6286 | 18.6286 | 2800.0 |
| 2013-11-22 07:00:00 | AAPL | Stock | 18.6207 | 18.6279 | 18.6143 | 18.6143 | 40796.0 |
| 2013-11-22 07:10:00 | AAPL | Stock | 18.6232 | 18.6232 | 18.6232 | 18.6232 | 2800.0 |
| 2013-11-22 07:25:00 | AAPL | Stock | 18.6275 | 18.6275 | 18.6275 | 18.6275 | 2800.0 |
| 2013-11-22 07:30:00 | AAPL | Stock | 18.6221 | 18.6286 | 18.6221 | 18.6286 | 28000.0 |
| 2013-11-22 07:45:00 | AAPL | Stock | 18.6289 | 18.6289 | 18.6214 | 18.6214 | 46200.0 |
| 2013-11-22 08:00:00 | AAPL | Stock | 18.6214 | 18.6357 | 18.5982 | 18.5982 | 115500.0 |
| 2013-11-22 08:05:00 | AAPL | Stock | 18.5939 | 18.6104 | 18.5929 | 18.6104 | 30436.0 |
| 2013-11-22 08:10:00 | AAPL | Stock | 18.6104 | 18.6121 | 18.6071 | 18.6086 | 114772.0 |
| 2013-11-22 08:15:00 | AAPL | Stock | 18.6075 | 18.6075 | 18.6068 | 18.6071 | 16800.0 |
| 2013-11-22 08:20:00 | AAPL | Stock | 18.6075 | 18.6082 | 18.5946 | 18.5946 | 107380.0 |
| 2013-11-22 08:25:00 | AAPL | Stock | 18.5946 | 18.6107 | 18.5929 | 18.6107 | 99820.0 |
| 2013-11-22 08:30:00 | AAPL | Stock | 18.6157 | 18.6161 | 18.6146 | 18.6154 | 16800.0 |
| 2013-11-22 08:35:00 | AAPL | Stock | 18.6136 | 18.6143 | 18.6039 | 18.6039 | 35000.0 |
| 2013-11-22 08:40:00 | AAPL | Stock | 18.6125 | 18.6125 | 18.6 | 18.6107 | 128800.0 |
| 2013-11-22 08:45:00 | AAPL | Stock | 18.6075 | 18.6214 | 18.6075 | 18.6214 | 90860.0 |
| 2013-11-22 08:50:00 | AAPL | Stock | 18.6207 | 18.6214 | 18.6071 | 18.6086 | 95200.0 |
| 2013-11-22 08:55:00 | AAPL | Stock | 18.61 | 18.6121 | 18.6061 | 18.6061 | 50400.0 |
| 2013-11-22 09:00:00 | AAPL | Stock | 18.6018 | 18.6018 | 18.6 | 18.6 | 33600.0 |
| 2013-11-22 09:05:00 | AAPL | Stock | 18.6 | 18.6018 | 18.5946 | 18.6018 | 62440.0 |
| 2013-11-22 09:10:00 | AAPL | Stock | 18.5986 | 18.6014 | 18.5968 | 18.6 | 20916.0 |
| 2013-11-22 09:15:00 | AAPL | Stock | 18.6 | 18.6068 | 18.5982 | 18.6025 | 91000.0 |
| 2013-11-22 09:20:00 | AAPL | Stock | 18.6029 | 18.6029 | 18.5954 | 18.5964 | 72520.0 |
| 2013-11-22 09:25:00 | AAPL | Stock | 18.5939 | 18.5964 | 18.5714 | 18.5714 | 251636.0 |
| 2013-11-22 09:30:00 | AAPL | Stock | 18.5575 | 18.5996 | 18.5393 | 18.5693 | 10247580.0 |
| 2013-11-22 09:35:00 | AAPL | Stock | 18.5693 | 18.6025 | 18.5514 | 18.5679 | 5870844.0 |
| 2013-11-22 09:40:00 | AAPL | Stock | 18.5696 | 18.5961 | 18.5654 | 18.5714 | 2994600.0 |
| 2013-11-22 09:45:00 | AAPL | Stock | 18.5743 | 18.5761 | 18.5189 | 18.5511 | 6118364.0 |
| 2013-11-22 09:50:00 | AAPL | Stock | 18.55 | 18.5811 | 18.545 | 18.5718 | 6776476.0 |
| 2013-11-22 09:55:00 | AAPL | Stock | 18.575 | 18.6282 | 18.5736 | 18.6007 | 7113708.0 |
| 2013-11-22 10:00:00 | AAPL | Stock | 18.6036 | 18.6218 | 18.5968 | 18.6157 | 4947404.0 |
| 2013-11-22 10:05:00 | AAPL | Stock | 18.6154 | 18.6375 | 18.5982 | 18.615 | 5312748.0 |
| 2013-11-22 10:10:00 | AAPL | Stock | 18.6154 | 18.6486 | 18.6125 | 18.6386 | 7917420.0 |
| 2013-11-22 10:15:00 | AAPL | Stock | 18.6354 | 18.6457 | 18.6093 | 18.6386 | 5302388.0 |
| 2013-11-22 10:20:00 | AAPL | Stock | 18.6393 | 18.6454 | 18.6082 | 18.6082 | 4010804.0 |
| 2013-11-22 10:25:00 | AAPL | Stock | 18.61 | 18.6243 | 18.6071 | 18.6239 | 4632292.0 |
| 2013-11-22 10:30:00 | AAPL | Stock | 18.6225 | 18.6404 | 18.6189 | 18.6321 | 2928296.0 |
| 2013-11-22 10:35:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.6075 | 18.6096 | 3940944.0 |
| 2013-11-22 10:40:00 | AAPL | Stock | 18.6096 | 18.6129 | 18.5939 | 18.6011 | 2647428.0 |
| 2013-11-22 10:45:00 | AAPL | Stock | 18.6025 | 18.6029 | 18.5832 | 18.5893 | 3183180.0 |
| 2013-11-22 10:50:00 | AAPL | Stock | 18.5884 | 18.5976 | 18.5821 | 18.5889 | 1705984.0 |
| 2013-11-22 10:55:00 | AAPL | Stock | 18.5893 | 18.5943 | 18.5782 | 18.5861 | 2135840.0 |
| 2013-11-22 11:00:00 | AAPL | Stock | 18.5864 | 18.6032 | 18.5839 | 18.5954 | 2329712.0 |
| 2013-11-22 11:05:00 | AAPL | Stock | 18.5957 | 18.6054 | 18.5943 | 18.5975 | 1992228.0 |
| 2013-11-22 11:10:00 | AAPL | Stock | 18.5961 | 18.5989 | 18.5839 | 18.5857 | 1918084.0 |
| 2013-11-22 11:15:00 | AAPL | Stock | 18.5864 | 18.6018 | 18.5821 | 18.5954 | 3095624.0 |
> showing 50 of 350,617 rows — these rows as CSV