PREVIEW / stock_5min / 2013-09-24
file: by_date/stock_5min/2013/2013-09-24.parquet size: 5.3 MB rows: 347,017 symbols: 3,511
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-09-24 04:00:00 | AAPL | Stock | 17.6421 | 17.6786 | 17.6421 | 17.6786 | 18200.0 |
| 2013-09-24 04:05:00 | AAPL | Stock | 17.6429 | 17.6543 | 17.6396 | 17.6536 | 56672.0 |
| 2013-09-24 04:10:00 | AAPL | Stock | 17.6482 | 17.6536 | 17.6482 | 17.6536 | 7896.0 |
| 2013-09-24 04:15:00 | AAPL | Stock | 17.6464 | 17.6464 | 17.6357 | 17.6357 | 30800.0 |
| 2013-09-24 04:20:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 3668.0 |
| 2013-09-24 04:35:00 | AAPL | Stock | 17.6432 | 17.6432 | 17.6432 | 17.6432 | 3360.0 |
| 2013-09-24 04:40:00 | AAPL | Stock | 17.6132 | 17.6132 | 17.6071 | 17.6071 | 21000.0 |
| 2013-09-24 04:45:00 | AAPL | Stock | 17.6171 | 17.6171 | 17.6171 | 17.6171 | 5600.0 |
| 2013-09-24 04:50:00 | AAPL | Stock | 17.6171 | 17.64 | 17.6171 | 17.64 | 11200.0 |
| 2013-09-24 05:00:00 | AAPL | Stock | 17.6286 | 17.6286 | 17.6286 | 17.6286 | 14000.0 |
| 2013-09-24 05:10:00 | AAPL | Stock | 17.6079 | 17.6079 | 17.6079 | 17.6079 | 2800.0 |
| 2013-09-24 05:15:00 | AAPL | Stock | 17.61 | 17.61 | 17.605 | 17.605 | 204400.0 |
| 2013-09-24 05:25:00 | AAPL | Stock | 17.6196 | 17.6196 | 17.6196 | 17.6196 | 2800.0 |
| 2013-09-24 05:30:00 | AAPL | Stock | 17.6068 | 17.6068 | 17.5857 | 17.5857 | 25060.0 |
| 2013-09-24 05:35:00 | AAPL | Stock | 17.6068 | 17.6068 | 17.6068 | 17.6068 | 5544.0 |
| 2013-09-24 05:40:00 | AAPL | Stock | 17.6036 | 17.6036 | 17.5879 | 17.5879 | 9716.0 |
| 2013-09-24 05:45:00 | AAPL | Stock | 17.5829 | 17.5829 | 17.5829 | 17.5829 | 5600.0 |
| 2013-09-24 05:50:00 | AAPL | Stock | 17.5879 | 17.5879 | 17.5879 | 17.5879 | 2800.0 |
| 2013-09-24 05:55:00 | AAPL | Stock | 17.5811 | 17.5811 | 17.5811 | 17.5811 | 9380.0 |
| 2013-09-24 06:00:00 | AAPL | Stock | 17.5857 | 17.6286 | 17.5536 | 17.6286 | 120120.0 |
| 2013-09-24 06:05:00 | AAPL | Stock | 17.6246 | 17.625 | 17.6246 | 17.625 | 35952.0 |
| 2013-09-24 06:10:00 | AAPL | Stock | 17.625 | 17.675 | 17.6196 | 17.6429 | 97552.0 |
| 2013-09-24 06:15:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6429 | 17.6429 | 16968.0 |
| 2013-09-24 06:25:00 | AAPL | Stock | 17.6536 | 17.6536 | 17.6429 | 17.6429 | 16800.0 |
| 2013-09-24 06:30:00 | AAPL | Stock | 17.6143 | 17.6661 | 17.6143 | 17.6661 | 105140.0 |
| 2013-09-24 06:35:00 | AAPL | Stock | 17.6618 | 17.6618 | 17.6618 | 17.6618 | 28000.0 |
| 2013-09-24 06:40:00 | AAPL | Stock | 17.6471 | 17.6471 | 17.645 | 17.645 | 31948.0 |
| 2013-09-24 06:50:00 | AAPL | Stock | 17.6271 | 17.6321 | 17.625 | 17.6321 | 11200.0 |
| 2013-09-24 06:55:00 | AAPL | Stock | 17.6182 | 17.6182 | 17.6164 | 17.6164 | 24080.0 |
| 2013-09-24 07:00:00 | AAPL | Stock | 17.6179 | 17.6429 | 17.6161 | 17.6339 | 176260.0 |
| 2013-09-24 07:05:00 | AAPL | Stock | 17.635 | 17.635 | 17.6268 | 17.635 | 16828.0 |
| 2013-09-24 07:10:00 | AAPL | Stock | 17.6354 | 17.6429 | 17.6354 | 17.6407 | 26600.0 |
| 2013-09-24 07:15:00 | AAPL | Stock | 17.6329 | 17.6536 | 17.6304 | 17.6536 | 136724.0 |
| 2013-09-24 07:20:00 | AAPL | Stock | 17.655 | 17.6607 | 17.6429 | 17.6429 | 276948.0 |
| 2013-09-24 07:25:00 | AAPL | Stock | 17.6482 | 17.6482 | 17.6207 | 17.6361 | 226100.0 |
| 2013-09-24 07:30:00 | AAPL | Stock | 17.6429 | 17.6429 | 17.6214 | 17.6214 | 178696.0 |
| 2013-09-24 07:35:00 | AAPL | Stock | 17.6214 | 17.625 | 17.6154 | 17.625 | 30240.0 |
| 2013-09-24 07:40:00 | AAPL | Stock | 17.625 | 17.625 | 17.6114 | 17.625 | 77700.0 |
| 2013-09-24 07:45:00 | AAPL | Stock | 17.6321 | 17.6321 | 17.6125 | 17.6125 | 90916.0 |
| 2013-09-24 07:50:00 | AAPL | Stock | 17.6157 | 17.6157 | 17.6086 | 17.6086 | 81200.0 |
| 2013-09-24 07:55:00 | AAPL | Stock | 17.6125 | 17.6125 | 17.5964 | 17.5964 | 82880.0 |
| 2013-09-24 08:00:00 | AAPL | Stock | 17.6039 | 17.6607 | 17.5736 | 17.5943 | 774788.0 |
| 2013-09-24 08:05:00 | AAPL | Stock | 17.5946 | 17.5946 | 17.5243 | 17.5479 | 939596.0 |
| 2013-09-24 08:10:00 | AAPL | Stock | 17.5686 | 17.5807 | 17.5518 | 17.5807 | 318948.0 |
| 2013-09-24 08:15:00 | AAPL | Stock | 17.58 | 17.5871 | 17.5764 | 17.5871 | 217756.0 |
| 2013-09-24 08:20:00 | AAPL | Stock | 17.5893 | 17.6036 | 17.5893 | 17.5893 | 321804.0 |
| 2013-09-24 08:25:00 | AAPL | Stock | 17.5857 | 17.6157 | 17.5846 | 17.6121 | 380100.0 |
| 2013-09-24 08:30:00 | AAPL | Stock | 17.6089 | 17.625 | 17.6004 | 17.6207 | 526820.0 |
| 2013-09-24 08:35:00 | AAPL | Stock | 17.6179 | 17.6339 | 17.6179 | 17.6232 | 628404.0 |
| 2013-09-24 08:40:00 | AAPL | Stock | 17.6264 | 17.6429 | 17.6246 | 17.6364 | 331604.0 |
> showing 50 of 347,017 rows — these rows as CSV