PREVIEW / stock_5min / 2012-08-08
file: by_date/stock_5min/2012/2012-08-08.parquet size: 4.7 MB rows: 315,086 symbols: 3,482
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-08-08 04:35:00 | AAPL | Stock | 22.1179 | 22.1179 | 22.1179 | 22.1179 | 6132.0 |
| 2012-08-08 04:50:00 | AAPL | Stock | 22.0911 | 22.0971 | 22.0911 | 22.0971 | 5600.0 |
| 2012-08-08 05:30:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 7000.0 |
| 2012-08-08 05:35:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 14000.0 |
| 2012-08-08 05:40:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 11200.0 |
| 2012-08-08 05:45:00 | AAPL | Stock | 22.0971 | 22.0971 | 22.0971 | 22.0971 | 5600.0 |
| 2012-08-08 06:30:00 | AAPL | Stock | 22.0786 | 22.0804 | 22.0786 | 22.0804 | 11200.0 |
| 2012-08-08 06:40:00 | AAPL | Stock | 22.0857 | 22.0857 | 22.0857 | 22.0857 | 14000.0 |
| 2012-08-08 07:05:00 | AAPL | Stock | 22.0968 | 22.1064 | 22.0968 | 22.1064 | 8400.0 |
| 2012-08-08 07:10:00 | AAPL | Stock | 22.1064 | 22.1175 | 22.0993 | 22.1175 | 47768.0 |
| 2012-08-08 07:15:00 | AAPL | Stock | 22.1111 | 22.1357 | 22.1111 | 22.1286 | 19600.0 |
| 2012-08-08 07:20:00 | AAPL | Stock | 22.1375 | 22.1504 | 22.1264 | 22.1286 | 47516.0 |
| 2012-08-08 07:25:00 | AAPL | Stock | 22.125 | 22.125 | 22.1146 | 22.1146 | 14000.0 |
| 2012-08-08 07:30:00 | AAPL | Stock | 22.1139 | 22.1139 | 22.1057 | 22.1057 | 33320.0 |
| 2012-08-08 07:35:00 | AAPL | Stock | 22.1136 | 22.1136 | 22.1071 | 22.1071 | 24920.0 |
| 2012-08-08 07:40:00 | AAPL | Stock | 22.0968 | 22.0968 | 22.0879 | 22.0896 | 18396.0 |
| 2012-08-08 07:50:00 | AAPL | Stock | 22.0964 | 22.0964 | 22.0911 | 22.0911 | 5600.0 |
| 2012-08-08 07:55:00 | AAPL | Stock | 22.1182 | 22.1214 | 22.1071 | 22.1071 | 39200.0 |
| 2012-08-08 08:00:00 | AAPL | Stock | 22.1504 | 22.1504 | 22.1036 | 22.1036 | 200508.0 |
| 2012-08-08 08:05:00 | AAPL | Stock | 22.0929 | 22.1071 | 22.0929 | 22.0964 | 38780.0 |
| 2012-08-08 08:10:00 | AAPL | Stock | 22.0936 | 22.0964 | 22.0857 | 22.0857 | 88844.0 |
| 2012-08-08 08:15:00 | AAPL | Stock | 22.0832 | 22.095 | 22.0789 | 22.0868 | 42392.0 |
| 2012-08-08 08:20:00 | AAPL | Stock | 22.0868 | 22.0868 | 22.0786 | 22.0786 | 70840.0 |
| 2012-08-08 08:25:00 | AAPL | Stock | 22.0821 | 22.0868 | 22.0775 | 22.0804 | 26712.0 |
| 2012-08-08 08:30:00 | AAPL | Stock | 22.0821 | 22.0968 | 22.0779 | 22.0964 | 135464.0 |
| 2012-08-08 08:35:00 | AAPL | Stock | 22.1007 | 22.1143 | 22.0946 | 22.1143 | 70000.0 |
| 2012-08-08 08:40:00 | AAPL | Stock | 22.1132 | 22.1161 | 22.0986 | 22.1071 | 133224.0 |
| 2012-08-08 08:45:00 | AAPL | Stock | 22.1125 | 22.1125 | 22.1079 | 22.1079 | 11200.0 |
| 2012-08-08 08:50:00 | AAPL | Stock | 22.1125 | 22.1125 | 22.095 | 22.095 | 141176.0 |
| 2012-08-08 08:55:00 | AAPL | Stock | 22.0968 | 22.0989 | 22.0939 | 22.0989 | 97804.0 |
| 2012-08-08 09:00:00 | AAPL | Stock | 22.1018 | 22.1104 | 22.1 | 22.1004 | 39200.0 |
| 2012-08-08 09:05:00 | AAPL | Stock | 22.1061 | 22.1368 | 22.1036 | 22.1275 | 146888.0 |
| 2012-08-08 09:10:00 | AAPL | Stock | 22.1293 | 22.1375 | 22.1236 | 22.125 | 95788.0 |
| 2012-08-08 09:15:00 | AAPL | Stock | 22.1271 | 22.1339 | 22.1243 | 22.125 | 55328.0 |
| 2012-08-08 09:20:00 | AAPL | Stock | 22.1304 | 22.1393 | 22.1211 | 22.1393 | 112280.0 |
| 2012-08-08 09:25:00 | AAPL | Stock | 22.1357 | 22.1389 | 22.1032 | 22.1071 | 308168.0 |
| 2012-08-08 09:30:00 | AAPL | Stock | 22.1071 | 22.1339 | 22.0393 | 22.0786 | 13627992.0 |
| 2012-08-08 09:35:00 | AAPL | Stock | 22.0821 | 22.1921 | 22.0761 | 22.1729 | 9264304.0 |
| 2012-08-08 09:40:00 | AAPL | Stock | 22.17 | 22.1911 | 22.1321 | 22.1514 | 4744376.0 |
| 2012-08-08 09:45:00 | AAPL | Stock | 22.1482 | 22.1571 | 22.0893 | 22.1239 | 4402804.0 |
| 2012-08-08 09:50:00 | AAPL | Stock | 22.1207 | 22.1525 | 22.1114 | 22.1455 | 4200728.0 |
| 2012-08-08 09:55:00 | AAPL | Stock | 22.1492 | 22.1492 | 22.0979 | 22.1064 | 4192188.0 |
| 2012-08-08 10:00:00 | AAPL | Stock | 22.1064 | 22.1196 | 22.0846 | 22.1061 | 3669736.0 |
| 2012-08-08 10:05:00 | AAPL | Stock | 22.1071 | 22.1079 | 22.0821 | 22.0989 | 2570232.0 |
| 2012-08-08 10:10:00 | AAPL | Stock | 22.0982 | 22.1282 | 22.0946 | 22.1225 | 2687272.0 |
| 2012-08-08 10:15:00 | AAPL | Stock | 22.1225 | 22.1332 | 22.1089 | 22.1094 | 2581460.0 |
| 2012-08-08 10:20:00 | AAPL | Stock | 22.1121 | 22.1225 | 22.1029 | 22.1043 | 1562820.0 |
| 2012-08-08 10:25:00 | AAPL | Stock | 22.1039 | 22.1139 | 22.0929 | 22.1132 | 1804124.0 |
| 2012-08-08 10:30:00 | AAPL | Stock | 22.1132 | 22.1146 | 22.0861 | 22.0868 | 2463104.0 |
| 2012-08-08 10:35:00 | AAPL | Stock | 22.0868 | 22.1007 | 22.0714 | 22.0837 | 3177216.0 |
> showing 50 of 315,086 rows — these rows as CSV