PREVIEW / stock_5min / 2013-09-30
file: by_date/stock_5min/2013/2013-09-30.parquet size: 5.2 MB rows: 346,908 symbols: 3,548
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-09-30 04:00:00 | AAPL | Stock | 17.1532 | 17.1532 | 17.0664 | 17.0664 | 5600.0 |
| 2013-09-30 04:05:00 | AAPL | Stock | 17.0664 | 17.0664 | 17.0664 | 17.0664 | 5600.0 |
| 2013-09-30 04:10:00 | AAPL | Stock | 17.0479 | 17.0479 | 17.0196 | 17.025 | 39676.0 |
| 2013-09-30 04:15:00 | AAPL | Stock | 17.0257 | 17.0257 | 17.0104 | 17.0104 | 89600.0 |
| 2013-09-30 04:20:00 | AAPL | Stock | 17.0104 | 17.0104 | 17.0104 | 17.0104 | 48412.0 |
| 2013-09-30 04:35:00 | AAPL | Stock | 17.0118 | 17.0357 | 17.0039 | 17.0357 | 30604.0 |
| 2013-09-30 04:45:00 | AAPL | Stock | 17.0446 | 17.0446 | 17.0446 | 17.0446 | 2800.0 |
| 2013-09-30 05:35:00 | AAPL | Stock | 17.0539 | 17.0539 | 17.0539 | 17.0539 | 2800.0 |
| 2013-09-30 05:50:00 | AAPL | Stock | 17.07 | 17.0714 | 17.0611 | 17.0714 | 14000.0 |
| 2013-09-30 06:00:00 | AAPL | Stock | 17.0543 | 17.0543 | 17.0543 | 17.0543 | 4452.0 |
| 2013-09-30 06:15:00 | AAPL | Stock | 17.0693 | 17.0786 | 17.0693 | 17.0714 | 31612.0 |
| 2013-09-30 06:35:00 | AAPL | Stock | 17.0754 | 17.0754 | 17.0714 | 17.0714 | 62720.0 |
| 2013-09-30 06:40:00 | AAPL | Stock | 17.075 | 17.075 | 17.0711 | 17.0711 | 64792.0 |
| 2013-09-30 06:45:00 | AAPL | Stock | 17.0611 | 17.0704 | 17.0611 | 17.0629 | 22400.0 |
| 2013-09-30 06:50:00 | AAPL | Stock | 17.0539 | 17.0625 | 17.0539 | 17.0593 | 75460.0 |
| 2013-09-30 07:00:00 | AAPL | Stock | 17.0607 | 17.0714 | 17.0607 | 17.0714 | 59332.0 |
| 2013-09-30 07:05:00 | AAPL | Stock | 17.0721 | 17.0757 | 17.0721 | 17.0757 | 45220.0 |
| 2013-09-30 07:10:00 | AAPL | Stock | 17.085 | 17.0961 | 17.0846 | 17.0946 | 32200.0 |
| 2013-09-30 07:15:00 | AAPL | Stock | 17.0896 | 17.09 | 17.0714 | 17.0714 | 96068.0 |
| 2013-09-30 07:20:00 | AAPL | Stock | 17.0682 | 17.0689 | 17.0639 | 17.0643 | 11564.0 |
| 2013-09-30 07:25:00 | AAPL | Stock | 17.0643 | 17.0714 | 17.0482 | 17.0482 | 85652.0 |
| 2013-09-30 07:30:00 | AAPL | Stock | 17.0586 | 17.0804 | 17.0571 | 17.0804 | 113876.0 |
| 2013-09-30 07:35:00 | AAPL | Stock | 17.0754 | 17.0821 | 17.0754 | 17.0821 | 68936.0 |
| 2013-09-30 07:40:00 | AAPL | Stock | 17.0889 | 17.0889 | 17.0589 | 17.0686 | 272104.0 |
| 2013-09-30 07:45:00 | AAPL | Stock | 17.0711 | 17.1204 | 17.0679 | 17.1204 | 145740.0 |
| 2013-09-30 07:50:00 | AAPL | Stock | 17.1139 | 17.1139 | 17.1021 | 17.1021 | 8120.0 |
| 2013-09-30 07:55:00 | AAPL | Stock | 17.0986 | 17.0993 | 17.0732 | 17.0893 | 177324.0 |
| 2013-09-30 08:00:00 | AAPL | Stock | 17.0893 | 17.1071 | 17.0393 | 17.0893 | 374836.0 |
| 2013-09-30 08:05:00 | AAPL | Stock | 17.1057 | 17.1175 | 17.0957 | 17.0957 | 138292.0 |
| 2013-09-30 08:10:00 | AAPL | Stock | 17.0957 | 17.1246 | 17.0957 | 17.1246 | 58184.0 |
| 2013-09-30 08:15:00 | AAPL | Stock | 17.1296 | 17.1304 | 17.1143 | 17.1186 | 138628.0 |
| 2013-09-30 08:20:00 | AAPL | Stock | 17.1182 | 17.1489 | 17.1182 | 17.1489 | 126616.0 |
| 2013-09-30 08:25:00 | AAPL | Stock | 17.1439 | 17.1439 | 17.1293 | 17.1314 | 65436.0 |
| 2013-09-30 08:30:00 | AAPL | Stock | 17.1411 | 17.155 | 17.1314 | 17.1371 | 255836.0 |
| 2013-09-30 08:35:00 | AAPL | Stock | 17.1261 | 17.1375 | 17.115 | 17.115 | 119812.0 |
| 2013-09-30 08:40:00 | AAPL | Stock | 17.1286 | 17.1286 | 17.0932 | 17.0975 | 119980.0 |
| 2013-09-30 08:45:00 | AAPL | Stock | 17.1032 | 17.1032 | 17.1 | 17.1021 | 86016.0 |
| 2013-09-30 08:50:00 | AAPL | Stock | 17.0971 | 17.1071 | 17.0911 | 17.0911 | 69888.0 |
| 2013-09-30 08:55:00 | AAPL | Stock | 17.0979 | 17.1007 | 17.0893 | 17.0929 | 225456.0 |
| 2013-09-30 09:00:00 | AAPL | Stock | 17.0904 | 17.1018 | 17.0893 | 17.0911 | 342468.0 |
| 2013-09-30 09:05:00 | AAPL | Stock | 17.0911 | 17.0929 | 17.0779 | 17.0875 | 205772.0 |
| 2013-09-30 09:10:00 | AAPL | Stock | 17.0875 | 17.3214 | 17.0875 | 17.0975 | 223636.0 |
| 2013-09-30 09:15:00 | AAPL | Stock | 17.0975 | 17.0986 | 17.0804 | 17.0804 | 172312.0 |
| 2013-09-30 09:20:00 | AAPL | Stock | 17.0811 | 17.0907 | 17.0625 | 17.0625 | 205856.0 |
| 2013-09-30 09:25:00 | AAPL | Stock | 17.0704 | 17.0707 | 17.0104 | 17.0204 | 918176.0 |
| 2013-09-30 09:30:00 | AAPL | Stock | 17.0296 | 17.0711 | 16.9432 | 17.0668 | 21156884.0 |
| 2013-09-30 09:35:00 | AAPL | Stock | 17.0668 | 17.0721 | 16.9907 | 16.9975 | 7391524.0 |
| 2013-09-30 09:40:00 | AAPL | Stock | 16.9975 | 17.0575 | 16.9929 | 17.012 | 7160692.0 |
| 2013-09-30 09:45:00 | AAPL | Stock | 17.0146 | 17.05 | 17.0071 | 17.0189 | 4070948.0 |
| 2013-09-30 09:50:00 | AAPL | Stock | 17.0164 | 17.0975 | 16.9932 | 17.0789 | 6858348.0 |
> showing 50 of 346,908 rows — these rows as CSV