PREVIEW / stock_5min / 2012-09-21
file: by_date/stock_5min/2012/2012-09-21.parquet size: 5.0 MB rows: 334,931 symbols: 3,505
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-21 04:05:00 | AAPL | Stock | 24.9911 | 24.9914 | 24.9911 | 24.9914 | 11200.0 |
| 2012-09-21 04:15:00 | AAPL | Stock | 25.0011 | 25.0011 | 25.0011 | 25.0011 | 2800.0 |
| 2012-09-21 04:30:00 | AAPL | Stock | 25.0125 | 25.0125 | 25.0021 | 25.0021 | 8400.0 |
| 2012-09-21 04:35:00 | AAPL | Stock | 25.0125 | 25.0161 | 25.0125 | 25.0161 | 14000.0 |
| 2012-09-21 04:50:00 | AAPL | Stock | 25.0357 | 25.045 | 25.0357 | 25.045 | 5600.0 |
| 2012-09-21 05:05:00 | AAPL | Stock | 25.0446 | 25.0446 | 25.0446 | 25.0446 | 2800.0 |
| 2012-09-21 05:10:00 | AAPL | Stock | 25.0446 | 25.0475 | 25.0446 | 25.0475 | 11200.0 |
| 2012-09-21 06:25:00 | AAPL | Stock | 25.0214 | 25.0214 | 25.0214 | 25.0214 | 5180.0 |
| 2012-09-21 06:35:00 | AAPL | Stock | 25.0475 | 25.0475 | 25.0475 | 25.0475 | 14000.0 |
| 2012-09-21 06:40:00 | AAPL | Stock | 25.0475 | 25.0475 | 25.0475 | 25.0475 | 12600.0 |
| 2012-09-21 06:50:00 | AAPL | Stock | 25.0393 | 25.0393 | 25.0393 | 25.0393 | 2800.0 |
| 2012-09-21 07:00:00 | AAPL | Stock | 25.0654 | 25.0654 | 25.0307 | 25.0529 | 88368.0 |
| 2012-09-21 07:05:00 | AAPL | Stock | 25.0536 | 25.0754 | 25.0429 | 25.0736 | 207592.0 |
| 2012-09-21 07:10:00 | AAPL | Stock | 25.0871 | 25.1018 | 25.0557 | 25.0557 | 144956.0 |
| 2012-09-21 07:15:00 | AAPL | Stock | 25.0714 | 25.0786 | 25.0714 | 25.0786 | 29204.0 |
| 2012-09-21 07:20:00 | AAPL | Stock | 25.0686 | 25.0782 | 25.0679 | 25.0714 | 62664.0 |
| 2012-09-21 07:25:00 | AAPL | Stock | 25.0729 | 25.095 | 25.0729 | 25.095 | 129108.0 |
| 2012-09-21 07:30:00 | AAPL | Stock | 25.0889 | 25.1179 | 25.0889 | 25.1179 | 114660.0 |
| 2012-09-21 07:35:00 | AAPL | Stock | 25.1171 | 25.1546 | 25.1168 | 25.1429 | 344988.0 |
| 2012-09-21 07:40:00 | AAPL | Stock | 25.1371 | 25.1479 | 25.1357 | 25.1479 | 80052.0 |
| 2012-09-21 07:45:00 | AAPL | Stock | 25.1339 | 25.1343 | 25.125 | 25.125 | 63924.0 |
| 2012-09-21 07:50:00 | AAPL | Stock | 25.125 | 25.1429 | 25.125 | 25.1282 | 96740.0 |
| 2012-09-21 07:55:00 | AAPL | Stock | 25.1279 | 25.1368 | 25.1279 | 25.1304 | 22400.0 |
| 2012-09-21 08:00:00 | AAPL | Stock | 25.1304 | 25.1518 | 25.0671 | 25.125 | 1046724.0 |
| 2012-09-21 08:05:00 | AAPL | Stock | 25.1211 | 25.125 | 25.1211 | 25.1214 | 81480.0 |
| 2012-09-21 08:10:00 | AAPL | Stock | 25.1243 | 25.1357 | 25.1232 | 25.1339 | 208852.0 |
| 2012-09-21 08:15:00 | AAPL | Stock | 25.1321 | 25.1339 | 25.125 | 25.1311 | 142240.0 |
| 2012-09-21 08:20:00 | AAPL | Stock | 25.1232 | 25.125 | 25.1143 | 25.1196 | 362768.0 |
| 2012-09-21 08:25:00 | AAPL | Stock | 25.1214 | 25.1339 | 25.1196 | 25.1321 | 504812.0 |
| 2012-09-21 08:30:00 | AAPL | Stock | 25.1339 | 25.1393 | 25.1196 | 25.1196 | 459368.0 |
| 2012-09-21 08:35:00 | AAPL | Stock | 25.1161 | 25.1214 | 25.0957 | 25.1018 | 680540.0 |
| 2012-09-21 08:40:00 | AAPL | Stock | 25.1018 | 25.1089 | 25.1 | 25.1068 | 187796.0 |
| 2012-09-21 08:45:00 | AAPL | Stock | 25.1025 | 25.1071 | 25.0975 | 25.1054 | 195552.0 |
| 2012-09-21 08:50:00 | AAPL | Stock | 25.1025 | 25.1243 | 25.1025 | 25.1157 | 405300.0 |
| 2012-09-21 08:55:00 | AAPL | Stock | 25.1229 | 25.1321 | 25.1214 | 25.1293 | 355600.0 |
| 2012-09-21 09:00:00 | AAPL | Stock | 25.1304 | 25.1304 | 25.1179 | 25.1225 | 299320.0 |
| 2012-09-21 09:05:00 | AAPL | Stock | 25.1214 | 25.1318 | 25.1193 | 25.125 | 326704.0 |
| 2012-09-21 09:10:00 | AAPL | Stock | 25.1232 | 25.1268 | 25.1057 | 25.1071 | 498932.0 |
| 2012-09-21 09:15:00 | AAPL | Stock | 25.1071 | 25.1082 | 25.0982 | 25.1071 | 276304.0 |
| 2012-09-21 09:20:00 | AAPL | Stock | 25.1064 | 25.1071 | 25.1007 | 25.1071 | 445060.0 |
| 2012-09-21 09:25:00 | AAPL | Stock | 25.1071 | 25.1071 | 25.0721 | 25.0775 | 1084020.0 |
| 2012-09-21 09:30:00 | AAPL | Stock | 25.0768 | 25.1146 | 25.0539 | 25.1025 | 76378176.0 |
| 2012-09-21 09:35:00 | AAPL | Stock | 25.1036 | 25.1546 | 25.1001 | 25.1477 | 20575184.0 |
| 2012-09-21 09:40:00 | AAPL | Stock | 25.15 | 25.1511 | 25.0875 | 25.1057 | 15329132.0 |
| 2012-09-21 09:45:00 | AAPL | Stock | 25.1061 | 25.1243 | 25.0929 | 25.1125 | 6678868.0 |
| 2012-09-21 09:50:00 | AAPL | Stock | 25.1137 | 25.1225 | 25.0964 | 25.1093 | 5384148.0 |
| 2012-09-21 09:55:00 | AAPL | Stock | 25.1086 | 25.1179 | 25.1036 | 25.1136 | 4379312.0 |
| 2012-09-21 10:00:00 | AAPL | Stock | 25.1139 | 25.1139 | 25.0957 | 25.1029 | 4818464.0 |
| 2012-09-21 10:05:00 | AAPL | Stock | 25.1025 | 25.1129 | 25.0954 | 25.1082 | 5440344.0 |
| 2012-09-21 10:10:00 | AAPL | Stock | 25.1089 | 25.1286 | 25.1068 | 25.1218 | 8996624.0 |
> showing 50 of 334,931 rows — these rows as CSV