PREVIEW / stock_5min / 2013-08-05
file: by_date/stock_5min/2013/2013-08-05.parquet size: 5.1 MB rows: 335,102 symbols: 3,503
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-08-05 04:00:00 | AAPL | Stock | 16.5054 | 16.5054 | 16.5054 | 16.5054 | 2800.0 |
| 2013-08-05 04:20:00 | AAPL | Stock | 16.55 | 16.55 | 16.55 | 16.55 | 2800.0 |
| 2013-08-05 05:25:00 | AAPL | Stock | 16.5675 | 16.5675 | 16.5675 | 16.5675 | 2800.0 |
| 2013-08-05 06:00:00 | AAPL | Stock | 16.5771 | 16.5771 | 16.5771 | 16.5771 | 2800.0 |
| 2013-08-05 06:45:00 | AAPL | Stock | 16.6029 | 16.6257 | 16.6018 | 16.6214 | 59080.0 |
| 2013-08-05 06:50:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 16184.0 |
| 2013-08-05 07:00:00 | AAPL | Stock | 16.5979 | 16.6214 | 16.5843 | 16.6214 | 77588.0 |
| 2013-08-05 07:05:00 | AAPL | Stock | 16.6339 | 16.7143 | 16.6339 | 16.7143 | 301504.0 |
| 2013-08-05 07:10:00 | AAPL | Stock | 16.7107 | 16.7129 | 16.6643 | 16.7125 | 307860.0 |
| 2013-08-05 07:15:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.6789 | 16.6789 | 50400.0 |
| 2013-08-05 07:20:00 | AAPL | Stock | 16.6768 | 16.6893 | 16.6607 | 16.6893 | 144396.0 |
| 2013-08-05 07:25:00 | AAPL | Stock | 16.6889 | 16.6911 | 16.6804 | 16.6825 | 76216.0 |
| 2013-08-05 07:30:00 | AAPL | Stock | 16.6818 | 16.6832 | 16.6682 | 16.6786 | 426524.0 |
| 2013-08-05 07:35:00 | AAPL | Stock | 16.6696 | 16.6696 | 16.6575 | 16.6643 | 121800.0 |
| 2013-08-05 07:40:00 | AAPL | Stock | 16.6582 | 16.6589 | 16.6432 | 16.6571 | 46592.0 |
| 2013-08-05 07:45:00 | AAPL | Stock | 16.65 | 16.65 | 16.6289 | 16.6289 | 60228.0 |
| 2013-08-05 07:50:00 | AAPL | Stock | 16.6275 | 16.655 | 16.6246 | 16.655 | 46284.0 |
| 2013-08-05 07:55:00 | AAPL | Stock | 16.6343 | 16.6411 | 16.625 | 16.6411 | 57400.0 |
| 2013-08-05 08:00:00 | AAPL | Stock | 16.6268 | 16.7121 | 16.4643 | 16.6518 | 488152.0 |
| 2013-08-05 08:05:00 | AAPL | Stock | 16.65 | 16.6586 | 16.635 | 16.6393 | 325472.0 |
| 2013-08-05 08:10:00 | AAPL | Stock | 16.6425 | 16.6425 | 16.625 | 16.6389 | 179564.0 |
| 2013-08-05 08:15:00 | AAPL | Stock | 16.6393 | 16.6471 | 16.6329 | 16.6375 | 108976.0 |
| 2013-08-05 08:20:00 | AAPL | Stock | 16.6429 | 16.6525 | 16.6282 | 16.6518 | 252364.0 |
| 2013-08-05 08:25:00 | AAPL | Stock | 16.6518 | 16.66 | 16.6432 | 16.6457 | 121884.0 |
| 2013-08-05 08:30:00 | AAPL | Stock | 16.6461 | 16.6536 | 16.6339 | 16.6429 | 340760.0 |
| 2013-08-05 08:35:00 | AAPL | Stock | 16.6429 | 16.6468 | 16.6357 | 16.6468 | 118776.0 |
| 2013-08-05 08:40:00 | AAPL | Stock | 16.6496 | 16.6664 | 16.6496 | 16.6536 | 153468.0 |
| 2013-08-05 08:45:00 | AAPL | Stock | 16.6536 | 16.6536 | 16.6429 | 16.6429 | 163520.0 |
| 2013-08-05 08:50:00 | AAPL | Stock | 16.6429 | 16.6471 | 16.6286 | 16.6286 | 228060.0 |
| 2013-08-05 08:55:00 | AAPL | Stock | 16.6286 | 16.6382 | 16.6236 | 16.6382 | 157640.0 |
| 2013-08-05 09:00:00 | AAPL | Stock | 16.6246 | 16.6382 | 16.6179 | 16.6196 | 182700.0 |
| 2013-08-05 09:05:00 | AAPL | Stock | 16.6196 | 16.6225 | 16.6168 | 16.6214 | 71428.0 |
| 2013-08-05 09:10:00 | AAPL | Stock | 16.6214 | 16.6357 | 16.6196 | 16.6268 | 248584.0 |
| 2013-08-05 09:15:00 | AAPL | Stock | 16.625 | 16.625 | 16.6193 | 16.6229 | 229516.0 |
| 2013-08-05 09:20:00 | AAPL | Stock | 16.6214 | 16.6336 | 16.6214 | 16.6336 | 112924.0 |
| 2013-08-05 09:25:00 | AAPL | Stock | 16.6329 | 16.6329 | 16.5932 | 16.5986 | 347676.0 |
| 2013-08-05 09:30:00 | AAPL | Stock | 16.5914 | 16.6414 | 16.5682 | 16.5864 | 20348244.0 |
| 2013-08-05 09:35:00 | AAPL | Stock | 16.5861 | 16.5993 | 16.5225 | 16.5267 | 14423360.0 |
| 2013-08-05 09:40:00 | AAPL | Stock | 16.5286 | 16.5621 | 16.5054 | 16.5129 | 8799700.0 |
| 2013-08-05 09:45:00 | AAPL | Stock | 16.515 | 16.5875 | 16.5079 | 16.5646 | 8891456.0 |
| 2013-08-05 09:50:00 | AAPL | Stock | 16.5661 | 16.5904 | 16.5514 | 16.5807 | 5216848.0 |
| 2013-08-05 09:55:00 | AAPL | Stock | 16.5825 | 16.6286 | 16.5757 | 16.62 | 5864572.0 |
| 2013-08-05 10:00:00 | AAPL | Stock | 16.62 | 16.6554 | 16.6043 | 16.6443 | 9197580.0 |
| 2013-08-05 10:05:00 | AAPL | Stock | 16.6436 | 16.6739 | 16.6393 | 16.6604 | 6752424.0 |
| 2013-08-05 10:10:00 | AAPL | Stock | 16.66 | 16.6904 | 16.66 | 16.6896 | 6710676.0 |
| 2013-08-05 10:15:00 | AAPL | Stock | 16.6879 | 16.7404 | 16.6861 | 16.7179 | 9391844.0 |
| 2013-08-05 10:20:00 | AAPL | Stock | 16.7204 | 16.7204 | 16.6789 | 16.6969 | 6033580.0 |
| 2013-08-05 10:25:00 | AAPL | Stock | 16.6943 | 16.6986 | 16.6718 | 16.6793 | 3410148.0 |
| 2013-08-05 10:30:00 | AAPL | Stock | 16.6773 | 16.6857 | 16.6525 | 16.6539 | 4052776.0 |
| 2013-08-05 10:35:00 | AAPL | Stock | 16.6567 | 16.6907 | 16.6514 | 16.6907 | 5850180.0 |
> showing 50 of 335,102 rows — these rows as CSV