PREVIEW / stock_5min / 2007-08-07
file: by_date/stock_5min/2007/2007-08-07.parquet size: 4.4 MB rows: 313,298 symbols: 3,117
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-08-07 09:30:00 | AAPL | Stock | 4.8193 | 4.8418 | 4.8007 | 4.8368 | 24834012.0 |
| 2007-08-07 09:35:00 | AAPL | Stock | 4.8382 | 4.8732 | 4.8361 | 4.8539 | 25298588.0 |
| 2007-08-07 09:40:00 | AAPL | Stock | 4.8539 | 4.8632 | 4.8464 | 4.8536 | 16529884.0 |
| 2007-08-07 09:45:00 | AAPL | Stock | 4.8539 | 4.8632 | 4.85 | 4.8586 | 11317292.0 |
| 2007-08-07 09:50:00 | AAPL | Stock | 4.8589 | 4.8875 | 4.8375 | 4.8854 | 21064120.0 |
| 2007-08-07 09:55:00 | AAPL | Stock | 4.8854 | 4.8929 | 4.875 | 4.875 | 17666152.0 |
| 2007-08-07 10:00:00 | AAPL | Stock | 4.875 | 4.8929 | 4.875 | 4.8857 | 14272664.0 |
| 2007-08-07 10:05:00 | AAPL | Stock | 4.8854 | 4.9014 | 4.8846 | 4.8929 | 17073000.0 |
| 2007-08-07 10:10:00 | AAPL | Stock | 4.8939 | 4.8943 | 4.8796 | 4.8808 | 11606084.0 |
| 2007-08-07 10:15:00 | AAPL | Stock | 4.8807 | 4.8864 | 4.8746 | 4.875 | 11408488.0 |
| 2007-08-07 10:20:00 | AAPL | Stock | 4.875 | 4.8793 | 4.8564 | 4.8564 | 12718748.0 |
| 2007-08-07 10:25:00 | AAPL | Stock | 4.8568 | 4.8679 | 4.8511 | 4.8661 | 9574628.0 |
| 2007-08-07 10:30:00 | AAPL | Stock | 4.8657 | 4.8718 | 4.8586 | 4.8707 | 7419300.0 |
| 2007-08-07 10:35:00 | AAPL | Stock | 4.8714 | 4.8786 | 4.8607 | 4.8614 | 9795968.0 |
| 2007-08-07 10:40:00 | AAPL | Stock | 4.8618 | 4.8704 | 4.85 | 4.8668 | 9373840.0 |
| 2007-08-07 10:45:00 | AAPL | Stock | 4.8668 | 4.8764 | 4.8643 | 4.875 | 6218128.0 |
| 2007-08-07 10:50:00 | AAPL | Stock | 4.8746 | 4.8825 | 4.8729 | 4.8729 | 7094304.0 |
| 2007-08-07 10:55:00 | AAPL | Stock | 4.8725 | 4.8929 | 4.8664 | 4.8925 | 9613380.0 |
| 2007-08-07 11:00:00 | AAPL | Stock | 4.8925 | 4.8929 | 4.8811 | 4.8829 | 11486608.0 |
| 2007-08-07 11:05:00 | AAPL | Stock | 4.8829 | 4.8829 | 4.8693 | 4.8714 | 7078260.0 |
| 2007-08-07 11:10:00 | AAPL | Stock | 4.8714 | 4.8839 | 4.87 | 4.8754 | 5755792.0 |
| 2007-08-07 11:15:00 | AAPL | Stock | 4.8757 | 4.8768 | 4.8625 | 4.8732 | 6265784.0 |
| 2007-08-07 11:20:00 | AAPL | Stock | 4.873 | 4.875 | 4.8661 | 4.8743 | 4063808.0 |
| 2007-08-07 11:25:00 | AAPL | Stock | 4.8732 | 4.8821 | 4.8707 | 4.882 | 5208756.0 |
| 2007-08-07 11:30:00 | AAPL | Stock | 4.8818 | 4.8825 | 4.8711 | 4.8771 | 4608240.0 |
| 2007-08-07 11:35:00 | AAPL | Stock | 4.8768 | 4.8786 | 4.87 | 4.8743 | 3704540.0 |
| 2007-08-07 11:40:00 | AAPL | Stock | 4.8736 | 4.885 | 4.8714 | 4.8843 | 5032664.0 |
| 2007-08-07 11:45:00 | AAPL | Stock | 4.8843 | 4.8929 | 4.8836 | 4.8836 | 9406096.0 |
| 2007-08-07 11:50:00 | AAPL | Stock | 4.8842 | 4.8914 | 4.8793 | 4.89 | 5446700.0 |
| 2007-08-07 11:55:00 | AAPL | Stock | 4.8904 | 4.8918 | 4.8829 | 4.885 | 4618992.0 |
| 2007-08-07 12:00:00 | AAPL | Stock | 4.8857 | 4.8857 | 4.8757 | 4.8818 | 5306868.0 |
| 2007-08-07 12:05:00 | AAPL | Stock | 4.8807 | 4.8893 | 4.8789 | 4.8871 | 6503840.0 |
| 2007-08-07 12:10:00 | AAPL | Stock | 4.8885 | 4.8893 | 4.8814 | 4.8832 | 3276168.0 |
| 2007-08-07 12:15:00 | AAPL | Stock | 4.8832 | 4.8857 | 4.8796 | 4.8807 | 3148404.0 |
| 2007-08-07 12:20:00 | AAPL | Stock | 4.8814 | 4.8814 | 4.8768 | 4.8782 | 3208240.0 |
| 2007-08-07 12:25:00 | AAPL | Stock | 4.8782 | 4.8804 | 4.875 | 4.8768 | 2728712.0 |
| 2007-08-07 12:30:00 | AAPL | Stock | 4.8771 | 4.8829 | 4.8757 | 4.8765 | 2535624.0 |
| 2007-08-07 12:35:00 | AAPL | Stock | 4.8761 | 4.8786 | 4.8711 | 4.8743 | 3431932.0 |
| 2007-08-07 12:40:00 | AAPL | Stock | 4.875 | 4.875 | 4.8707 | 4.8736 | 2770236.0 |
| 2007-08-07 12:45:00 | AAPL | Stock | 4.8736 | 4.8804 | 4.8729 | 4.8793 | 3613652.0 |
| 2007-08-07 12:50:00 | AAPL | Stock | 4.8793 | 4.8911 | 4.8793 | 4.8893 | 6716780.0 |
| 2007-08-07 12:55:00 | AAPL | Stock | 4.8893 | 4.8893 | 4.8789 | 4.8804 | 4576824.0 |
| 2007-08-07 13:00:00 | AAPL | Stock | 4.88 | 4.8836 | 4.8764 | 4.8779 | 4579596.0 |
| 2007-08-07 13:05:00 | AAPL | Stock | 4.8775 | 4.8793 | 4.8507 | 4.8682 | 18657604.0 |
| 2007-08-07 13:10:00 | AAPL | Stock | 4.8679 | 4.8714 | 4.8539 | 4.8611 | 9519468.0 |
| 2007-08-07 13:15:00 | AAPL | Stock | 4.8611 | 4.8661 | 4.8525 | 4.8596 | 7518084.0 |
| 2007-08-07 13:20:00 | AAPL | Stock | 4.8593 | 4.8886 | 4.8582 | 4.8736 | 14380940.0 |
| 2007-08-07 13:25:00 | AAPL | Stock | 4.8725 | 4.8814 | 4.8686 | 4.8789 | 5421500.0 |
| 2007-08-07 13:30:00 | AAPL | Stock | 4.8789 | 4.8821 | 4.8725 | 4.8739 | 5016200.0 |
| 2007-08-07 13:35:00 | AAPL | Stock | 4.8739 | 4.8782 | 4.8686 | 4.8757 | 4528692.0 |
> showing 50 of 313,298 rows — these rows as CSV