PREVIEW / stock_5min / 2011-12-06
file: by_date/stock_5min/2011/2011-12-06.parquet size: 4.7 MB rows: 319,983 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 |
|---|---|---|---|---|---|---|---|
| 2011-12-06 04:00:00 | AAPL | Stock | 14.0107 | 14.0429 | 14.0107 | 14.0429 | 8400.0 |
| 2011-12-06 04:05:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 11200.0 |
| 2011-12-06 04:25:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 14000.0 |
| 2011-12-06 04:55:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 14000.0 |
| 2011-12-06 05:00:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 2800.0 |
| 2011-12-06 05:05:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 11200.0 |
| 2011-12-06 05:20:00 | AAPL | Stock | 14.0179 | 14.0179 | 14.0179 | 14.0179 | 14000.0 |
| 2011-12-06 05:35:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 11200.0 |
| 2011-12-06 05:40:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0357 | 14.0357 | 14000.0 |
| 2011-12-06 05:45:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0232 | 14.0232 | 11200.0 |
| 2011-12-06 05:50:00 | AAPL | Stock | 14.0339 | 14.0357 | 14.0339 | 14.0357 | 8708.0 |
| 2011-12-06 05:55:00 | AAPL | Stock | 14.0429 | 14.0429 | 14.0429 | 14.0429 | 5600.0 |
| 2011-12-06 06:20:00 | AAPL | Stock | 14.0446 | 14.0446 | 14.0446 | 14.0446 | 2800.0 |
| 2011-12-06 06:45:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0143 | 14.0143 | 5600.0 |
| 2011-12-06 07:00:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0357 | 14.0357 | 5600.0 |
| 2011-12-06 07:05:00 | AAPL | Stock | 14.0286 | 14.0286 | 14.0286 | 14.0286 | 8400.0 |
| 2011-12-06 07:20:00 | AAPL | Stock | 14.0393 | 14.0393 | 14.0393 | 14.0393 | 2800.0 |
| 2011-12-06 07:35:00 | AAPL | Stock | 14.0464 | 14.0471 | 14.0464 | 14.0471 | 22400.0 |
| 2011-12-06 07:40:00 | AAPL | Stock | 14.0486 | 14.05 | 14.04 | 14.04 | 16800.0 |
| 2011-12-06 07:45:00 | AAPL | Stock | 14.0361 | 14.0361 | 14.0275 | 14.0275 | 8400.0 |
| 2011-12-06 07:50:00 | AAPL | Stock | 14.0271 | 14.0271 | 14.0271 | 14.0271 | 2800.0 |
| 2011-12-06 08:00:00 | AAPL | Stock | 14.0357 | 14.0411 | 14.0286 | 14.0357 | 57400.0 |
| 2011-12-06 08:05:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0179 | 14.0304 | 129780.0 |
| 2011-12-06 08:15:00 | AAPL | Stock | 14.0225 | 14.0225 | 14.0036 | 14.0036 | 62580.0 |
| 2011-12-06 08:20:00 | AAPL | Stock | 14.0071 | 14.0071 | 13.9904 | 13.9904 | 80164.0 |
| 2011-12-06 08:25:00 | AAPL | Stock | 13.9904 | 13.9904 | 13.9732 | 13.9754 | 37380.0 |
| 2011-12-06 08:30:00 | AAPL | Stock | 13.9736 | 13.9807 | 13.9689 | 13.9807 | 39760.0 |
| 2011-12-06 08:35:00 | AAPL | Stock | 13.9786 | 13.9907 | 13.9771 | 13.9893 | 48944.0 |
| 2011-12-06 08:40:00 | AAPL | Stock | 14.0 | 14.0046 | 14.0 | 14.0004 | 23884.0 |
| 2011-12-06 08:45:00 | AAPL | Stock | 13.9979 | 14.0007 | 13.9979 | 14.0007 | 5600.0 |
| 2011-12-06 08:50:00 | AAPL | Stock | 13.9964 | 13.9993 | 13.9839 | 13.9993 | 98168.0 |
| 2011-12-06 08:55:00 | AAPL | Stock | 13.9957 | 14.0107 | 13.9957 | 14.0107 | 45080.0 |
| 2011-12-06 09:00:00 | AAPL | Stock | 14.0107 | 14.0125 | 13.9993 | 14.0125 | 142800.0 |
| 2011-12-06 09:05:00 | AAPL | Stock | 14.0125 | 14.0179 | 14.005 | 14.0179 | 34468.0 |
| 2011-12-06 09:10:00 | AAPL | Stock | 14.0154 | 14.0179 | 14.0021 | 14.0021 | 173684.0 |
| 2011-12-06 09:15:00 | AAPL | Stock | 14.0089 | 14.0154 | 14.0089 | 14.0154 | 47600.0 |
| 2011-12-06 09:20:00 | AAPL | Stock | 14.0154 | 14.0189 | 14.0154 | 14.0182 | 49700.0 |
| 2011-12-06 09:25:00 | AAPL | Stock | 14.0157 | 14.0196 | 14.0107 | 14.0196 | 221620.0 |
| 2011-12-06 09:30:00 | AAPL | Stock | 14.0196 | 14.0714 | 14.0086 | 14.0578 | 13482728.0 |
| 2011-12-06 09:35:00 | AAPL | Stock | 14.0589 | 14.0939 | 14.0561 | 14.0754 | 6309408.0 |
| 2011-12-06 09:40:00 | AAPL | Stock | 14.0755 | 14.08 | 14.045 | 14.0543 | 4614624.0 |
| 2011-12-06 09:45:00 | AAPL | Stock | 14.0548 | 14.0679 | 14.03 | 14.0407 | 6153420.0 |
| 2011-12-06 09:50:00 | AAPL | Stock | 14.04 | 14.0518 | 14.0304 | 14.0464 | 4940964.0 |
| 2011-12-06 09:55:00 | AAPL | Stock | 14.0446 | 14.0693 | 14.0394 | 14.0532 | 7551600.0 |
| 2011-12-06 10:00:00 | AAPL | Stock | 14.0518 | 14.0654 | 14.0457 | 14.0586 | 4438196.0 |
| 2011-12-06 10:05:00 | AAPL | Stock | 14.058 | 14.0657 | 14.0436 | 14.0514 | 5053664.0 |
| 2011-12-06 10:10:00 | AAPL | Stock | 14.0496 | 14.0529 | 13.9907 | 14.0075 | 8394008.0 |
| 2011-12-06 10:15:00 | AAPL | Stock | 14.0075 | 14.015 | 13.9921 | 14.0086 | 5511660.0 |
| 2011-12-06 10:20:00 | AAPL | Stock | 14.0071 | 14.0099 | 13.95 | 13.9932 | 9106524.0 |
| 2011-12-06 10:25:00 | AAPL | Stock | 13.9904 | 14.0143 | 13.99 | 14.0045 | 3067092.0 |
> showing 50 of 319,983 rows — these rows as CSV