PREVIEW / stock_5min / 2012-02-16
file: by_date/stock_5min/2012/2012-02-16.parquet size: 5.0 MB rows: 332,237 symbols: 3,526
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-16 04:00:00 | AAPL | Stock | 17.6079 | 17.6079 | 17.6079 | 17.6079 | 28000.0 |
| 2012-02-16 04:10:00 | AAPL | Stock | 17.6418 | 17.6418 | 17.6418 | 17.6418 | 2800.0 |
| 2012-02-16 04:15:00 | AAPL | Stock | 17.665 | 17.665 | 17.665 | 17.665 | 5600.0 |
| 2012-02-16 04:40:00 | AAPL | Stock | 17.6961 | 17.6964 | 17.6961 | 17.6964 | 16800.0 |
| 2012-02-16 04:45:00 | AAPL | Stock | 17.6789 | 17.6789 | 17.6789 | 17.6789 | 5600.0 |
| 2012-02-16 04:50:00 | AAPL | Stock | 17.6789 | 17.6789 | 17.6786 | 17.6786 | 8400.0 |
| 2012-02-16 04:55:00 | AAPL | Stock | 17.7071 | 17.7071 | 17.7071 | 17.7071 | 7840.0 |
| 2012-02-16 05:00:00 | AAPL | Stock | 17.6843 | 17.6843 | 17.6786 | 17.6786 | 5600.0 |
| 2012-02-16 05:05:00 | AAPL | Stock | 17.7218 | 17.7218 | 17.7 | 17.7 | 6552.0 |
| 2012-02-16 05:10:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7214 | 17.7214 | 28000.0 |
| 2012-02-16 05:35:00 | AAPL | Stock | 17.7061 | 17.7061 | 17.7 | 17.7054 | 11200.0 |
| 2012-02-16 05:50:00 | AAPL | Stock | 17.7061 | 17.7061 | 17.7061 | 17.7061 | 2800.0 |
| 2012-02-16 06:05:00 | AAPL | Stock | 17.7264 | 17.7264 | 17.7171 | 17.7171 | 10920.0 |
| 2012-02-16 06:10:00 | AAPL | Stock | 17.7132 | 17.7132 | 17.7132 | 17.7132 | 2800.0 |
| 2012-02-16 06:20:00 | AAPL | Stock | 17.7314 | 17.7314 | 17.7314 | 17.7314 | 17080.0 |
| 2012-02-16 06:35:00 | AAPL | Stock | 17.7314 | 17.7314 | 17.7286 | 17.7286 | 14000.0 |
| 2012-02-16 06:50:00 | AAPL | Stock | 17.7146 | 17.7146 | 17.7146 | 17.7146 | 2800.0 |
| 2012-02-16 07:00:00 | AAPL | Stock | 17.7121 | 17.7121 | 17.6361 | 17.6375 | 187376.0 |
| 2012-02-16 07:05:00 | AAPL | Stock | 17.6321 | 17.6679 | 17.6157 | 17.6679 | 220752.0 |
| 2012-02-16 07:10:00 | AAPL | Stock | 17.6571 | 17.6779 | 17.6521 | 17.6779 | 14000.0 |
| 2012-02-16 07:15:00 | AAPL | Stock | 17.6768 | 17.6782 | 17.6768 | 17.6782 | 14336.0 |
| 2012-02-16 07:20:00 | AAPL | Stock | 17.6696 | 17.6964 | 17.6607 | 17.6793 | 202832.0 |
| 2012-02-16 07:25:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6536 | 17.6714 | 20104.0 |
| 2012-02-16 07:30:00 | AAPL | Stock | 17.6471 | 17.6707 | 17.6286 | 17.6393 | 204344.0 |
| 2012-02-16 07:35:00 | AAPL | Stock | 17.6446 | 17.6536 | 17.6286 | 17.6346 | 125104.0 |
| 2012-02-16 07:40:00 | AAPL | Stock | 17.635 | 17.6429 | 17.6257 | 17.6271 | 107100.0 |
| 2012-02-16 07:45:00 | AAPL | Stock | 17.6389 | 17.6607 | 17.6361 | 17.6429 | 34160.0 |
| 2012-02-16 07:50:00 | AAPL | Stock | 17.655 | 17.655 | 17.6393 | 17.6393 | 84000.0 |
| 2012-02-16 07:55:00 | AAPL | Stock | 17.6429 | 17.6457 | 17.6311 | 17.6457 | 248192.0 |
| 2012-02-16 08:00:00 | AAPL | Stock | 17.6361 | 17.6786 | 17.5893 | 17.6075 | 1112804.0 |
| 2012-02-16 08:05:00 | AAPL | Stock | 17.6089 | 17.6179 | 17.5861 | 17.6079 | 612080.0 |
| 2012-02-16 08:10:00 | AAPL | Stock | 17.6114 | 17.6321 | 17.6075 | 17.6321 | 177464.0 |
| 2012-02-16 08:15:00 | AAPL | Stock | 17.6346 | 17.6693 | 17.6332 | 17.6639 | 503776.0 |
| 2012-02-16 08:20:00 | AAPL | Stock | 17.6643 | 17.6786 | 17.6511 | 17.6718 | 480312.0 |
| 2012-02-16 08:25:00 | AAPL | Stock | 17.6764 | 17.7061 | 17.6686 | 17.7054 | 698712.0 |
| 2012-02-16 08:30:00 | AAPL | Stock | 17.7061 | 17.7382 | 17.6968 | 17.7321 | 732228.0 |
| 2012-02-16 08:35:00 | AAPL | Stock | 17.735 | 17.7618 | 17.7164 | 17.7618 | 1293740.0 |
| 2012-02-16 08:40:00 | AAPL | Stock | 17.7514 | 17.7857 | 17.7411 | 17.7618 | 1938720.0 |
| 2012-02-16 08:45:00 | AAPL | Stock | 17.7632 | 17.7636 | 17.7293 | 17.7429 | 1069376.0 |
| 2012-02-16 08:50:00 | AAPL | Stock | 17.7457 | 17.75 | 17.6964 | 17.6968 | 1413384.0 |
| 2012-02-16 08:55:00 | AAPL | Stock | 17.6982 | 17.7082 | 17.6664 | 17.685 | 710444.0 |
| 2012-02-16 09:00:00 | AAPL | Stock | 17.6786 | 17.7057 | 17.6714 | 17.6843 | 757876.0 |
| 2012-02-16 09:05:00 | AAPL | Stock | 17.6807 | 17.71 | 17.6786 | 17.6968 | 1053556.0 |
| 2012-02-16 09:10:00 | AAPL | Stock | 17.7025 | 17.715 | 17.6786 | 17.6964 | 1475068.0 |
| 2012-02-16 09:15:00 | AAPL | Stock | 17.6896 | 17.7 | 17.6568 | 17.6875 | 1008756.0 |
| 2012-02-16 09:20:00 | AAPL | Stock | 17.6832 | 17.6889 | 17.6171 | 17.6175 | 1661016.0 |
| 2012-02-16 09:25:00 | AAPL | Stock | 17.6236 | 17.6414 | 17.5521 | 17.5536 | 3071404.0 |
| 2012-02-16 09:30:00 | AAPL | Stock | 17.5539 | 17.6196 | 17.4304 | 17.6079 | 57908956.0 |
| 2012-02-16 09:35:00 | AAPL | Stock | 17.6 | 17.6075 | 17.3796 | 17.4529 | 46380824.0 |
| 2012-02-16 09:40:00 | AAPL | Stock | 17.4532 | 17.5246 | 17.4404 | 17.5054 | 30432724.0 |
> showing 50 of 332,237 rows — these rows as CSV