PREVIEW / stock_5min / 2000-04-18
file: by_date/stock_5min/2000/2000-04-18.parquet size: 1.2 MB rows: 92,889 symbols: 1,162
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-18 09:30:00 | AAPL | Stock | 1.1027 | 1.1071 | 1.1004 | 1.1007 | 7694400.0 |
| 2000-04-18 09:35:00 | AAPL | Stock | 1.101 | 1.106 | 1.0871 | 1.0871 | 10404800.0 |
| 2000-04-18 09:40:00 | AAPL | Stock | 1.0893 | 1.0904 | 1.077 | 1.0893 | 5107200.0 |
| 2000-04-18 09:45:00 | AAPL | Stock | 1.0904 | 1.1071 | 1.0893 | 1.1071 | 7548800.0 |
| 2000-04-18 09:50:00 | AAPL | Stock | 1.1071 | 1.1127 | 1.1049 | 1.1071 | 15792000.0 |
| 2000-04-18 09:55:00 | AAPL | Stock | 1.1119 | 1.1183 | 1.1071 | 1.1071 | 6820800.0 |
| 2000-04-18 10:00:00 | AAPL | Stock | 1.1077 | 1.111 | 1.1004 | 1.1102 | 7515200.0 |
| 2000-04-18 10:05:00 | AAPL | Stock | 1.1071 | 1.111 | 1.1027 | 1.1094 | 6854400.0 |
| 2000-04-18 10:10:00 | AAPL | Stock | 1.1044 | 1.1049 | 1.0904 | 1.0926 | 2105600.0 |
| 2000-04-18 10:15:00 | AAPL | Stock | 1.0932 | 1.0971 | 1.0804 | 1.0804 | 6204800.0 |
| 2000-04-18 10:20:00 | AAPL | Stock | 1.0809 | 1.0882 | 1.0781 | 1.0848 | 9912000.0 |
| 2000-04-18 10:25:00 | AAPL | Stock | 1.0848 | 1.0871 | 1.0798 | 1.0804 | 3897600.0 |
| 2000-04-18 10:30:00 | AAPL | Stock | 1.0804 | 1.0804 | 1.0714 | 1.0728 | 5790400.0 |
| 2000-04-18 10:35:00 | AAPL | Stock | 1.0725 | 1.0809 | 1.0658 | 1.0706 | 6585600.0 |
| 2000-04-18 10:40:00 | AAPL | Stock | 1.0698 | 1.0759 | 1.067 | 1.0753 | 3012800.0 |
| 2000-04-18 10:45:00 | AAPL | Stock | 1.0751 | 1.0843 | 1.0714 | 1.0843 | 3348800.0 |
| 2000-04-18 10:50:00 | AAPL | Stock | 1.0843 | 1.0845 | 1.0759 | 1.0776 | 3528000.0 |
| 2000-04-18 10:55:00 | AAPL | Stock | 1.0798 | 1.0865 | 1.0798 | 1.082 | 3796800.0 |
| 2000-04-18 11:00:00 | AAPL | Stock | 1.0798 | 1.0798 | 1.0759 | 1.0776 | 3035200.0 |
| 2000-04-18 11:05:00 | AAPL | Stock | 1.0776 | 1.0859 | 1.0776 | 1.0837 | 3236800.0 |
| 2000-04-18 11:10:00 | AAPL | Stock | 1.082 | 1.0859 | 1.0776 | 1.0776 | 3102400.0 |
| 2000-04-18 11:15:00 | AAPL | Stock | 1.077 | 1.0843 | 1.077 | 1.0837 | 2979200.0 |
| 2000-04-18 11:20:00 | AAPL | Stock | 1.0837 | 1.0859 | 1.0804 | 1.0843 | 1747200.0 |
| 2000-04-18 11:25:00 | AAPL | Stock | 1.0843 | 1.0915 | 1.084 | 1.0865 | 9206400.0 |
| 2000-04-18 11:30:00 | AAPL | Stock | 1.0876 | 1.0957 | 1.0876 | 1.0943 | 4379200.0 |
| 2000-04-18 11:35:00 | AAPL | Stock | 1.0949 | 1.1071 | 1.0943 | 1.1049 | 5779200.0 |
| 2000-04-18 11:40:00 | AAPL | Stock | 1.1071 | 1.1083 | 1.0982 | 1.0982 | 5140800.0 |
| 2000-04-18 11:45:00 | AAPL | Stock | 1.0982 | 1.1044 | 1.0982 | 1.0988 | 2945600.0 |
| 2000-04-18 11:50:00 | AAPL | Stock | 1.0982 | 1.1027 | 1.096 | 1.1004 | 2755200.0 |
| 2000-04-18 11:55:00 | AAPL | Stock | 1.0999 | 1.106 | 1.0988 | 1.0988 | 3326400.0 |
| 2000-04-18 12:00:00 | AAPL | Stock | 1.0985 | 1.1027 | 1.0965 | 1.1016 | 3404800.0 |
| 2000-04-18 12:05:00 | AAPL | Stock | 1.0993 | 1.1116 | 1.0993 | 1.1116 | 4648000.0 |
| 2000-04-18 12:10:00 | AAPL | Stock | 1.1116 | 1.1161 | 1.1049 | 1.1161 | 5532800.0 |
| 2000-04-18 12:15:00 | AAPL | Stock | 1.1161 | 1.125 | 1.1105 | 1.1211 | 7134400.0 |
| 2000-04-18 12:20:00 | AAPL | Stock | 1.1205 | 1.1272 | 1.1183 | 1.1228 | 6955200.0 |
| 2000-04-18 12:25:00 | AAPL | Stock | 1.1233 | 1.125 | 1.1194 | 1.1194 | 5499200.0 |
| 2000-04-18 12:30:00 | AAPL | Stock | 1.1194 | 1.125 | 1.1194 | 1.1194 | 1836800.0 |
| 2000-04-18 12:35:00 | AAPL | Stock | 1.1194 | 1.1211 | 1.1161 | 1.1177 | 3113600.0 |
| 2000-04-18 12:40:00 | AAPL | Stock | 1.1161 | 1.1183 | 1.1094 | 1.1105 | 2363200.0 |
| 2000-04-18 12:45:00 | AAPL | Stock | 1.1105 | 1.1161 | 1.1094 | 1.1099 | 1288000.0 |
| 2000-04-18 12:50:00 | AAPL | Stock | 1.1099 | 1.1161 | 1.1094 | 1.1161 | 537600.0 |
| 2000-04-18 12:55:00 | AAPL | Stock | 1.1155 | 1.1217 | 1.1155 | 1.1161 | 1803200.0 |
| 2000-04-18 13:00:00 | AAPL | Stock | 1.1161 | 1.1161 | 1.1116 | 1.1116 | 1131200.0 |
| 2000-04-18 13:05:00 | AAPL | Stock | 1.1116 | 1.1119 | 1.1071 | 1.1088 | 2441600.0 |
| 2000-04-18 13:10:00 | AAPL | Stock | 1.1088 | 1.1116 | 1.1032 | 1.1032 | 2889600.0 |
| 2000-04-18 13:15:00 | AAPL | Stock | 1.1032 | 1.1105 | 1.1027 | 1.1094 | 3169600.0 |
| 2000-04-18 13:20:00 | AAPL | Stock | 1.1094 | 1.1138 | 1.1071 | 1.1077 | 2889600.0 |
| 2000-04-18 13:25:00 | AAPL | Stock | 1.1116 | 1.1217 | 1.111 | 1.1205 | 5387200.0 |
| 2000-04-18 13:30:00 | AAPL | Stock | 1.1217 | 1.1228 | 1.1183 | 1.1228 | 2172800.0 |
| 2000-04-18 13:35:00 | AAPL | Stock | 1.1217 | 1.1217 | 1.1094 | 1.1094 | 2273600.0 |
> showing 50 of 92,889 rows — these rows as CSV