PREVIEW / stock_5min / 2006-10-31
file: by_date/stock_5min/2006/2006-10-31.parquet size: 3.2 MB rows: 236,716 symbols: 2,436
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-10-31 07:55:00 | AAPL | Stock | 2.8918 | 2.8932 | 2.8918 | 2.8918 | 134400.0 |
| 2006-10-31 08:00:00 | AAPL | Stock | 2.8946 | 2.8996 | 2.8911 | 2.8975 | 337400.0 |
| 2006-10-31 08:05:00 | AAPL | Stock | 2.8971 | 2.8996 | 2.8936 | 2.8993 | 130788.0 |
| 2006-10-31 08:10:00 | AAPL | Stock | 2.8982 | 2.8982 | 2.8943 | 2.8943 | 28000.0 |
| 2006-10-31 08:15:00 | AAPL | Stock | 2.8946 | 2.8975 | 2.8936 | 2.8961 | 111664.0 |
| 2006-10-31 08:20:00 | AAPL | Stock | 2.8964 | 2.8986 | 2.8939 | 2.8964 | 71904.0 |
| 2006-10-31 08:25:00 | AAPL | Stock | 2.8964 | 2.8964 | 2.8964 | 2.8964 | 12292.0 |
| 2006-10-31 08:30:00 | AAPL | Stock | 2.8957 | 2.8989 | 2.8957 | 2.8989 | 232540.0 |
| 2006-10-31 08:35:00 | AAPL | Stock | 2.8989 | 2.91 | 2.8964 | 2.9057 | 698880.0 |
| 2006-10-31 08:40:00 | AAPL | Stock | 2.9071 | 2.9107 | 2.905 | 2.9064 | 785988.0 |
| 2006-10-31 08:45:00 | AAPL | Stock | 2.9064 | 2.91 | 2.9036 | 2.9096 | 221788.0 |
| 2006-10-31 08:50:00 | AAPL | Stock | 2.91 | 2.9107 | 2.9061 | 2.9107 | 377272.0 |
| 2006-10-31 08:55:00 | AAPL | Stock | 2.9107 | 2.9143 | 2.9104 | 2.9104 | 534912.0 |
| 2006-10-31 09:00:00 | AAPL | Stock | 2.9104 | 2.9143 | 2.9064 | 2.9125 | 701120.0 |
| 2006-10-31 09:05:00 | AAPL | Stock | 2.9125 | 2.9168 | 2.9114 | 2.9168 | 1424640.0 |
| 2006-10-31 09:10:00 | AAPL | Stock | 2.9168 | 2.9179 | 2.9143 | 2.9161 | 375816.0 |
| 2006-10-31 09:15:00 | AAPL | Stock | 2.9161 | 2.9161 | 2.9143 | 2.9161 | 120400.0 |
| 2006-10-31 09:20:00 | AAPL | Stock | 2.9157 | 2.9157 | 2.9075 | 2.9075 | 167244.0 |
| 2006-10-31 09:25:00 | AAPL | Stock | 2.9111 | 2.9111 | 2.9068 | 2.9071 | 1150800.0 |
| 2006-10-31 09:30:00 | AAPL | Stock | 2.9089 | 2.9118 | 2.9054 | 2.9089 | 21654920.0 |
| 2006-10-31 09:35:00 | AAPL | Stock | 2.9087 | 2.9096 | 2.8929 | 2.8986 | 16142560.0 |
| 2006-10-31 09:40:00 | AAPL | Stock | 2.8986 | 2.9029 | 2.8864 | 2.9006 | 17971716.0 |
| 2006-10-31 09:45:00 | AAPL | Stock | 2.9 | 2.905 | 2.8982 | 2.8986 | 15723904.0 |
| 2006-10-31 09:50:00 | AAPL | Stock | 2.8989 | 2.9 | 2.8893 | 2.8929 | 10403092.0 |
| 2006-10-31 09:55:00 | AAPL | Stock | 2.8929 | 2.8996 | 2.8929 | 2.8982 | 9511768.0 |
| 2006-10-31 10:00:00 | AAPL | Stock | 2.8986 | 2.8996 | 2.8914 | 2.8939 | 9375324.0 |
| 2006-10-31 10:05:00 | AAPL | Stock | 2.8939 | 2.8982 | 2.8939 | 2.8954 | 6961892.0 |
| 2006-10-31 10:10:00 | AAPL | Stock | 2.895 | 2.8989 | 2.8929 | 2.8946 | 6018628.0 |
| 2006-10-31 10:15:00 | AAPL | Stock | 2.8946 | 2.8982 | 2.8929 | 2.8979 | 6382404.0 |
| 2006-10-31 10:20:00 | AAPL | Stock | 2.8979 | 2.9004 | 2.8914 | 2.8996 | 8104880.0 |
| 2006-10-31 10:25:00 | AAPL | Stock | 2.8993 | 2.9 | 2.8943 | 2.8982 | 4379928.0 |
| 2006-10-31 10:30:00 | AAPL | Stock | 2.8982 | 2.9007 | 2.8964 | 2.8986 | 4170068.0 |
| 2006-10-31 10:35:00 | AAPL | Stock | 2.8993 | 2.9029 | 2.8982 | 2.9007 | 4880540.0 |
| 2006-10-31 10:40:00 | AAPL | Stock | 2.9011 | 2.9071 | 2.9007 | 2.905 | 6240528.0 |
| 2006-10-31 10:45:00 | AAPL | Stock | 2.9054 | 2.9054 | 2.9 | 2.9021 | 3935316.0 |
| 2006-10-31 10:50:00 | AAPL | Stock | 2.902 | 2.915 | 2.9015 | 2.9129 | 9767940.0 |
| 2006-10-31 10:55:00 | AAPL | Stock | 2.9132 | 2.9168 | 2.9118 | 2.9139 | 9461032.0 |
| 2006-10-31 11:00:00 | AAPL | Stock | 2.9139 | 2.9171 | 2.9061 | 2.9075 | 8500800.0 |
| 2006-10-31 11:05:00 | AAPL | Stock | 2.9075 | 2.9093 | 2.9043 | 2.9068 | 5255460.0 |
| 2006-10-31 11:10:00 | AAPL | Stock | 2.9071 | 2.9096 | 2.9064 | 2.9082 | 4480364.0 |
| 2006-10-31 11:15:00 | AAPL | Stock | 2.9082 | 2.9093 | 2.8993 | 2.9018 | 6218296.0 |
| 2006-10-31 11:20:00 | AAPL | Stock | 2.9018 | 2.9046 | 2.9014 | 2.9038 | 4358116.0 |
| 2006-10-31 11:25:00 | AAPL | Stock | 2.9039 | 2.9039 | 2.8996 | 2.9025 | 4566128.0 |
| 2006-10-31 11:30:00 | AAPL | Stock | 2.9025 | 2.905 | 2.9004 | 2.9018 | 3135776.0 |
| 2006-10-31 11:35:00 | AAPL | Stock | 2.9018 | 2.9043 | 2.9007 | 2.9029 | 3337656.0 |
| 2006-10-31 11:40:00 | AAPL | Stock | 2.9029 | 2.9039 | 2.8986 | 2.8989 | 2894360.0 |
| 2006-10-31 11:45:00 | AAPL | Stock | 2.8989 | 2.8993 | 2.8954 | 2.8968 | 5238268.0 |
| 2006-10-31 11:50:00 | AAPL | Stock | 2.8961 | 2.8968 | 2.8943 | 2.8968 | 3372964.0 |
| 2006-10-31 11:55:00 | AAPL | Stock | 2.8968 | 2.8986 | 2.8943 | 2.8968 | 4293688.0 |
| 2006-10-31 12:00:00 | AAPL | Stock | 2.8971 | 2.8982 | 2.8964 | 2.8979 | 2089584.0 |
> showing 50 of 236,716 rows — these rows as CSV