PREVIEW / stock_5min / 2006-11-07
file: by_date/stock_5min/2006/2006-11-07.parquet size: 3.2 MB rows: 236,620 symbols: 2,426
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-07 07:05:00 | AAPL | Stock | 2.8546 | 2.8571 | 2.8546 | 2.8571 | 56000.0 |
| 2006-11-07 07:10:00 | AAPL | Stock | 2.855 | 2.8571 | 2.855 | 2.8571 | 8400.0 |
| 2006-11-07 07:30:00 | AAPL | Stock | 2.8625 | 2.8625 | 2.8625 | 2.8625 | 28000.0 |
| 2006-11-07 07:35:00 | AAPL | Stock | 2.8625 | 2.8625 | 2.8625 | 2.8625 | 28000.0 |
| 2006-11-07 07:45:00 | AAPL | Stock | 2.8607 | 2.8607 | 2.8607 | 2.8607 | 5600.0 |
| 2006-11-07 07:55:00 | AAPL | Stock | 2.8636 | 2.8636 | 2.8636 | 2.8636 | 14000.0 |
| 2006-11-07 08:00:00 | AAPL | Stock | 2.8546 | 2.8625 | 2.8543 | 2.8604 | 125048.0 |
| 2006-11-07 08:05:00 | AAPL | Stock | 2.8604 | 2.8604 | 2.86 | 2.86 | 30800.0 |
| 2006-11-07 08:10:00 | AAPL | Stock | 2.86 | 2.8607 | 2.86 | 2.8604 | 51240.0 |
| 2006-11-07 08:15:00 | AAPL | Stock | 2.8604 | 2.8604 | 2.8589 | 2.8604 | 21056.0 |
| 2006-11-07 08:20:00 | AAPL | Stock | 2.8604 | 2.8607 | 2.8604 | 2.8607 | 64344.0 |
| 2006-11-07 08:25:00 | AAPL | Stock | 2.8625 | 2.8625 | 2.8604 | 2.8607 | 33600.0 |
| 2006-11-07 08:30:00 | AAPL | Stock | 2.8607 | 2.8607 | 2.8579 | 2.8604 | 132776.0 |
| 2006-11-07 08:35:00 | AAPL | Stock | 2.8604 | 2.8607 | 2.8604 | 2.8607 | 95424.0 |
| 2006-11-07 08:40:00 | AAPL | Stock | 2.8621 | 2.8671 | 2.8621 | 2.8661 | 364000.0 |
| 2006-11-07 08:45:00 | AAPL | Stock | 2.8661 | 2.8668 | 2.8625 | 2.8625 | 316400.0 |
| 2006-11-07 08:50:00 | AAPL | Stock | 2.8625 | 2.8625 | 2.8604 | 2.8618 | 201236.0 |
| 2006-11-07 08:55:00 | AAPL | Stock | 2.8618 | 2.865 | 2.8618 | 2.8643 | 58632.0 |
| 2006-11-07 09:00:00 | AAPL | Stock | 2.8654 | 2.8657 | 2.8579 | 2.8625 | 274568.0 |
| 2006-11-07 09:05:00 | AAPL | Stock | 2.8618 | 2.8625 | 2.8618 | 2.8625 | 18032.0 |
| 2006-11-07 09:10:00 | AAPL | Stock | 2.8625 | 2.8632 | 2.8625 | 2.8632 | 183400.0 |
| 2006-11-07 09:15:00 | AAPL | Stock | 2.8654 | 2.8671 | 2.8654 | 2.8664 | 83692.0 |
| 2006-11-07 09:20:00 | AAPL | Stock | 2.8664 | 2.8679 | 2.8629 | 2.8629 | 57708.0 |
| 2006-11-07 09:25:00 | AAPL | Stock | 2.8629 | 2.8732 | 2.8625 | 2.8732 | 1010492.0 |
| 2006-11-07 09:30:00 | AAPL | Stock | 2.8732 | 2.8775 | 2.8618 | 2.8711 | 26688396.0 |
| 2006-11-07 09:35:00 | AAPL | Stock | 2.8711 | 2.875 | 2.8664 | 2.8743 | 12214384.0 |
| 2006-11-07 09:40:00 | AAPL | Stock | 2.8743 | 2.8796 | 2.8718 | 2.8736 | 12139344.0 |
| 2006-11-07 09:45:00 | AAPL | Stock | 2.8743 | 2.8757 | 2.8704 | 2.8732 | 6481216.0 |
| 2006-11-07 09:50:00 | AAPL | Stock | 2.8736 | 2.8739 | 2.8664 | 2.8686 | 6557040.0 |
| 2006-11-07 09:55:00 | AAPL | Stock | 2.8689 | 2.8718 | 2.8639 | 2.8718 | 7188132.0 |
| 2006-11-07 10:00:00 | AAPL | Stock | 2.8718 | 2.8743 | 2.8682 | 2.8693 | 4998196.0 |
| 2006-11-07 10:05:00 | AAPL | Stock | 2.8693 | 2.8732 | 2.8682 | 2.8721 | 6387612.0 |
| 2006-11-07 10:10:00 | AAPL | Stock | 2.8718 | 2.8796 | 2.8707 | 2.8789 | 11981284.0 |
| 2006-11-07 10:15:00 | AAPL | Stock | 2.8789 | 2.8804 | 2.8757 | 2.8775 | 12317816.0 |
| 2006-11-07 10:20:00 | AAPL | Stock | 2.8775 | 2.8786 | 2.8743 | 2.8779 | 7835296.0 |
| 2006-11-07 10:25:00 | AAPL | Stock | 2.8782 | 2.8786 | 2.8743 | 2.8761 | 11081084.0 |
| 2006-11-07 10:30:00 | AAPL | Stock | 2.8757 | 2.8825 | 2.8746 | 2.8811 | 9808260.0 |
| 2006-11-07 10:35:00 | AAPL | Stock | 2.8811 | 2.8814 | 2.8775 | 2.8786 | 6553652.0 |
| 2006-11-07 10:40:00 | AAPL | Stock | 2.8782 | 2.8796 | 2.8771 | 2.8775 | 4917724.0 |
| 2006-11-07 10:45:00 | AAPL | Stock | 2.8771 | 2.8818 | 2.8757 | 2.8807 | 8198036.0 |
| 2006-11-07 10:50:00 | AAPL | Stock | 2.8807 | 2.8825 | 2.8793 | 2.8814 | 6356644.0 |
| 2006-11-07 10:55:00 | AAPL | Stock | 2.8818 | 2.8825 | 2.8796 | 2.8818 | 4681880.0 |
| 2006-11-07 11:00:00 | AAPL | Stock | 2.8818 | 2.8839 | 2.8786 | 2.8793 | 5719644.0 |
| 2006-11-07 11:05:00 | AAPL | Stock | 2.8795 | 2.8814 | 2.8786 | 2.88 | 3440808.0 |
| 2006-11-07 11:10:00 | AAPL | Stock | 2.8804 | 2.8814 | 2.8786 | 2.8804 | 2171932.0 |
| 2006-11-07 11:15:00 | AAPL | Stock | 2.88 | 2.8807 | 2.8786 | 2.8796 | 1698284.0 |
| 2006-11-07 11:20:00 | AAPL | Stock | 2.8796 | 2.885 | 2.8796 | 2.885 | 6346536.0 |
| 2006-11-07 11:25:00 | AAPL | Stock | 2.8846 | 2.8893 | 2.8839 | 2.8889 | 7357084.0 |
| 2006-11-07 11:30:00 | AAPL | Stock | 2.8893 | 2.8904 | 2.8861 | 2.8882 | 7315560.0 |
| 2006-11-07 11:35:00 | AAPL | Stock | 2.8882 | 2.8893 | 2.885 | 2.8886 | 5439616.0 |
> showing 50 of 236,620 rows — these rows as CSV