PREVIEW / stock_5min / 2000-01-20
file: by_date/stock_5min/2000/2000-01-20.parquet size: 1.2 MB rows: 90,228 symbols: 1,130
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-01-20 09:30:00 | AAPL | Stock | 1.0313 | 1.0402 | 1.0313 | 1.0374 | 55608000.0 |
| 2000-01-20 09:35:00 | AAPL | Stock | 1.0363 | 1.0491 | 1.0313 | 1.0435 | 87796800.0 |
| 2000-01-20 09:40:00 | AAPL | Stock | 1.0435 | 1.0469 | 1.0313 | 1.0352 | 94080000.0 |
| 2000-01-20 09:45:00 | AAPL | Stock | 1.0377 | 1.0379 | 1.0301 | 1.0313 | 31483200.0 |
| 2000-01-20 09:50:00 | AAPL | Stock | 1.0335 | 1.0338 | 1.0268 | 1.0335 | 53211200.0 |
| 2000-01-20 09:55:00 | AAPL | Stock | 1.0335 | 1.0407 | 1.0301 | 1.0368 | 46480000.0 |
| 2000-01-20 10:00:00 | AAPL | Stock | 1.0379 | 1.0513 | 1.0377 | 1.0508 | 55619200.0 |
| 2000-01-20 10:05:00 | AAPL | Stock | 1.0491 | 1.0513 | 1.0446 | 1.0474 | 54667200.0 |
| 2000-01-20 10:10:00 | AAPL | Stock | 1.0491 | 1.0502 | 1.043 | 1.0441 | 24416000.0 |
| 2000-01-20 10:15:00 | AAPL | Stock | 1.0446 | 1.0491 | 1.0441 | 1.0446 | 27955200.0 |
| 2000-01-20 10:20:00 | AAPL | Stock | 1.0446 | 1.0463 | 1.0402 | 1.0419 | 27854400.0 |
| 2000-01-20 10:25:00 | AAPL | Stock | 1.0419 | 1.048 | 1.0413 | 1.0452 | 22388800.0 |
| 2000-01-20 10:30:00 | AAPL | Stock | 1.0458 | 1.0491 | 1.0446 | 1.048 | 21515200.0 |
| 2000-01-20 10:35:00 | AAPL | Stock | 1.0491 | 1.0491 | 1.0458 | 1.0485 | 26252800.0 |
| 2000-01-20 10:40:00 | AAPL | Stock | 1.048 | 1.0513 | 1.0446 | 1.0491 | 18726400.0 |
| 2000-01-20 10:45:00 | AAPL | Stock | 1.0491 | 1.0508 | 1.0485 | 1.0485 | 21089600.0 |
| 2000-01-20 10:50:00 | AAPL | Stock | 1.0485 | 1.0525 | 1.048 | 1.0519 | 28089600.0 |
| 2000-01-20 10:55:00 | AAPL | Stock | 1.0519 | 1.058 | 1.0502 | 1.0552 | 56033600.0 |
| 2000-01-20 11:00:00 | AAPL | Stock | 1.0558 | 1.0681 | 1.0536 | 1.0653 | 76406400.0 |
| 2000-01-20 11:05:00 | AAPL | Stock | 1.0619 | 1.067 | 1.0614 | 1.0658 | 43164800.0 |
| 2000-01-20 11:10:00 | AAPL | Stock | 1.0658 | 1.0698 | 1.0647 | 1.067 | 40678400.0 |
| 2000-01-20 11:15:00 | AAPL | Stock | 1.067 | 1.0725 | 1.0664 | 1.0703 | 43355200.0 |
| 2000-01-20 11:20:00 | AAPL | Stock | 1.0692 | 1.0748 | 1.0692 | 1.0692 | 85590400.0 |
| 2000-01-20 11:25:00 | AAPL | Stock | 1.0692 | 1.072 | 1.067 | 1.0703 | 18211200.0 |
| 2000-01-20 11:30:00 | AAPL | Stock | 1.0703 | 1.0714 | 1.0647 | 1.0647 | 17472000.0 |
| 2000-01-20 11:35:00 | AAPL | Stock | 1.0647 | 1.0692 | 1.0631 | 1.0686 | 21067200.0 |
| 2000-01-20 11:40:00 | AAPL | Stock | 1.0686 | 1.0742 | 1.0684 | 1.0703 | 29713600.0 |
| 2000-01-20 11:45:00 | AAPL | Stock | 1.0709 | 1.0804 | 1.0703 | 1.0804 | 40476800.0 |
| 2000-01-20 11:50:00 | AAPL | Stock | 1.0798 | 1.0848 | 1.0781 | 1.0804 | 52460800.0 |
| 2000-01-20 11:55:00 | AAPL | Stock | 1.0798 | 1.0826 | 1.0781 | 1.0792 | 21560000.0 |
| 2000-01-20 12:00:00 | AAPL | Stock | 1.0792 | 1.0798 | 1.0698 | 1.0714 | 30464000.0 |
| 2000-01-20 12:05:00 | AAPL | Stock | 1.0725 | 1.0734 | 1.0647 | 1.067 | 22859200.0 |
| 2000-01-20 12:10:00 | AAPL | Stock | 1.067 | 1.0737 | 1.0647 | 1.0714 | 20048000.0 |
| 2000-01-20 12:15:00 | AAPL | Stock | 1.0692 | 1.0787 | 1.0692 | 1.0776 | 14358400.0 |
| 2000-01-20 12:20:00 | AAPL | Stock | 1.0776 | 1.0781 | 1.0725 | 1.0776 | 12958400.0 |
| 2000-01-20 12:25:00 | AAPL | Stock | 1.077 | 1.0787 | 1.0748 | 1.0753 | 13384000.0 |
| 2000-01-20 12:30:00 | AAPL | Stock | 1.0748 | 1.0759 | 1.0686 | 1.0692 | 6249600.0 |
| 2000-01-20 12:35:00 | AAPL | Stock | 1.0686 | 1.0692 | 1.0603 | 1.0603 | 10931200.0 |
| 2000-01-20 12:40:00 | AAPL | Stock | 1.0608 | 1.0664 | 1.0569 | 1.0647 | 24460800.0 |
| 2000-01-20 12:45:00 | AAPL | Stock | 1.0642 | 1.0664 | 1.0592 | 1.0603 | 7392000.0 |
| 2000-01-20 12:50:00 | AAPL | Stock | 1.0603 | 1.0653 | 1.0592 | 1.0592 | 4177600.0 |
| 2000-01-20 12:55:00 | AAPL | Stock | 1.0608 | 1.0653 | 1.058 | 1.0653 | 7638400.0 |
| 2000-01-20 13:00:00 | AAPL | Stock | 1.0653 | 1.0653 | 1.0592 | 1.0625 | 6708800.0 |
| 2000-01-20 13:05:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0519 | 1.0519 | 12712000.0 |
| 2000-01-20 13:10:00 | AAPL | Stock | 1.0519 | 1.0541 | 1.0474 | 1.0485 | 11536000.0 |
| 2000-01-20 13:15:00 | AAPL | Stock | 1.0485 | 1.0536 | 1.048 | 1.053 | 8321600.0 |
| 2000-01-20 13:20:00 | AAPL | Stock | 1.0525 | 1.0569 | 1.0525 | 1.0541 | 8153600.0 |
| 2000-01-20 13:25:00 | AAPL | Stock | 1.0555 | 1.058 | 1.0547 | 1.0575 | 6809600.0 |
| 2000-01-20 13:30:00 | AAPL | Stock | 1.058 | 1.058 | 1.0519 | 1.0525 | 6070400.0 |
| 2000-01-20 13:35:00 | AAPL | Stock | 1.053 | 1.0558 | 1.0519 | 1.0552 | 4950400.0 |
> showing 50 of 90,228 rows — these rows as CSV