PREVIEW / stock_5min / 2014-02-07
file: by_date/stock_5min/2014/2014-02-07.parquet size: 5.5 MB rows: 360,753 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-07 04:00:00 | AAPL | Stock | 18.3893 | 18.5382 | 18.3893 | 18.5 | 94500.0 |
| 2014-02-07 04:05:00 | AAPL | Stock | 18.5675 | 18.5714 | 18.5675 | 18.5714 | 40628.0 |
| 2014-02-07 04:15:00 | AAPL | Stock | 18.6239 | 18.6239 | 18.6114 | 18.6114 | 22400.0 |
| 2014-02-07 04:20:00 | AAPL | Stock | 18.5939 | 18.6004 | 18.5939 | 18.6004 | 5600.0 |
| 2014-02-07 04:30:00 | AAPL | Stock | 18.6414 | 18.6429 | 18.6414 | 18.6429 | 8400.0 |
| 2014-02-07 04:35:00 | AAPL | Stock | 18.6571 | 18.6571 | 18.6429 | 18.6461 | 11200.0 |
| 2014-02-07 04:45:00 | AAPL | Stock | 18.65 | 18.6904 | 18.65 | 18.6732 | 22008.0 |
| 2014-02-07 04:50:00 | AAPL | Stock | 18.6968 | 18.7107 | 18.6929 | 18.6929 | 34244.0 |
| 2014-02-07 04:55:00 | AAPL | Stock | 18.6832 | 18.6832 | 18.6561 | 18.6561 | 8400.0 |
| 2014-02-07 05:00:00 | AAPL | Stock | 18.6632 | 18.6632 | 18.6632 | 18.6632 | 16800.0 |
| 2014-02-07 05:05:00 | AAPL | Stock | 18.6539 | 18.6539 | 18.6539 | 18.6539 | 2800.0 |
| 2014-02-07 05:10:00 | AAPL | Stock | 18.6521 | 18.6521 | 18.6521 | 18.6521 | 5600.0 |
| 2014-02-07 05:15:00 | AAPL | Stock | 18.6721 | 18.6721 | 18.6721 | 18.6721 | 2800.0 |
| 2014-02-07 05:20:00 | AAPL | Stock | 18.7107 | 18.7107 | 18.7107 | 18.7107 | 11200.0 |
| 2014-02-07 05:25:00 | AAPL | Stock | 18.7161 | 18.7314 | 18.7161 | 18.7314 | 11200.0 |
| 2014-02-07 05:30:00 | AAPL | Stock | 18.7218 | 18.7321 | 18.7218 | 18.7321 | 16800.0 |
| 2014-02-07 05:35:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2014-02-07 05:40:00 | AAPL | Stock | 18.7214 | 18.7214 | 18.7214 | 18.7214 | 2800.0 |
| 2014-02-07 05:45:00 | AAPL | Stock | 18.7146 | 18.7146 | 18.7071 | 18.7071 | 23492.0 |
| 2014-02-07 05:50:00 | AAPL | Stock | 18.7054 | 18.7071 | 18.6979 | 18.7071 | 19600.0 |
| 2014-02-07 05:55:00 | AAPL | Stock | 18.7232 | 18.7232 | 18.7232 | 18.7232 | 2800.0 |
| 2014-02-07 06:00:00 | AAPL | Stock | 18.7189 | 18.7304 | 18.6979 | 18.7304 | 68040.0 |
| 2014-02-07 06:05:00 | AAPL | Stock | 18.7071 | 18.7679 | 18.7071 | 18.7357 | 216300.0 |
| 2014-02-07 06:10:00 | AAPL | Stock | 18.7396 | 18.7407 | 18.7321 | 18.7407 | 14000.0 |
| 2014-02-07 06:15:00 | AAPL | Stock | 18.7339 | 18.75 | 18.7321 | 18.75 | 69776.0 |
| 2014-02-07 06:20:00 | AAPL | Stock | 18.75 | 18.75 | 18.7357 | 18.74 | 130200.0 |
| 2014-02-07 06:25:00 | AAPL | Stock | 18.75 | 18.7679 | 18.75 | 18.7607 | 110516.0 |
| 2014-02-07 06:30:00 | AAPL | Stock | 18.75 | 18.7943 | 18.75 | 18.7857 | 93128.0 |
| 2014-02-07 06:35:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7143 | 18.7286 | 90720.0 |
| 2014-02-07 06:40:00 | AAPL | Stock | 18.7371 | 18.7379 | 18.7093 | 18.7093 | 89600.0 |
| 2014-02-07 06:45:00 | AAPL | Stock | 18.7143 | 18.75 | 18.6979 | 18.6979 | 78792.0 |
| 2014-02-07 06:50:00 | AAPL | Stock | 18.7 | 18.7143 | 18.7 | 18.7143 | 29708.0 |
| 2014-02-07 06:55:00 | AAPL | Stock | 18.7196 | 18.7196 | 18.7143 | 18.7189 | 116340.0 |
| 2014-02-07 07:00:00 | AAPL | Stock | 18.6943 | 18.7143 | 18.6732 | 18.6732 | 74592.0 |
| 2014-02-07 07:05:00 | AAPL | Stock | 18.6629 | 18.6743 | 18.645 | 18.6632 | 229348.0 |
| 2014-02-07 07:10:00 | AAPL | Stock | 18.6607 | 18.67 | 18.6446 | 18.6539 | 90160.0 |
| 2014-02-07 07:15:00 | AAPL | Stock | 18.6471 | 18.6471 | 18.625 | 18.6429 | 291228.0 |
| 2014-02-07 07:20:00 | AAPL | Stock | 18.6425 | 18.6604 | 18.6339 | 18.6429 | 175224.0 |
| 2014-02-07 07:25:00 | AAPL | Stock | 18.6436 | 18.6579 | 18.6286 | 18.6579 | 173684.0 |
| 2014-02-07 07:30:00 | AAPL | Stock | 18.6471 | 18.6575 | 18.6286 | 18.6371 | 192892.0 |
| 2014-02-07 07:35:00 | AAPL | Stock | 18.6496 | 18.6539 | 18.6361 | 18.6479 | 154112.0 |
| 2014-02-07 07:40:00 | AAPL | Stock | 18.6429 | 18.6461 | 18.5904 | 18.5989 | 194572.0 |
| 2014-02-07 07:45:00 | AAPL | Stock | 18.6071 | 18.6239 | 18.6071 | 18.6157 | 182280.0 |
| 2014-02-07 07:50:00 | AAPL | Stock | 18.6168 | 18.6179 | 18.6079 | 18.6089 | 132692.0 |
| 2014-02-07 07:55:00 | AAPL | Stock | 18.6139 | 18.6454 | 18.6129 | 18.6243 | 354200.0 |
| 2014-02-07 08:00:00 | AAPL | Stock | 18.6232 | 18.7143 | 18.6068 | 18.625 | 1336552.0 |
| 2014-02-07 08:05:00 | AAPL | Stock | 18.625 | 18.6336 | 18.5968 | 18.6018 | 401716.0 |
| 2014-02-07 08:10:00 | AAPL | Stock | 18.6039 | 18.6071 | 18.5832 | 18.5836 | 495656.0 |
| 2014-02-07 08:15:00 | AAPL | Stock | 18.5839 | 18.5964 | 18.575 | 18.5804 | 583072.0 |
| 2014-02-07 08:20:00 | AAPL | Stock | 18.5757 | 18.58 | 18.5439 | 18.5439 | 536928.0 |
> showing 50 of 360,753 rows — these rows as CSV