PREVIEW / stock_5min / 2010-08-18
file: by_date/stock_5min/2010/2010-08-18.parquet size: 4.6 MB rows: 318,448 symbols: 3,469
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-18 04:05:00 | AAPL | Stock | 8.9964 | 8.9964 | 8.9964 | 8.9964 | 11900.0 |
| 2010-08-18 04:35:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 2800.0 |
| 2010-08-18 05:15:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 11200.0 |
| 2010-08-18 05:45:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 5600.0 |
| 2010-08-18 05:55:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 3724.0 |
| 2010-08-18 06:15:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0286 | 9.0286 | 2800.0 |
| 2010-08-18 06:50:00 | AAPL | Stock | 9.025 | 9.025 | 9.0246 | 9.0246 | 5600.0 |
| 2010-08-18 07:05:00 | AAPL | Stock | 9.0071 | 9.0071 | 9.0071 | 9.0071 | 5600.0 |
| 2010-08-18 07:35:00 | AAPL | Stock | 9.0175 | 9.0175 | 9.0175 | 9.0175 | 5600.0 |
| 2010-08-18 07:40:00 | AAPL | Stock | 9.0161 | 9.0214 | 9.0161 | 9.0214 | 28000.0 |
| 2010-08-18 07:45:00 | AAPL | Stock | 9.0286 | 9.0304 | 9.0286 | 9.0304 | 26320.0 |
| 2010-08-18 07:55:00 | AAPL | Stock | 9.0304 | 9.0346 | 9.0304 | 9.0307 | 28000.0 |
| 2010-08-18 08:00:00 | AAPL | Stock | 9.0286 | 9.0286 | 8.9964 | 8.9982 | 185780.0 |
| 2010-08-18 08:05:00 | AAPL | Stock | 8.9993 | 9.0054 | 8.9993 | 9.0036 | 66080.0 |
| 2010-08-18 08:10:00 | AAPL | Stock | 9.0018 | 9.0061 | 8.9968 | 8.9968 | 132356.0 |
| 2010-08-18 08:15:00 | AAPL | Stock | 9.0043 | 9.0168 | 9.0043 | 9.0168 | 97160.0 |
| 2010-08-18 08:20:00 | AAPL | Stock | 9.0182 | 9.0246 | 9.0182 | 9.0246 | 160440.0 |
| 2010-08-18 08:25:00 | AAPL | Stock | 9.0239 | 9.0261 | 9.0214 | 9.0261 | 131460.0 |
| 2010-08-18 08:30:00 | AAPL | Stock | 9.0264 | 9.0264 | 9.0207 | 9.0214 | 131684.0 |
| 2010-08-18 08:35:00 | AAPL | Stock | 9.02 | 9.0243 | 9.02 | 9.0232 | 25200.0 |
| 2010-08-18 08:40:00 | AAPL | Stock | 9.0232 | 9.0268 | 9.0204 | 9.0268 | 70000.0 |
| 2010-08-18 08:45:00 | AAPL | Stock | 9.0246 | 9.0286 | 9.0246 | 9.0286 | 55020.0 |
| 2010-08-18 08:50:00 | AAPL | Stock | 9.0296 | 9.0354 | 9.0296 | 9.0339 | 298760.0 |
| 2010-08-18 08:55:00 | AAPL | Stock | 9.0343 | 9.0461 | 9.0332 | 9.0443 | 306600.0 |
| 2010-08-18 09:00:00 | AAPL | Stock | 9.0443 | 9.0496 | 9.0379 | 9.0379 | 271908.0 |
| 2010-08-18 09:05:00 | AAPL | Stock | 9.0379 | 9.0379 | 9.0275 | 9.0289 | 116060.0 |
| 2010-08-18 09:10:00 | AAPL | Stock | 9.0289 | 9.0307 | 9.0257 | 9.0268 | 64932.0 |
| 2010-08-18 09:15:00 | AAPL | Stock | 9.0268 | 9.0307 | 9.0268 | 9.0307 | 68460.0 |
| 2010-08-18 09:20:00 | AAPL | Stock | 9.035 | 9.0357 | 9.0289 | 9.0289 | 28000.0 |
| 2010-08-18 09:25:00 | AAPL | Stock | 9.0289 | 9.0439 | 9.0121 | 9.0132 | 386820.0 |
| 2010-08-18 09:30:00 | AAPL | Stock | 9.0186 | 9.0414 | 8.9936 | 8.9957 | 16451624.0 |
| 2010-08-18 09:35:00 | AAPL | Stock | 8.995 | 9.0214 | 8.985 | 9.0199 | 9477468.0 |
| 2010-08-18 09:40:00 | AAPL | Stock | 9.0189 | 9.0221 | 8.9929 | 8.9993 | 8469048.0 |
| 2010-08-18 09:45:00 | AAPL | Stock | 8.9957 | 9.0232 | 8.9904 | 9.0101 | 6538616.0 |
| 2010-08-18 09:50:00 | AAPL | Stock | 9.0104 | 9.0257 | 9.0039 | 9.0189 | 5887756.0 |
| 2010-08-18 09:55:00 | AAPL | Stock | 9.0189 | 9.0407 | 9.0089 | 9.0407 | 7026292.0 |
| 2010-08-18 10:00:00 | AAPL | Stock | 9.0407 | 9.07 | 9.0382 | 9.0671 | 12293288.0 |
| 2010-08-18 10:05:00 | AAPL | Stock | 9.067 | 9.08 | 9.0572 | 9.0607 | 10662876.0 |
| 2010-08-18 10:10:00 | AAPL | Stock | 9.0603 | 9.075 | 9.0583 | 9.0671 | 4046840.0 |
| 2010-08-18 10:15:00 | AAPL | Stock | 9.0689 | 9.0732 | 9.0543 | 9.0561 | 4463648.0 |
| 2010-08-18 10:20:00 | AAPL | Stock | 9.0554 | 9.0589 | 9.0429 | 9.0507 | 5210212.0 |
| 2010-08-18 10:25:00 | AAPL | Stock | 9.0493 | 9.0514 | 9.0161 | 9.0268 | 7724332.0 |
| 2010-08-18 10:30:00 | AAPL | Stock | 9.0289 | 9.0429 | 9.0261 | 9.0389 | 4400648.0 |
| 2010-08-18 10:35:00 | AAPL | Stock | 9.0407 | 9.0525 | 9.0354 | 9.0471 | 3332000.0 |
| 2010-08-18 10:40:00 | AAPL | Stock | 9.0493 | 9.0529 | 9.045 | 9.0511 | 2069060.0 |
| 2010-08-18 10:45:00 | AAPL | Stock | 9.0507 | 9.0509 | 9.0361 | 9.0394 | 2337916.0 |
| 2010-08-18 10:50:00 | AAPL | Stock | 9.0397 | 9.0432 | 9.0221 | 9.0328 | 3110156.0 |
| 2010-08-18 10:55:00 | AAPL | Stock | 9.0329 | 9.0464 | 9.0271 | 9.0457 | 1901732.0 |
| 2010-08-18 11:00:00 | AAPL | Stock | 9.0449 | 9.0582 | 9.0357 | 9.0546 | 3065524.0 |
| 2010-08-18 11:05:00 | AAPL | Stock | 9.0561 | 9.0671 | 9.0561 | 9.0604 | 6759928.0 |
> showing 50 of 318,448 rows — these rows as CSV