PREVIEW / stock_5min / 2004-11-23
file: by_date/stock_5min/2004/2004-11-23.parquet size: 2.6 MB rows: 188,982 symbols: 1,879
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-23 08:00:00 | AAPL | Stock | 1.1 | 1.1071 | 1.1 | 1.1045 | 1093064.0 |
| 2004-11-23 08:05:00 | AAPL | Stock | 1.1043 | 1.1043 | 1.1 | 1.1009 | 270088.0 |
| 2004-11-23 08:10:00 | AAPL | Stock | 1.1009 | 1.1027 | 1.1009 | 1.1018 | 274400.0 |
| 2004-11-23 08:15:00 | AAPL | Stock | 1.1021 | 1.1045 | 1.1021 | 1.1045 | 178584.0 |
| 2004-11-23 08:20:00 | AAPL | Stock | 1.1045 | 1.1107 | 1.1045 | 1.1107 | 1038800.0 |
| 2004-11-23 08:25:00 | AAPL | Stock | 1.1107 | 1.1148 | 1.1107 | 1.1121 | 1189048.0 |
| 2004-11-23 08:30:00 | AAPL | Stock | 1.1118 | 1.1118 | 1.1089 | 1.1089 | 791336.0 |
| 2004-11-23 08:35:00 | AAPL | Stock | 1.1089 | 1.1098 | 1.1064 | 1.1089 | 1453984.0 |
| 2004-11-23 08:40:00 | AAPL | Stock | 1.1088 | 1.1107 | 1.1055 | 1.1061 | 1409016.0 |
| 2004-11-23 08:45:00 | AAPL | Stock | 1.1063 | 1.108 | 1.1036 | 1.1055 | 1017240.0 |
| 2004-11-23 08:50:00 | AAPL | Stock | 1.105 | 1.1077 | 1.1036 | 1.1054 | 803600.0 |
| 2004-11-23 08:55:00 | AAPL | Stock | 1.1041 | 1.1073 | 1.1041 | 1.1071 | 481432.0 |
| 2004-11-23 09:00:00 | AAPL | Stock | 1.1073 | 1.1088 | 1.1071 | 1.1071 | 566440.0 |
| 2004-11-23 09:05:00 | AAPL | Stock | 1.1071 | 1.1071 | 1.1064 | 1.1064 | 72800.0 |
| 2004-11-23 09:10:00 | AAPL | Stock | 1.1071 | 1.1082 | 1.1054 | 1.1082 | 1615712.0 |
| 2004-11-23 09:15:00 | AAPL | Stock | 1.1084 | 1.1096 | 1.1082 | 1.1089 | 847280.0 |
| 2004-11-23 09:20:00 | AAPL | Stock | 1.1084 | 1.1091 | 1.1073 | 1.1091 | 235200.0 |
| 2004-11-23 09:25:00 | AAPL | Stock | 1.1093 | 1.1138 | 1.1023 | 1.1125 | 9998184.0 |
| 2004-11-23 09:30:00 | AAPL | Stock | 1.1123 | 1.1141 | 1.105 | 1.1071 | 63227528.0 |
| 2004-11-23 09:35:00 | AAPL | Stock | 1.1066 | 1.1077 | 1.1004 | 1.1043 | 38675000.0 |
| 2004-11-23 09:40:00 | AAPL | Stock | 1.1043 | 1.1068 | 1.1013 | 1.1052 | 27869296.0 |
| 2004-11-23 09:45:00 | AAPL | Stock | 1.1054 | 1.1059 | 1.0993 | 1.0998 | 25653040.0 |
| 2004-11-23 09:50:00 | AAPL | Stock | 1.0998 | 1.105 | 1.0982 | 1.1002 | 17120040.0 |
| 2004-11-23 09:55:00 | AAPL | Stock | 1.1007 | 1.1011 | 1.0914 | 1.0934 | 28836080.0 |
| 2004-11-23 10:00:00 | AAPL | Stock | 1.0931 | 1.1023 | 1.092 | 1.102 | 20398840.0 |
| 2004-11-23 10:05:00 | AAPL | Stock | 1.102 | 1.1066 | 1.1009 | 1.1054 | 35949648.0 |
| 2004-11-23 10:10:00 | AAPL | Stock | 1.1054 | 1.1079 | 1.1018 | 1.105 | 26194168.0 |
| 2004-11-23 10:15:00 | AAPL | Stock | 1.1052 | 1.1059 | 1.0975 | 1.0977 | 16695000.0 |
| 2004-11-23 10:20:00 | AAPL | Stock | 1.0979 | 1.1011 | 1.0964 | 1.0996 | 24249624.0 |
| 2004-11-23 10:25:00 | AAPL | Stock | 1.0995 | 1.1027 | 1.0971 | 1.0977 | 10536288.0 |
| 2004-11-23 10:30:00 | AAPL | Stock | 1.0979 | 1.1018 | 1.0964 | 1.1005 | 9027032.0 |
| 2004-11-23 10:35:00 | AAPL | Stock | 1.1007 | 1.1036 | 1.0984 | 1.0988 | 9873360.0 |
| 2004-11-23 10:40:00 | AAPL | Stock | 1.0988 | 1.1 | 1.0955 | 1.0959 | 9580872.0 |
| 2004-11-23 10:45:00 | AAPL | Stock | 1.0961 | 1.0996 | 1.0959 | 1.0982 | 5483632.0 |
| 2004-11-23 10:50:00 | AAPL | Stock | 1.0982 | 1.0984 | 1.0934 | 1.0954 | 12095552.0 |
| 2004-11-23 10:55:00 | AAPL | Stock | 1.0954 | 1.0991 | 1.0902 | 1.0964 | 17767064.0 |
| 2004-11-23 11:00:00 | AAPL | Stock | 1.0961 | 1.0982 | 1.0938 | 1.0973 | 10988432.0 |
| 2004-11-23 11:05:00 | AAPL | Stock | 1.0977 | 1.098 | 1.0959 | 1.0964 | 4966080.0 |
| 2004-11-23 11:10:00 | AAPL | Stock | 1.0964 | 1.0996 | 1.0963 | 1.0995 | 10680488.0 |
| 2004-11-23 11:15:00 | AAPL | Stock | 1.0993 | 1.0996 | 1.0979 | 1.0984 | 11935336.0 |
| 2004-11-23 11:20:00 | AAPL | Stock | 1.0986 | 1.1 | 1.0982 | 1.0998 | 12383952.0 |
| 2004-11-23 11:25:00 | AAPL | Stock | 1.0996 | 1.1 | 1.0982 | 1.0986 | 4803792.0 |
| 2004-11-23 11:30:00 | AAPL | Stock | 1.0986 | 1.1 | 1.0982 | 1.0996 | 4437328.0 |
| 2004-11-23 11:35:00 | AAPL | Stock | 1.0996 | 1.1045 | 1.0995 | 1.1041 | 10568936.0 |
| 2004-11-23 11:40:00 | AAPL | Stock | 1.1043 | 1.1043 | 1.1009 | 1.1011 | 8870736.0 |
| 2004-11-23 11:45:00 | AAPL | Stock | 1.1013 | 1.1014 | 1.0988 | 1.1 | 5559456.0 |
| 2004-11-23 11:50:00 | AAPL | Stock | 1.0998 | 1.1009 | 1.0998 | 1.1005 | 2925384.0 |
| 2004-11-23 11:55:00 | AAPL | Stock | 1.1005 | 1.1021 | 1.1 | 1.1014 | 5400864.0 |
| 2004-11-23 12:00:00 | AAPL | Stock | 1.102 | 1.1023 | 1.1005 | 1.1013 | 8062544.0 |
| 2004-11-23 12:05:00 | AAPL | Stock | 1.1014 | 1.1023 | 1.1009 | 1.1016 | 6012272.0 |
> showing 50 of 188,982 rows — these rows as CSV