PREVIEW / stock_5min / 2007-11-15
file: by_date/stock_5min/2007/2007-11-15.parquet size: 4.3 MB rows: 313,990 symbols: 3,193
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-15 04:15:00 | AAPL | Stock | 5.8946 | 5.8946 | 5.8946 | 5.8946 | 2800.0 |
| 2007-11-15 05:40:00 | AAPL | Stock | 5.8575 | 5.8575 | 5.8529 | 5.8529 | 8400.0 |
| 2007-11-15 05:45:00 | AAPL | Stock | 5.8536 | 5.8536 | 5.8536 | 5.8536 | 2800.0 |
| 2007-11-15 05:50:00 | AAPL | Stock | 5.8471 | 5.8471 | 5.8471 | 5.8471 | 5600.0 |
| 2007-11-15 05:55:00 | AAPL | Stock | 5.8489 | 5.8489 | 5.8489 | 5.8489 | 2800.0 |
| 2007-11-15 06:00:00 | AAPL | Stock | 5.8746 | 5.8746 | 5.8746 | 5.8746 | 11200.0 |
| 2007-11-15 06:05:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 2800.0 |
| 2007-11-15 06:35:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 28000.0 |
| 2007-11-15 07:00:00 | AAPL | Stock | 5.8571 | 5.93 | 5.8571 | 5.93 | 82068.0 |
| 2007-11-15 07:10:00 | AAPL | Stock | 5.8825 | 5.8825 | 5.8825 | 5.8825 | 9772.0 |
| 2007-11-15 07:15:00 | AAPL | Stock | 5.8818 | 5.8825 | 5.8818 | 5.8825 | 7392.0 |
| 2007-11-15 07:20:00 | AAPL | Stock | 5.8796 | 5.8829 | 5.8682 | 5.8682 | 44800.0 |
| 2007-11-15 07:25:00 | AAPL | Stock | 5.8614 | 5.8746 | 5.8614 | 5.8746 | 19600.0 |
| 2007-11-15 07:30:00 | AAPL | Stock | 5.875 | 5.8875 | 5.875 | 5.8875 | 11200.0 |
| 2007-11-15 07:35:00 | AAPL | Stock | 5.8968 | 5.9046 | 5.8968 | 5.9046 | 44492.0 |
| 2007-11-15 07:40:00 | AAPL | Stock | 5.9 | 5.9214 | 5.9 | 5.9214 | 129584.0 |
| 2007-11-15 07:50:00 | AAPL | Stock | 5.9193 | 5.9211 | 5.9171 | 5.9211 | 67760.0 |
| 2007-11-15 07:55:00 | AAPL | Stock | 5.9004 | 5.9004 | 5.8929 | 5.8932 | 68600.0 |
| 2007-11-15 08:00:00 | AAPL | Stock | 5.8932 | 5.9643 | 5.8929 | 5.9643 | 1172920.0 |
| 2007-11-15 08:05:00 | AAPL | Stock | 5.9636 | 6.0175 | 5.9479 | 6.0107 | 1523984.0 |
| 2007-11-15 08:10:00 | AAPL | Stock | 6.0071 | 6.0204 | 5.9932 | 6.0071 | 1034292.0 |
| 2007-11-15 08:15:00 | AAPL | Stock | 6.0071 | 6.0268 | 5.9982 | 6.0257 | 1219456.0 |
| 2007-11-15 08:20:00 | AAPL | Stock | 6.0257 | 6.055 | 6.0257 | 6.0475 | 1874684.0 |
| 2007-11-15 08:25:00 | AAPL | Stock | 6.0443 | 6.045 | 6.025 | 6.0289 | 1481956.0 |
| 2007-11-15 08:30:00 | AAPL | Stock | 6.0264 | 6.0607 | 6.0039 | 6.0179 | 2854516.0 |
| 2007-11-15 08:35:00 | AAPL | Stock | 6.0157 | 6.0157 | 6.0 | 6.0039 | 1513512.0 |
| 2007-11-15 08:40:00 | AAPL | Stock | 6.0032 | 6.0032 | 5.9679 | 5.9682 | 1449616.0 |
| 2007-11-15 08:45:00 | AAPL | Stock | 5.9739 | 5.9775 | 5.9136 | 5.9432 | 1946140.0 |
| 2007-11-15 08:50:00 | AAPL | Stock | 5.9446 | 5.9536 | 5.9211 | 5.95 | 2368632.0 |
| 2007-11-15 08:55:00 | AAPL | Stock | 5.95 | 5.9536 | 5.9325 | 5.935 | 1521100.0 |
| 2007-11-15 09:00:00 | AAPL | Stock | 5.9407 | 5.9436 | 5.9214 | 5.9364 | 1209460.0 |
| 2007-11-15 09:05:00 | AAPL | Stock | 5.9389 | 5.9482 | 5.9289 | 5.94 | 999600.0 |
| 2007-11-15 09:10:00 | AAPL | Stock | 5.9429 | 5.9439 | 5.9075 | 5.9161 | 1133272.0 |
| 2007-11-15 09:15:00 | AAPL | Stock | 5.9111 | 5.9329 | 5.9111 | 5.9239 | 444864.0 |
| 2007-11-15 09:20:00 | AAPL | Stock | 5.9239 | 5.9557 | 5.9239 | 5.9546 | 602728.0 |
| 2007-11-15 09:25:00 | AAPL | Stock | 5.9557 | 5.9607 | 5.9232 | 5.9364 | 782516.0 |
| 2007-11-15 09:30:00 | AAPL | Stock | 5.9425 | 6.025 | 5.9193 | 5.9771 | 42182840.0 |
| 2007-11-15 09:35:00 | AAPL | Stock | 5.9761 | 6.0279 | 5.9286 | 6.0257 | 41481020.0 |
| 2007-11-15 09:40:00 | AAPL | Stock | 6.0257 | 6.0468 | 5.9996 | 6.0175 | 31220532.0 |
| 2007-11-15 09:45:00 | AAPL | Stock | 6.0168 | 6.0289 | 5.9668 | 5.9675 | 20471948.0 |
| 2007-11-15 09:50:00 | AAPL | Stock | 5.9675 | 5.9929 | 5.9464 | 5.9471 | 25899300.0 |
| 2007-11-15 09:55:00 | AAPL | Stock | 5.9464 | 5.9732 | 5.9189 | 5.9436 | 28323456.0 |
| 2007-11-15 10:00:00 | AAPL | Stock | 5.9432 | 5.9714 | 5.9093 | 5.9636 | 46641420.0 |
| 2007-11-15 10:05:00 | AAPL | Stock | 5.9636 | 5.9996 | 5.94 | 5.9996 | 22683472.0 |
| 2007-11-15 10:10:00 | AAPL | Stock | 5.9975 | 6.015 | 5.9904 | 6.0007 | 20820856.0 |
| 2007-11-15 10:15:00 | AAPL | Stock | 6.0018 | 6.0107 | 5.9686 | 6.0061 | 17247552.0 |
| 2007-11-15 10:20:00 | AAPL | Stock | 6.0057 | 6.0064 | 5.9707 | 5.9754 | 13137936.0 |
| 2007-11-15 10:25:00 | AAPL | Stock | 5.9757 | 5.9886 | 5.9582 | 5.9775 | 12833800.0 |
| 2007-11-15 10:30:00 | AAPL | Stock | 5.9761 | 5.9982 | 5.9589 | 5.9754 | 15016064.0 |
| 2007-11-15 10:35:00 | AAPL | Stock | 5.9757 | 6.0321 | 5.9721 | 6.0246 | 21529368.0 |
> showing 50 of 313,990 rows — these rows as CSV