PREVIEW / stock_5min / 2014-03-03
file: by_date/stock_5min/2014/2014-03-03.parquet size: 5.6 MB rows: 369,783 symbols: 3,537
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-03-03 04:00:00 | AAPL | Stock | 18.6436 | 18.6436 | 18.5536 | 18.5714 | 94528.0 |
| 2014-03-03 04:10:00 | AAPL | Stock | 18.6064 | 18.6064 | 18.6064 | 18.6064 | 2800.0 |
| 2014-03-03 04:20:00 | AAPL | Stock | 18.63 | 18.6429 | 18.6186 | 18.6186 | 38640.0 |
| 2014-03-03 04:25:00 | AAPL | Stock | 18.6164 | 18.6164 | 18.6164 | 18.6164 | 3304.0 |
| 2014-03-03 04:45:00 | AAPL | Stock | 18.6246 | 18.6246 | 18.6246 | 18.6246 | 14000.0 |
| 2014-03-03 04:50:00 | AAPL | Stock | 18.6229 | 18.6229 | 18.6229 | 18.6229 | 8400.0 |
| 2014-03-03 05:00:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 2800.0 |
| 2014-03-03 05:15:00 | AAPL | Stock | 18.6246 | 18.6246 | 18.6246 | 18.6246 | 2800.0 |
| 2014-03-03 05:25:00 | AAPL | Stock | 18.625 | 18.625 | 18.6114 | 18.6114 | 11900.0 |
| 2014-03-03 05:35:00 | AAPL | Stock | 18.6082 | 18.6082 | 18.6082 | 18.6082 | 5600.0 |
| 2014-03-03 05:40:00 | AAPL | Stock | 18.5968 | 18.5968 | 18.5893 | 18.5893 | 28000.0 |
| 2014-03-03 05:45:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 2800.0 |
| 2014-03-03 05:50:00 | AAPL | Stock | 18.5968 | 18.6071 | 18.5968 | 18.6071 | 8400.0 |
| 2014-03-03 05:55:00 | AAPL | Stock | 18.6064 | 18.6104 | 18.6064 | 18.6104 | 11200.0 |
| 2014-03-03 06:10:00 | AAPL | Stock | 18.5989 | 18.5989 | 18.5989 | 18.5989 | 2800.0 |
| 2014-03-03 06:15:00 | AAPL | Stock | 18.5982 | 18.5989 | 18.5982 | 18.5989 | 11200.0 |
| 2014-03-03 06:20:00 | AAPL | Stock | 18.5993 | 18.5993 | 18.5993 | 18.5993 | 5600.0 |
| 2014-03-03 06:25:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 5600.0 |
| 2014-03-03 06:30:00 | AAPL | Stock | 18.6139 | 18.6411 | 18.6139 | 18.6411 | 42084.0 |
| 2014-03-03 06:35:00 | AAPL | Stock | 18.6257 | 18.6257 | 18.6257 | 18.6257 | 2800.0 |
| 2014-03-03 06:45:00 | AAPL | Stock | 18.6143 | 18.6143 | 18.6143 | 18.6143 | 4956.0 |
| 2014-03-03 06:50:00 | AAPL | Stock | 18.5914 | 18.5914 | 18.5896 | 18.5896 | 30156.0 |
| 2014-03-03 07:00:00 | AAPL | Stock | 18.5821 | 18.5879 | 18.5821 | 18.5879 | 24696.0 |
| 2014-03-03 07:10:00 | AAPL | Stock | 18.6068 | 18.6111 | 18.6068 | 18.6111 | 19600.0 |
| 2014-03-03 07:15:00 | AAPL | Stock | 18.6189 | 18.6189 | 18.5989 | 18.6071 | 111916.0 |
| 2014-03-03 07:25:00 | AAPL | Stock | 18.5957 | 18.6036 | 18.5932 | 18.5982 | 44800.0 |
| 2014-03-03 07:30:00 | AAPL | Stock | 18.5986 | 18.6232 | 18.5986 | 18.6232 | 57232.0 |
| 2014-03-03 07:35:00 | AAPL | Stock | 18.6104 | 18.6107 | 18.6104 | 18.6107 | 19600.0 |
| 2014-03-03 07:40:00 | AAPL | Stock | 18.6107 | 18.6368 | 18.6107 | 18.6368 | 26208.0 |
| 2014-03-03 07:45:00 | AAPL | Stock | 18.6286 | 18.6604 | 18.6271 | 18.6604 | 70588.0 |
| 2014-03-03 07:50:00 | AAPL | Stock | 18.6429 | 18.6471 | 18.6321 | 18.6471 | 133224.0 |
| 2014-03-03 07:55:00 | AAPL | Stock | 18.6432 | 18.6432 | 18.6393 | 18.6393 | 30800.0 |
| 2014-03-03 08:00:00 | AAPL | Stock | 18.6429 | 18.6679 | 18.5821 | 18.6579 | 255472.0 |
| 2014-03-03 08:05:00 | AAPL | Stock | 18.6554 | 18.6571 | 18.6361 | 18.6361 | 198240.0 |
| 2014-03-03 08:10:00 | AAPL | Stock | 18.6421 | 18.6421 | 18.6339 | 18.6411 | 32200.0 |
| 2014-03-03 08:15:00 | AAPL | Stock | 18.6411 | 18.6529 | 18.6411 | 18.6521 | 35812.0 |
| 2014-03-03 08:20:00 | AAPL | Stock | 18.6532 | 18.7943 | 18.6532 | 18.6679 | 125328.0 |
| 2014-03-03 08:25:00 | AAPL | Stock | 18.6679 | 18.6764 | 18.6675 | 18.6764 | 16800.0 |
| 2014-03-03 08:30:00 | AAPL | Stock | 18.6657 | 18.7139 | 18.6657 | 18.6786 | 98616.0 |
| 2014-03-03 08:35:00 | AAPL | Stock | 18.6821 | 18.6932 | 18.6818 | 18.6893 | 81984.0 |
| 2014-03-03 08:40:00 | AAPL | Stock | 18.6829 | 18.6829 | 18.6639 | 18.6654 | 41888.0 |
| 2014-03-03 08:45:00 | AAPL | Stock | 18.6682 | 18.6696 | 18.6643 | 18.6643 | 32088.0 |
| 2014-03-03 08:50:00 | AAPL | Stock | 18.6643 | 18.6771 | 18.6468 | 18.6504 | 277368.0 |
| 2014-03-03 08:55:00 | AAPL | Stock | 18.6571 | 18.6714 | 18.6521 | 18.6714 | 70000.0 |
| 2014-03-03 09:00:00 | AAPL | Stock | 18.6696 | 18.6939 | 18.6696 | 18.6839 | 110488.0 |
| 2014-03-03 09:05:00 | AAPL | Stock | 18.6907 | 18.7471 | 18.6907 | 18.7036 | 343196.0 |
| 2014-03-03 09:10:00 | AAPL | Stock | 18.705 | 18.7143 | 18.6786 | 18.6943 | 157164.0 |
| 2014-03-03 09:15:00 | AAPL | Stock | 18.695 | 18.7171 | 18.695 | 18.7164 | 220752.0 |
| 2014-03-03 09:20:00 | AAPL | Stock | 18.7143 | 18.7168 | 18.7 | 18.7071 | 83440.0 |
| 2014-03-03 09:25:00 | AAPL | Stock | 18.7071 | 18.7075 | 18.6786 | 18.6793 | 320516.0 |
> showing 50 of 369,783 rows — these rows as CSV