PREVIEW / stock_5min / 2000-09-05
file: by_date/stock_5min/2000/2000-09-05.parquet size: 1.2 MB rows: 92,794 symbols: 1,220
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 |
|---|---|---|---|---|---|---|---|
| 2000-09-05 08:00:00 | AAPL | Stock | 1.1328 | 1.1339 | 1.1328 | 1.1339 | 11200.0 |
| 2000-09-05 08:05:00 | AAPL | Stock | 1.135 | 1.1362 | 1.135 | 1.1362 | 11200.0 |
| 2000-09-05 08:10:00 | AAPL | Stock | 1.1362 | 1.1362 | 1.1362 | 1.1362 | 28000.0 |
| 2000-09-05 08:30:00 | AAPL | Stock | 1.1205 | 1.1205 | 1.1205 | 1.1205 | 5600.0 |
| 2000-09-05 08:55:00 | AAPL | Stock | 1.1228 | 1.1228 | 1.1228 | 1.1228 | 16800.0 |
| 2000-09-05 09:00:00 | AAPL | Stock | 1.1228 | 1.1228 | 1.1228 | 1.1228 | 28000.0 |
| 2000-09-05 09:05:00 | AAPL | Stock | 1.1205 | 1.1205 | 1.1194 | 1.1205 | 56000.0 |
| 2000-09-05 09:10:00 | AAPL | Stock | 1.1205 | 1.1205 | 1.1194 | 1.1205 | 39200.0 |
| 2000-09-05 09:15:00 | AAPL | Stock | 1.1205 | 1.1228 | 1.1205 | 1.1228 | 44800.0 |
| 2000-09-05 09:20:00 | AAPL | Stock | 1.1205 | 1.1228 | 1.1205 | 1.1228 | 240800.0 |
| 2000-09-05 09:25:00 | AAPL | Stock | 1.1228 | 1.1228 | 1.1183 | 1.1183 | 285600.0 |
| 2000-09-05 09:30:00 | AAPL | Stock | 1.1189 | 1.1228 | 1.1172 | 1.1228 | 7263200.0 |
| 2000-09-05 09:35:00 | AAPL | Stock | 1.1228 | 1.1261 | 1.1172 | 1.1228 | 7901600.0 |
| 2000-09-05 09:40:00 | AAPL | Stock | 1.1239 | 1.1317 | 1.1205 | 1.1228 | 5868800.0 |
| 2000-09-05 09:45:00 | AAPL | Stock | 1.1228 | 1.1295 | 1.1205 | 1.1283 | 6630400.0 |
| 2000-09-05 09:50:00 | AAPL | Stock | 1.1283 | 1.1395 | 1.1272 | 1.1395 | 5756800.0 |
| 2000-09-05 09:55:00 | AAPL | Stock | 1.1384 | 1.1451 | 1.1384 | 1.1395 | 8540000.0 |
| 2000-09-05 10:00:00 | AAPL | Stock | 1.1395 | 1.1429 | 1.1373 | 1.1395 | 3987200.0 |
| 2000-09-05 10:05:00 | AAPL | Stock | 1.1406 | 1.1406 | 1.1373 | 1.1395 | 3511200.0 |
| 2000-09-05 10:10:00 | AAPL | Stock | 1.1384 | 1.1429 | 1.1339 | 1.1406 | 6535200.0 |
| 2000-09-05 10:15:00 | AAPL | Stock | 1.1412 | 1.1417 | 1.135 | 1.1395 | 6048000.0 |
| 2000-09-05 10:20:00 | AAPL | Stock | 1.1384 | 1.1406 | 1.1373 | 1.1395 | 3197600.0 |
| 2000-09-05 10:25:00 | AAPL | Stock | 1.1384 | 1.1406 | 1.1362 | 1.1362 | 3164000.0 |
| 2000-09-05 10:30:00 | AAPL | Stock | 1.1395 | 1.1395 | 1.1362 | 1.1395 | 3024000.0 |
| 2000-09-05 10:35:00 | AAPL | Stock | 1.139 | 1.1406 | 1.1362 | 1.1373 | 5684000.0 |
| 2000-09-05 10:40:00 | AAPL | Stock | 1.1373 | 1.1417 | 1.1362 | 1.1384 | 2195200.0 |
| 2000-09-05 10:45:00 | AAPL | Stock | 1.1373 | 1.1401 | 1.1373 | 1.1384 | 2783200.0 |
| 2000-09-05 10:50:00 | AAPL | Stock | 1.1384 | 1.1395 | 1.1378 | 1.1384 | 2139200.0 |
| 2000-09-05 10:55:00 | AAPL | Stock | 1.139 | 1.1406 | 1.1384 | 1.1406 | 1388800.0 |
| 2000-09-05 11:00:00 | AAPL | Stock | 1.1406 | 1.1406 | 1.1395 | 1.1406 | 1176000.0 |
| 2000-09-05 11:05:00 | AAPL | Stock | 1.1395 | 1.1395 | 1.1373 | 1.1373 | 453600.0 |
| 2000-09-05 11:10:00 | AAPL | Stock | 1.1384 | 1.1406 | 1.1373 | 1.1406 | 2223200.0 |
| 2000-09-05 11:15:00 | AAPL | Stock | 1.1401 | 1.1429 | 1.1395 | 1.1417 | 2592800.0 |
| 2000-09-05 11:20:00 | AAPL | Stock | 1.1429 | 1.1429 | 1.1406 | 1.1406 | 1758400.0 |
| 2000-09-05 11:25:00 | AAPL | Stock | 1.1395 | 1.1417 | 1.1395 | 1.1406 | 1377600.0 |
| 2000-09-05 11:30:00 | AAPL | Stock | 1.1412 | 1.1417 | 1.1395 | 1.1406 | 2531200.0 |
| 2000-09-05 11:35:00 | AAPL | Stock | 1.1406 | 1.1406 | 1.1395 | 1.1395 | 856800.0 |
| 2000-09-05 11:40:00 | AAPL | Stock | 1.1395 | 1.1406 | 1.1373 | 1.1373 | 1825600.0 |
| 2000-09-05 11:45:00 | AAPL | Stock | 1.1373 | 1.1384 | 1.1362 | 1.1384 | 644000.0 |
| 2000-09-05 11:50:00 | AAPL | Stock | 1.1373 | 1.1384 | 1.1317 | 1.1317 | 2492000.0 |
| 2000-09-05 11:55:00 | AAPL | Stock | 1.1317 | 1.135 | 1.1317 | 1.135 | 2844800.0 |
| 2000-09-05 12:00:00 | AAPL | Stock | 1.1339 | 1.135 | 1.1295 | 1.1317 | 1915200.0 |
| 2000-09-05 12:05:00 | AAPL | Stock | 1.1317 | 1.135 | 1.1306 | 1.1339 | 2990400.0 |
| 2000-09-05 12:10:00 | AAPL | Stock | 1.1339 | 1.135 | 1.1328 | 1.1339 | 2100000.0 |
| 2000-09-05 12:15:00 | AAPL | Stock | 1.135 | 1.1362 | 1.1339 | 1.1362 | 2592800.0 |
| 2000-09-05 12:20:00 | AAPL | Stock | 1.1373 | 1.1384 | 1.1362 | 1.1362 | 3483200.0 |
| 2000-09-05 12:25:00 | AAPL | Stock | 1.1367 | 1.1384 | 1.1362 | 1.1373 | 1444800.0 |
| 2000-09-05 12:30:00 | AAPL | Stock | 1.1373 | 1.1384 | 1.1373 | 1.1384 | 1411200.0 |
| 2000-09-05 12:35:00 | AAPL | Stock | 1.1373 | 1.1384 | 1.135 | 1.135 | 3376800.0 |
| 2000-09-05 12:40:00 | AAPL | Stock | 1.1362 | 1.1362 | 1.135 | 1.135 | 526400.0 |
> showing 50 of 92,794 rows — these rows as CSV