PREVIEW / stock_1min / 2011-08-17
file: by_date/stock_1min/2011/2011-08-17.parquet size: 13.2 MB rows: 991,366 symbols: 2,840
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-17 04:20:00 | AAPL | Stock | 13.58 | 13.58 | 13.58 | 13.58 | 2800.0 |
| 2011-08-17 04:50:00 | AAPL | Stock | 13.5532 | 13.5532 | 13.5532 | 13.5532 | 2800.0 |
| 2011-08-17 05:40:00 | AAPL | Stock | 13.6246 | 13.6246 | 13.6246 | 13.6246 | 8400.0 |
| 2011-08-17 06:18:00 | AAPL | Stock | 13.5696 | 13.5696 | 13.5689 | 13.5689 | 5600.0 |
| 2011-08-17 06:47:00 | AAPL | Stock | 13.6143 | 13.6143 | 13.6143 | 13.6143 | 5600.0 |
| 2011-08-17 06:52:00 | AAPL | Stock | 13.6225 | 13.6225 | 13.6225 | 13.6225 | 2800.0 |
| 2011-08-17 06:53:00 | AAPL | Stock | 13.6382 | 13.6386 | 13.6382 | 13.6386 | 5600.0 |
| 2011-08-17 06:55:00 | AAPL | Stock | 13.645 | 13.6475 | 13.645 | 13.6475 | 5600.0 |
| 2011-08-17 07:00:00 | AAPL | Stock | 13.6075 | 13.6075 | 13.6071 | 13.6071 | 14000.0 |
| 2011-08-17 07:01:00 | AAPL | Stock | 13.6129 | 13.6129 | 13.6071 | 13.6071 | 11200.0 |
| 2011-08-17 07:02:00 | AAPL | Stock | 13.6346 | 13.6346 | 13.6346 | 13.6346 | 2800.0 |
| 2011-08-17 07:07:00 | AAPL | Stock | 13.6386 | 13.6386 | 13.6386 | 13.6386 | 5600.0 |
| 2011-08-17 07:09:00 | AAPL | Stock | 13.6439 | 13.6439 | 13.6439 | 13.6439 | 8400.0 |
| 2011-08-17 07:13:00 | AAPL | Stock | 13.6411 | 13.6411 | 13.6411 | 13.6411 | 2800.0 |
| 2011-08-17 07:14:00 | AAPL | Stock | 13.6429 | 13.6475 | 13.6429 | 13.6475 | 16044.0 |
| 2011-08-17 07:15:00 | AAPL | Stock | 13.6507 | 13.6607 | 13.65 | 13.6607 | 17248.0 |
| 2011-08-17 07:19:00 | AAPL | Stock | 13.6507 | 13.6507 | 13.6429 | 13.6429 | 10724.0 |
| 2011-08-17 07:23:00 | AAPL | Stock | 13.6425 | 13.6425 | 13.6425 | 13.6425 | 2800.0 |
| 2011-08-17 07:25:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 12572.0 |
| 2011-08-17 07:28:00 | AAPL | Stock | 13.6446 | 13.6446 | 13.6446 | 13.6446 | 2800.0 |
| 2011-08-17 07:32:00 | AAPL | Stock | 13.6529 | 13.6529 | 13.6461 | 13.6461 | 5600.0 |
| 2011-08-17 07:34:00 | AAPL | Stock | 13.6468 | 13.6468 | 13.6461 | 13.6461 | 19600.0 |
| 2011-08-17 07:35:00 | AAPL | Stock | 13.6529 | 13.6529 | 13.6529 | 13.6529 | 5600.0 |
| 2011-08-17 07:36:00 | AAPL | Stock | 13.6532 | 13.6536 | 13.6532 | 13.6536 | 5600.0 |
| 2011-08-17 07:37:00 | AAPL | Stock | 13.6571 | 13.6732 | 13.6571 | 13.6732 | 19600.0 |
| 2011-08-17 07:39:00 | AAPL | Stock | 13.6721 | 13.6721 | 13.6721 | 13.6721 | 2800.0 |
| 2011-08-17 07:40:00 | AAPL | Stock | 13.6693 | 13.6693 | 13.6636 | 13.6639 | 50400.0 |
| 2011-08-17 07:41:00 | AAPL | Stock | 13.6643 | 13.6704 | 13.6582 | 13.6611 | 86520.0 |
| 2011-08-17 07:42:00 | AAPL | Stock | 13.6596 | 13.6596 | 13.6596 | 13.6596 | 8400.0 |
| 2011-08-17 07:43:00 | AAPL | Stock | 13.6671 | 13.6671 | 13.6575 | 13.6575 | 30800.0 |
| 2011-08-17 07:44:00 | AAPL | Stock | 13.66 | 13.6607 | 13.6557 | 13.6557 | 9800.0 |
| 2011-08-17 07:45:00 | AAPL | Stock | 13.6539 | 13.6539 | 13.6464 | 13.6464 | 53200.0 |
| 2011-08-17 07:46:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 2800.0 |
| 2011-08-17 07:47:00 | AAPL | Stock | 13.6361 | 13.6361 | 13.625 | 13.625 | 39200.0 |
| 2011-08-17 07:48:00 | AAPL | Stock | 13.625 | 13.6275 | 13.625 | 13.6271 | 18480.0 |
| 2011-08-17 07:49:00 | AAPL | Stock | 13.6393 | 13.6393 | 13.6286 | 13.6286 | 5600.0 |
| 2011-08-17 07:51:00 | AAPL | Stock | 13.6314 | 13.6314 | 13.6314 | 13.6314 | 2800.0 |
| 2011-08-17 07:52:00 | AAPL | Stock | 13.6386 | 13.6386 | 13.6386 | 13.6386 | 11200.0 |
| 2011-08-17 07:53:00 | AAPL | Stock | 13.6386 | 13.6386 | 13.6386 | 13.6386 | 2800.0 |
| 2011-08-17 07:57:00 | AAPL | Stock | 13.6439 | 13.6439 | 13.6439 | 13.6439 | 5600.0 |
| 2011-08-17 08:00:00 | AAPL | Stock | 13.6411 | 13.6532 | 13.6411 | 13.6532 | 42000.0 |
| 2011-08-17 08:01:00 | AAPL | Stock | 13.6471 | 13.6571 | 13.6471 | 13.6518 | 54768.0 |
| 2011-08-17 08:02:00 | AAPL | Stock | 13.6521 | 13.6571 | 13.6479 | 13.6479 | 26796.0 |
| 2011-08-17 08:03:00 | AAPL | Stock | 13.6511 | 13.6514 | 13.6511 | 13.6514 | 10780.0 |
| 2011-08-17 08:04:00 | AAPL | Stock | 13.6518 | 13.6536 | 13.6518 | 13.6536 | 30800.0 |
| 2011-08-17 08:05:00 | AAPL | Stock | 13.6536 | 13.6536 | 13.6496 | 13.6496 | 39340.0 |
| 2011-08-17 08:06:00 | AAPL | Stock | 13.6496 | 13.6571 | 13.6496 | 13.6571 | 65828.0 |
| 2011-08-17 08:07:00 | AAPL | Stock | 13.6511 | 13.6525 | 13.65 | 13.6504 | 39200.0 |
| 2011-08-17 08:08:00 | AAPL | Stock | 13.6536 | 13.6557 | 13.6507 | 13.6518 | 39200.0 |
| 2011-08-17 08:09:00 | AAPL | Stock | 13.6536 | 13.6536 | 13.6518 | 13.6518 | 14000.0 |
> showing 50 of 991,366 rows — these rows as CSV