PREVIEW / stock_5min / 2000-04-27
file: by_date/stock_5min/2000/2000-04-27.parquet size: 1.1 MB rows: 82,485 symbols: 1,156
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-27 09:30:00 | AAPL | Stock | 1.0463 | 1.0642 | 1.0424 | 1.0541 | 11032000.0 |
| 2000-04-27 09:35:00 | AAPL | Stock | 1.0558 | 1.0692 | 1.0469 | 1.067 | 5969600.0 |
| 2000-04-27 09:40:00 | AAPL | Stock | 1.0658 | 1.0703 | 1.0569 | 1.0647 | 5454400.0 |
| 2000-04-27 09:45:00 | AAPL | Stock | 1.0592 | 1.0614 | 1.0497 | 1.0502 | 4860800.0 |
| 2000-04-27 09:50:00 | AAPL | Stock | 1.0511 | 1.0525 | 1.0424 | 1.0452 | 6059200.0 |
| 2000-04-27 09:55:00 | AAPL | Stock | 1.0446 | 1.0519 | 1.0407 | 1.0519 | 4916800.0 |
| 2000-04-27 10:00:00 | AAPL | Stock | 1.0491 | 1.0547 | 1.0458 | 1.0491 | 5947200.0 |
| 2000-04-27 10:05:00 | AAPL | Stock | 1.0491 | 1.0625 | 1.048 | 1.0625 | 16195200.0 |
| 2000-04-27 10:10:00 | AAPL | Stock | 1.0619 | 1.0804 | 1.0547 | 1.0753 | 7952000.0 |
| 2000-04-27 10:15:00 | AAPL | Stock | 1.0773 | 1.0804 | 1.0714 | 1.0781 | 9441600.0 |
| 2000-04-27 10:20:00 | AAPL | Stock | 1.0804 | 1.0837 | 1.0759 | 1.0795 | 5174400.0 |
| 2000-04-27 10:25:00 | AAPL | Stock | 1.0798 | 1.0901 | 1.0765 | 1.0795 | 5398400.0 |
| 2000-04-27 10:30:00 | AAPL | Stock | 1.077 | 1.0848 | 1.0731 | 1.0737 | 4256000.0 |
| 2000-04-27 10:35:00 | AAPL | Stock | 1.0742 | 1.0784 | 1.0698 | 1.0731 | 2564800.0 |
| 2000-04-27 10:40:00 | AAPL | Stock | 1.0731 | 1.0737 | 1.0703 | 1.0725 | 2598400.0 |
| 2000-04-27 10:45:00 | AAPL | Stock | 1.0737 | 1.0776 | 1.0725 | 1.077 | 817600.0 |
| 2000-04-27 10:50:00 | AAPL | Stock | 1.0776 | 1.0787 | 1.0742 | 1.0748 | 1635200.0 |
| 2000-04-27 10:55:00 | AAPL | Stock | 1.0753 | 1.0792 | 1.0742 | 1.0742 | 851200.0 |
| 2000-04-27 11:00:00 | AAPL | Stock | 1.0742 | 1.0742 | 1.0714 | 1.0714 | 1568000.0 |
| 2000-04-27 11:05:00 | AAPL | Stock | 1.0714 | 1.0742 | 1.0692 | 1.0709 | 4804800.0 |
| 2000-04-27 11:10:00 | AAPL | Stock | 1.0709 | 1.072 | 1.0681 | 1.0686 | 3371200.0 |
| 2000-04-27 11:15:00 | AAPL | Stock | 1.0681 | 1.0714 | 1.067 | 1.0714 | 974400.0 |
| 2000-04-27 11:20:00 | AAPL | Stock | 1.0714 | 1.072 | 1.0703 | 1.072 | 2296000.0 |
| 2000-04-27 11:25:00 | AAPL | Stock | 1.0714 | 1.072 | 1.0714 | 1.072 | 1344000.0 |
| 2000-04-27 11:30:00 | AAPL | Stock | 1.0725 | 1.0871 | 1.072 | 1.0848 | 2452800.0 |
| 2000-04-27 11:35:00 | AAPL | Stock | 1.0871 | 1.0893 | 1.0831 | 1.0893 | 2396800.0 |
| 2000-04-27 11:40:00 | AAPL | Stock | 1.0893 | 1.091 | 1.0854 | 1.0893 | 2027200.0 |
| 2000-04-27 11:45:00 | AAPL | Stock | 1.0893 | 1.0915 | 1.0871 | 1.0882 | 907200.0 |
| 2000-04-27 11:50:00 | AAPL | Stock | 1.0876 | 1.0965 | 1.0876 | 1.0965 | 3304000.0 |
| 2000-04-27 11:55:00 | AAPL | Stock | 1.0965 | 1.1027 | 1.0943 | 1.1027 | 15489600.0 |
| 2000-04-27 12:00:00 | AAPL | Stock | 1.1027 | 1.1071 | 1.1004 | 1.1071 | 3035200.0 |
| 2000-04-27 12:05:00 | AAPL | Stock | 1.106 | 1.1094 | 1.1016 | 1.1066 | 3819200.0 |
| 2000-04-27 12:10:00 | AAPL | Stock | 1.1066 | 1.1083 | 1.1027 | 1.1066 | 2755200.0 |
| 2000-04-27 12:15:00 | AAPL | Stock | 1.1083 | 1.1083 | 1.1027 | 1.1044 | 1232000.0 |
| 2000-04-27 12:20:00 | AAPL | Stock | 1.1032 | 1.1071 | 1.1032 | 1.1044 | 4099200.0 |
| 2000-04-27 12:25:00 | AAPL | Stock | 1.1038 | 1.115 | 1.1032 | 1.115 | 7246400.0 |
| 2000-04-27 12:30:00 | AAPL | Stock | 1.1138 | 1.1183 | 1.1071 | 1.1105 | 5230400.0 |
| 2000-04-27 12:35:00 | AAPL | Stock | 1.1116 | 1.115 | 1.1083 | 1.1133 | 1355200.0 |
| 2000-04-27 12:40:00 | AAPL | Stock | 1.1127 | 1.115 | 1.1083 | 1.115 | 4368000.0 |
| 2000-04-27 12:45:00 | AAPL | Stock | 1.1144 | 1.1172 | 1.1105 | 1.1105 | 2049600.0 |
| 2000-04-27 12:50:00 | AAPL | Stock | 1.1105 | 1.1161 | 1.1105 | 1.1138 | 1355200.0 |
| 2000-04-27 12:55:00 | AAPL | Stock | 1.1133 | 1.115 | 1.1105 | 1.1138 | 560000.0 |
| 2000-04-27 13:00:00 | AAPL | Stock | 1.1141 | 1.1141 | 1.1105 | 1.1127 | 952000.0 |
| 2000-04-27 13:05:00 | AAPL | Stock | 1.1105 | 1.1105 | 1.1071 | 1.1071 | 2990400.0 |
| 2000-04-27 13:10:00 | AAPL | Stock | 1.1071 | 1.1071 | 1.1038 | 1.1038 | 1332800.0 |
| 2000-04-27 13:15:00 | AAPL | Stock | 1.1044 | 1.1116 | 1.1038 | 1.1099 | 1904000.0 |
| 2000-04-27 13:20:00 | AAPL | Stock | 1.1088 | 1.1116 | 1.106 | 1.106 | 660800.0 |
| 2000-04-27 13:25:00 | AAPL | Stock | 1.1088 | 1.1113 | 1.106 | 1.111 | 1064000.0 |
| 2000-04-27 13:30:00 | AAPL | Stock | 1.1088 | 1.111 | 1.1038 | 1.1044 | 1904000.0 |
| 2000-04-27 13:35:00 | AAPL | Stock | 1.1044 | 1.1105 | 1.1044 | 1.106 | 2766400.0 |
> showing 50 of 82,485 rows — these rows as CSV