PREVIEW / stock_5min / 2000-03-28
file: by_date/stock_5min/2000/2000-03-28.parquet size: 1.2 MB rows: 89,191 symbols: 1,142
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-03-28 09:30:00 | AAPL | Stock | 1.2254 | 1.2321 | 1.2243 | 1.2316 | 5913600.0 |
| 2000-03-28 09:35:00 | AAPL | Stock | 1.2313 | 1.25 | 1.2305 | 1.2472 | 5062400.0 |
| 2000-03-28 09:40:00 | AAPL | Stock | 1.25 | 1.25 | 1.2433 | 1.2478 | 5028800.0 |
| 2000-03-28 09:45:00 | AAPL | Stock | 1.2489 | 1.2679 | 1.2483 | 1.2676 | 5443200.0 |
| 2000-03-28 09:50:00 | AAPL | Stock | 1.2676 | 1.2679 | 1.2617 | 1.2634 | 3416000.0 |
| 2000-03-28 09:55:00 | AAPL | Stock | 1.264 | 1.2679 | 1.2556 | 1.2679 | 7179200.0 |
| 2000-03-28 10:00:00 | AAPL | Stock | 1.2667 | 1.2667 | 1.2545 | 1.2545 | 3505600.0 |
| 2000-03-28 10:05:00 | AAPL | Stock | 1.2545 | 1.255 | 1.2478 | 1.2478 | 7672000.0 |
| 2000-03-28 10:10:00 | AAPL | Stock | 1.2472 | 1.2511 | 1.2455 | 1.2467 | 5745600.0 |
| 2000-03-28 10:15:00 | AAPL | Stock | 1.2472 | 1.2472 | 1.2366 | 1.2397 | 3875200.0 |
| 2000-03-28 10:20:00 | AAPL | Stock | 1.24 | 1.2492 | 1.2377 | 1.2478 | 3460800.0 |
| 2000-03-28 10:25:00 | AAPL | Stock | 1.2455 | 1.2475 | 1.2388 | 1.2475 | 6899200.0 |
| 2000-03-28 10:30:00 | AAPL | Stock | 1.25 | 1.2506 | 1.2433 | 1.2444 | 2564800.0 |
| 2000-03-28 10:35:00 | AAPL | Stock | 1.245 | 1.2455 | 1.2422 | 1.2439 | 3304000.0 |
| 2000-03-28 10:40:00 | AAPL | Stock | 1.2427 | 1.2511 | 1.2422 | 1.2511 | 1444800.0 |
| 2000-03-28 10:45:00 | AAPL | Stock | 1.2511 | 1.2511 | 1.2467 | 1.25 | 1780800.0 |
| 2000-03-28 10:50:00 | AAPL | Stock | 1.2506 | 1.2522 | 1.2494 | 1.2511 | 2553600.0 |
| 2000-03-28 10:55:00 | AAPL | Stock | 1.2508 | 1.2533 | 1.2506 | 1.2522 | 6888000.0 |
| 2000-03-28 11:00:00 | AAPL | Stock | 1.2533 | 1.2533 | 1.2444 | 1.2444 | 1366400.0 |
| 2000-03-28 11:05:00 | AAPL | Stock | 1.2444 | 1.245 | 1.2366 | 1.2383 | 3494400.0 |
| 2000-03-28 11:10:00 | AAPL | Stock | 1.2383 | 1.2427 | 1.2383 | 1.2427 | 1142400.0 |
| 2000-03-28 11:15:00 | AAPL | Stock | 1.2422 | 1.2455 | 1.2394 | 1.2444 | 1288000.0 |
| 2000-03-28 11:20:00 | AAPL | Stock | 1.2444 | 1.2511 | 1.2433 | 1.2511 | 716800.0 |
| 2000-03-28 11:25:00 | AAPL | Stock | 1.25 | 1.2522 | 1.2478 | 1.2483 | 5734400.0 |
| 2000-03-28 11:30:00 | AAPL | Stock | 1.25 | 1.25 | 1.2422 | 1.2458 | 2968000.0 |
| 2000-03-28 11:35:00 | AAPL | Stock | 1.2455 | 1.25 | 1.245 | 1.2489 | 1982400.0 |
| 2000-03-28 11:40:00 | AAPL | Stock | 1.2467 | 1.25 | 1.2461 | 1.2472 | 649600.0 |
| 2000-03-28 11:45:00 | AAPL | Stock | 1.2478 | 1.25 | 1.2472 | 1.2472 | 526400.0 |
| 2000-03-28 11:50:00 | AAPL | Stock | 1.2489 | 1.2494 | 1.2461 | 1.2494 | 134400.0 |
| 2000-03-28 11:55:00 | AAPL | Stock | 1.2494 | 1.25 | 1.2455 | 1.2455 | 862400.0 |
| 2000-03-28 12:00:00 | AAPL | Stock | 1.2455 | 1.2455 | 1.2455 | 1.2455 | 134400.0 |
| 2000-03-28 12:05:00 | AAPL | Stock | 1.2472 | 1.2489 | 1.2472 | 1.2489 | 123200.0 |
| 2000-03-28 12:10:00 | AAPL | Stock | 1.2478 | 1.2489 | 1.2478 | 1.2483 | 705600.0 |
| 2000-03-28 12:15:00 | AAPL | Stock | 1.2472 | 1.2478 | 1.2467 | 1.2478 | 369600.0 |
| 2000-03-28 12:20:00 | AAPL | Stock | 1.2461 | 1.2467 | 1.2444 | 1.2444 | 1075200.0 |
| 2000-03-28 12:25:00 | AAPL | Stock | 1.2455 | 1.2478 | 1.2455 | 1.2472 | 78400.0 |
| 2000-03-28 12:30:00 | AAPL | Stock | 1.2475 | 1.2475 | 1.2411 | 1.2433 | 1097600.0 |
| 2000-03-28 12:35:00 | AAPL | Stock | 1.2427 | 1.2433 | 1.2422 | 1.2433 | 257600.0 |
| 2000-03-28 12:40:00 | AAPL | Stock | 1.2416 | 1.2433 | 1.2411 | 1.2411 | 526400.0 |
| 2000-03-28 12:45:00 | AAPL | Stock | 1.2411 | 1.2414 | 1.24 | 1.2411 | 1198400.0 |
| 2000-03-28 12:50:00 | AAPL | Stock | 1.2405 | 1.2405 | 1.2377 | 1.2388 | 1052800.0 |
| 2000-03-28 12:55:00 | AAPL | Stock | 1.2394 | 1.2416 | 1.2366 | 1.2405 | 2755200.0 |
| 2000-03-28 13:00:00 | AAPL | Stock | 1.2405 | 1.2416 | 1.2388 | 1.2416 | 1321600.0 |
| 2000-03-28 13:05:00 | AAPL | Stock | 1.2416 | 1.2455 | 1.2416 | 1.2455 | 1489600.0 |
| 2000-03-28 13:10:00 | AAPL | Stock | 1.245 | 1.2455 | 1.2411 | 1.2447 | 481600.0 |
| 2000-03-28 13:15:00 | AAPL | Stock | 1.2433 | 1.2455 | 1.2411 | 1.2455 | 806400.0 |
| 2000-03-28 13:20:00 | AAPL | Stock | 1.2455 | 1.2478 | 1.2455 | 1.2478 | 257600.0 |
| 2000-03-28 13:25:00 | AAPL | Stock | 1.2478 | 1.2478 | 1.2444 | 1.2467 | 1792000.0 |
| 2000-03-28 13:30:00 | AAPL | Stock | 1.2467 | 1.25 | 1.2444 | 1.25 | 940800.0 |
| 2000-03-28 13:35:00 | AAPL | Stock | 1.25 | 1.2589 | 1.25 | 1.2589 | 1848000.0 |
> showing 50 of 89,191 rows — these rows as CSV