PREVIEW / stock_1min / 2011-12-19
file: by_date/stock_1min/2011/2011-12-19.parquet size: 13.0 MB rows: 970,611 symbols: 2,860
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-12-19 05:36:00 | AAPL | Stock | 13.6571 | 13.6571 | 13.6571 | 13.6571 | 2800.0 |
| 2011-12-19 05:48:00 | AAPL | Stock | 13.6507 | 13.6507 | 13.6507 | 13.6507 | 2800.0 |
| 2011-12-19 05:52:00 | AAPL | Stock | 13.6507 | 13.6507 | 13.6507 | 13.6507 | 2800.0 |
| 2011-12-19 06:57:00 | AAPL | Stock | 13.6557 | 13.6557 | 13.6557 | 13.6557 | 2800.0 |
| 2011-12-19 07:00:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 8400.0 |
| 2011-12-19 07:01:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 14000.0 |
| 2011-12-19 07:03:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6786 | 13.6786 | 5600.0 |
| 2011-12-19 07:06:00 | AAPL | Stock | 13.6679 | 13.6679 | 13.6679 | 13.6679 | 2800.0 |
| 2011-12-19 07:07:00 | AAPL | Stock | 13.6629 | 13.6629 | 13.6429 | 13.6429 | 25200.0 |
| 2011-12-19 07:08:00 | AAPL | Stock | 13.6604 | 13.6604 | 13.6604 | 13.6604 | 2800.0 |
| 2011-12-19 07:09:00 | AAPL | Stock | 13.6579 | 13.6579 | 13.6579 | 13.6579 | 2800.0 |
| 2011-12-19 07:13:00 | AAPL | Stock | 13.6579 | 13.6679 | 13.6579 | 13.6679 | 14000.0 |
| 2011-12-19 07:17:00 | AAPL | Stock | 13.6761 | 13.6761 | 13.6761 | 13.6761 | 4200.0 |
| 2011-12-19 07:21:00 | AAPL | Stock | 13.6625 | 13.6625 | 13.6607 | 13.6607 | 14084.0 |
| 2011-12-19 07:24:00 | AAPL | Stock | 13.6607 | 13.6607 | 13.6607 | 13.6607 | 8400.0 |
| 2011-12-19 07:33:00 | AAPL | Stock | 13.6675 | 13.6679 | 13.6675 | 13.6679 | 5600.0 |
| 2011-12-19 07:34:00 | AAPL | Stock | 13.6679 | 13.6679 | 13.6679 | 13.6679 | 2800.0 |
| 2011-12-19 07:36:00 | AAPL | Stock | 13.6714 | 13.6714 | 13.6714 | 13.6714 | 2800.0 |
| 2011-12-19 07:37:00 | AAPL | Stock | 13.6679 | 13.6679 | 13.6679 | 13.6679 | 2800.0 |
| 2011-12-19 07:43:00 | AAPL | Stock | 13.6782 | 13.6782 | 13.6782 | 13.6782 | 2800.0 |
| 2011-12-19 07:46:00 | AAPL | Stock | 13.6721 | 13.6721 | 13.6696 | 13.6696 | 8400.0 |
| 2011-12-19 07:48:00 | AAPL | Stock | 13.665 | 13.665 | 13.665 | 13.665 | 8400.0 |
| 2011-12-19 07:54:00 | AAPL | Stock | 13.6571 | 13.6571 | 13.6571 | 13.6571 | 2800.0 |
| 2011-12-19 07:55:00 | AAPL | Stock | 13.6511 | 13.6575 | 13.6479 | 13.6525 | 46480.0 |
| 2011-12-19 07:56:00 | AAPL | Stock | 13.6529 | 13.6529 | 13.6525 | 13.6525 | 33600.0 |
| 2011-12-19 07:58:00 | AAPL | Stock | 13.6479 | 13.6479 | 13.6479 | 13.6479 | 2800.0 |
| 2011-12-19 07:59:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6518 | 13.6518 | 11200.0 |
| 2011-12-19 08:00:00 | AAPL | Stock | 13.6457 | 13.6518 | 13.6386 | 13.6429 | 42392.0 |
| 2011-12-19 08:01:00 | AAPL | Stock | 13.6461 | 13.6461 | 13.6461 | 13.6461 | 2800.0 |
| 2011-12-19 08:02:00 | AAPL | Stock | 13.6375 | 13.6375 | 13.6375 | 13.6375 | 2800.0 |
| 2011-12-19 08:03:00 | AAPL | Stock | 13.6339 | 13.6339 | 13.6339 | 13.6339 | 2800.0 |
| 2011-12-19 08:04:00 | AAPL | Stock | 13.6268 | 13.6268 | 13.625 | 13.625 | 50484.0 |
| 2011-12-19 08:05:00 | AAPL | Stock | 13.625 | 13.6321 | 13.625 | 13.6321 | 111356.0 |
| 2011-12-19 08:08:00 | AAPL | Stock | 13.6389 | 13.6414 | 13.6386 | 13.6386 | 17360.0 |
| 2011-12-19 08:09:00 | AAPL | Stock | 13.6386 | 13.6429 | 13.6386 | 13.6429 | 8400.0 |
| 2011-12-19 08:10:00 | AAPL | Stock | 13.6375 | 13.6418 | 13.6375 | 13.6418 | 16800.0 |
| 2011-12-19 08:11:00 | AAPL | Stock | 13.6375 | 13.6443 | 13.6375 | 13.6443 | 25200.0 |
| 2011-12-19 08:12:00 | AAPL | Stock | 13.6443 | 13.6518 | 13.6443 | 13.6518 | 9240.0 |
| 2011-12-19 08:13:00 | AAPL | Stock | 13.65 | 13.6518 | 13.65 | 13.6518 | 5600.0 |
| 2011-12-19 08:15:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6518 | 13.6518 | 2800.0 |
| 2011-12-19 08:16:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6518 | 13.6518 | 3024.0 |
| 2011-12-19 08:18:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6375 | 13.6375 | 5600.0 |
| 2011-12-19 08:20:00 | AAPL | Stock | 13.6393 | 13.6429 | 13.6393 | 13.6429 | 11480.0 |
| 2011-12-19 08:21:00 | AAPL | Stock | 13.6464 | 13.6468 | 13.6464 | 13.6468 | 30800.0 |
| 2011-12-19 08:23:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 10500.0 |
| 2011-12-19 08:25:00 | AAPL | Stock | 13.6504 | 13.6536 | 13.6482 | 13.6536 | 8400.0 |
| 2011-12-19 08:26:00 | AAPL | Stock | 13.6589 | 13.6589 | 13.6589 | 13.6589 | 2800.0 |
| 2011-12-19 08:30:00 | AAPL | Stock | 13.6571 | 13.6571 | 13.6571 | 13.6571 | 8400.0 |
| 2011-12-19 08:31:00 | AAPL | Stock | 13.6589 | 13.66 | 13.6571 | 13.66 | 22400.0 |
| 2011-12-19 08:32:00 | AAPL | Stock | 13.66 | 13.6643 | 13.66 | 13.6643 | 23660.0 |
> showing 50 of 970,611 rows — these rows as CSV