PREVIEW / stock_5min / 2004-11-22
file: by_date/stock_5min/2004/2004-11-22.parquet size: 2.6 MB rows: 192,072 symbols: 1,877
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-22 08:00:00 | AAPL | Stock | 1.027 | 1.0446 | 0.9839 | 1.0309 | 3731616.0 |
| 2004-11-22 08:05:00 | AAPL | Stock | 1.0311 | 1.0357 | 1.0268 | 1.0268 | 3479728.0 |
| 2004-11-22 08:10:00 | AAPL | Stock | 1.0275 | 1.0277 | 1.0232 | 1.0277 | 2891392.0 |
| 2004-11-22 08:15:00 | AAPL | Stock | 1.0277 | 1.0311 | 1.0259 | 1.0286 | 2155440.0 |
| 2004-11-22 08:20:00 | AAPL | Stock | 1.0277 | 1.0277 | 1.017 | 1.0232 | 2328200.0 |
| 2004-11-22 08:25:00 | AAPL | Stock | 1.0238 | 1.0279 | 1.0211 | 1.0268 | 927304.0 |
| 2004-11-22 08:30:00 | AAPL | Stock | 1.0268 | 1.033 | 1.025 | 1.0321 | 985544.0 |
| 2004-11-22 08:35:00 | AAPL | Stock | 1.0329 | 1.0375 | 1.0313 | 1.0373 | 4382168.0 |
| 2004-11-22 08:40:00 | AAPL | Stock | 1.0373 | 1.0445 | 1.0357 | 1.0382 | 3917144.0 |
| 2004-11-22 08:45:00 | AAPL | Stock | 1.0393 | 1.0393 | 1.0366 | 1.0393 | 1545040.0 |
| 2004-11-22 08:50:00 | AAPL | Stock | 1.0393 | 1.0402 | 1.0384 | 1.0393 | 1746920.0 |
| 2004-11-22 08:55:00 | AAPL | Stock | 1.0393 | 1.0393 | 1.0361 | 1.0384 | 640360.0 |
| 2004-11-22 09:00:00 | AAPL | Stock | 1.0375 | 1.0398 | 1.0375 | 1.0393 | 3568880.0 |
| 2004-11-22 09:05:00 | AAPL | Stock | 1.0396 | 1.0441 | 1.0179 | 1.0432 | 3559248.0 |
| 2004-11-22 09:10:00 | AAPL | Stock | 1.0429 | 1.0482 | 1.0413 | 1.0429 | 3279360.0 |
| 2004-11-22 09:15:00 | AAPL | Stock | 1.0429 | 1.0455 | 1.0391 | 1.0396 | 3052560.0 |
| 2004-11-22 09:20:00 | AAPL | Stock | 1.0393 | 1.0405 | 1.0309 | 1.0321 | 2794288.0 |
| 2004-11-22 09:25:00 | AAPL | Stock | 1.0321 | 1.0393 | 0.9884 | 1.0355 | 14845264.0 |
| 2004-11-22 09:30:00 | AAPL | Stock | 1.0361 | 1.0439 | 1.0339 | 1.0439 | 95322248.0 |
| 2004-11-22 09:35:00 | AAPL | Stock | 1.0441 | 1.0655 | 1.0439 | 1.0646 | 107992640.0 |
| 2004-11-22 09:40:00 | AAPL | Stock | 1.0646 | 1.0707 | 1.06 | 1.0607 | 74487784.0 |
| 2004-11-22 09:45:00 | AAPL | Stock | 1.0605 | 1.0675 | 1.06 | 1.0661 | 49612472.0 |
| 2004-11-22 09:50:00 | AAPL | Stock | 1.0655 | 1.0746 | 1.0648 | 1.0741 | 79854768.0 |
| 2004-11-22 09:55:00 | AAPL | Stock | 1.0738 | 1.0945 | 1.0709 | 1.0929 | 117282872.0 |
| 2004-11-22 10:00:00 | AAPL | Stock | 1.093 | 1.1152 | 1.0923 | 1.1036 | 135974384.0 |
| 2004-11-22 10:05:00 | AAPL | Stock | 1.1036 | 1.1118 | 1.1025 | 1.1084 | 77876232.0 |
| 2004-11-22 10:10:00 | AAPL | Stock | 1.1086 | 1.128 | 1.1054 | 1.1261 | 83415584.0 |
| 2004-11-22 10:15:00 | AAPL | Stock | 1.1263 | 1.1295 | 1.1132 | 1.1193 | 83598256.0 |
| 2004-11-22 10:20:00 | AAPL | Stock | 1.1193 | 1.1216 | 1.1114 | 1.1136 | 54818400.0 |
| 2004-11-22 10:25:00 | AAPL | Stock | 1.1136 | 1.1175 | 1.1077 | 1.1095 | 51293984.0 |
| 2004-11-22 10:30:00 | AAPL | Stock | 1.1091 | 1.1107 | 1.1027 | 1.1082 | 59644256.0 |
| 2004-11-22 10:35:00 | AAPL | Stock | 1.1082 | 1.1096 | 1.1039 | 1.1039 | 35572152.0 |
| 2004-11-22 10:40:00 | AAPL | Stock | 1.1039 | 1.1063 | 1.1014 | 1.1036 | 35952000.0 |
| 2004-11-22 10:45:00 | AAPL | Stock | 1.1036 | 1.1073 | 1.1004 | 1.1009 | 33601288.0 |
| 2004-11-22 10:50:00 | AAPL | Stock | 1.1009 | 1.1045 | 1.095 | 1.1016 | 40673696.0 |
| 2004-11-22 10:55:00 | AAPL | Stock | 1.1016 | 1.1039 | 1.0973 | 1.1038 | 27844264.0 |
| 2004-11-22 11:00:00 | AAPL | Stock | 1.1039 | 1.1039 | 1.0964 | 1.0982 | 23261056.0 |
| 2004-11-22 11:05:00 | AAPL | Stock | 1.0982 | 1.0989 | 1.0955 | 1.0975 | 26098576.0 |
| 2004-11-22 11:10:00 | AAPL | Stock | 1.0975 | 1.0988 | 1.0943 | 1.0948 | 20921824.0 |
| 2004-11-22 11:15:00 | AAPL | Stock | 1.0946 | 1.1014 | 1.0938 | 1.0982 | 28508816.0 |
| 2004-11-22 11:20:00 | AAPL | Stock | 1.098 | 1.0984 | 1.0861 | 1.0871 | 38871392.0 |
| 2004-11-22 11:25:00 | AAPL | Stock | 1.0875 | 1.092 | 1.0866 | 1.0914 | 25123672.0 |
| 2004-11-22 11:30:00 | AAPL | Stock | 1.0904 | 1.0911 | 1.088 | 1.0893 | 16588936.0 |
| 2004-11-22 11:35:00 | AAPL | Stock | 1.0891 | 1.093 | 1.0863 | 1.093 | 20623008.0 |
| 2004-11-22 11:40:00 | AAPL | Stock | 1.093 | 1.0952 | 1.0914 | 1.092 | 22820336.0 |
| 2004-11-22 11:45:00 | AAPL | Stock | 1.092 | 1.0955 | 1.092 | 1.0948 | 18056248.0 |
| 2004-11-22 11:50:00 | AAPL | Stock | 1.095 | 1.0971 | 1.0939 | 1.0941 | 13578432.0 |
| 2004-11-22 11:55:00 | AAPL | Stock | 1.0939 | 1.0946 | 1.0916 | 1.094 | 16345672.0 |
| 2004-11-22 12:00:00 | AAPL | Stock | 1.0934 | 1.0938 | 1.0895 | 1.09 | 11680984.0 |
| 2004-11-22 12:05:00 | AAPL | Stock | 1.0902 | 1.0927 | 1.0893 | 1.0896 | 9161432.0 |
> showing 50 of 192,072 rows — these rows as CSV