PREVIEW / stock_5min / 2005-11-02
file: by_date/stock_5min/2005/2005-11-02.parquet size: 2.9 MB rows: 211,316 symbols: 2,104
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-02 08:00:00 | AAPL | Stock | 2.0614 | 2.0614 | 2.0571 | 2.0582 | 45248.0 |
| 2005-11-02 08:10:00 | AAPL | Stock | 2.0561 | 2.0561 | 2.0561 | 2.0561 | 11200.0 |
| 2005-11-02 08:15:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 8400.0 |
| 2005-11-02 08:20:00 | AAPL | Stock | 2.0575 | 2.0575 | 2.0571 | 2.0571 | 46200.0 |
| 2005-11-02 08:25:00 | AAPL | Stock | 2.0564 | 2.0564 | 2.0564 | 2.0564 | 2800.0 |
| 2005-11-02 08:30:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0554 | 2.0554 | 43400.0 |
| 2005-11-02 08:35:00 | AAPL | Stock | 2.0536 | 2.0546 | 2.0536 | 2.0546 | 13300.0 |
| 2005-11-02 08:40:00 | AAPL | Stock | 2.0536 | 2.0546 | 2.0521 | 2.0546 | 110600.0 |
| 2005-11-02 08:45:00 | AAPL | Stock | 2.0571 | 2.0582 | 2.0539 | 2.0539 | 231868.0 |
| 2005-11-02 08:50:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0554 | 2.0554 | 16800.0 |
| 2005-11-02 08:55:00 | AAPL | Stock | 2.0571 | 2.0586 | 2.0546 | 2.0546 | 93240.0 |
| 2005-11-02 09:00:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0571 | 2.0571 | 8400.0 |
| 2005-11-02 09:05:00 | AAPL | Stock | 2.0571 | 2.0571 | 2.0536 | 2.0536 | 69468.0 |
| 2005-11-02 09:10:00 | AAPL | Stock | 2.0521 | 2.0568 | 2.0521 | 2.0568 | 91000.0 |
| 2005-11-02 09:20:00 | AAPL | Stock | 2.0539 | 2.0554 | 2.0536 | 2.0536 | 86800.0 |
| 2005-11-02 09:25:00 | AAPL | Stock | 2.0536 | 2.0625 | 2.0536 | 2.0618 | 578508.0 |
| 2005-11-02 09:30:00 | AAPL | Stock | 2.0614 | 2.0807 | 2.0571 | 2.0796 | 19744452.0 |
| 2005-11-02 09:35:00 | AAPL | Stock | 2.0796 | 2.0839 | 2.0736 | 2.0818 | 18064452.0 |
| 2005-11-02 09:40:00 | AAPL | Stock | 2.0818 | 2.0914 | 2.0811 | 2.0882 | 21314160.0 |
| 2005-11-02 09:45:00 | AAPL | Stock | 2.0882 | 2.0961 | 2.0868 | 2.0879 | 16715020.0 |
| 2005-11-02 09:50:00 | AAPL | Stock | 2.0879 | 2.0946 | 2.0868 | 2.0929 | 11477760.0 |
| 2005-11-02 09:55:00 | AAPL | Stock | 2.0929 | 2.0982 | 2.0921 | 2.095 | 14684544.0 |
| 2005-11-02 10:00:00 | AAPL | Stock | 2.0949 | 2.0996 | 2.0893 | 2.0904 | 17275328.0 |
| 2005-11-02 10:05:00 | AAPL | Stock | 2.09 | 2.0946 | 2.0893 | 2.0929 | 7163408.0 |
| 2005-11-02 10:10:00 | AAPL | Stock | 2.0925 | 2.0986 | 2.0921 | 2.0971 | 13351548.0 |
| 2005-11-02 10:15:00 | AAPL | Stock | 2.0971 | 2.1029 | 2.0964 | 2.0982 | 16058952.0 |
| 2005-11-02 10:20:00 | AAPL | Stock | 2.0982 | 2.1007 | 2.0954 | 2.0975 | 11457964.0 |
| 2005-11-02 10:25:00 | AAPL | Stock | 2.0979 | 2.1018 | 2.0957 | 2.1014 | 10661476.0 |
| 2005-11-02 10:30:00 | AAPL | Stock | 2.1014 | 2.1139 | 2.1007 | 2.1093 | 29148532.0 |
| 2005-11-02 10:35:00 | AAPL | Stock | 2.1089 | 2.1136 | 2.1046 | 2.1057 | 18480364.0 |
| 2005-11-02 10:40:00 | AAPL | Stock | 2.1057 | 2.1189 | 2.105 | 2.1189 | 19724320.0 |
| 2005-11-02 10:45:00 | AAPL | Stock | 2.1189 | 2.1286 | 2.1186 | 2.1254 | 43995364.0 |
| 2005-11-02 10:50:00 | AAPL | Stock | 2.1257 | 2.1289 | 2.1214 | 2.1243 | 22171324.0 |
| 2005-11-02 10:55:00 | AAPL | Stock | 2.1246 | 2.1289 | 2.1225 | 2.1246 | 13140932.0 |
| 2005-11-02 11:00:00 | AAPL | Stock | 2.1243 | 2.1371 | 2.1243 | 2.1368 | 30569924.0 |
| 2005-11-02 11:05:00 | AAPL | Stock | 2.1368 | 2.1393 | 2.1321 | 2.1321 | 22392608.0 |
| 2005-11-02 11:10:00 | AAPL | Stock | 2.1321 | 2.1375 | 2.1304 | 2.1336 | 17923080.0 |
| 2005-11-02 11:15:00 | AAPL | Stock | 2.1336 | 2.1357 | 2.1304 | 2.1354 | 10672788.0 |
| 2005-11-02 11:20:00 | AAPL | Stock | 2.1357 | 2.1361 | 2.1286 | 2.1306 | 10217984.0 |
| 2005-11-02 11:25:00 | AAPL | Stock | 2.1304 | 2.1318 | 2.1243 | 2.1282 | 10217592.0 |
| 2005-11-02 11:30:00 | AAPL | Stock | 2.1286 | 2.1321 | 2.1271 | 2.1289 | 8241632.0 |
| 2005-11-02 11:35:00 | AAPL | Stock | 2.1296 | 2.1357 | 2.1293 | 2.1296 | 9147908.0 |
| 2005-11-02 11:40:00 | AAPL | Stock | 2.1304 | 2.1329 | 2.1296 | 2.1311 | 4296964.0 |
| 2005-11-02 11:45:00 | AAPL | Stock | 2.1311 | 2.1311 | 2.1211 | 2.1242 | 10591000.0 |
| 2005-11-02 11:50:00 | AAPL | Stock | 2.1243 | 2.1246 | 2.1186 | 2.1229 | 6437872.0 |
| 2005-11-02 11:55:00 | AAPL | Stock | 2.1225 | 2.1293 | 2.1218 | 2.1279 | 6708296.0 |
| 2005-11-02 12:00:00 | AAPL | Stock | 2.1271 | 2.1307 | 2.1268 | 2.13 | 5904584.0 |
| 2005-11-02 12:05:00 | AAPL | Stock | 2.1296 | 2.1307 | 2.1268 | 2.1271 | 5778248.0 |
| 2005-11-02 12:10:00 | AAPL | Stock | 2.1271 | 2.1286 | 2.1254 | 2.1286 | 3459428.0 |
| 2005-11-02 12:15:00 | AAPL | Stock | 2.1286 | 2.1304 | 2.1239 | 2.125 | 3776136.0 |
> showing 50 of 211,316 rows — these rows as CSV