PREVIEW / stock_5min / 2012-06-04
file: by_date/stock_5min/2012/2012-06-04.parquet size: 4.9 MB rows: 330,688 symbols: 3,532
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-06-04 04:00:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.8682 | 19.8936 | 8400.0 |
| 2012-06-04 04:05:00 | AAPL | Stock | 19.8646 | 19.8646 | 19.8625 | 19.8625 | 31444.0 |
| 2012-06-04 04:10:00 | AAPL | Stock | 19.8821 | 19.8857 | 19.875 | 19.8857 | 24444.0 |
| 2012-06-04 04:15:00 | AAPL | Stock | 19.8893 | 19.8893 | 19.8893 | 19.8893 | 11200.0 |
| 2012-06-04 04:20:00 | AAPL | Stock | 19.8893 | 19.8893 | 19.8893 | 19.8893 | 2800.0 |
| 2012-06-04 04:30:00 | AAPL | Stock | 19.8536 | 19.8536 | 19.8536 | 19.8536 | 2800.0 |
| 2012-06-04 04:45:00 | AAPL | Stock | 19.8529 | 19.8529 | 19.8529 | 19.8529 | 25760.0 |
| 2012-06-04 04:55:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5460.0 |
| 2012-06-04 05:10:00 | AAPL | Stock | 19.8571 | 19.8571 | 19.8571 | 19.8571 | 5600.0 |
| 2012-06-04 05:15:00 | AAPL | Stock | 19.8857 | 19.8857 | 19.8857 | 19.8857 | 28000.0 |
| 2012-06-04 05:30:00 | AAPL | Stock | 19.8929 | 19.8929 | 19.8929 | 19.8929 | 2800.0 |
| 2012-06-04 05:35:00 | AAPL | Stock | 19.8932 | 19.8932 | 19.8929 | 19.8929 | 5600.0 |
| 2012-06-04 05:45:00 | AAPL | Stock | 19.9071 | 19.9071 | 19.9071 | 19.9071 | 5600.0 |
| 2012-06-04 05:50:00 | AAPL | Stock | 19.9071 | 19.9286 | 19.9071 | 19.9107 | 17276.0 |
| 2012-06-04 06:05:00 | AAPL | Stock | 19.9321 | 19.9446 | 19.9321 | 19.9446 | 14000.0 |
| 2012-06-04 06:10:00 | AAPL | Stock | 19.9525 | 19.9643 | 19.9525 | 19.9643 | 26320.0 |
| 2012-06-04 06:15:00 | AAPL | Stock | 19.9321 | 19.9321 | 19.9321 | 19.9321 | 5600.0 |
| 2012-06-04 06:20:00 | AAPL | Stock | 19.9339 | 19.9339 | 19.9339 | 19.9339 | 7980.0 |
| 2012-06-04 06:25:00 | AAPL | Stock | 19.9536 | 19.9639 | 19.9536 | 19.9639 | 14000.0 |
| 2012-06-04 06:30:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 2800.0 |
| 2012-06-04 06:35:00 | AAPL | Stock | 19.9714 | 19.9714 | 19.9714 | 19.9714 | 5600.0 |
| 2012-06-04 06:45:00 | AAPL | Stock | 20.0321 | 20.0321 | 20.0321 | 20.0321 | 5600.0 |
| 2012-06-04 06:50:00 | AAPL | Stock | 20.0354 | 20.0357 | 20.0354 | 20.0357 | 50960.0 |
| 2012-06-04 07:00:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0 | 20.0357 | 51800.0 |
| 2012-06-04 07:05:00 | AAPL | Stock | 20.0361 | 20.0489 | 20.0354 | 20.0357 | 23800.0 |
| 2012-06-04 07:10:00 | AAPL | Stock | 20.0389 | 20.0507 | 20.0357 | 20.0507 | 19180.0 |
| 2012-06-04 07:15:00 | AAPL | Stock | 20.0529 | 20.0536 | 20.0429 | 20.0536 | 32060.0 |
| 2012-06-04 07:20:00 | AAPL | Stock | 20.0357 | 20.0375 | 20.0186 | 20.0357 | 49700.0 |
| 2012-06-04 07:25:00 | AAPL | Stock | 20.0321 | 20.0321 | 20.0321 | 20.0321 | 2800.0 |
| 2012-06-04 07:30:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0075 | 20.0075 | 8400.0 |
| 2012-06-04 07:35:00 | AAPL | Stock | 20.0057 | 20.0057 | 19.9911 | 19.9911 | 11200.0 |
| 2012-06-04 07:40:00 | AAPL | Stock | 19.9843 | 20.0264 | 19.9843 | 20.0089 | 69160.0 |
| 2012-06-04 07:45:00 | AAPL | Stock | 20.0175 | 20.0568 | 20.0175 | 20.0564 | 185976.0 |
| 2012-06-04 07:50:00 | AAPL | Stock | 20.0439 | 20.0671 | 20.0439 | 20.0671 | 70980.0 |
| 2012-06-04 07:55:00 | AAPL | Stock | 20.065 | 20.0864 | 20.065 | 20.0664 | 56000.0 |
| 2012-06-04 08:00:00 | AAPL | Stock | 20.0625 | 20.0893 | 19.9821 | 20.0879 | 350056.0 |
| 2012-06-04 08:05:00 | AAPL | Stock | 20.0857 | 20.0893 | 20.0643 | 20.0643 | 343308.0 |
| 2012-06-04 08:10:00 | AAPL | Stock | 20.0643 | 20.1071 | 20.0571 | 20.1071 | 151900.0 |
| 2012-06-04 08:15:00 | AAPL | Stock | 20.1104 | 20.1161 | 20.1039 | 20.1071 | 178052.0 |
| 2012-06-04 08:20:00 | AAPL | Stock | 20.1136 | 20.1236 | 20.1075 | 20.1086 | 252224.0 |
| 2012-06-04 08:25:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.0893 | 20.0946 | 68740.0 |
| 2012-06-04 08:30:00 | AAPL | Stock | 20.0946 | 20.1061 | 20.0946 | 20.0946 | 102620.0 |
| 2012-06-04 08:35:00 | AAPL | Stock | 20.0964 | 20.0968 | 20.0793 | 20.0929 | 138684.0 |
| 2012-06-04 08:40:00 | AAPL | Stock | 20.0932 | 20.0932 | 20.0714 | 20.0714 | 144452.0 |
| 2012-06-04 08:45:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0393 | 20.0393 | 309288.0 |
| 2012-06-04 08:50:00 | AAPL | Stock | 20.0432 | 20.0611 | 20.0396 | 20.0571 | 131852.0 |
| 2012-06-04 08:55:00 | AAPL | Stock | 20.0539 | 20.0836 | 20.0496 | 20.0646 | 373660.0 |
| 2012-06-04 09:00:00 | AAPL | Stock | 20.0636 | 20.0814 | 20.0536 | 20.0746 | 298312.0 |
| 2012-06-04 09:05:00 | AAPL | Stock | 20.0714 | 20.0854 | 20.0711 | 20.0821 | 124180.0 |
| 2012-06-04 09:10:00 | AAPL | Stock | 20.0864 | 20.0864 | 20.0721 | 20.075 | 101388.0 |
> showing 50 of 330,688 rows — these rows as CSV