PREVIEW / stock_5min / 2012-07-06
file: by_date/stock_5min/2012/2012-07-06.parquet size: 4.5 MB rows: 311,290 symbols: 3,477
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-07-06 04:15:00 | AAPL | Stock | 21.6825 | 21.6825 | 21.6821 | 21.6821 | 5600.0 |
| 2012-07-06 04:20:00 | AAPL | Stock | 21.6789 | 21.6789 | 21.6786 | 21.6786 | 14000.0 |
| 2012-07-06 04:25:00 | AAPL | Stock | 21.6789 | 21.6789 | 21.6789 | 21.6789 | 5600.0 |
| 2012-07-06 04:40:00 | AAPL | Stock | 21.6471 | 21.6786 | 21.6471 | 21.6786 | 8400.0 |
| 2012-07-06 04:45:00 | AAPL | Stock | 21.6471 | 21.6639 | 21.6471 | 21.6471 | 28700.0 |
| 2012-07-06 05:00:00 | AAPL | Stock | 21.6471 | 21.6471 | 21.6471 | 21.6471 | 4900.0 |
| 2012-07-06 05:25:00 | AAPL | Stock | 21.6232 | 21.6232 | 21.6232 | 21.6232 | 2800.0 |
| 2012-07-06 05:35:00 | AAPL | Stock | 21.6232 | 21.6232 | 21.6232 | 21.6232 | 4172.0 |
| 2012-07-06 05:40:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6107 | 21.6107 | 8400.0 |
| 2012-07-06 05:45:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6071 | 21.6071 | 12740.0 |
| 2012-07-06 05:50:00 | AAPL | Stock | 21.6125 | 21.6125 | 21.6118 | 21.6118 | 5600.0 |
| 2012-07-06 05:55:00 | AAPL | Stock | 21.6118 | 21.6118 | 21.6071 | 21.6071 | 5600.0 |
| 2012-07-06 06:05:00 | AAPL | Stock | 21.6336 | 21.6336 | 21.6336 | 21.6336 | 2800.0 |
| 2012-07-06 06:15:00 | AAPL | Stock | 21.6339 | 21.6339 | 21.6339 | 21.6339 | 26600.0 |
| 2012-07-06 06:20:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6518 | 21.6518 | 2800.0 |
| 2012-07-06 06:25:00 | AAPL | Stock | 21.6518 | 21.6518 | 21.6518 | 21.6518 | 2800.0 |
| 2012-07-06 06:45:00 | AAPL | Stock | 21.6679 | 21.6679 | 21.6679 | 21.6679 | 5600.0 |
| 2012-07-06 07:00:00 | AAPL | Stock | 21.6696 | 21.6911 | 21.6689 | 21.6786 | 47908.0 |
| 2012-07-06 07:05:00 | AAPL | Stock | 21.6875 | 21.7136 | 21.6875 | 21.7136 | 25424.0 |
| 2012-07-06 07:10:00 | AAPL | Stock | 21.7039 | 21.7675 | 21.7039 | 21.7661 | 74928.0 |
| 2012-07-06 07:15:00 | AAPL | Stock | 21.7582 | 21.7582 | 21.7582 | 21.7582 | 2800.0 |
| 2012-07-06 07:20:00 | AAPL | Stock | 21.7454 | 21.7457 | 21.7236 | 21.7357 | 28000.0 |
| 2012-07-06 07:25:00 | AAPL | Stock | 21.7357 | 21.75 | 21.7357 | 21.75 | 12684.0 |
| 2012-07-06 07:30:00 | AAPL | Stock | 21.7589 | 21.7679 | 21.7589 | 21.7625 | 40376.0 |
| 2012-07-06 07:35:00 | AAPL | Stock | 21.7536 | 21.7536 | 21.7536 | 21.7536 | 5040.0 |
| 2012-07-06 07:40:00 | AAPL | Stock | 21.7643 | 21.7643 | 21.7614 | 21.7625 | 14000.0 |
| 2012-07-06 07:45:00 | AAPL | Stock | 21.7625 | 21.7625 | 21.7482 | 21.75 | 41216.0 |
| 2012-07-06 07:50:00 | AAPL | Stock | 21.7511 | 21.7511 | 21.7393 | 21.7454 | 70000.0 |
| 2012-07-06 07:55:00 | AAPL | Stock | 21.74 | 21.74 | 21.7257 | 21.7257 | 130592.0 |
| 2012-07-06 08:00:00 | AAPL | Stock | 21.7314 | 21.7464 | 21.6964 | 21.7375 | 183596.0 |
| 2012-07-06 08:05:00 | AAPL | Stock | 21.7382 | 21.7382 | 21.7232 | 21.7321 | 200872.0 |
| 2012-07-06 08:10:00 | AAPL | Stock | 21.7357 | 21.75 | 21.7321 | 21.7454 | 153720.0 |
| 2012-07-06 08:15:00 | AAPL | Stock | 21.7393 | 21.7425 | 21.735 | 21.7425 | 272944.0 |
| 2012-07-06 08:20:00 | AAPL | Stock | 21.7364 | 21.7429 | 21.7357 | 21.7429 | 76132.0 |
| 2012-07-06 08:25:00 | AAPL | Stock | 21.7429 | 21.7464 | 21.7364 | 21.74 | 164500.0 |
| 2012-07-06 08:30:00 | AAPL | Stock | 21.7393 | 21.7393 | 21.6646 | 21.6786 | 1306480.0 |
| 2012-07-06 08:35:00 | AAPL | Stock | 21.6789 | 21.6864 | 21.6521 | 21.6757 | 529732.0 |
| 2012-07-06 08:40:00 | AAPL | Stock | 21.6696 | 21.6929 | 21.6696 | 21.6786 | 211260.0 |
| 2012-07-06 08:45:00 | AAPL | Stock | 21.6732 | 21.675 | 21.6479 | 21.6518 | 610260.0 |
| 2012-07-06 08:50:00 | AAPL | Stock | 21.6507 | 21.6536 | 21.6279 | 21.6339 | 824880.0 |
| 2012-07-06 08:55:00 | AAPL | Stock | 21.6375 | 21.6571 | 21.6375 | 21.6571 | 295008.0 |
| 2012-07-06 09:00:00 | AAPL | Stock | 21.6571 | 21.6571 | 21.6443 | 21.6525 | 349496.0 |
| 2012-07-06 09:05:00 | AAPL | Stock | 21.655 | 21.6679 | 21.6546 | 21.6643 | 248976.0 |
| 2012-07-06 09:10:00 | AAPL | Stock | 21.6629 | 21.6696 | 21.6614 | 21.6629 | 390292.0 |
| 2012-07-06 09:15:00 | AAPL | Stock | 21.665 | 21.6732 | 21.665 | 21.6696 | 282632.0 |
| 2012-07-06 09:20:00 | AAPL | Stock | 21.6707 | 21.6889 | 21.6696 | 21.6889 | 286188.0 |
| 2012-07-06 09:25:00 | AAPL | Stock | 21.6893 | 21.6893 | 21.6696 | 21.6814 | 876652.0 |
| 2012-07-06 09:30:00 | AAPL | Stock | 21.6818 | 21.73 | 21.6371 | 21.6429 | 20016276.0 |
| 2012-07-06 09:35:00 | AAPL | Stock | 21.6475 | 21.7229 | 21.6293 | 21.6536 | 12693800.0 |
| 2012-07-06 09:40:00 | AAPL | Stock | 21.6521 | 21.6714 | 21.6307 | 21.6632 | 8254232.0 |
> showing 50 of 311,290 rows — these rows as CSV