PREVIEW / stock_5min / 2009-12-22
file: by_date/stock_5min/2009/2009-12-22.parquet size: 4.6 MB rows: 318,355 symbols: 3,444
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-12-22 04:30:00 | AAPL | Stock | 7.0836 | 7.0836 | 7.0836 | 7.0836 | 5600.0 |
| 2009-12-22 05:35:00 | AAPL | Stock | 7.0914 | 7.0914 | 7.0914 | 7.0914 | 8400.0 |
| 2009-12-22 06:25:00 | AAPL | Stock | 7.0882 | 7.0882 | 7.0882 | 7.0882 | 14000.0 |
| 2009-12-22 06:30:00 | AAPL | Stock | 7.0961 | 7.0961 | 7.0893 | 7.0893 | 9800.0 |
| 2009-12-22 06:55:00 | AAPL | Stock | 7.0811 | 7.0811 | 7.0811 | 7.0811 | 14000.0 |
| 2009-12-22 07:00:00 | AAPL | Stock | 7.0893 | 7.0893 | 7.0714 | 7.0804 | 8400.0 |
| 2009-12-22 07:05:00 | AAPL | Stock | 7.0893 | 7.0907 | 7.0893 | 7.0907 | 34832.0 |
| 2009-12-22 07:20:00 | AAPL | Stock | 7.1071 | 7.1175 | 7.1071 | 7.1175 | 13300.0 |
| 2009-12-22 07:30:00 | AAPL | Stock | 7.1161 | 7.1171 | 7.1136 | 7.1154 | 64400.0 |
| 2009-12-22 07:35:00 | AAPL | Stock | 7.1111 | 7.1121 | 7.1107 | 7.1107 | 19600.0 |
| 2009-12-22 07:40:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1143 | 7.1143 | 54320.0 |
| 2009-12-22 07:45:00 | AAPL | Stock | 7.1121 | 7.1132 | 7.1114 | 7.1114 | 30800.0 |
| 2009-12-22 07:50:00 | AAPL | Stock | 7.1114 | 7.1125 | 7.11 | 7.11 | 21616.0 |
| 2009-12-22 07:55:00 | AAPL | Stock | 7.1093 | 7.1143 | 7.1093 | 7.1132 | 122500.0 |
| 2009-12-22 08:00:00 | AAPL | Stock | 7.1143 | 7.1179 | 7.1114 | 7.1143 | 350588.0 |
| 2009-12-22 08:05:00 | AAPL | Stock | 7.1157 | 7.1193 | 7.0796 | 7.1168 | 392924.0 |
| 2009-12-22 08:10:00 | AAPL | Stock | 7.1171 | 7.1186 | 7.1125 | 7.1129 | 311108.0 |
| 2009-12-22 08:15:00 | AAPL | Stock | 7.1136 | 7.1161 | 7.1089 | 7.1154 | 141204.0 |
| 2009-12-22 08:20:00 | AAPL | Stock | 7.1161 | 7.1175 | 7.1143 | 7.1161 | 112616.0 |
| 2009-12-22 08:25:00 | AAPL | Stock | 7.1157 | 7.1161 | 7.1118 | 7.1118 | 138824.0 |
| 2009-12-22 08:30:00 | AAPL | Stock | 7.1114 | 7.1114 | 7.0971 | 7.0971 | 700700.0 |
| 2009-12-22 08:35:00 | AAPL | Stock | 7.1004 | 7.1018 | 7.0932 | 7.1018 | 218876.0 |
| 2009-12-22 08:40:00 | AAPL | Stock | 7.1018 | 7.1071 | 7.0982 | 7.1054 | 116340.0 |
| 2009-12-22 08:45:00 | AAPL | Stock | 7.1054 | 7.11 | 7.1018 | 7.11 | 295400.0 |
| 2009-12-22 08:50:00 | AAPL | Stock | 7.1075 | 7.1125 | 7.1075 | 7.1125 | 215404.0 |
| 2009-12-22 08:55:00 | AAPL | Stock | 7.1139 | 7.1161 | 7.1132 | 7.1132 | 222460.0 |
| 2009-12-22 09:00:00 | AAPL | Stock | 7.1112 | 7.1146 | 7.1111 | 7.1146 | 50400.0 |
| 2009-12-22 09:05:00 | AAPL | Stock | 7.1143 | 7.1179 | 7.1143 | 7.1143 | 54572.0 |
| 2009-12-22 09:10:00 | AAPL | Stock | 7.1179 | 7.1179 | 7.1107 | 7.115 | 135800.0 |
| 2009-12-22 09:15:00 | AAPL | Stock | 7.1125 | 7.1125 | 7.1125 | 7.1125 | 47404.0 |
| 2009-12-22 09:20:00 | AAPL | Stock | 7.1143 | 7.1143 | 7.1039 | 7.1039 | 130200.0 |
| 2009-12-22 09:25:00 | AAPL | Stock | 7.1071 | 7.1232 | 7.1054 | 7.1232 | 589456.0 |
| 2009-12-22 09:30:00 | AAPL | Stock | 7.1229 | 7.1425 | 7.1036 | 7.1411 | 17675084.0 |
| 2009-12-22 09:35:00 | AAPL | Stock | 7.1396 | 7.1732 | 7.1307 | 7.1571 | 26595912.0 |
| 2009-12-22 09:40:00 | AAPL | Stock | 7.1572 | 7.1679 | 7.1461 | 7.1461 | 13812876.0 |
| 2009-12-22 09:45:00 | AAPL | Stock | 7.1461 | 7.1489 | 7.1354 | 7.1471 | 10647252.0 |
| 2009-12-22 09:50:00 | AAPL | Stock | 7.1461 | 7.1496 | 7.1361 | 7.1397 | 6377308.0 |
| 2009-12-22 09:55:00 | AAPL | Stock | 7.1396 | 7.1429 | 7.1321 | 7.135 | 5897360.0 |
| 2009-12-22 10:00:00 | AAPL | Stock | 7.1357 | 7.1432 | 7.1111 | 7.1154 | 14588644.0 |
| 2009-12-22 10:05:00 | AAPL | Stock | 7.1157 | 7.1268 | 7.1111 | 7.125 | 7263928.0 |
| 2009-12-22 10:10:00 | AAPL | Stock | 7.125 | 7.1318 | 7.1218 | 7.1257 | 5419708.0 |
| 2009-12-22 10:15:00 | AAPL | Stock | 7.1257 | 7.1411 | 7.1257 | 7.1325 | 5264980.0 |
| 2009-12-22 10:20:00 | AAPL | Stock | 7.1325 | 7.1407 | 7.125 | 7.1379 | 5494776.0 |
| 2009-12-22 10:25:00 | AAPL | Stock | 7.1371 | 7.1407 | 7.1354 | 7.1393 | 3141236.0 |
| 2009-12-22 10:30:00 | AAPL | Stock | 7.1386 | 7.14 | 7.1268 | 7.127 | 3652824.0 |
| 2009-12-22 10:35:00 | AAPL | Stock | 7.1268 | 7.1332 | 7.1268 | 7.1289 | 2335116.0 |
| 2009-12-22 10:40:00 | AAPL | Stock | 7.1282 | 7.1296 | 7.1214 | 7.1279 | 2795828.0 |
| 2009-12-22 10:45:00 | AAPL | Stock | 7.1268 | 7.1314 | 7.1246 | 7.125 | 2998408.0 |
| 2009-12-22 10:50:00 | AAPL | Stock | 7.1257 | 7.1264 | 7.1176 | 7.1239 | 3701068.0 |
| 2009-12-22 10:55:00 | AAPL | Stock | 7.1232 | 7.1296 | 7.1214 | 7.1254 | 3437756.0 |
> showing 50 of 318,355 rows — these rows as CSV