PREVIEW / stock_5min / 2000-09-20
file: by_date/stock_5min/2000/2000-09-20.parquet size: 1.2 MB rows: 90,795 symbols: 1,229
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-20 08:00:00 | AAPL | Stock | 1.0698 | 1.0698 | 1.0698 | 1.0698 | 677600.0 |
| 2000-09-20 08:25:00 | AAPL | Stock | 1.0748 | 1.0748 | 1.0748 | 1.0748 | 22400.0 |
| 2000-09-20 08:30:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.0714 | 1.0714 | 112000.0 |
| 2000-09-20 09:20:00 | AAPL | Stock | 1.067 | 1.067 | 1.067 | 1.067 | 33600.0 |
| 2000-09-20 09:25:00 | AAPL | Stock | 1.067 | 1.067 | 1.0603 | 1.0603 | 173600.0 |
| 2000-09-20 09:30:00 | AAPL | Stock | 1.0608 | 1.0614 | 1.0513 | 1.0525 | 3718400.0 |
| 2000-09-20 09:35:00 | AAPL | Stock | 1.0513 | 1.0536 | 1.0491 | 1.0502 | 8052800.0 |
| 2000-09-20 09:40:00 | AAPL | Stock | 1.0502 | 1.0625 | 1.0458 | 1.0625 | 4009600.0 |
| 2000-09-20 09:45:00 | AAPL | Stock | 1.0614 | 1.067 | 1.0558 | 1.0625 | 2240000.0 |
| 2000-09-20 09:50:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0536 | 1.0536 | 1332800.0 |
| 2000-09-20 09:55:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0458 | 1.0502 | 3528000.0 |
| 2000-09-20 10:00:00 | AAPL | Stock | 1.0502 | 1.0558 | 1.0469 | 1.0552 | 2195200.0 |
| 2000-09-20 10:05:00 | AAPL | Stock | 1.0552 | 1.0552 | 1.0525 | 1.0536 | 1545600.0 |
| 2000-09-20 10:10:00 | AAPL | Stock | 1.0525 | 1.0547 | 1.048 | 1.0547 | 2598400.0 |
| 2000-09-20 10:15:00 | AAPL | Stock | 1.0547 | 1.0558 | 1.0525 | 1.0547 | 4407200.0 |
| 2000-09-20 10:20:00 | AAPL | Stock | 1.0552 | 1.058 | 1.0547 | 1.058 | 1702400.0 |
| 2000-09-20 10:25:00 | AAPL | Stock | 1.0575 | 1.0647 | 1.0569 | 1.0625 | 3012800.0 |
| 2000-09-20 10:30:00 | AAPL | Stock | 1.0614 | 1.0647 | 1.0614 | 1.0642 | 1164800.0 |
| 2000-09-20 10:35:00 | AAPL | Stock | 1.0636 | 1.0692 | 1.0636 | 1.0647 | 2772000.0 |
| 2000-09-20 10:40:00 | AAPL | Stock | 1.0647 | 1.067 | 1.0603 | 1.0647 | 3393600.0 |
| 2000-09-20 10:45:00 | AAPL | Stock | 1.0636 | 1.0636 | 1.0558 | 1.0558 | 2004800.0 |
| 2000-09-20 10:50:00 | AAPL | Stock | 1.0569 | 1.067 | 1.0547 | 1.067 | 1618400.0 |
| 2000-09-20 10:55:00 | AAPL | Stock | 1.0658 | 1.0692 | 1.0636 | 1.0636 | 2335200.0 |
| 2000-09-20 11:00:00 | AAPL | Stock | 1.0636 | 1.067 | 1.0558 | 1.0558 | 3231200.0 |
| 2000-09-20 11:05:00 | AAPL | Stock | 1.0569 | 1.0592 | 1.0569 | 1.0586 | 683200.0 |
| 2000-09-20 11:10:00 | AAPL | Stock | 1.058 | 1.0592 | 1.0547 | 1.0547 | 1125600.0 |
| 2000-09-20 11:15:00 | AAPL | Stock | 1.0547 | 1.0558 | 1.0525 | 1.0525 | 2436000.0 |
| 2000-09-20 11:20:00 | AAPL | Stock | 1.0525 | 1.0547 | 1.0513 | 1.0525 | 1349600.0 |
| 2000-09-20 11:25:00 | AAPL | Stock | 1.0525 | 1.0569 | 1.0525 | 1.0536 | 1304800.0 |
| 2000-09-20 11:30:00 | AAPL | Stock | 1.0536 | 1.0569 | 1.0536 | 1.0547 | 604800.0 |
| 2000-09-20 11:35:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.0525 | 1.0547 | 1579200.0 |
| 2000-09-20 11:40:00 | AAPL | Stock | 1.0547 | 1.0592 | 1.0536 | 1.0592 | 2312800.0 |
| 2000-09-20 11:45:00 | AAPL | Stock | 1.058 | 1.0636 | 1.058 | 1.0625 | 1741600.0 |
| 2000-09-20 11:50:00 | AAPL | Stock | 1.0619 | 1.0647 | 1.0614 | 1.0614 | 924000.0 |
| 2000-09-20 11:55:00 | AAPL | Stock | 1.0603 | 1.0625 | 1.0603 | 1.0603 | 425600.0 |
| 2000-09-20 12:00:00 | AAPL | Stock | 1.0614 | 1.0625 | 1.0603 | 1.0614 | 655200.0 |
| 2000-09-20 12:05:00 | AAPL | Stock | 1.0614 | 1.0658 | 1.0614 | 1.0647 | 1360800.0 |
| 2000-09-20 12:10:00 | AAPL | Stock | 1.0647 | 1.0647 | 1.0636 | 1.0647 | 548800.0 |
| 2000-09-20 12:15:00 | AAPL | Stock | 1.0642 | 1.0647 | 1.0636 | 1.0636 | 851200.0 |
| 2000-09-20 12:20:00 | AAPL | Stock | 1.0636 | 1.0647 | 1.0603 | 1.0603 | 1316000.0 |
| 2000-09-20 12:25:00 | AAPL | Stock | 1.0603 | 1.0625 | 1.0603 | 1.0614 | 711200.0 |
| 2000-09-20 12:30:00 | AAPL | Stock | 1.0614 | 1.0625 | 1.0558 | 1.058 | 2088800.0 |
| 2000-09-20 12:35:00 | AAPL | Stock | 1.0569 | 1.058 | 1.0536 | 1.0536 | 733600.0 |
| 2000-09-20 12:40:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.0513 | 1.0536 | 1254400.0 |
| 2000-09-20 12:45:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.0513 | 1.0536 | 1355200.0 |
| 2000-09-20 12:50:00 | AAPL | Stock | 1.0541 | 1.0558 | 1.0513 | 1.0525 | 1164800.0 |
| 2000-09-20 12:55:00 | AAPL | Stock | 1.0525 | 1.058 | 1.0513 | 1.0569 | 862400.0 |
| 2000-09-20 13:00:00 | AAPL | Stock | 1.0575 | 1.0625 | 1.0569 | 1.0603 | 1758400.0 |
| 2000-09-20 13:05:00 | AAPL | Stock | 1.0603 | 1.0614 | 1.058 | 1.0592 | 1293600.0 |
| 2000-09-20 13:10:00 | AAPL | Stock | 1.0603 | 1.0603 | 1.0558 | 1.0558 | 929600.0 |
> showing 50 of 90,795 rows — these rows as CSV