PREVIEW / stock_5min / 2007-11-06
file: by_date/stock_5min/2007/2007-11-06.parquet size: 4.4 MB rows: 315,877 symbols: 3,190
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-06 04:25:00 | AAPL | Stock | 6.6493 | 6.6493 | 6.6493 | 6.6493 | 5600.0 |
| 2007-11-06 05:15:00 | AAPL | Stock | 6.6493 | 6.6493 | 6.6493 | 6.6493 | 3976.0 |
| 2007-11-06 05:25:00 | AAPL | Stock | 6.6682 | 6.6682 | 6.6682 | 6.6682 | 4200.0 |
| 2007-11-06 05:50:00 | AAPL | Stock | 6.6682 | 6.6682 | 6.6682 | 6.6682 | 5600.0 |
| 2007-11-06 06:50:00 | AAPL | Stock | 6.6964 | 6.7121 | 6.6964 | 6.7121 | 67200.0 |
| 2007-11-06 06:55:00 | AAPL | Stock | 6.715 | 6.715 | 6.715 | 6.715 | 28000.0 |
| 2007-11-06 07:00:00 | AAPL | Stock | 6.7179 | 6.7318 | 6.7121 | 6.7318 | 32200.0 |
| 2007-11-06 07:05:00 | AAPL | Stock | 6.7257 | 6.7318 | 6.7257 | 6.7318 | 18200.0 |
| 2007-11-06 07:10:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7129 | 6.7129 | 85400.0 |
| 2007-11-06 07:20:00 | AAPL | Stock | 6.7146 | 6.7146 | 6.7143 | 6.7146 | 86800.0 |
| 2007-11-06 07:25:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 36400.0 |
| 2007-11-06 07:30:00 | AAPL | Stock | 6.7179 | 6.7179 | 6.7179 | 6.7179 | 4200.0 |
| 2007-11-06 07:35:00 | AAPL | Stock | 6.7175 | 6.7175 | 6.7154 | 6.7175 | 25928.0 |
| 2007-11-06 07:40:00 | AAPL | Stock | 6.7232 | 6.7232 | 6.72 | 6.7211 | 50400.0 |
| 2007-11-06 07:50:00 | AAPL | Stock | 6.7196 | 6.7207 | 6.7196 | 6.7196 | 36400.0 |
| 2007-11-06 07:55:00 | AAPL | Stock | 6.7121 | 6.7196 | 6.7121 | 6.7196 | 91840.0 |
| 2007-11-06 08:00:00 | AAPL | Stock | 6.7196 | 6.7196 | 6.6964 | 6.6964 | 664524.0 |
| 2007-11-06 08:05:00 | AAPL | Stock | 6.7011 | 6.7068 | 6.7 | 6.7046 | 267204.0 |
| 2007-11-06 08:10:00 | AAPL | Stock | 6.7018 | 6.7082 | 6.7018 | 6.7079 | 284788.0 |
| 2007-11-06 08:15:00 | AAPL | Stock | 6.7057 | 6.7093 | 6.7054 | 6.7093 | 333816.0 |
| 2007-11-06 08:20:00 | AAPL | Stock | 6.7093 | 6.7093 | 6.6964 | 6.6986 | 291060.0 |
| 2007-11-06 08:25:00 | AAPL | Stock | 6.6993 | 6.6993 | 6.6893 | 6.6957 | 342160.0 |
| 2007-11-06 08:30:00 | AAPL | Stock | 6.6957 | 6.7032 | 6.6925 | 6.6979 | 352968.0 |
| 2007-11-06 08:35:00 | AAPL | Stock | 6.6993 | 6.7025 | 6.6964 | 6.7025 | 291116.0 |
| 2007-11-06 08:40:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.6968 | 6.6982 | 79800.0 |
| 2007-11-06 08:45:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6911 | 6.6914 | 322336.0 |
| 2007-11-06 08:50:00 | AAPL | Stock | 6.6911 | 6.6961 | 6.6911 | 6.6918 | 88200.0 |
| 2007-11-06 08:55:00 | AAPL | Stock | 6.6929 | 6.6943 | 6.6875 | 6.6889 | 247240.0 |
| 2007-11-06 09:00:00 | AAPL | Stock | 6.6864 | 6.7018 | 6.6857 | 6.7018 | 326900.0 |
| 2007-11-06 09:05:00 | AAPL | Stock | 6.6964 | 6.7 | 6.6964 | 6.6982 | 84000.0 |
| 2007-11-06 09:10:00 | AAPL | Stock | 6.6971 | 6.6971 | 6.69 | 6.6918 | 80780.0 |
| 2007-11-06 09:15:00 | AAPL | Stock | 6.6889 | 6.6893 | 6.6879 | 6.6893 | 36400.0 |
| 2007-11-06 09:20:00 | AAPL | Stock | 6.6893 | 6.7014 | 6.6893 | 6.6964 | 105280.0 |
| 2007-11-06 09:25:00 | AAPL | Stock | 6.6961 | 6.6996 | 6.6786 | 6.6843 | 705180.0 |
| 2007-11-06 09:30:00 | AAPL | Stock | 6.685 | 6.695 | 6.6689 | 6.6768 | 19522748.0 |
| 2007-11-06 09:35:00 | AAPL | Stock | 6.6779 | 6.6925 | 6.6714 | 6.6804 | 14681296.0 |
| 2007-11-06 09:40:00 | AAPL | Stock | 6.6804 | 6.7075 | 6.6754 | 6.705 | 16880164.0 |
| 2007-11-06 09:45:00 | AAPL | Stock | 6.7046 | 6.7071 | 6.6904 | 6.7054 | 10512152.0 |
| 2007-11-06 09:50:00 | AAPL | Stock | 6.7039 | 6.7054 | 6.6857 | 6.6879 | 10166576.0 |
| 2007-11-06 09:55:00 | AAPL | Stock | 6.6878 | 6.7011 | 6.6857 | 6.6943 | 7870492.0 |
| 2007-11-06 10:00:00 | AAPL | Stock | 6.6944 | 6.7107 | 6.6921 | 6.7107 | 11987920.0 |
| 2007-11-06 10:05:00 | AAPL | Stock | 6.7107 | 6.7139 | 6.7018 | 6.7064 | 10121328.0 |
| 2007-11-06 10:10:00 | AAPL | Stock | 6.7054 | 6.7104 | 6.6982 | 6.7025 | 8949472.0 |
| 2007-11-06 10:15:00 | AAPL | Stock | 6.7021 | 6.7089 | 6.6968 | 6.7036 | 7788284.0 |
| 2007-11-06 10:20:00 | AAPL | Stock | 6.7039 | 6.7039 | 6.6789 | 6.6913 | 15890084.0 |
| 2007-11-06 10:25:00 | AAPL | Stock | 6.6914 | 6.6964 | 6.6821 | 6.6893 | 7061432.0 |
| 2007-11-06 10:30:00 | AAPL | Stock | 6.6882 | 6.6893 | 6.665 | 6.6659 | 11404988.0 |
| 2007-11-06 10:35:00 | AAPL | Stock | 6.6668 | 6.6857 | 6.6607 | 6.6832 | 14116676.0 |
| 2007-11-06 10:40:00 | AAPL | Stock | 6.6843 | 6.6864 | 6.6464 | 6.6504 | 15287916.0 |
| 2007-11-06 10:45:00 | AAPL | Stock | 6.6504 | 6.6604 | 6.6232 | 6.6232 | 15885380.0 |
> showing 50 of 315,877 rows — these rows as CSV