PREVIEW / stock_5min / 2012-08-29
file: by_date/stock_5min/2012/2012-08-29.parquet size: 4.5 MB rows: 307,375 symbols: 3,429
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-29 04:00:00 | AAPL | Stock | 24.1054 | 24.1054 | 24.1054 | 24.1054 | 5600.0 |
| 2012-08-29 04:05:00 | AAPL | Stock | 24.1054 | 24.1054 | 24.1054 | 24.1054 | 11200.0 |
| 2012-08-29 04:15:00 | AAPL | Stock | 24.1054 | 24.1054 | 24.1054 | 24.1054 | 5600.0 |
| 2012-08-29 05:05:00 | AAPL | Stock | 24.0986 | 24.0986 | 24.0986 | 24.0986 | 2800.0 |
| 2012-08-29 05:10:00 | AAPL | Stock | 24.0911 | 24.0911 | 24.0911 | 24.0911 | 2800.0 |
| 2012-08-29 05:30:00 | AAPL | Stock | 24.1018 | 24.1018 | 24.1018 | 24.1018 | 2800.0 |
| 2012-08-29 05:40:00 | AAPL | Stock | 24.105 | 24.105 | 24.105 | 24.105 | 2800.0 |
| 2012-08-29 06:30:00 | AAPL | Stock | 24.1139 | 24.1139 | 24.1139 | 24.1139 | 2800.0 |
| 2012-08-29 06:35:00 | AAPL | Stock | 24.1139 | 24.1139 | 24.1139 | 24.1139 | 2800.0 |
| 2012-08-29 07:00:00 | AAPL | Stock | 24.1143 | 24.1143 | 24.0893 | 24.0893 | 33740.0 |
| 2012-08-29 07:05:00 | AAPL | Stock | 24.1054 | 24.125 | 24.1054 | 24.125 | 44940.0 |
| 2012-08-29 07:10:00 | AAPL | Stock | 24.1161 | 24.1161 | 24.1071 | 24.1071 | 8400.0 |
| 2012-08-29 07:15:00 | AAPL | Stock | 24.1025 | 24.1036 | 24.1025 | 24.1032 | 17360.0 |
| 2012-08-29 07:25:00 | AAPL | Stock | 24.0961 | 24.0982 | 24.0961 | 24.0982 | 5600.0 |
| 2012-08-29 07:30:00 | AAPL | Stock | 24.0964 | 24.0982 | 24.0964 | 24.0982 | 5600.0 |
| 2012-08-29 07:55:00 | AAPL | Stock | 24.1032 | 24.1064 | 24.1032 | 24.1064 | 12012.0 |
| 2012-08-29 08:00:00 | AAPL | Stock | 24.0954 | 24.1064 | 24.0896 | 24.0943 | 56560.0 |
| 2012-08-29 08:05:00 | AAPL | Stock | 24.0893 | 24.0964 | 24.0893 | 24.0957 | 15428.0 |
| 2012-08-29 08:10:00 | AAPL | Stock | 24.0893 | 24.1068 | 24.0893 | 24.1064 | 50400.0 |
| 2012-08-29 08:15:00 | AAPL | Stock | 24.1007 | 24.1007 | 24.0993 | 24.0993 | 5768.0 |
| 2012-08-29 08:20:00 | AAPL | Stock | 24.0989 | 24.1 | 24.0882 | 24.1 | 65072.0 |
| 2012-08-29 08:25:00 | AAPL | Stock | 24.1046 | 24.1046 | 24.0464 | 24.0929 | 42840.0 |
| 2012-08-29 08:30:00 | AAPL | Stock | 24.0904 | 24.0911 | 24.0643 | 24.0707 | 232064.0 |
| 2012-08-29 08:35:00 | AAPL | Stock | 24.0743 | 24.105 | 24.0743 | 24.0857 | 126980.0 |
| 2012-08-29 08:40:00 | AAPL | Stock | 24.0911 | 24.1214 | 24.0911 | 24.1086 | 208572.0 |
| 2012-08-29 08:45:00 | AAPL | Stock | 24.1121 | 24.125 | 24.1111 | 24.1143 | 127932.0 |
| 2012-08-29 08:50:00 | AAPL | Stock | 24.1179 | 24.1214 | 24.1179 | 24.1214 | 18620.0 |
| 2012-08-29 08:55:00 | AAPL | Stock | 24.1207 | 24.1307 | 24.1207 | 24.1307 | 76748.0 |
| 2012-08-29 09:00:00 | AAPL | Stock | 24.1339 | 24.1339 | 24.12 | 24.12 | 123536.0 |
| 2012-08-29 09:05:00 | AAPL | Stock | 24.1179 | 24.1268 | 24.1179 | 24.1268 | 61040.0 |
| 2012-08-29 09:10:00 | AAPL | Stock | 24.1189 | 24.125 | 24.1146 | 24.1246 | 48860.0 |
| 2012-08-29 09:15:00 | AAPL | Stock | 24.1239 | 24.1286 | 24.1161 | 24.1196 | 71568.0 |
| 2012-08-29 09:20:00 | AAPL | Stock | 24.1214 | 24.1257 | 24.1161 | 24.1182 | 67032.0 |
| 2012-08-29 09:25:00 | AAPL | Stock | 24.1182 | 24.1261 | 24.1143 | 24.1193 | 172480.0 |
| 2012-08-29 09:30:00 | AAPL | Stock | 24.1161 | 24.1868 | 24.0832 | 24.1693 | 14603260.0 |
| 2012-08-29 09:35:00 | AAPL | Stock | 24.1687 | 24.1786 | 24.1471 | 24.1539 | 6045956.0 |
| 2012-08-29 09:40:00 | AAPL | Stock | 24.1504 | 24.1839 | 24.1475 | 24.1818 | 7106540.0 |
| 2012-08-29 09:45:00 | AAPL | Stock | 24.1789 | 24.2025 | 24.1518 | 24.1632 | 7253736.0 |
| 2012-08-29 09:50:00 | AAPL | Stock | 24.1629 | 24.1857 | 24.155 | 24.1554 | 3806208.0 |
| 2012-08-29 09:55:00 | AAPL | Stock | 24.1554 | 24.1679 | 24.1357 | 24.1436 | 5060776.0 |
| 2012-08-29 10:00:00 | AAPL | Stock | 24.1446 | 24.1689 | 24.135 | 24.1657 | 3401608.0 |
| 2012-08-29 10:05:00 | AAPL | Stock | 24.1657 | 24.1693 | 24.1439 | 24.1618 | 2654400.0 |
| 2012-08-29 10:10:00 | AAPL | Stock | 24.1611 | 24.1729 | 24.1546 | 24.1679 | 3492328.0 |
| 2012-08-29 10:15:00 | AAPL | Stock | 24.1721 | 24.1782 | 24.1439 | 24.1468 | 4444468.0 |
| 2012-08-29 10:20:00 | AAPL | Stock | 24.145 | 24.1511 | 24.1125 | 24.1136 | 4451384.0 |
| 2012-08-29 10:25:00 | AAPL | Stock | 24.1168 | 24.1314 | 24.1129 | 24.1236 | 2542764.0 |
| 2012-08-29 10:30:00 | AAPL | Stock | 24.1218 | 24.1304 | 24.1025 | 24.1207 | 3028648.0 |
| 2012-08-29 10:35:00 | AAPL | Stock | 24.1241 | 24.1304 | 24.1021 | 24.1071 | 2611392.0 |
| 2012-08-29 10:40:00 | AAPL | Stock | 24.1057 | 24.1179 | 24.0957 | 24.1056 | 2512972.0 |
| 2012-08-29 10:45:00 | AAPL | Stock | 24.1054 | 24.1071 | 24.0843 | 24.0872 | 2477440.0 |
> showing 50 of 307,375 rows — these rows as CSV