PREVIEW / stock_5min / 2013-07-10
file: by_date/stock_5min/2013/2013-07-10.parquet size: 5.0 MB rows: 337,981 symbols: 3,494
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-10 04:00:00 | AAPL | Stock | 15.1232 | 15.1232 | 15.1232 | 15.1232 | 8400.0 |
| 2013-07-10 06:15:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 7056.0 |
| 2013-07-10 06:20:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 4256.0 |
| 2013-07-10 06:25:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 8400.0 |
| 2013-07-10 06:45:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0718 | 15.0718 | 11200.0 |
| 2013-07-10 06:50:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0718 | 15.0718 | 2800.0 |
| 2013-07-10 06:55:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0718 | 15.0718 | 5600.0 |
| 2013-07-10 07:20:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0714 | 15.0714 | 7364.0 |
| 2013-07-10 07:25:00 | AAPL | Stock | 15.0414 | 15.0468 | 15.0393 | 15.0393 | 25200.0 |
| 2013-07-10 07:30:00 | AAPL | Stock | 15.0421 | 15.0421 | 15.0357 | 15.0357 | 22400.0 |
| 2013-07-10 07:50:00 | AAPL | Stock | 15.0375 | 15.0375 | 15.0318 | 15.0318 | 16800.0 |
| 2013-07-10 07:55:00 | AAPL | Stock | 15.0218 | 15.0232 | 15.0079 | 15.0079 | 57400.0 |
| 2013-07-10 08:00:00 | AAPL | Stock | 15.0164 | 15.0318 | 15.0079 | 15.0286 | 270900.0 |
| 2013-07-10 08:05:00 | AAPL | Stock | 15.0304 | 15.0668 | 15.0304 | 15.0668 | 89460.0 |
| 2013-07-10 08:10:00 | AAPL | Stock | 15.0568 | 15.0568 | 15.0432 | 15.0432 | 9436.0 |
| 2013-07-10 08:15:00 | AAPL | Stock | 15.0357 | 15.0393 | 15.0357 | 15.0393 | 26572.0 |
| 2013-07-10 08:20:00 | AAPL | Stock | 15.0554 | 15.0554 | 15.0382 | 15.0393 | 33600.0 |
| 2013-07-10 08:25:00 | AAPL | Stock | 15.0479 | 15.0564 | 15.0464 | 15.0564 | 16800.0 |
| 2013-07-10 08:30:00 | AAPL | Stock | 15.0539 | 15.0539 | 15.0518 | 15.0536 | 11200.0 |
| 2013-07-10 08:35:00 | AAPL | Stock | 15.0654 | 15.0654 | 15.0536 | 15.055 | 59416.0 |
| 2013-07-10 08:40:00 | AAPL | Stock | 15.0557 | 15.0557 | 15.0368 | 15.0507 | 69860.0 |
| 2013-07-10 08:45:00 | AAPL | Stock | 15.0421 | 15.0711 | 15.0386 | 15.0711 | 55020.0 |
| 2013-07-10 08:50:00 | AAPL | Stock | 15.07 | 15.0704 | 15.0593 | 15.0593 | 18200.0 |
| 2013-07-10 08:55:00 | AAPL | Stock | 15.0686 | 15.0704 | 15.0564 | 15.0679 | 136696.0 |
| 2013-07-10 09:00:00 | AAPL | Stock | 15.0593 | 15.0607 | 15.0329 | 15.0329 | 531608.0 |
| 2013-07-10 09:05:00 | AAPL | Stock | 15.0357 | 15.0468 | 14.9921 | 15.0 | 483644.0 |
| 2013-07-10 09:10:00 | AAPL | Stock | 14.9975 | 15.0071 | 14.9554 | 14.9682 | 957152.0 |
| 2013-07-10 09:15:00 | AAPL | Stock | 14.975 | 14.9907 | 14.975 | 14.9857 | 64876.0 |
| 2013-07-10 09:20:00 | AAPL | Stock | 14.9886 | 14.9979 | 14.9861 | 14.9936 | 238448.0 |
| 2013-07-10 09:25:00 | AAPL | Stock | 14.9911 | 15.0021 | 14.9707 | 14.9811 | 551880.0 |
| 2013-07-10 09:30:00 | AAPL | Stock | 14.9857 | 15.0179 | 14.9375 | 14.9854 | 11170432.0 |
| 2013-07-10 09:35:00 | AAPL | Stock | 14.9836 | 15.0882 | 14.9825 | 15.0743 | 13272504.0 |
| 2013-07-10 09:40:00 | AAPL | Stock | 15.0743 | 15.15 | 15.0454 | 15.0936 | 13792296.0 |
| 2013-07-10 09:45:00 | AAPL | Stock | 15.0918 | 15.1143 | 15.0529 | 15.0571 | 8689380.0 |
| 2013-07-10 09:50:00 | AAPL | Stock | 15.0582 | 15.0825 | 14.9754 | 15.0071 | 11397680.0 |
| 2013-07-10 09:55:00 | AAPL | Stock | 15.0036 | 15.0393 | 14.9964 | 15.0282 | 7075880.0 |
| 2013-07-10 10:00:00 | AAPL | Stock | 15.0314 | 15.05 | 14.9879 | 15.0175 | 5440876.0 |
| 2013-07-10 10:05:00 | AAPL | Stock | 15.0162 | 15.0318 | 14.9893 | 15.0196 | 6336680.0 |
| 2013-07-10 10:10:00 | AAPL | Stock | 15.0196 | 15.1107 | 15.0104 | 15.0837 | 8804320.0 |
| 2013-07-10 10:15:00 | AAPL | Stock | 15.0861 | 15.0868 | 15.0357 | 15.0561 | 5561108.0 |
| 2013-07-10 10:20:00 | AAPL | Stock | 15.0561 | 15.0714 | 15.0393 | 15.0536 | 2902648.0 |
| 2013-07-10 10:25:00 | AAPL | Stock | 15.055 | 15.1629 | 15.0446 | 15.1493 | 11823616.0 |
| 2013-07-10 10:30:00 | AAPL | Stock | 15.1464 | 15.1632 | 15.1157 | 15.125 | 8074360.0 |
| 2013-07-10 10:35:00 | AAPL | Stock | 15.115 | 15.1714 | 15.115 | 15.1372 | 10629052.0 |
| 2013-07-10 10:40:00 | AAPL | Stock | 15.1373 | 15.1404 | 15.0746 | 15.075 | 8474284.0 |
| 2013-07-10 10:45:00 | AAPL | Stock | 15.0782 | 15.1029 | 15.0632 | 15.0975 | 4013240.0 |
| 2013-07-10 10:50:00 | AAPL | Stock | 15.0984 | 15.1207 | 15.095 | 15.1071 | 2402372.0 |
| 2013-07-10 10:55:00 | AAPL | Stock | 15.1068 | 15.1182 | 15.0736 | 15.1032 | 2785328.0 |
| 2013-07-10 11:00:00 | AAPL | Stock | 15.1036 | 15.1146 | 15.0675 | 15.0807 | 2961168.0 |
| 2013-07-10 11:05:00 | AAPL | Stock | 15.0772 | 15.0907 | 15.0646 | 15.0796 | 1908004.0 |
> showing 50 of 337,981 rows — these rows as CSV