PREVIEW / stock_5min / 2000-03-15
file: by_date/stock_5min/2000/2000-03-15.parquet size: 1.2 MB rows: 88,769 symbols: 1,148
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-15 09:30:00 | AAPL | Stock | 1.0324 | 1.0324 | 1.0201 | 1.0201 | 8265600.0 |
| 2000-03-15 09:35:00 | AAPL | Stock | 1.0206 | 1.0435 | 1.019 | 1.0268 | 8500800.0 |
| 2000-03-15 09:40:00 | AAPL | Stock | 1.0385 | 1.0525 | 1.0296 | 1.0307 | 28795200.0 |
| 2000-03-15 09:45:00 | AAPL | Stock | 1.0335 | 1.0379 | 1.029 | 1.0363 | 15478400.0 |
| 2000-03-15 09:50:00 | AAPL | Stock | 1.0366 | 1.0413 | 1.0354 | 1.0363 | 12364800.0 |
| 2000-03-15 09:55:00 | AAPL | Stock | 1.0374 | 1.0513 | 1.0368 | 1.0491 | 8646400.0 |
| 2000-03-15 10:00:00 | AAPL | Stock | 1.0513 | 1.067 | 1.0497 | 1.0656 | 13529600.0 |
| 2000-03-15 10:05:00 | AAPL | Stock | 1.0653 | 1.067 | 1.0592 | 1.0647 | 12443200.0 |
| 2000-03-15 10:10:00 | AAPL | Stock | 1.0636 | 1.0681 | 1.0625 | 1.067 | 11065600.0 |
| 2000-03-15 10:15:00 | AAPL | Stock | 1.0681 | 1.0737 | 1.0658 | 1.0714 | 18737600.0 |
| 2000-03-15 10:20:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.0631 | 1.0647 | 19924800.0 |
| 2000-03-15 10:25:00 | AAPL | Stock | 1.0636 | 1.0642 | 1.0592 | 1.0603 | 11513600.0 |
| 2000-03-15 10:30:00 | AAPL | Stock | 1.0608 | 1.067 | 1.0603 | 1.0636 | 6160000.0 |
| 2000-03-15 10:35:00 | AAPL | Stock | 1.0631 | 1.0639 | 1.0625 | 1.0631 | 5230400.0 |
| 2000-03-15 10:40:00 | AAPL | Stock | 1.0628 | 1.067 | 1.0625 | 1.0647 | 4121600.0 |
| 2000-03-15 10:45:00 | AAPL | Stock | 1.0647 | 1.067 | 1.0592 | 1.0592 | 3192000.0 |
| 2000-03-15 10:50:00 | AAPL | Stock | 1.0592 | 1.0647 | 1.0569 | 1.0603 | 4345600.0 |
| 2000-03-15 10:55:00 | AAPL | Stock | 1.0614 | 1.067 | 1.0575 | 1.0592 | 2049600.0 |
| 2000-03-15 11:00:00 | AAPL | Stock | 1.0592 | 1.0625 | 1.0586 | 1.0592 | 4916800.0 |
| 2000-03-15 11:05:00 | AAPL | Stock | 1.0592 | 1.0631 | 1.0569 | 1.0592 | 2520000.0 |
| 2000-03-15 11:10:00 | AAPL | Stock | 1.0592 | 1.0614 | 1.0592 | 1.0597 | 2856000.0 |
| 2000-03-15 11:15:00 | AAPL | Stock | 1.0592 | 1.0603 | 1.0592 | 1.0603 | 3550400.0 |
| 2000-03-15 11:20:00 | AAPL | Stock | 1.0614 | 1.0625 | 1.0575 | 1.058 | 2486400.0 |
| 2000-03-15 11:25:00 | AAPL | Stock | 1.0575 | 1.058 | 1.0536 | 1.0541 | 2945600.0 |
| 2000-03-15 11:30:00 | AAPL | Stock | 1.0541 | 1.0547 | 1.0502 | 1.0525 | 4558400.0 |
| 2000-03-15 11:35:00 | AAPL | Stock | 1.0525 | 1.0536 | 1.0513 | 1.0519 | 2665600.0 |
| 2000-03-15 11:40:00 | AAPL | Stock | 1.0536 | 1.0603 | 1.0525 | 1.0527 | 3875200.0 |
| 2000-03-15 11:45:00 | AAPL | Stock | 1.0525 | 1.0608 | 1.0525 | 1.0597 | 2822400.0 |
| 2000-03-15 11:50:00 | AAPL | Stock | 1.0597 | 1.067 | 1.0586 | 1.0592 | 3796800.0 |
| 2000-03-15 11:55:00 | AAPL | Stock | 1.0597 | 1.0614 | 1.0558 | 1.0614 | 1915200.0 |
| 2000-03-15 12:00:00 | AAPL | Stock | 1.0614 | 1.0658 | 1.0614 | 1.0647 | 2452800.0 |
| 2000-03-15 12:05:00 | AAPL | Stock | 1.0625 | 1.0642 | 1.0536 | 1.0536 | 1937600.0 |
| 2000-03-15 12:10:00 | AAPL | Stock | 1.0547 | 1.0555 | 1.0474 | 1.0477 | 3147200.0 |
| 2000-03-15 12:15:00 | AAPL | Stock | 1.0477 | 1.053 | 1.0474 | 1.0525 | 1680000.0 |
| 2000-03-15 12:20:00 | AAPL | Stock | 1.053 | 1.0536 | 1.0513 | 1.0519 | 2150400.0 |
| 2000-03-15 12:25:00 | AAPL | Stock | 1.0513 | 1.0519 | 1.0458 | 1.048 | 4088000.0 |
| 2000-03-15 12:30:00 | AAPL | Stock | 1.0469 | 1.0491 | 1.0446 | 1.0446 | 4144000.0 |
| 2000-03-15 12:35:00 | AAPL | Stock | 1.0452 | 1.0575 | 1.0419 | 1.0525 | 6608000.0 |
| 2000-03-15 12:40:00 | AAPL | Stock | 1.0497 | 1.0536 | 1.0452 | 1.053 | 1232000.0 |
| 2000-03-15 12:45:00 | AAPL | Stock | 1.0525 | 1.0558 | 1.0497 | 1.0541 | 1276800.0 |
| 2000-03-15 12:50:00 | AAPL | Stock | 1.0519 | 1.0536 | 1.0435 | 1.0435 | 1534400.0 |
| 2000-03-15 12:55:00 | AAPL | Stock | 1.0424 | 1.0485 | 1.0413 | 1.0474 | 3304000.0 |
| 2000-03-15 13:00:00 | AAPL | Stock | 1.048 | 1.0547 | 1.0469 | 1.0547 | 3012800.0 |
| 2000-03-15 13:05:00 | AAPL | Stock | 1.0536 | 1.058 | 1.0525 | 1.058 | 3270400.0 |
| 2000-03-15 13:10:00 | AAPL | Stock | 1.058 | 1.0636 | 1.058 | 1.0603 | 5499200.0 |
| 2000-03-15 13:15:00 | AAPL | Stock | 1.0603 | 1.0619 | 1.0597 | 1.0603 | 3931200.0 |
| 2000-03-15 13:20:00 | AAPL | Stock | 1.0603 | 1.0611 | 1.0603 | 1.0608 | 2049600.0 |
| 2000-03-15 13:25:00 | AAPL | Stock | 1.0608 | 1.0619 | 1.0603 | 1.0619 | 616000.0 |
| 2000-03-15 13:30:00 | AAPL | Stock | 1.0625 | 1.0631 | 1.0619 | 1.0625 | 2374400.0 |
| 2000-03-15 13:35:00 | AAPL | Stock | 1.0631 | 1.0636 | 1.0625 | 1.0631 | 2766400.0 |
> showing 50 of 88,769 rows — these rows as CSV