PREVIEW / stock_5min / 2008-04-25
file: by_date/stock_5min/2008/2008-04-25.parquet size: 4.3 MB rows: 307,186 symbols: 3,271
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-25 07:00:00 | AAPL | Stock | 6.0018 | 6.0018 | 5.9875 | 5.9875 | 25200.0 |
| 2008-04-25 07:05:00 | AAPL | Stock | 6.0004 | 6.0261 | 6.0004 | 6.0261 | 30800.0 |
| 2008-04-25 07:10:00 | AAPL | Stock | 6.0257 | 6.0332 | 6.025 | 6.0286 | 88004.0 |
| 2008-04-25 07:15:00 | AAPL | Stock | 6.0261 | 6.0357 | 6.0261 | 6.0286 | 85820.0 |
| 2008-04-25 07:25:00 | AAPL | Stock | 6.0321 | 6.0486 | 6.0321 | 6.0486 | 50400.0 |
| 2008-04-25 07:30:00 | AAPL | Stock | 6.0486 | 6.0536 | 6.0475 | 6.0486 | 39144.0 |
| 2008-04-25 07:35:00 | AAPL | Stock | 6.0532 | 6.0536 | 6.05 | 6.0536 | 43400.0 |
| 2008-04-25 07:40:00 | AAPL | Stock | 6.0589 | 6.1607 | 6.0589 | 6.1071 | 544600.0 |
| 2008-04-25 07:45:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.0714 | 6.1 | 326620.0 |
| 2008-04-25 07:50:00 | AAPL | Stock | 6.0875 | 6.0982 | 6.0875 | 6.0982 | 25200.0 |
| 2008-04-25 07:55:00 | AAPL | Stock | 6.0929 | 6.0979 | 6.0871 | 6.0979 | 30800.0 |
| 2008-04-25 08:00:00 | AAPL | Stock | 6.0964 | 6.0982 | 6.0421 | 6.0836 | 1031940.0 |
| 2008-04-25 08:05:00 | AAPL | Stock | 6.0836 | 6.1071 | 6.0836 | 6.1071 | 583128.0 |
| 2008-04-25 08:10:00 | AAPL | Stock | 6.1071 | 6.1296 | 6.1071 | 6.1225 | 1481424.0 |
| 2008-04-25 08:15:00 | AAPL | Stock | 6.1221 | 6.1318 | 6.1186 | 6.1243 | 872844.0 |
| 2008-04-25 08:20:00 | AAPL | Stock | 6.1246 | 6.1246 | 6.1146 | 6.1146 | 371868.0 |
| 2008-04-25 08:25:00 | AAPL | Stock | 6.1164 | 6.1211 | 6.1021 | 6.105 | 722624.0 |
| 2008-04-25 08:30:00 | AAPL | Stock | 6.1032 | 6.1071 | 6.0993 | 6.1039 | 581532.0 |
| 2008-04-25 08:35:00 | AAPL | Stock | 6.1061 | 6.1143 | 6.1014 | 6.1129 | 758436.0 |
| 2008-04-25 08:40:00 | AAPL | Stock | 6.1139 | 6.125 | 6.1089 | 6.1214 | 1241352.0 |
| 2008-04-25 08:45:00 | AAPL | Stock | 6.1214 | 6.1218 | 6.1089 | 6.1111 | 267064.0 |
| 2008-04-25 08:50:00 | AAPL | Stock | 6.1107 | 6.1111 | 6.1 | 6.1021 | 636188.0 |
| 2008-04-25 08:55:00 | AAPL | Stock | 6.105 | 6.1179 | 6.0982 | 6.1168 | 815948.0 |
| 2008-04-25 09:00:00 | AAPL | Stock | 6.1168 | 6.1182 | 6.0993 | 6.0993 | 431564.0 |
| 2008-04-25 09:05:00 | AAPL | Stock | 6.1014 | 6.1046 | 6.0982 | 6.1 | 360808.0 |
| 2008-04-25 09:10:00 | AAPL | Stock | 6.0993 | 6.1086 | 6.0993 | 6.1039 | 218904.0 |
| 2008-04-25 09:15:00 | AAPL | Stock | 6.1018 | 6.1143 | 6.1 | 6.1071 | 532952.0 |
| 2008-04-25 09:20:00 | AAPL | Stock | 6.1054 | 6.1111 | 6.1043 | 6.1068 | 390824.0 |
| 2008-04-25 09:25:00 | AAPL | Stock | 6.1039 | 6.1121 | 6.0896 | 6.0954 | 2601844.0 |
| 2008-04-25 09:30:00 | AAPL | Stock | 6.0954 | 6.1068 | 6.0714 | 6.1004 | 32143300.0 |
| 2008-04-25 09:35:00 | AAPL | Stock | 6.1004 | 6.1107 | 6.0643 | 6.0704 | 37114308.0 |
| 2008-04-25 09:40:00 | AAPL | Stock | 6.0704 | 6.0929 | 6.0679 | 6.0719 | 22831144.0 |
| 2008-04-25 09:45:00 | AAPL | Stock | 6.0729 | 6.0754 | 6.0193 | 6.0229 | 35460404.0 |
| 2008-04-25 09:50:00 | AAPL | Stock | 6.0243 | 6.0264 | 5.9946 | 5.9957 | 29461236.0 |
| 2008-04-25 09:55:00 | AAPL | Stock | 5.9954 | 5.9954 | 5.9436 | 5.9664 | 30970660.0 |
| 2008-04-25 10:00:00 | AAPL | Stock | 5.9661 | 5.9729 | 5.9457 | 5.9522 | 24675840.0 |
| 2008-04-25 10:05:00 | AAPL | Stock | 5.9525 | 5.9904 | 5.9525 | 5.9868 | 20081152.0 |
| 2008-04-25 10:10:00 | AAPL | Stock | 5.9864 | 6.0093 | 5.9836 | 6.0093 | 18199300.0 |
| 2008-04-25 10:15:00 | AAPL | Stock | 6.0082 | 6.0218 | 5.9918 | 6.0211 | 17780644.0 |
| 2008-04-25 10:20:00 | AAPL | Stock | 6.0214 | 6.0536 | 6.0179 | 6.0518 | 24043488.0 |
| 2008-04-25 10:25:00 | AAPL | Stock | 6.0511 | 6.0671 | 6.0461 | 6.0536 | 23668400.0 |
| 2008-04-25 10:30:00 | AAPL | Stock | 6.0536 | 6.0725 | 6.0479 | 6.0679 | 18557308.0 |
| 2008-04-25 10:35:00 | AAPL | Stock | 6.0671 | 6.0732 | 6.0389 | 6.0404 | 18579260.0 |
| 2008-04-25 10:40:00 | AAPL | Stock | 6.0404 | 6.0489 | 6.0329 | 6.0396 | 14244328.0 |
| 2008-04-25 10:45:00 | AAPL | Stock | 6.0396 | 6.0475 | 6.025 | 6.0382 | 14727916.0 |
| 2008-04-25 10:50:00 | AAPL | Stock | 6.0382 | 6.0529 | 6.0336 | 6.0511 | 11989712.0 |
| 2008-04-25 10:55:00 | AAPL | Stock | 6.05 | 6.0625 | 6.0429 | 6.0625 | 8458660.0 |
| 2008-04-25 11:00:00 | AAPL | Stock | 6.0625 | 6.0661 | 6.0511 | 6.0514 | 9701636.0 |
| 2008-04-25 11:05:00 | AAPL | Stock | 6.0511 | 6.0607 | 6.0482 | 6.0546 | 10126900.0 |
| 2008-04-25 11:10:00 | AAPL | Stock | 6.055 | 6.0586 | 6.0179 | 6.0393 | 18900980.0 |
> showing 50 of 307,186 rows — these rows as CSV