PREVIEW / stock_5min / 2014-02-26
file: by_date/stock_5min/2014/2014-02-26.parquet size: 5.4 MB rows: 357,527 symbols: 3,535
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-26 04:00:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 2800.0 |
| 2014-02-26 04:10:00 | AAPL | Stock | 18.6079 | 18.6079 | 18.575 | 18.575 | 8400.0 |
| 2014-02-26 04:15:00 | AAPL | Stock | 18.5532 | 18.5532 | 18.5532 | 18.5532 | 2800.0 |
| 2014-02-26 04:25:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2014-02-26 04:30:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.555 | 18.555 | 8400.0 |
| 2014-02-26 04:35:00 | AAPL | Stock | 18.5636 | 18.5636 | 18.555 | 18.555 | 14000.0 |
| 2014-02-26 04:40:00 | AAPL | Stock | 18.5532 | 18.5532 | 18.5418 | 18.5418 | 25200.0 |
| 2014-02-26 04:50:00 | AAPL | Stock | 18.5346 | 18.5346 | 18.5346 | 18.5346 | 2800.0 |
| 2014-02-26 04:55:00 | AAPL | Stock | 18.5214 | 18.525 | 18.5214 | 18.525 | 58464.0 |
| 2014-02-26 05:10:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 2800.0 |
| 2014-02-26 05:30:00 | AAPL | Stock | 18.5429 | 18.5429 | 18.5429 | 18.5429 | 2800.0 |
| 2014-02-26 05:40:00 | AAPL | Stock | 18.5857 | 18.5857 | 18.5857 | 18.5857 | 5600.0 |
| 2014-02-26 05:50:00 | AAPL | Stock | 18.5868 | 18.5868 | 18.5821 | 18.5821 | 28000.0 |
| 2014-02-26 06:05:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5671 | 18.5671 | 11200.0 |
| 2014-02-26 06:30:00 | AAPL | Stock | 18.5768 | 18.5768 | 18.5768 | 18.5768 | 2800.0 |
| 2014-02-26 06:50:00 | AAPL | Stock | 18.5996 | 18.6071 | 18.5996 | 18.6071 | 30380.0 |
| 2014-02-26 06:55:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 3864.0 |
| 2014-02-26 07:00:00 | AAPL | Stock | 18.6071 | 18.6143 | 18.6071 | 18.6071 | 22736.0 |
| 2014-02-26 07:10:00 | AAPL | Stock | 18.6161 | 18.6221 | 18.6161 | 18.6221 | 5600.0 |
| 2014-02-26 07:15:00 | AAPL | Stock | 18.6221 | 18.6279 | 18.6221 | 18.6279 | 8400.0 |
| 2014-02-26 07:20:00 | AAPL | Stock | 18.6407 | 18.6429 | 18.6407 | 18.6429 | 101108.0 |
| 2014-02-26 07:25:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6379 | 18.6379 | 8400.0 |
| 2014-02-26 07:30:00 | AAPL | Stock | 18.6171 | 18.6171 | 18.6164 | 18.6164 | 28700.0 |
| 2014-02-26 07:35:00 | AAPL | Stock | 18.6232 | 18.6236 | 18.6232 | 18.6236 | 9100.0 |
| 2014-02-26 07:40:00 | AAPL | Stock | 18.6332 | 18.6339 | 18.6332 | 18.6339 | 5600.0 |
| 2014-02-26 07:45:00 | AAPL | Stock | 18.625 | 18.6275 | 18.625 | 18.6275 | 8400.0 |
| 2014-02-26 07:50:00 | AAPL | Stock | 18.6332 | 18.6607 | 18.6332 | 18.6607 | 112000.0 |
| 2014-02-26 07:55:00 | AAPL | Stock | 18.6607 | 18.6607 | 18.6471 | 18.66 | 16800.0 |
| 2014-02-26 08:00:00 | AAPL | Stock | 18.62 | 18.6729 | 18.62 | 18.6721 | 30800.0 |
| 2014-02-26 08:05:00 | AAPL | Stock | 18.6607 | 18.6786 | 18.6607 | 18.6786 | 95228.0 |
| 2014-02-26 08:10:00 | AAPL | Stock | 18.6786 | 18.6961 | 18.6786 | 18.6811 | 93688.0 |
| 2014-02-26 08:15:00 | AAPL | Stock | 18.6907 | 18.7104 | 18.69 | 18.7104 | 87080.0 |
| 2014-02-26 08:20:00 | AAPL | Stock | 18.7029 | 18.7125 | 18.6996 | 18.7125 | 30688.0 |
| 2014-02-26 08:25:00 | AAPL | Stock | 18.7107 | 18.7232 | 18.7021 | 18.7143 | 99568.0 |
| 2014-02-26 08:30:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.6725 | 18.6725 | 74480.0 |
| 2014-02-26 08:35:00 | AAPL | Stock | 18.6946 | 18.7107 | 18.6929 | 18.7054 | 111440.0 |
| 2014-02-26 08:40:00 | AAPL | Stock | 18.7111 | 18.7143 | 18.6964 | 18.6964 | 94724.0 |
| 2014-02-26 08:45:00 | AAPL | Stock | 18.7018 | 18.7096 | 18.6964 | 18.7096 | 114660.0 |
| 2014-02-26 08:50:00 | AAPL | Stock | 18.7096 | 18.75 | 18.7096 | 18.7482 | 227472.0 |
| 2014-02-26 08:55:00 | AAPL | Stock | 18.7454 | 18.7468 | 18.7379 | 18.7429 | 59976.0 |
| 2014-02-26 09:00:00 | AAPL | Stock | 18.7407 | 18.7407 | 18.725 | 18.7325 | 84000.0 |
| 2014-02-26 09:05:00 | AAPL | Stock | 18.7304 | 18.7304 | 18.7161 | 18.7161 | 28000.0 |
| 2014-02-26 09:10:00 | AAPL | Stock | 18.7143 | 18.7339 | 18.7143 | 18.7154 | 78120.0 |
| 2014-02-26 09:15:00 | AAPL | Stock | 18.7214 | 18.7318 | 18.7211 | 18.7318 | 93296.0 |
| 2014-02-26 09:20:00 | AAPL | Stock | 18.7336 | 18.7343 | 18.7143 | 18.7161 | 71092.0 |
| 2014-02-26 09:25:00 | AAPL | Stock | 18.7232 | 18.7232 | 18.6964 | 18.6964 | 57176.0 |
| 2014-02-26 09:30:00 | AAPL | Stock | 18.6964 | 18.75 | 18.6821 | 18.6946 | 9635780.0 |
| 2014-02-26 09:35:00 | AAPL | Stock | 18.6993 | 18.7196 | 18.6607 | 18.6875 | 4908764.0 |
| 2014-02-26 09:40:00 | AAPL | Stock | 18.6807 | 18.7071 | 18.6646 | 18.6939 | 3347652.0 |
| 2014-02-26 09:45:00 | AAPL | Stock | 18.6943 | 18.6943 | 18.6068 | 18.6345 | 6192368.0 |
> showing 50 of 357,527 rows — these rows as CSV