PREVIEW / stock_5min / 2006-09-13
file: by_date/stock_5min/2006/2006-09-13.parquet size: 3.1 MB rows: 225,243 symbols: 2,364
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-09-13 04:20:00 | AAPL | Stock | 2.5982 | 2.5982 | 2.5982 | 2.5982 | 140000.0 |
| 2006-09-13 06:55:00 | AAPL | Stock | 2.6018 | 2.6018 | 2.6018 | 2.6018 | 11200.0 |
| 2006-09-13 07:00:00 | AAPL | Stock | 2.6071 | 2.6071 | 2.6071 | 2.6071 | 5600.0 |
| 2006-09-13 07:15:00 | AAPL | Stock | 2.6114 | 2.6114 | 2.6061 | 2.6061 | 14000.0 |
| 2006-09-13 08:00:00 | AAPL | Stock | 2.6071 | 2.6089 | 2.6061 | 2.6061 | 593180.0 |
| 2006-09-13 08:05:00 | AAPL | Stock | 2.6061 | 2.6107 | 2.6061 | 2.6089 | 230160.0 |
| 2006-09-13 08:10:00 | AAPL | Stock | 2.6107 | 2.6136 | 2.6075 | 2.6136 | 512540.0 |
| 2006-09-13 08:15:00 | AAPL | Stock | 2.6125 | 2.6136 | 2.6107 | 2.6107 | 172368.0 |
| 2006-09-13 08:20:00 | AAPL | Stock | 2.6096 | 2.6107 | 2.6086 | 2.61 | 223552.0 |
| 2006-09-13 08:25:00 | AAPL | Stock | 2.61 | 2.6114 | 2.6079 | 2.6093 | 127680.0 |
| 2006-09-13 08:30:00 | AAPL | Stock | 2.6096 | 2.6107 | 2.6071 | 2.6089 | 1411760.0 |
| 2006-09-13 08:35:00 | AAPL | Stock | 2.6089 | 2.61 | 2.6071 | 2.6071 | 233548.0 |
| 2006-09-13 08:40:00 | AAPL | Stock | 2.6071 | 2.6089 | 2.6054 | 2.6054 | 795200.0 |
| 2006-09-13 08:45:00 | AAPL | Stock | 2.6068 | 2.6089 | 2.6054 | 2.6054 | 238000.0 |
| 2006-09-13 08:50:00 | AAPL | Stock | 2.6057 | 2.6121 | 2.6054 | 2.6121 | 662760.0 |
| 2006-09-13 08:55:00 | AAPL | Stock | 2.6104 | 2.6125 | 2.6086 | 2.6089 | 412160.0 |
| 2006-09-13 09:00:00 | AAPL | Stock | 2.6093 | 2.6093 | 2.6075 | 2.6082 | 570640.0 |
| 2006-09-13 09:05:00 | AAPL | Stock | 2.6079 | 2.6125 | 2.6079 | 2.6125 | 621320.0 |
| 2006-09-13 09:10:00 | AAPL | Stock | 2.6125 | 2.6125 | 2.6061 | 2.6071 | 537880.0 |
| 2006-09-13 09:15:00 | AAPL | Stock | 2.6071 | 2.6071 | 2.6036 | 2.6054 | 403564.0 |
| 2006-09-13 09:20:00 | AAPL | Stock | 2.6054 | 2.6054 | 2.6007 | 2.6036 | 708288.0 |
| 2006-09-13 09:25:00 | AAPL | Stock | 2.6036 | 2.605 | 2.6 | 2.6011 | 2603496.0 |
| 2006-09-13 09:30:00 | AAPL | Stock | 2.6018 | 2.6104 | 2.5889 | 2.6021 | 38083388.0 |
| 2006-09-13 09:35:00 | AAPL | Stock | 2.6018 | 2.6132 | 2.5936 | 2.6129 | 19692428.0 |
| 2006-09-13 09:40:00 | AAPL | Stock | 2.6125 | 2.6179 | 2.6043 | 2.6118 | 24573052.0 |
| 2006-09-13 09:45:00 | AAPL | Stock | 2.6121 | 2.6179 | 2.6025 | 2.6071 | 30662408.0 |
| 2006-09-13 09:50:00 | AAPL | Stock | 2.6071 | 2.6329 | 2.6064 | 2.6269 | 41086836.0 |
| 2006-09-13 09:55:00 | AAPL | Stock | 2.6257 | 2.6386 | 2.6218 | 2.6225 | 46809364.0 |
| 2006-09-13 10:00:00 | AAPL | Stock | 2.6221 | 2.6229 | 2.6082 | 2.6107 | 35984032.0 |
| 2006-09-13 10:05:00 | AAPL | Stock | 2.6107 | 2.6193 | 2.6093 | 2.6111 | 19936672.0 |
| 2006-09-13 10:10:00 | AAPL | Stock | 2.6111 | 2.6143 | 2.6018 | 2.6025 | 20529236.0 |
| 2006-09-13 10:15:00 | AAPL | Stock | 2.6025 | 2.6086 | 2.6004 | 2.6004 | 25179980.0 |
| 2006-09-13 10:20:00 | AAPL | Stock | 2.6004 | 2.6129 | 2.5982 | 2.6046 | 17834964.0 |
| 2006-09-13 10:25:00 | AAPL | Stock | 2.6042 | 2.6139 | 2.6039 | 2.6118 | 20561268.0 |
| 2006-09-13 10:30:00 | AAPL | Stock | 2.6121 | 2.6121 | 2.6 | 2.6036 | 17322592.0 |
| 2006-09-13 10:35:00 | AAPL | Stock | 2.6036 | 2.6039 | 2.5961 | 2.6025 | 17293024.0 |
| 2006-09-13 10:40:00 | AAPL | Stock | 2.6025 | 2.6025 | 2.5864 | 2.5886 | 24121944.0 |
| 2006-09-13 10:45:00 | AAPL | Stock | 2.5892 | 2.5946 | 2.585 | 2.5904 | 21830956.0 |
| 2006-09-13 10:50:00 | AAPL | Stock | 2.5907 | 2.6029 | 2.5821 | 2.6 | 20924904.0 |
| 2006-09-13 10:55:00 | AAPL | Stock | 2.6 | 2.6036 | 2.5957 | 2.6021 | 10436888.0 |
| 2006-09-13 11:00:00 | AAPL | Stock | 2.6018 | 2.605 | 2.6011 | 2.6029 | 11258324.0 |
| 2006-09-13 11:05:00 | AAPL | Stock | 2.6032 | 2.6129 | 2.6007 | 2.6075 | 18504948.0 |
| 2006-09-13 11:10:00 | AAPL | Stock | 2.6079 | 2.6082 | 2.6032 | 2.6046 | 10046848.0 |
| 2006-09-13 11:15:00 | AAPL | Stock | 2.6039 | 2.6068 | 2.6032 | 2.6061 | 6132364.0 |
| 2006-09-13 11:20:00 | AAPL | Stock | 2.6064 | 2.6125 | 2.6061 | 2.61 | 10025484.0 |
| 2006-09-13 11:25:00 | AAPL | Stock | 2.61 | 2.6171 | 2.6089 | 2.6125 | 17288180.0 |
| 2006-09-13 11:30:00 | AAPL | Stock | 2.6129 | 2.6157 | 2.6107 | 2.6121 | 9347044.0 |
| 2006-09-13 11:35:00 | AAPL | Stock | 2.6121 | 2.6132 | 2.6075 | 2.6107 | 7446516.0 |
| 2006-09-13 11:40:00 | AAPL | Stock | 2.6107 | 2.636 | 2.6064 | 2.6071 | 8066940.0 |
| 2006-09-13 11:45:00 | AAPL | Stock | 2.6068 | 2.6089 | 2.6032 | 2.6068 | 8996428.0 |
> showing 50 of 225,243 rows — these rows as CSV