PREVIEW / stock_5min / 2012-10-25
file: by_date/stock_5min/2012/2012-10-25.parquet size: 4.6 MB rows: 308,877 symbols: 3,485
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-10-25 04:00:00 | AAPL | Stock | 22.0271 | 22.1071 | 22.0271 | 22.0929 | 53200.0 |
| 2012-10-25 04:05:00 | AAPL | Stock | 22.125 | 22.125 | 22.1214 | 22.1214 | 24920.0 |
| 2012-10-25 04:10:00 | AAPL | Stock | 22.1214 | 22.1214 | 22.1214 | 22.1214 | 13776.0 |
| 2012-10-25 04:15:00 | AAPL | Stock | 22.0982 | 22.1143 | 22.0982 | 22.1143 | 11200.0 |
| 2012-10-25 04:20:00 | AAPL | Stock | 22.125 | 22.125 | 22.125 | 22.125 | 2800.0 |
| 2012-10-25 04:30:00 | AAPL | Stock | 22.1246 | 22.1246 | 22.1 | 22.1 | 16800.0 |
| 2012-10-25 04:45:00 | AAPL | Stock | 22.0929 | 22.0929 | 22.0929 | 22.0929 | 3416.0 |
| 2012-10-25 05:35:00 | AAPL | Stock | 22.1032 | 22.1032 | 22.1032 | 22.1032 | 26516.0 |
| 2012-10-25 05:40:00 | AAPL | Stock | 22.1071 | 22.1071 | 22.1071 | 22.1071 | 14000.0 |
| 2012-10-25 05:45:00 | AAPL | Stock | 22.1161 | 22.1161 | 22.1161 | 22.1161 | 2800.0 |
| 2012-10-25 05:50:00 | AAPL | Stock | 22.1068 | 22.1068 | 22.0964 | 22.0964 | 65800.0 |
| 2012-10-25 06:35:00 | AAPL | Stock | 22.0929 | 22.1061 | 22.0929 | 22.1061 | 5768.0 |
| 2012-10-25 07:00:00 | AAPL | Stock | 22.0932 | 22.105 | 22.09 | 22.0918 | 115360.0 |
| 2012-10-25 07:05:00 | AAPL | Stock | 22.0918 | 22.1 | 22.09 | 22.0929 | 94724.0 |
| 2012-10-25 07:10:00 | AAPL | Stock | 22.0957 | 22.1043 | 22.0929 | 22.0929 | 38640.0 |
| 2012-10-25 07:15:00 | AAPL | Stock | 22.0964 | 22.0982 | 22.09 | 22.09 | 64400.0 |
| 2012-10-25 07:20:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.09 | 22.09 | 16800.0 |
| 2012-10-25 07:25:00 | AAPL | Stock | 22.09 | 22.1161 | 22.0893 | 22.1161 | 28700.0 |
| 2012-10-25 07:30:00 | AAPL | Stock | 22.1329 | 22.1604 | 22.1329 | 22.1518 | 48020.0 |
| 2012-10-25 07:35:00 | AAPL | Stock | 22.1564 | 22.1607 | 22.1564 | 22.1607 | 20160.0 |
| 2012-10-25 07:40:00 | AAPL | Stock | 22.1607 | 22.1607 | 22.1607 | 22.1607 | 2800.0 |
| 2012-10-25 07:45:00 | AAPL | Stock | 22.1643 | 22.175 | 22.1643 | 22.17 | 70112.0 |
| 2012-10-25 07:50:00 | AAPL | Stock | 22.1714 | 22.1714 | 22.1536 | 22.1554 | 71988.0 |
| 2012-10-25 07:55:00 | AAPL | Stock | 22.1579 | 22.1604 | 22.1429 | 22.1546 | 191380.0 |
| 2012-10-25 08:00:00 | AAPL | Stock | 22.1429 | 22.1604 | 22.0929 | 22.1411 | 375032.0 |
| 2012-10-25 08:05:00 | AAPL | Stock | 22.1414 | 22.1414 | 22.1161 | 22.1232 | 279608.0 |
| 2012-10-25 08:10:00 | AAPL | Stock | 22.1246 | 22.1529 | 22.1246 | 22.1493 | 217000.0 |
| 2012-10-25 08:15:00 | AAPL | Stock | 22.1486 | 22.1536 | 22.1214 | 22.1232 | 135856.0 |
| 2012-10-25 08:20:00 | AAPL | Stock | 22.1332 | 22.1336 | 22.1243 | 22.1286 | 36960.0 |
| 2012-10-25 08:25:00 | AAPL | Stock | 22.1218 | 22.1286 | 22.1143 | 22.1143 | 71484.0 |
| 2012-10-25 08:30:00 | AAPL | Stock | 22.1179 | 22.1207 | 22.0918 | 22.0918 | 151200.0 |
| 2012-10-25 08:35:00 | AAPL | Stock | 22.0936 | 22.1046 | 22.0882 | 22.0982 | 86800.0 |
| 2012-10-25 08:40:00 | AAPL | Stock | 22.0864 | 22.0911 | 22.0764 | 22.0911 | 191548.0 |
| 2012-10-25 08:45:00 | AAPL | Stock | 22.1 | 22.1057 | 22.0964 | 22.1057 | 19600.0 |
| 2012-10-25 08:50:00 | AAPL | Stock | 22.0964 | 22.1071 | 22.0964 | 22.1071 | 167356.0 |
| 2012-10-25 08:55:00 | AAPL | Stock | 22.1068 | 22.1193 | 22.1068 | 22.1193 | 53200.0 |
| 2012-10-25 09:00:00 | AAPL | Stock | 22.1196 | 22.1214 | 22.1143 | 22.1179 | 168672.0 |
| 2012-10-25 09:05:00 | AAPL | Stock | 22.1118 | 22.1179 | 22.1071 | 22.1125 | 137004.0 |
| 2012-10-25 09:10:00 | AAPL | Stock | 22.1154 | 22.1307 | 22.1129 | 22.1296 | 78624.0 |
| 2012-10-25 09:15:00 | AAPL | Stock | 22.1339 | 22.1604 | 22.1257 | 22.1564 | 282912.0 |
| 2012-10-25 09:20:00 | AAPL | Stock | 22.1604 | 22.1607 | 22.1429 | 22.1432 | 285432.0 |
| 2012-10-25 09:25:00 | AAPL | Stock | 22.1443 | 22.1514 | 22.1261 | 22.1396 | 259980.0 |
| 2012-10-25 09:30:00 | AAPL | Stock | 22.1429 | 22.2143 | 22.0718 | 22.0786 | 16925972.0 |
| 2012-10-25 09:35:00 | AAPL | Stock | 22.0786 | 22.0834 | 21.9364 | 21.9568 | 15631476.0 |
| 2012-10-25 09:40:00 | AAPL | Stock | 21.9575 | 22.0536 | 21.9386 | 22.0114 | 12427632.0 |
| 2012-10-25 09:45:00 | AAPL | Stock | 22.0146 | 22.0589 | 21.9821 | 22.0061 | 7652596.0 |
| 2012-10-25 09:50:00 | AAPL | Stock | 21.9993 | 22.0268 | 21.9293 | 21.9432 | 8079260.0 |
| 2012-10-25 09:55:00 | AAPL | Stock | 21.9525 | 21.9882 | 21.9139 | 21.9382 | 7342188.0 |
| 2012-10-25 10:00:00 | AAPL | Stock | 21.9382 | 21.9443 | 21.8986 | 21.9143 | 6084400.0 |
| 2012-10-25 10:05:00 | AAPL | Stock | 21.9161 | 22.0195 | 21.9146 | 21.995 | 8499652.0 |
> showing 50 of 308,877 rows — these rows as CSV