PREVIEW / stock_5min / 2000-04-20
file: by_date/stock_5min/2000/2000-04-20.parquet size: 1.1 MB rows: 82,273 symbols: 1,160
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-04-20 09:30:00 | AAPL | Stock | 1.1044 | 1.1044 | 1.0804 | 1.0876 | 50198400.0 |
| 2000-04-20 09:35:00 | AAPL | Stock | 1.0859 | 1.1138 | 1.082 | 1.111 | 41249600.0 |
| 2000-04-20 09:40:00 | AAPL | Stock | 1.1116 | 1.1116 | 1.0859 | 1.0876 | 21795200.0 |
| 2000-04-20 09:45:00 | AAPL | Stock | 1.0865 | 1.0938 | 1.0748 | 1.0826 | 24214400.0 |
| 2000-04-20 09:50:00 | AAPL | Stock | 1.0826 | 1.0848 | 1.0647 | 1.0689 | 34328000.0 |
| 2000-04-20 09:55:00 | AAPL | Stock | 1.0692 | 1.0759 | 1.067 | 1.0692 | 29624000.0 |
| 2000-04-20 10:00:00 | AAPL | Stock | 1.0692 | 1.0826 | 1.0686 | 1.0745 | 18603200.0 |
| 2000-04-20 10:05:00 | AAPL | Stock | 1.0748 | 1.0781 | 1.0658 | 1.0714 | 18782400.0 |
| 2000-04-20 10:10:00 | AAPL | Stock | 1.0737 | 1.0781 | 1.067 | 1.0765 | 14302400.0 |
| 2000-04-20 10:15:00 | AAPL | Stock | 1.0759 | 1.077 | 1.067 | 1.0675 | 10416000.0 |
| 2000-04-20 10:20:00 | AAPL | Stock | 1.0675 | 1.0692 | 1.0558 | 1.0564 | 16049600.0 |
| 2000-04-20 10:25:00 | AAPL | Stock | 1.0558 | 1.067 | 1.0513 | 1.0569 | 21459200.0 |
| 2000-04-20 10:30:00 | AAPL | Stock | 1.0569 | 1.0731 | 1.0569 | 1.072 | 12174400.0 |
| 2000-04-20 10:35:00 | AAPL | Stock | 1.0731 | 1.0753 | 1.0675 | 1.0709 | 9419200.0 |
| 2000-04-20 10:40:00 | AAPL | Stock | 1.0698 | 1.0737 | 1.0698 | 1.0703 | 6249600.0 |
| 2000-04-20 10:45:00 | AAPL | Stock | 1.0698 | 1.0714 | 1.0642 | 1.0642 | 4692800.0 |
| 2000-04-20 10:50:00 | AAPL | Stock | 1.0647 | 1.0714 | 1.0647 | 1.0703 | 3729600.0 |
| 2000-04-20 10:55:00 | AAPL | Stock | 1.0709 | 1.0709 | 1.0658 | 1.0703 | 4468800.0 |
| 2000-04-20 11:00:00 | AAPL | Stock | 1.0703 | 1.0709 | 1.0647 | 1.0664 | 1590400.0 |
| 2000-04-20 11:05:00 | AAPL | Stock | 1.0658 | 1.0703 | 1.0625 | 1.0647 | 6910400.0 |
| 2000-04-20 11:10:00 | AAPL | Stock | 1.0647 | 1.0647 | 1.0586 | 1.0592 | 9016000.0 |
| 2000-04-20 11:15:00 | AAPL | Stock | 1.0603 | 1.0625 | 1.058 | 1.0625 | 5118400.0 |
| 2000-04-20 11:20:00 | AAPL | Stock | 1.0625 | 1.0658 | 1.0603 | 1.0625 | 6955200.0 |
| 2000-04-20 11:25:00 | AAPL | Stock | 1.0625 | 1.0647 | 1.0614 | 1.0647 | 5320000.0 |
| 2000-04-20 11:30:00 | AAPL | Stock | 1.0647 | 1.0692 | 1.0625 | 1.0647 | 8321600.0 |
| 2000-04-20 11:35:00 | AAPL | Stock | 1.0647 | 1.0647 | 1.0592 | 1.0603 | 8848000.0 |
| 2000-04-20 11:40:00 | AAPL | Stock | 1.0603 | 1.0603 | 1.0575 | 1.0592 | 11838400.0 |
| 2000-04-20 11:45:00 | AAPL | Stock | 1.058 | 1.0647 | 1.0541 | 1.0642 | 4681600.0 |
| 2000-04-20 11:50:00 | AAPL | Stock | 1.0633 | 1.0647 | 1.0547 | 1.0586 | 5219200.0 |
| 2000-04-20 11:55:00 | AAPL | Stock | 1.0586 | 1.0586 | 1.0474 | 1.048 | 7996800.0 |
| 2000-04-20 12:00:00 | AAPL | Stock | 1.0469 | 1.0519 | 1.0463 | 1.0513 | 5980800.0 |
| 2000-04-20 12:05:00 | AAPL | Stock | 1.0513 | 1.0536 | 1.048 | 1.048 | 6249600.0 |
| 2000-04-20 12:10:00 | AAPL | Stock | 1.0491 | 1.0536 | 1.0463 | 1.0536 | 3147200.0 |
| 2000-04-20 12:15:00 | AAPL | Stock | 1.0519 | 1.0564 | 1.0508 | 1.0547 | 4121600.0 |
| 2000-04-20 12:20:00 | AAPL | Stock | 1.0547 | 1.0558 | 1.0513 | 1.0519 | 4390400.0 |
| 2000-04-20 12:25:00 | AAPL | Stock | 1.0513 | 1.053 | 1.048 | 1.0497 | 5040000.0 |
| 2000-04-20 12:30:00 | AAPL | Stock | 1.0502 | 1.0608 | 1.0485 | 1.0608 | 6675200.0 |
| 2000-04-20 12:35:00 | AAPL | Stock | 1.0605 | 1.0636 | 1.0564 | 1.0608 | 5443200.0 |
| 2000-04-20 12:40:00 | AAPL | Stock | 1.0603 | 1.0642 | 1.0603 | 1.0631 | 7358400.0 |
| 2000-04-20 12:45:00 | AAPL | Stock | 1.0631 | 1.0647 | 1.0625 | 1.0625 | 6518400.0 |
| 2000-04-20 12:50:00 | AAPL | Stock | 1.0619 | 1.0636 | 1.0608 | 1.0619 | 3024000.0 |
| 2000-04-20 12:55:00 | AAPL | Stock | 1.0619 | 1.0619 | 1.0558 | 1.0564 | 2945600.0 |
| 2000-04-20 13:00:00 | AAPL | Stock | 1.058 | 1.0636 | 1.0569 | 1.0625 | 3404800.0 |
| 2000-04-20 13:05:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0603 | 1.0633 | 963200.0 |
| 2000-04-20 13:10:00 | AAPL | Stock | 1.0636 | 1.0653 | 1.0619 | 1.0647 | 3897600.0 |
| 2000-04-20 13:15:00 | AAPL | Stock | 1.0658 | 1.067 | 1.0625 | 1.0631 | 5734400.0 |
| 2000-04-20 13:20:00 | AAPL | Stock | 1.0625 | 1.0631 | 1.058 | 1.0586 | 4323200.0 |
| 2000-04-20 13:25:00 | AAPL | Stock | 1.058 | 1.0603 | 1.0541 | 1.0569 | 2956800.0 |
| 2000-04-20 13:30:00 | AAPL | Stock | 1.0569 | 1.0619 | 1.0564 | 1.0619 | 3953600.0 |
| 2000-04-20 13:35:00 | AAPL | Stock | 1.0619 | 1.0636 | 1.0603 | 1.0631 | 3438400.0 |
> showing 50 of 82,273 rows — these rows as CSV