PREVIEW / stock_5min / 2008-07-03
file: by_date/stock_5min/2008/2008-07-03.parquet size: 2.8 MB rows: 182,871 symbols: 3,245
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-07-03 07:05:00 | AAPL | Stock | 5.975 | 5.975 | 5.975 | 5.975 | 11200.0 |
| 2008-07-03 07:20:00 | AAPL | Stock | 5.975 | 5.975 | 5.975 | 5.975 | 9520.0 |
| 2008-07-03 07:35:00 | AAPL | Stock | 5.975 | 5.975 | 5.9679 | 5.9679 | 57680.0 |
| 2008-07-03 07:40:00 | AAPL | Stock | 5.9714 | 5.9714 | 5.9714 | 5.9714 | 28000.0 |
| 2008-07-03 07:45:00 | AAPL | Stock | 5.9696 | 5.9696 | 5.9682 | 5.9682 | 16800.0 |
| 2008-07-03 07:50:00 | AAPL | Stock | 5.9768 | 5.9768 | 5.9768 | 5.9768 | 5600.0 |
| 2008-07-03 08:00:00 | AAPL | Stock | 5.975 | 5.9821 | 5.9643 | 5.9814 | 183148.0 |
| 2008-07-03 08:05:00 | AAPL | Stock | 5.9818 | 5.9836 | 5.9732 | 5.9786 | 112084.0 |
| 2008-07-03 08:10:00 | AAPL | Stock | 5.9786 | 5.9786 | 5.9732 | 5.9736 | 62888.0 |
| 2008-07-03 08:15:00 | AAPL | Stock | 5.975 | 5.9754 | 5.9718 | 5.975 | 130956.0 |
| 2008-07-03 08:20:00 | AAPL | Stock | 5.9718 | 5.9768 | 5.9643 | 5.9768 | 74284.0 |
| 2008-07-03 08:25:00 | AAPL | Stock | 5.9686 | 5.9821 | 5.9679 | 5.9821 | 71932.0 |
| 2008-07-03 08:30:00 | AAPL | Stock | 5.9736 | 6.01 | 5.9475 | 6.0036 | 680148.0 |
| 2008-07-03 08:35:00 | AAPL | Stock | 6.0054 | 6.0604 | 6.0007 | 6.0464 | 1437660.0 |
| 2008-07-03 08:40:00 | AAPL | Stock | 6.0446 | 6.0479 | 6.0064 | 6.0314 | 783300.0 |
| 2008-07-03 08:45:00 | AAPL | Stock | 6.0289 | 6.0289 | 6.0064 | 6.0104 | 615804.0 |
| 2008-07-03 08:50:00 | AAPL | Stock | 6.0107 | 6.0518 | 6.0107 | 6.0496 | 1772876.0 |
| 2008-07-03 08:55:00 | AAPL | Stock | 6.0496 | 6.0625 | 6.0464 | 6.0536 | 295820.0 |
| 2008-07-03 09:00:00 | AAPL | Stock | 6.0536 | 6.0786 | 6.0536 | 6.0786 | 645652.0 |
| 2008-07-03 09:05:00 | AAPL | Stock | 6.0789 | 6.0821 | 6.0707 | 6.0714 | 566020.0 |
| 2008-07-03 09:10:00 | AAPL | Stock | 6.0714 | 6.0907 | 6.0714 | 6.0825 | 585536.0 |
| 2008-07-03 09:15:00 | AAPL | Stock | 6.0804 | 6.0857 | 6.0707 | 6.0714 | 431368.0 |
| 2008-07-03 09:20:00 | AAPL | Stock | 6.0718 | 6.0775 | 6.0675 | 6.0675 | 114660.0 |
| 2008-07-03 09:25:00 | AAPL | Stock | 6.0671 | 6.0714 | 6.0482 | 6.0604 | 309932.0 |
| 2008-07-03 09:30:00 | AAPL | Stock | 6.0589 | 6.0964 | 6.0536 | 6.0611 | 23808876.0 |
| 2008-07-03 09:35:00 | AAPL | Stock | 6.0618 | 6.0696 | 6.0064 | 6.0082 | 19829740.0 |
| 2008-07-03 09:40:00 | AAPL | Stock | 6.0082 | 6.0182 | 5.9832 | 5.9961 | 19184256.0 |
| 2008-07-03 09:45:00 | AAPL | Stock | 5.9964 | 6.0111 | 5.9534 | 5.9693 | 20535256.0 |
| 2008-07-03 09:50:00 | AAPL | Stock | 5.9675 | 5.975 | 5.9329 | 5.9461 | 18788504.0 |
| 2008-07-03 09:55:00 | AAPL | Stock | 5.9445 | 6.0104 | 5.9389 | 6.0104 | 19663700.0 |
| 2008-07-03 10:00:00 | AAPL | Stock | 6.0104 | 6.0104 | 5.9196 | 5.9329 | 20156892.0 |
| 2008-07-03 10:05:00 | AAPL | Stock | 5.9329 | 5.9725 | 5.9314 | 5.9568 | 15342292.0 |
| 2008-07-03 10:10:00 | AAPL | Stock | 5.9561 | 5.9818 | 5.9514 | 5.9711 | 14423696.0 |
| 2008-07-03 10:15:00 | AAPL | Stock | 5.9706 | 6.0757 | 5.9686 | 6.0729 | 20962816.0 |
| 2008-07-03 10:20:00 | AAPL | Stock | 6.07 | 6.0911 | 6.0518 | 6.0632 | 18046224.0 |
| 2008-07-03 10:25:00 | AAPL | Stock | 6.0646 | 6.0911 | 6.055 | 6.0891 | 14122052.0 |
| 2008-07-03 10:30:00 | AAPL | Stock | 6.0893 | 6.1354 | 6.0882 | 6.1164 | 22209908.0 |
| 2008-07-03 10:35:00 | AAPL | Stock | 6.1164 | 6.1379 | 6.1075 | 6.1357 | 16941316.0 |
| 2008-07-03 10:40:00 | AAPL | Stock | 6.1357 | 6.1375 | 6.1136 | 6.1214 | 11834508.0 |
| 2008-07-03 10:45:00 | AAPL | Stock | 6.1214 | 6.1214 | 6.0911 | 6.1071 | 13076728.0 |
| 2008-07-03 10:50:00 | AAPL | Stock | 6.1075 | 6.1179 | 6.0896 | 6.11 | 9478700.0 |
| 2008-07-03 10:55:00 | AAPL | Stock | 6.1104 | 6.1154 | 6.0968 | 6.0996 | 7833644.0 |
| 2008-07-03 11:00:00 | AAPL | Stock | 6.099 | 6.12 | 6.0864 | 6.0999 | 10261412.0 |
| 2008-07-03 11:05:00 | AAPL | Stock | 6.0993 | 6.1325 | 6.0964 | 6.1325 | 9670388.0 |
| 2008-07-03 11:10:00 | AAPL | Stock | 6.1321 | 6.1364 | 6.1168 | 6.1364 | 7538552.0 |
| 2008-07-03 11:15:00 | AAPL | Stock | 6.1364 | 6.1489 | 6.1243 | 6.1339 | 10528644.0 |
| 2008-07-03 11:20:00 | AAPL | Stock | 6.1343 | 6.1357 | 6.1075 | 6.1104 | 7514192.0 |
| 2008-07-03 11:25:00 | AAPL | Stock | 6.1096 | 6.1268 | 6.1096 | 6.1243 | 6511036.0 |
| 2008-07-03 11:30:00 | AAPL | Stock | 6.1232 | 6.1264 | 6.1129 | 6.1164 | 6324388.0 |
| 2008-07-03 11:35:00 | AAPL | Stock | 6.1164 | 6.1264 | 6.1111 | 6.1253 | 4812864.0 |
> showing 50 of 182,871 rows — these rows as CSV