PREVIEW / stock_5min / 2012-06-05
file: by_date/stock_5min/2012/2012-06-05.parquet size: 4.8 MB rows: 327,289 symbols: 3,513
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-06-05 05:10:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 3080.0 |
| 2012-06-05 05:20:00 | AAPL | Stock | 20.0536 | 20.0536 | 20.0536 | 20.0536 | 11200.0 |
| 2012-06-05 05:40:00 | AAPL | Stock | 20.0432 | 20.0432 | 20.0432 | 20.0432 | 28000.0 |
| 2012-06-05 05:50:00 | AAPL | Stock | 20.0286 | 20.0286 | 20.0286 | 20.0286 | 2800.0 |
| 2012-06-05 06:15:00 | AAPL | Stock | 20.07 | 20.07 | 20.07 | 20.07 | 2800.0 |
| 2012-06-05 06:50:00 | AAPL | Stock | 20.0632 | 20.0632 | 20.0632 | 20.0632 | 2800.0 |
| 2012-06-05 07:05:00 | AAPL | Stock | 20.0475 | 20.0643 | 20.0411 | 20.0643 | 33600.0 |
| 2012-06-05 07:10:00 | AAPL | Stock | 20.0393 | 20.0393 | 20.0214 | 20.0357 | 25200.0 |
| 2012-06-05 07:15:00 | AAPL | Stock | 20.0357 | 20.0361 | 20.0357 | 20.0357 | 30800.0 |
| 2012-06-05 07:20:00 | AAPL | Stock | 20.0243 | 20.0268 | 20.02 | 20.0268 | 16100.0 |
| 2012-06-05 07:25:00 | AAPL | Stock | 20.0246 | 20.0357 | 20.0211 | 20.035 | 59080.0 |
| 2012-06-05 07:30:00 | AAPL | Stock | 20.0304 | 20.0361 | 20.0304 | 20.0361 | 8400.0 |
| 2012-06-05 07:35:00 | AAPL | Stock | 20.0482 | 20.0482 | 20.0482 | 20.0482 | 2800.0 |
| 2012-06-05 07:40:00 | AAPL | Stock | 20.0364 | 20.0364 | 20.0268 | 20.0268 | 68040.0 |
| 2012-06-05 07:45:00 | AAPL | Stock | 20.0357 | 20.0368 | 20.0357 | 20.0368 | 18760.0 |
| 2012-06-05 07:50:00 | AAPL | Stock | 20.0357 | 20.0539 | 20.0357 | 20.0539 | 8400.0 |
| 2012-06-05 07:55:00 | AAPL | Stock | 20.0607 | 20.0961 | 20.0571 | 20.0961 | 130480.0 |
| 2012-06-05 08:00:00 | AAPL | Stock | 20.0929 | 20.1 | 20.0629 | 20.0629 | 202888.0 |
| 2012-06-05 08:05:00 | AAPL | Stock | 20.0636 | 20.0804 | 20.0636 | 20.0804 | 27160.0 |
| 2012-06-05 08:10:00 | AAPL | Stock | 20.0889 | 20.1225 | 20.0889 | 20.1164 | 148092.0 |
| 2012-06-05 08:15:00 | AAPL | Stock | 20.1193 | 20.1211 | 20.1007 | 20.1179 | 124740.0 |
| 2012-06-05 08:20:00 | AAPL | Stock | 20.1179 | 20.1179 | 20.0982 | 20.1071 | 56980.0 |
| 2012-06-05 08:25:00 | AAPL | Stock | 20.1004 | 20.1139 | 20.0993 | 20.1054 | 18424.0 |
| 2012-06-05 08:30:00 | AAPL | Stock | 20.0929 | 20.1214 | 20.0929 | 20.1214 | 24080.0 |
| 2012-06-05 08:35:00 | AAPL | Stock | 20.1311 | 20.1536 | 20.1311 | 20.1429 | 204344.0 |
| 2012-06-05 08:40:00 | AAPL | Stock | 20.1446 | 20.15 | 20.125 | 20.1357 | 70000.0 |
| 2012-06-05 08:45:00 | AAPL | Stock | 20.1311 | 20.1311 | 20.09 | 20.0986 | 300188.0 |
| 2012-06-05 08:50:00 | AAPL | Stock | 20.1068 | 20.1368 | 20.1068 | 20.1343 | 63700.0 |
| 2012-06-05 08:55:00 | AAPL | Stock | 20.1346 | 20.1407 | 20.1189 | 20.1407 | 95816.0 |
| 2012-06-05 09:00:00 | AAPL | Stock | 20.135 | 20.1429 | 20.1139 | 20.1218 | 272860.0 |
| 2012-06-05 09:05:00 | AAPL | Stock | 20.1236 | 20.125 | 20.0871 | 20.0964 | 257320.0 |
| 2012-06-05 09:10:00 | AAPL | Stock | 20.0871 | 20.1 | 20.0861 | 20.1 | 145040.0 |
| 2012-06-05 09:15:00 | AAPL | Stock | 20.0921 | 20.0921 | 20.0254 | 20.0346 | 433944.0 |
| 2012-06-05 09:20:00 | AAPL | Stock | 20.025 | 20.0536 | 20.0221 | 20.0411 | 261408.0 |
| 2012-06-05 09:25:00 | AAPL | Stock | 20.0446 | 20.0539 | 20.0196 | 20.0311 | 426216.0 |
| 2012-06-05 09:30:00 | AAPL | Stock | 20.0454 | 20.1321 | 20.0214 | 20.1321 | 14445788.0 |
| 2012-06-05 09:35:00 | AAPL | Stock | 20.1336 | 20.2054 | 20.1264 | 20.1429 | 14182588.0 |
| 2012-06-05 09:40:00 | AAPL | Stock | 20.1368 | 20.1946 | 20.1189 | 20.1429 | 7902468.0 |
| 2012-06-05 09:45:00 | AAPL | Stock | 20.1454 | 20.2232 | 20.1429 | 20.2089 | 11124176.0 |
| 2012-06-05 09:50:00 | AAPL | Stock | 20.2093 | 20.2275 | 20.1429 | 20.1729 | 8516200.0 |
| 2012-06-05 09:55:00 | AAPL | Stock | 20.1729 | 20.1882 | 20.0946 | 20.1148 | 7211680.0 |
| 2012-06-05 10:00:00 | AAPL | Stock | 20.1152 | 20.2311 | 20.1132 | 20.1486 | 13849976.0 |
| 2012-06-05 10:05:00 | AAPL | Stock | 20.1473 | 20.1679 | 20.1161 | 20.1279 | 7802396.0 |
| 2012-06-05 10:10:00 | AAPL | Stock | 20.1178 | 20.1589 | 20.0943 | 20.1414 | 6948032.0 |
| 2012-06-05 10:15:00 | AAPL | Stock | 20.1479 | 20.1911 | 20.1121 | 20.1157 | 7529480.0 |
| 2012-06-05 10:20:00 | AAPL | Stock | 20.1161 | 20.1621 | 20.0875 | 20.1014 | 6334188.0 |
| 2012-06-05 10:25:00 | AAPL | Stock | 20.0946 | 20.1204 | 20.059 | 20.0857 | 8304828.0 |
| 2012-06-05 10:30:00 | AAPL | Stock | 20.0843 | 20.0918 | 20.0311 | 20.0743 | 6223056.0 |
| 2012-06-05 10:35:00 | AAPL | Stock | 20.0743 | 20.0996 | 20.0468 | 20.0911 | 3972948.0 |
| 2012-06-05 10:40:00 | AAPL | Stock | 20.0964 | 20.1025 | 20.0593 | 20.0982 | 4397540.0 |
> showing 50 of 327,289 rows — these rows as CSV