PREVIEW / stock_5min / 2013-04-16
file: by_date/stock_5min/2013/2013-04-16.parquet size: 5.0 MB rows: 335,035 symbols: 3,477
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-04-16 04:10:00 | AAPL | Stock | 15.0357 | 15.0357 | 15.0357 | 15.0357 | 17304.0 |
| 2013-04-16 05:15:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 2800.0 |
| 2013-04-16 05:30:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 17360.0 |
| 2013-04-16 06:30:00 | AAPL | Stock | 15.0821 | 15.0857 | 15.0821 | 15.0857 | 25200.0 |
| 2013-04-16 06:35:00 | AAPL | Stock | 15.0768 | 15.0768 | 15.0768 | 15.0768 | 5600.0 |
| 2013-04-16 06:40:00 | AAPL | Stock | 15.0925 | 15.0925 | 15.0786 | 15.0786 | 11200.0 |
| 2013-04-16 06:45:00 | AAPL | Stock | 15.0786 | 15.0786 | 15.0786 | 15.0786 | 8400.0 |
| 2013-04-16 06:55:00 | AAPL | Stock | 15.0786 | 15.0786 | 15.0786 | 15.0786 | 5600.0 |
| 2013-04-16 07:00:00 | AAPL | Stock | 15.0786 | 15.0786 | 15.0786 | 15.0786 | 8400.0 |
| 2013-04-16 07:10:00 | AAPL | Stock | 15.0893 | 15.0946 | 15.0843 | 15.0893 | 62440.0 |
| 2013-04-16 07:15:00 | AAPL | Stock | 15.1064 | 15.1143 | 15.1064 | 15.1071 | 36428.0 |
| 2013-04-16 07:25:00 | AAPL | Stock | 15.1064 | 15.1064 | 15.1064 | 15.1064 | 2800.0 |
| 2013-04-16 07:30:00 | AAPL | Stock | 15.09 | 15.0957 | 15.0714 | 15.0714 | 118048.0 |
| 2013-04-16 07:35:00 | AAPL | Stock | 15.0929 | 15.0982 | 15.0832 | 15.0832 | 31584.0 |
| 2013-04-16 07:40:00 | AAPL | Stock | 15.0868 | 15.0925 | 15.0868 | 15.0925 | 28784.0 |
| 2013-04-16 07:45:00 | AAPL | Stock | 15.0879 | 15.0986 | 15.0879 | 15.0982 | 92596.0 |
| 2013-04-16 07:50:00 | AAPL | Stock | 15.0982 | 15.1589 | 15.0975 | 15.1382 | 228340.0 |
| 2013-04-16 07:55:00 | AAPL | Stock | 15.1382 | 15.1418 | 15.1218 | 15.1218 | 103936.0 |
| 2013-04-16 08:00:00 | AAPL | Stock | 15.1146 | 15.1468 | 15.0 | 15.1354 | 403256.0 |
| 2013-04-16 08:05:00 | AAPL | Stock | 15.1361 | 15.1361 | 15.0968 | 15.1196 | 149772.0 |
| 2013-04-16 08:10:00 | AAPL | Stock | 15.1075 | 15.1075 | 15.09 | 15.09 | 136052.0 |
| 2013-04-16 08:15:00 | AAPL | Stock | 15.0896 | 15.1057 | 15.0879 | 15.0893 | 92316.0 |
| 2013-04-16 08:20:00 | AAPL | Stock | 15.0975 | 15.1029 | 15.0896 | 15.0986 | 58716.0 |
| 2013-04-16 08:25:00 | AAPL | Stock | 15.0989 | 15.1071 | 15.0982 | 15.1071 | 124600.0 |
| 2013-04-16 08:30:00 | AAPL | Stock | 15.1071 | 15.12 | 15.1068 | 15.1071 | 200900.0 |
| 2013-04-16 08:35:00 | AAPL | Stock | 15.1071 | 15.1357 | 15.1071 | 15.1282 | 333928.0 |
| 2013-04-16 08:40:00 | AAPL | Stock | 15.1214 | 15.1382 | 15.1196 | 15.1261 | 178836.0 |
| 2013-04-16 08:45:00 | AAPL | Stock | 15.1186 | 15.125 | 15.1186 | 15.1189 | 57680.0 |
| 2013-04-16 08:50:00 | AAPL | Stock | 15.1143 | 15.1143 | 15.0786 | 15.1 | 290360.0 |
| 2013-04-16 08:55:00 | AAPL | Stock | 15.0843 | 15.1018 | 15.0839 | 15.0893 | 89460.0 |
| 2013-04-16 09:00:00 | AAPL | Stock | 15.0914 | 15.0996 | 15.0893 | 15.0996 | 108948.0 |
| 2013-04-16 09:05:00 | AAPL | Stock | 15.0989 | 15.1025 | 15.0964 | 15.0982 | 65968.0 |
| 2013-04-16 09:10:00 | AAPL | Stock | 15.0943 | 15.0968 | 15.0507 | 15.0546 | 315420.0 |
| 2013-04-16 09:15:00 | AAPL | Stock | 15.0675 | 15.0718 | 15.0625 | 15.0625 | 106540.0 |
| 2013-04-16 09:20:00 | AAPL | Stock | 15.0764 | 15.0921 | 15.0764 | 15.0921 | 82740.0 |
| 2013-04-16 09:25:00 | AAPL | Stock | 15.0832 | 15.0893 | 15.0386 | 15.055 | 516852.0 |
| 2013-04-16 09:30:00 | AAPL | Stock | 15.0557 | 15.1496 | 15.0204 | 15.125 | 20778044.0 |
| 2013-04-16 09:35:00 | AAPL | Stock | 15.1232 | 15.1411 | 15.0743 | 15.1371 | 9367540.0 |
| 2013-04-16 09:40:00 | AAPL | Stock | 15.1364 | 15.1714 | 15.095 | 15.1282 | 10468332.0 |
| 2013-04-16 09:45:00 | AAPL | Stock | 15.1321 | 15.1329 | 15.0954 | 15.1089 | 6226136.0 |
| 2013-04-16 09:50:00 | AAPL | Stock | 15.1118 | 15.1161 | 15.0821 | 15.1025 | 5397112.0 |
| 2013-04-16 09:55:00 | AAPL | Stock | 15.105 | 15.1075 | 15.0561 | 15.0795 | 7552244.0 |
| 2013-04-16 10:00:00 | AAPL | Stock | 15.0769 | 15.0854 | 15.0279 | 15.0339 | 8015812.0 |
| 2013-04-16 10:05:00 | AAPL | Stock | 15.0357 | 15.0704 | 15.0286 | 15.0625 | 4857132.0 |
| 2013-04-16 10:10:00 | AAPL | Stock | 15.0657 | 15.0875 | 15.0632 | 15.0687 | 4648000.0 |
| 2013-04-16 10:15:00 | AAPL | Stock | 15.0696 | 15.0804 | 15.0357 | 15.0416 | 4020520.0 |
| 2013-04-16 10:20:00 | AAPL | Stock | 15.0382 | 15.0782 | 15.0368 | 15.066 | 4074952.0 |
| 2013-04-16 10:25:00 | AAPL | Stock | 15.07 | 15.0979 | 15.0643 | 15.0841 | 4517856.0 |
| 2013-04-16 10:30:00 | AAPL | Stock | 15.0875 | 15.1661 | 15.0832 | 15.1512 | 9251620.0 |
| 2013-04-16 10:35:00 | AAPL | Stock | 15.1539 | 15.1579 | 15.1071 | 15.1096 | 5251372.0 |
> showing 50 of 335,035 rows — these rows as CSV