PREVIEW / stock_5min / 2009-06-16
file: by_date/stock_5min/2009/2009-06-16.parquet size: 4.6 MB rows: 319,585 symbols: 3,338
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-16 05:25:00 | AAPL | Stock | 4.8771 | 4.8771 | 4.8725 | 4.8725 | 28000.0 |
| 2009-06-16 05:50:00 | AAPL | Stock | 4.8725 | 4.8725 | 4.8725 | 4.8725 | 2800.0 |
| 2009-06-16 05:55:00 | AAPL | Stock | 4.87 | 4.87 | 4.87 | 4.87 | 5600.0 |
| 2009-06-16 06:05:00 | AAPL | Stock | 4.8654 | 4.8654 | 4.8654 | 4.8654 | 5600.0 |
| 2009-06-16 06:55:00 | AAPL | Stock | 4.8632 | 4.8643 | 4.8571 | 4.8571 | 47600.0 |
| 2009-06-16 07:15:00 | AAPL | Stock | 4.8679 | 4.8679 | 4.8643 | 4.8643 | 61600.0 |
| 2009-06-16 07:20:00 | AAPL | Stock | 4.8814 | 4.8875 | 4.8764 | 4.8768 | 49000.0 |
| 2009-06-16 07:30:00 | AAPL | Stock | 4.8732 | 4.8732 | 4.8732 | 4.8732 | 2800.0 |
| 2009-06-16 07:45:00 | AAPL | Stock | 4.8625 | 4.8625 | 4.8607 | 4.8607 | 18200.0 |
| 2009-06-16 07:55:00 | AAPL | Stock | 4.8693 | 4.8721 | 4.8693 | 4.8721 | 5600.0 |
| 2009-06-16 08:00:00 | AAPL | Stock | 4.8679 | 4.875 | 4.8661 | 4.8661 | 112476.0 |
| 2009-06-16 08:05:00 | AAPL | Stock | 4.865 | 4.8729 | 4.8618 | 4.8618 | 135100.0 |
| 2009-06-16 08:10:00 | AAPL | Stock | 4.8575 | 4.8693 | 4.8575 | 4.8661 | 43960.0 |
| 2009-06-16 08:15:00 | AAPL | Stock | 4.8625 | 4.8657 | 4.8625 | 4.8657 | 16800.0 |
| 2009-06-16 08:20:00 | AAPL | Stock | 4.8657 | 4.8711 | 4.8657 | 4.8689 | 69076.0 |
| 2009-06-16 08:25:00 | AAPL | Stock | 4.8696 | 4.8696 | 4.8679 | 4.8696 | 34720.0 |
| 2009-06-16 08:30:00 | AAPL | Stock | 4.8714 | 4.8886 | 4.8696 | 4.8857 | 242256.0 |
| 2009-06-16 08:35:00 | AAPL | Stock | 4.8843 | 4.8857 | 4.8839 | 4.8843 | 96040.0 |
| 2009-06-16 08:40:00 | AAPL | Stock | 4.885 | 4.8907 | 4.885 | 4.8907 | 95900.0 |
| 2009-06-16 08:45:00 | AAPL | Stock | 4.8893 | 4.8911 | 4.8839 | 4.8843 | 387884.0 |
| 2009-06-16 08:50:00 | AAPL | Stock | 4.8818 | 4.8818 | 4.8818 | 4.8818 | 2800.0 |
| 2009-06-16 08:55:00 | AAPL | Stock | 4.8854 | 4.8854 | 4.8811 | 4.8846 | 41160.0 |
| 2009-06-16 09:00:00 | AAPL | Stock | 4.8839 | 4.8893 | 4.8839 | 4.8893 | 76440.0 |
| 2009-06-16 09:05:00 | AAPL | Stock | 4.8893 | 4.8964 | 4.8879 | 4.8929 | 319900.0 |
| 2009-06-16 09:10:00 | AAPL | Stock | 4.8929 | 4.895 | 4.8882 | 4.8893 | 247072.0 |
| 2009-06-16 09:15:00 | AAPL | Stock | 4.8893 | 4.8893 | 4.8843 | 4.8889 | 39200.0 |
| 2009-06-16 09:20:00 | AAPL | Stock | 4.8893 | 4.8911 | 4.8861 | 4.8893 | 145992.0 |
| 2009-06-16 09:25:00 | AAPL | Stock | 4.8882 | 4.8896 | 4.8804 | 4.8804 | 217336.0 |
| 2009-06-16 09:30:00 | AAPL | Stock | 4.8811 | 4.8925 | 4.8607 | 4.8748 | 15579396.0 |
| 2009-06-16 09:35:00 | AAPL | Stock | 4.8729 | 4.885 | 4.8629 | 4.8732 | 11608828.0 |
| 2009-06-16 09:40:00 | AAPL | Stock | 4.8739 | 4.9071 | 4.8714 | 4.9046 | 17167892.0 |
| 2009-06-16 09:45:00 | AAPL | Stock | 4.9046 | 4.9193 | 4.8929 | 4.9175 | 17926272.0 |
| 2009-06-16 09:50:00 | AAPL | Stock | 4.9171 | 4.9234 | 4.9086 | 4.9136 | 14071512.0 |
| 2009-06-16 09:55:00 | AAPL | Stock | 4.9136 | 4.9175 | 4.9046 | 4.9118 | 10519684.0 |
| 2009-06-16 10:00:00 | AAPL | Stock | 4.9114 | 4.9168 | 4.9071 | 4.9132 | 7783216.0 |
| 2009-06-16 10:05:00 | AAPL | Stock | 4.9146 | 4.9189 | 4.9111 | 4.9139 | 9567208.0 |
| 2009-06-16 10:10:00 | AAPL | Stock | 4.9143 | 4.9193 | 4.9039 | 4.9071 | 7424312.0 |
| 2009-06-16 10:15:00 | AAPL | Stock | 4.9075 | 4.9093 | 4.8864 | 4.8896 | 10305736.0 |
| 2009-06-16 10:20:00 | AAPL | Stock | 4.89 | 4.9036 | 4.8886 | 4.8986 | 6423368.0 |
| 2009-06-16 10:25:00 | AAPL | Stock | 4.8986 | 4.9107 | 4.8957 | 4.9061 | 3961300.0 |
| 2009-06-16 10:30:00 | AAPL | Stock | 4.9061 | 4.9107 | 4.9004 | 4.9071 | 3836420.0 |
| 2009-06-16 10:35:00 | AAPL | Stock | 4.9068 | 4.9271 | 4.9064 | 4.926 | 11177124.0 |
| 2009-06-16 10:40:00 | AAPL | Stock | 4.9254 | 4.93 | 4.9204 | 4.9214 | 10152660.0 |
| 2009-06-16 10:45:00 | AAPL | Stock | 4.9214 | 4.9221 | 4.9146 | 4.9186 | 5650092.0 |
| 2009-06-16 10:50:00 | AAPL | Stock | 4.9179 | 4.925 | 4.9161 | 4.9232 | 4628708.0 |
| 2009-06-16 10:55:00 | AAPL | Stock | 4.9236 | 4.9254 | 4.9182 | 4.92 | 2771916.0 |
| 2009-06-16 11:00:00 | AAPL | Stock | 4.92 | 4.9371 | 4.9193 | 4.9336 | 8300292.0 |
| 2009-06-16 11:05:00 | AAPL | Stock | 4.9339 | 4.9371 | 4.9289 | 4.9293 | 5096700.0 |
| 2009-06-16 11:10:00 | AAPL | Stock | 4.9296 | 4.9414 | 4.9296 | 4.94 | 6813604.0 |
| 2009-06-16 11:15:00 | AAPL | Stock | 4.94 | 4.94 | 4.9357 | 4.9379 | 3787112.0 |
> showing 50 of 319,585 rows — these rows as CSV