PREVIEW / stock_5min / 2009-06-08
file: by_date/stock_5min/2009/2009-06-08.parquet size: 4.5 MB rows: 314,541 symbols: 3,356
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-08 04:15:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 19600.0 |
| 2009-06-08 05:05:00 | AAPL | Stock | 5.1114 | 5.1114 | 5.1114 | 5.1114 | 28000.0 |
| 2009-06-08 06:50:00 | AAPL | Stock | 5.1368 | 5.1368 | 5.1368 | 5.1368 | 2800.0 |
| 2009-06-08 06:55:00 | AAPL | Stock | 5.1368 | 5.1368 | 5.1368 | 5.1368 | 5600.0 |
| 2009-06-08 07:00:00 | AAPL | Stock | 5.1311 | 5.1311 | 5.1268 | 5.1286 | 44800.0 |
| 2009-06-08 07:05:00 | AAPL | Stock | 5.1286 | 5.1286 | 5.1164 | 5.1164 | 37352.0 |
| 2009-06-08 07:10:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1118 | 5.1121 | 56336.0 |
| 2009-06-08 07:15:00 | AAPL | Stock | 5.1121 | 5.1179 | 5.1121 | 5.1121 | 67200.0 |
| 2009-06-08 07:20:00 | AAPL | Stock | 5.1214 | 5.1214 | 5.1214 | 5.1214 | 28000.0 |
| 2009-06-08 07:25:00 | AAPL | Stock | 5.1186 | 5.1186 | 5.1182 | 5.1182 | 13524.0 |
| 2009-06-08 07:30:00 | AAPL | Stock | 5.1182 | 5.1182 | 5.1139 | 5.1161 | 47600.0 |
| 2009-06-08 07:35:00 | AAPL | Stock | 5.1179 | 5.1279 | 5.1179 | 5.1243 | 31724.0 |
| 2009-06-08 07:55:00 | AAPL | Stock | 5.1268 | 5.1271 | 5.1268 | 5.1271 | 8400.0 |
| 2009-06-08 08:00:00 | AAPL | Stock | 5.125 | 5.1368 | 5.1161 | 5.1232 | 143612.0 |
| 2009-06-08 08:05:00 | AAPL | Stock | 5.1218 | 5.1268 | 5.1179 | 5.1268 | 91700.0 |
| 2009-06-08 08:10:00 | AAPL | Stock | 5.1268 | 5.1268 | 5.12 | 5.125 | 66500.0 |
| 2009-06-08 08:15:00 | AAPL | Stock | 5.1214 | 5.1229 | 5.1071 | 5.1071 | 301700.0 |
| 2009-06-08 08:20:00 | AAPL | Stock | 5.1071 | 5.1075 | 5.1021 | 5.1061 | 292012.0 |
| 2009-06-08 08:25:00 | AAPL | Stock | 5.1061 | 5.1096 | 5.1039 | 5.1057 | 122920.0 |
| 2009-06-08 08:30:00 | AAPL | Stock | 5.1071 | 5.1089 | 5.1039 | 5.1089 | 83356.0 |
| 2009-06-08 08:35:00 | AAPL | Stock | 5.1071 | 5.1118 | 5.1054 | 5.1071 | 159404.0 |
| 2009-06-08 08:40:00 | AAPL | Stock | 5.1064 | 5.1089 | 5.105 | 5.1068 | 239848.0 |
| 2009-06-08 08:45:00 | AAPL | Stock | 5.1071 | 5.1164 | 5.1064 | 5.1071 | 143584.0 |
| 2009-06-08 08:50:00 | AAPL | Stock | 5.1125 | 5.1139 | 5.1075 | 5.1104 | 82600.0 |
| 2009-06-08 08:55:00 | AAPL | Stock | 5.1104 | 5.1164 | 5.1104 | 5.1136 | 40096.0 |
| 2009-06-08 09:00:00 | AAPL | Stock | 5.1125 | 5.1143 | 5.1107 | 5.1132 | 73556.0 |
| 2009-06-08 09:05:00 | AAPL | Stock | 5.1136 | 5.1164 | 5.1125 | 5.1164 | 159992.0 |
| 2009-06-08 09:10:00 | AAPL | Stock | 5.1164 | 5.1336 | 5.1161 | 5.1336 | 275632.0 |
| 2009-06-08 09:15:00 | AAPL | Stock | 5.1329 | 5.1382 | 5.13 | 5.1364 | 382340.0 |
| 2009-06-08 09:20:00 | AAPL | Stock | 5.1382 | 5.1407 | 5.1371 | 5.14 | 133560.0 |
| 2009-06-08 09:25:00 | AAPL | Stock | 5.1393 | 5.1407 | 5.135 | 5.1389 | 329840.0 |
| 2009-06-08 09:30:00 | AAPL | Stock | 5.1364 | 5.1507 | 5.0868 | 5.0954 | 26096028.0 |
| 2009-06-08 09:35:00 | AAPL | Stock | 5.0954 | 5.0996 | 5.0739 | 5.0746 | 17664836.0 |
| 2009-06-08 09:40:00 | AAPL | Stock | 5.0742 | 5.0796 | 5.0579 | 5.075 | 21397488.0 |
| 2009-06-08 09:45:00 | AAPL | Stock | 5.0757 | 5.0768 | 5.0654 | 5.0693 | 7898464.0 |
| 2009-06-08 09:50:00 | AAPL | Stock | 5.0686 | 5.0761 | 5.0479 | 5.0604 | 14382536.0 |
| 2009-06-08 09:55:00 | AAPL | Stock | 5.0591 | 5.0625 | 5.0407 | 5.0507 | 11422040.0 |
| 2009-06-08 10:00:00 | AAPL | Stock | 5.0507 | 5.0568 | 5.0429 | 5.0504 | 9900884.0 |
| 2009-06-08 10:05:00 | AAPL | Stock | 5.0514 | 5.0564 | 5.0382 | 5.0529 | 10318196.0 |
| 2009-06-08 10:10:00 | AAPL | Stock | 5.0529 | 5.0643 | 5.0482 | 5.0489 | 11197368.0 |
| 2009-06-08 10:15:00 | AAPL | Stock | 5.0496 | 5.0586 | 5.045 | 5.0579 | 6407212.0 |
| 2009-06-08 10:20:00 | AAPL | Stock | 5.0571 | 5.0582 | 5.0479 | 5.0521 | 3700172.0 |
| 2009-06-08 10:25:00 | AAPL | Stock | 5.0518 | 5.06 | 5.0486 | 5.0543 | 4397540.0 |
| 2009-06-08 10:30:00 | AAPL | Stock | 5.0546 | 5.0671 | 5.0536 | 5.0539 | 7551964.0 |
| 2009-06-08 10:35:00 | AAPL | Stock | 5.0539 | 5.0571 | 5.045 | 5.0548 | 4894484.0 |
| 2009-06-08 10:40:00 | AAPL | Stock | 5.055 | 5.0568 | 5.0414 | 5.0536 | 8016120.0 |
| 2009-06-08 10:45:00 | AAPL | Stock | 5.0529 | 5.0543 | 5.0436 | 5.0486 | 4922736.0 |
| 2009-06-08 10:50:00 | AAPL | Stock | 5.0482 | 5.0546 | 5.0461 | 5.0529 | 3890068.0 |
| 2009-06-08 10:55:00 | AAPL | Stock | 5.0529 | 5.0614 | 5.0471 | 5.0557 | 3953376.0 |
| 2009-06-08 11:00:00 | AAPL | Stock | 5.0546 | 5.0668 | 5.0511 | 5.0593 | 4266304.0 |
> showing 50 of 314,541 rows — these rows as CSV