PREVIEW / stock_5min / 2012-08-14
file: by_date/stock_5min/2012/2012-08-14.parquet size: 4.6 MB rows: 313,167 symbols: 3,485
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-14 04:00:00 | AAPL | Stock | 22.6225 | 22.6225 | 22.6107 | 22.6107 | 9800.0 |
| 2012-08-14 04:05:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5893 | 22.5893 | 2800.0 |
| 2012-08-14 04:10:00 | AAPL | Stock | 22.5932 | 22.5932 | 22.5929 | 22.5929 | 5600.0 |
| 2012-08-14 04:20:00 | AAPL | Stock | 22.6211 | 22.6211 | 22.6211 | 22.6211 | 5180.0 |
| 2012-08-14 04:25:00 | AAPL | Stock | 22.6375 | 22.6375 | 22.6375 | 22.6375 | 7000.0 |
| 2012-08-14 04:30:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6214 | 22.6214 | 2800.0 |
| 2012-08-14 04:40:00 | AAPL | Stock | 22.625 | 22.625 | 22.625 | 22.625 | 2800.0 |
| 2012-08-14 04:45:00 | AAPL | Stock | 22.6079 | 22.6079 | 22.6079 | 22.6079 | 2800.0 |
| 2012-08-14 04:50:00 | AAPL | Stock | 22.6521 | 22.6521 | 22.6521 | 22.6521 | 2800.0 |
| 2012-08-14 04:55:00 | AAPL | Stock | 22.6464 | 22.6521 | 22.6464 | 22.6464 | 14000.0 |
| 2012-08-14 05:00:00 | AAPL | Stock | 22.6093 | 22.6093 | 22.6089 | 22.6089 | 5600.0 |
| 2012-08-14 05:05:00 | AAPL | Stock | 22.6482 | 22.6482 | 22.6482 | 22.6482 | 5600.0 |
| 2012-08-14 05:10:00 | AAPL | Stock | 22.6429 | 22.6429 | 22.6429 | 22.6429 | 8400.0 |
| 2012-08-14 05:30:00 | AAPL | Stock | 22.6429 | 22.6429 | 22.6357 | 22.6357 | 22400.0 |
| 2012-08-14 05:35:00 | AAPL | Stock | 22.6339 | 22.6339 | 22.6339 | 22.6339 | 2800.0 |
| 2012-08-14 05:45:00 | AAPL | Stock | 22.6339 | 22.6339 | 22.6339 | 22.6339 | 2800.0 |
| 2012-08-14 05:50:00 | AAPL | Stock | 22.6214 | 22.6357 | 22.61 | 22.6357 | 22260.0 |
| 2012-08-14 05:55:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6354 | 22.6354 | 19600.0 |
| 2012-08-14 06:00:00 | AAPL | Stock | 22.6261 | 22.6261 | 22.6261 | 22.6261 | 2800.0 |
| 2012-08-14 06:05:00 | AAPL | Stock | 22.6354 | 22.6357 | 22.6354 | 22.6357 | 11200.0 |
| 2012-08-14 06:10:00 | AAPL | Stock | 22.6493 | 22.6496 | 22.6493 | 22.6496 | 5600.0 |
| 2012-08-14 06:25:00 | AAPL | Stock | 22.6361 | 22.6361 | 22.6357 | 22.6357 | 20440.0 |
| 2012-08-14 06:35:00 | AAPL | Stock | 22.6493 | 22.6493 | 22.6493 | 22.6493 | 2800.0 |
| 2012-08-14 06:50:00 | AAPL | Stock | 22.6496 | 22.6496 | 22.6496 | 22.6496 | 2800.0 |
| 2012-08-14 06:55:00 | AAPL | Stock | 22.6357 | 22.6357 | 22.6339 | 22.6339 | 30800.0 |
| 2012-08-14 07:00:00 | AAPL | Stock | 22.6389 | 22.6425 | 22.62 | 22.6261 | 90300.0 |
| 2012-08-14 07:05:00 | AAPL | Stock | 22.6182 | 22.6239 | 22.6143 | 22.6143 | 32172.0 |
| 2012-08-14 07:10:00 | AAPL | Stock | 22.6121 | 22.6246 | 22.6036 | 22.6139 | 44940.0 |
| 2012-08-14 07:15:00 | AAPL | Stock | 22.6107 | 22.6143 | 22.6071 | 22.6071 | 18872.0 |
| 2012-08-14 07:25:00 | AAPL | Stock | 22.5982 | 22.5989 | 22.5982 | 22.5982 | 8400.0 |
| 2012-08-14 07:30:00 | AAPL | Stock | 22.605 | 22.6064 | 22.5968 | 22.6064 | 19628.0 |
| 2012-08-14 07:35:00 | AAPL | Stock | 22.6036 | 22.6143 | 22.6036 | 22.6071 | 79072.0 |
| 2012-08-14 07:40:00 | AAPL | Stock | 22.5986 | 22.5989 | 22.5879 | 22.5879 | 52948.0 |
| 2012-08-14 07:45:00 | AAPL | Stock | 22.5929 | 22.5993 | 22.5786 | 22.5979 | 67424.0 |
| 2012-08-14 07:50:00 | AAPL | Stock | 22.6021 | 22.6139 | 22.6021 | 22.6036 | 93240.0 |
| 2012-08-14 07:55:00 | AAPL | Stock | 22.6139 | 22.6143 | 22.6071 | 22.61 | 56952.0 |
| 2012-08-14 08:00:00 | AAPL | Stock | 22.6071 | 22.6193 | 22.5536 | 22.615 | 496272.0 |
| 2012-08-14 08:05:00 | AAPL | Stock | 22.6079 | 22.6214 | 22.6071 | 22.6146 | 234080.0 |
| 2012-08-14 08:10:00 | AAPL | Stock | 22.6146 | 22.6211 | 22.6143 | 22.6189 | 45920.0 |
| 2012-08-14 08:15:00 | AAPL | Stock | 22.6179 | 22.6179 | 22.6093 | 22.6093 | 113708.0 |
| 2012-08-14 08:20:00 | AAPL | Stock | 22.6125 | 22.6146 | 22.6071 | 22.6143 | 109228.0 |
| 2012-08-14 08:25:00 | AAPL | Stock | 22.6143 | 22.6214 | 22.6075 | 22.6214 | 109732.0 |
| 2012-08-14 08:30:00 | AAPL | Stock | 22.6214 | 22.635 | 22.6211 | 22.6321 | 320796.0 |
| 2012-08-14 08:35:00 | AAPL | Stock | 22.6321 | 22.6393 | 22.6318 | 22.6321 | 392616.0 |
| 2012-08-14 08:40:00 | AAPL | Stock | 22.6304 | 22.6382 | 22.6125 | 22.6129 | 343028.0 |
| 2012-08-14 08:45:00 | AAPL | Stock | 22.6114 | 22.615 | 22.5968 | 22.6054 | 371588.0 |
| 2012-08-14 08:50:00 | AAPL | Stock | 22.6057 | 22.6071 | 22.5936 | 22.6039 | 296772.0 |
| 2012-08-14 08:55:00 | AAPL | Stock | 22.6 | 22.605 | 22.5964 | 22.5964 | 215012.0 |
| 2012-08-14 09:00:00 | AAPL | Stock | 22.5946 | 22.6057 | 22.5946 | 22.6057 | 181468.0 |
| 2012-08-14 09:05:00 | AAPL | Stock | 22.6046 | 22.6071 | 22.6029 | 22.6054 | 110488.0 |
> showing 50 of 313,167 rows — these rows as CSV