PREVIEW / stock_5min / 2009-08-04
file: by_date/stock_5min/2009/2009-08-04.parquet size: 4.7 MB rows: 321,113 symbols: 3,381
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-08-04 04:35:00 | AAPL | Stock | 5.9364 | 5.9364 | 5.9364 | 5.9364 | 2800.0 |
| 2009-08-04 06:10:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 8400.0 |
| 2009-08-04 06:35:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9107 | 5.9107 | 5600.0 |
| 2009-08-04 07:00:00 | AAPL | Stock | 5.8936 | 5.9161 | 5.8929 | 5.9161 | 58800.0 |
| 2009-08-04 07:45:00 | AAPL | Stock | 5.9154 | 5.9179 | 5.9154 | 5.9179 | 11200.0 |
| 2009-08-04 07:50:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9179 | 5.9179 | 5600.0 |
| 2009-08-04 08:00:00 | AAPL | Stock | 5.9107 | 5.9161 | 5.9107 | 5.9157 | 104692.0 |
| 2009-08-04 08:05:00 | AAPL | Stock | 5.9114 | 5.9161 | 5.9114 | 5.9129 | 297192.0 |
| 2009-08-04 08:10:00 | AAPL | Stock | 5.9082 | 5.9129 | 5.9082 | 5.9129 | 100716.0 |
| 2009-08-04 08:15:00 | AAPL | Stock | 5.9143 | 5.9161 | 5.9143 | 5.9161 | 405132.0 |
| 2009-08-04 08:20:00 | AAPL | Stock | 5.9161 | 5.925 | 5.9107 | 5.915 | 131600.0 |
| 2009-08-04 08:25:00 | AAPL | Stock | 5.915 | 5.915 | 5.9093 | 5.9107 | 33600.0 |
| 2009-08-04 08:30:00 | AAPL | Stock | 5.9079 | 5.9125 | 5.9075 | 5.9125 | 89040.0 |
| 2009-08-04 08:35:00 | AAPL | Stock | 5.915 | 5.9232 | 5.915 | 5.9161 | 86996.0 |
| 2009-08-04 08:40:00 | AAPL | Stock | 5.9182 | 5.9182 | 5.9107 | 5.9107 | 87136.0 |
| 2009-08-04 08:45:00 | AAPL | Stock | 5.9089 | 5.9107 | 5.9032 | 5.9032 | 75656.0 |
| 2009-08-04 08:50:00 | AAPL | Stock | 5.9025 | 5.9046 | 5.9 | 5.9046 | 34104.0 |
| 2009-08-04 08:55:00 | AAPL | Stock | 5.9082 | 5.9107 | 5.9046 | 5.9107 | 47964.0 |
| 2009-08-04 09:00:00 | AAPL | Stock | 5.9125 | 5.9125 | 5.9089 | 5.9089 | 84532.0 |
| 2009-08-04 09:05:00 | AAPL | Stock | 5.9121 | 5.9121 | 5.9036 | 5.9096 | 120820.0 |
| 2009-08-04 09:10:00 | AAPL | Stock | 5.9104 | 5.9107 | 5.9054 | 5.9071 | 62020.0 |
| 2009-08-04 09:15:00 | AAPL | Stock | 5.9036 | 5.9071 | 5.9011 | 5.9011 | 88704.0 |
| 2009-08-04 09:20:00 | AAPL | Stock | 5.9004 | 5.9054 | 5.9 | 5.9025 | 327600.0 |
| 2009-08-04 09:25:00 | AAPL | Stock | 5.9025 | 5.9032 | 5.8918 | 5.8921 | 635852.0 |
| 2009-08-04 09:30:00 | AAPL | Stock | 5.8925 | 5.9014 | 5.8707 | 5.88 | 19653088.0 |
| 2009-08-04 09:35:00 | AAPL | Stock | 5.8796 | 5.9104 | 5.8796 | 5.9021 | 17024784.0 |
| 2009-08-04 09:40:00 | AAPL | Stock | 5.9036 | 5.9114 | 5.8957 | 5.9025 | 8667820.0 |
| 2009-08-04 09:45:00 | AAPL | Stock | 5.9029 | 5.9132 | 5.885 | 5.8896 | 11450656.0 |
| 2009-08-04 09:50:00 | AAPL | Stock | 5.8896 | 5.9 | 5.885 | 5.8914 | 5876556.0 |
| 2009-08-04 09:55:00 | AAPL | Stock | 5.8907 | 5.8999 | 5.8875 | 5.8957 | 7730408.0 |
| 2009-08-04 10:00:00 | AAPL | Stock | 5.8957 | 5.9032 | 5.8821 | 5.8856 | 10846220.0 |
| 2009-08-04 10:05:00 | AAPL | Stock | 5.8857 | 5.8929 | 5.8829 | 5.8843 | 5700352.0 |
| 2009-08-04 10:10:00 | AAPL | Stock | 5.8857 | 5.9021 | 5.8841 | 5.8964 | 6979140.0 |
| 2009-08-04 10:15:00 | AAPL | Stock | 5.8968 | 5.9014 | 5.8857 | 5.8857 | 5389944.0 |
| 2009-08-04 10:20:00 | AAPL | Stock | 5.8861 | 5.8868 | 5.8786 | 5.8829 | 6417544.0 |
| 2009-08-04 10:25:00 | AAPL | Stock | 5.8829 | 5.8832 | 5.8736 | 5.8785 | 6863416.0 |
| 2009-08-04 10:30:00 | AAPL | Stock | 5.8793 | 5.8807 | 5.8689 | 5.8786 | 7292432.0 |
| 2009-08-04 10:35:00 | AAPL | Stock | 5.8779 | 5.8868 | 5.8779 | 5.8814 | 3441564.0 |
| 2009-08-04 10:40:00 | AAPL | Stock | 5.8821 | 5.8868 | 5.8789 | 5.8854 | 2736916.0 |
| 2009-08-04 10:45:00 | AAPL | Stock | 5.8843 | 5.8875 | 5.8818 | 5.8821 | 3137288.0 |
| 2009-08-04 10:50:00 | AAPL | Stock | 5.8818 | 5.8857 | 5.8782 | 5.885 | 3471188.0 |
| 2009-08-04 10:55:00 | AAPL | Stock | 5.8854 | 5.8925 | 5.8836 | 5.8925 | 4559492.0 |
| 2009-08-04 11:00:00 | AAPL | Stock | 5.8918 | 5.8993 | 5.8914 | 5.8982 | 5074552.0 |
| 2009-08-04 11:05:00 | AAPL | Stock | 5.8982 | 5.9007 | 5.895 | 5.8971 | 3239572.0 |
| 2009-08-04 11:10:00 | AAPL | Stock | 5.8968 | 5.9 | 5.8957 | 5.8961 | 2677136.0 |
| 2009-08-04 11:15:00 | AAPL | Stock | 5.8957 | 5.8982 | 5.8939 | 5.8968 | 3542420.0 |
| 2009-08-04 11:20:00 | AAPL | Stock | 5.897 | 5.8993 | 5.8893 | 5.8925 | 4469668.0 |
| 2009-08-04 11:25:00 | AAPL | Stock | 5.8921 | 5.8939 | 5.8889 | 5.8923 | 2686292.0 |
| 2009-08-04 11:30:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8879 | 5.8896 | 2016756.0 |
| 2009-08-04 11:35:00 | AAPL | Stock | 5.8895 | 5.8993 | 5.8861 | 5.8982 | 3773756.0 |
> showing 50 of 321,113 rows — these rows as CSV