PREVIEW / stock_5min / 2009-01-02
file: by_date/stock_5min/2009/2009-01-02.parquet size: 4.4 MB rows: 307,883 symbols: 3,320
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-01-02 07:35:00 | AAPL | Stock | 3.0696 | 3.0696 | 3.0696 | 3.0696 | 18060.0 |
| 2009-01-02 07:45:00 | AAPL | Stock | 3.0714 | 3.0786 | 3.0714 | 3.0786 | 8400.0 |
| 2009-01-02 07:50:00 | AAPL | Stock | 3.0796 | 3.0796 | 3.0796 | 3.0796 | 2800.0 |
| 2009-01-02 07:55:00 | AAPL | Stock | 3.0768 | 3.0768 | 3.0768 | 3.0768 | 5600.0 |
| 2009-01-02 08:00:00 | AAPL | Stock | 3.0768 | 3.0768 | 3.0714 | 3.0714 | 108052.0 |
| 2009-01-02 08:05:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0661 | 3.0661 | 80108.0 |
| 2009-01-02 08:10:00 | AAPL | Stock | 3.0664 | 3.0664 | 3.0482 | 3.0661 | 596568.0 |
| 2009-01-02 08:15:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0571 | 3.0571 | 182000.0 |
| 2009-01-02 08:20:00 | AAPL | Stock | 3.0625 | 3.0654 | 3.0561 | 3.0561 | 36400.0 |
| 2009-01-02 08:25:00 | AAPL | Stock | 3.0575 | 3.0614 | 3.0575 | 3.0614 | 31360.0 |
| 2009-01-02 08:30:00 | AAPL | Stock | 3.0482 | 3.0593 | 3.0482 | 3.0482 | 1225028.0 |
| 2009-01-02 08:35:00 | AAPL | Stock | 3.0636 | 3.0646 | 3.0593 | 3.0607 | 130480.0 |
| 2009-01-02 08:40:00 | AAPL | Stock | 3.0589 | 3.0618 | 3.0482 | 3.0618 | 570612.0 |
| 2009-01-02 08:45:00 | AAPL | Stock | 3.0482 | 3.0643 | 3.0482 | 3.0643 | 45360.0 |
| 2009-01-02 08:50:00 | AAPL | Stock | 3.0625 | 3.0643 | 3.0625 | 3.0643 | 29960.0 |
| 2009-01-02 08:55:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0643 | 3.0661 | 81704.0 |
| 2009-01-02 09:00:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0571 | 3.0571 | 180740.0 |
| 2009-01-02 09:05:00 | AAPL | Stock | 3.0643 | 3.0654 | 3.0575 | 3.0654 | 30800.0 |
| 2009-01-02 09:10:00 | AAPL | Stock | 3.0661 | 3.07 | 3.0482 | 3.07 | 877744.0 |
| 2009-01-02 09:15:00 | AAPL | Stock | 3.0693 | 3.0693 | 3.0629 | 3.0664 | 47600.0 |
| 2009-01-02 09:20:00 | AAPL | Stock | 3.0664 | 3.0664 | 3.0661 | 3.0661 | 49056.0 |
| 2009-01-02 09:25:00 | AAPL | Stock | 3.0661 | 3.0682 | 3.0571 | 3.0579 | 73640.0 |
| 2009-01-02 09:30:00 | AAPL | Stock | 3.0579 | 3.0939 | 3.0414 | 3.0907 | 15552852.0 |
| 2009-01-02 09:35:00 | AAPL | Stock | 3.0907 | 3.1014 | 3.0829 | 3.0929 | 12614364.0 |
| 2009-01-02 09:40:00 | AAPL | Stock | 3.0925 | 3.1046 | 3.0875 | 3.0975 | 13390188.0 |
| 2009-01-02 09:45:00 | AAPL | Stock | 3.0979 | 3.1171 | 3.0946 | 3.1161 | 13559756.0 |
| 2009-01-02 09:50:00 | AAPL | Stock | 3.1161 | 3.1179 | 3.1025 | 3.1032 | 17123456.0 |
| 2009-01-02 09:55:00 | AAPL | Stock | 3.1032 | 3.1153 | 3.1025 | 3.1064 | 10306632.0 |
| 2009-01-02 10:00:00 | AAPL | Stock | 3.1054 | 3.1104 | 3.1004 | 3.1071 | 13110384.0 |
| 2009-01-02 10:05:00 | AAPL | Stock | 3.1082 | 3.1125 | 3.105 | 3.1121 | 6042260.0 |
| 2009-01-02 10:10:00 | AAPL | Stock | 3.1123 | 3.1154 | 3.1071 | 3.1129 | 7752360.0 |
| 2009-01-02 10:15:00 | AAPL | Stock | 3.1125 | 3.1136 | 3.1082 | 3.1125 | 5934124.0 |
| 2009-01-02 10:20:00 | AAPL | Stock | 3.1129 | 3.1157 | 3.0964 | 3.0975 | 9377200.0 |
| 2009-01-02 10:25:00 | AAPL | Stock | 3.0975 | 3.1129 | 3.0954 | 3.1079 | 10529792.0 |
| 2009-01-02 10:30:00 | AAPL | Stock | 3.1079 | 3.1104 | 3.1025 | 3.1082 | 5473020.0 |
| 2009-01-02 10:35:00 | AAPL | Stock | 3.1082 | 3.125 | 3.1064 | 3.125 | 13032796.0 |
| 2009-01-02 10:40:00 | AAPL | Stock | 3.1243 | 3.13 | 3.1232 | 3.1261 | 10273900.0 |
| 2009-01-02 10:45:00 | AAPL | Stock | 3.1254 | 3.1357 | 3.1254 | 3.1348 | 10111136.0 |
| 2009-01-02 10:50:00 | AAPL | Stock | 3.1346 | 3.1379 | 3.1304 | 3.1364 | 8403948.0 |
| 2009-01-02 10:55:00 | AAPL | Stock | 3.1364 | 3.1375 | 3.1271 | 3.1271 | 6819568.0 |
| 2009-01-02 11:00:00 | AAPL | Stock | 3.1279 | 3.1361 | 3.1275 | 3.1289 | 6754104.0 |
| 2009-01-02 11:05:00 | AAPL | Stock | 3.1286 | 3.1346 | 3.1268 | 3.1339 | 6975220.0 |
| 2009-01-02 11:10:00 | AAPL | Stock | 3.1339 | 3.1343 | 3.1214 | 3.1264 | 6126512.0 |
| 2009-01-02 11:15:00 | AAPL | Stock | 3.1261 | 3.1286 | 3.1182 | 3.1232 | 5640124.0 |
| 2009-01-02 11:20:00 | AAPL | Stock | 3.1236 | 3.1329 | 3.1236 | 3.1327 | 6217904.0 |
| 2009-01-02 11:25:00 | AAPL | Stock | 3.1325 | 3.1389 | 3.1304 | 3.1364 | 7958104.0 |
| 2009-01-02 11:30:00 | AAPL | Stock | 3.1357 | 3.14 | 3.1329 | 3.1386 | 7637812.0 |
| 2009-01-02 11:35:00 | AAPL | Stock | 3.1386 | 3.1464 | 3.1375 | 3.1393 | 10610796.0 |
| 2009-01-02 11:40:00 | AAPL | Stock | 3.1393 | 3.1454 | 3.1357 | 3.1386 | 5250392.0 |
| 2009-01-02 11:45:00 | AAPL | Stock | 3.1386 | 3.14 | 3.135 | 3.1361 | 5221524.0 |
> showing 50 of 307,883 rows — these rows as CSV