PREVIEW / stock_5min / 2014-03-12
file: by_date/stock_5min/2014/2014-03-12.parquet size: 5.4 MB rows: 359,903 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2014-03-12 04:05:00 | AAPL | Stock | 19.1446 | 19.1446 | 19.1446 | 19.1446 | 2800.0 |
| 2014-03-12 06:05:00 | AAPL | Stock | 19.1082 | 19.1082 | 19.1079 | 19.1079 | 5600.0 |
| 2014-03-12 06:15:00 | AAPL | Stock | 19.1043 | 19.1043 | 19.1043 | 19.1043 | 2800.0 |
| 2014-03-12 06:35:00 | AAPL | Stock | 19.0893 | 19.0893 | 19.0829 | 19.0829 | 5600.0 |
| 2014-03-12 06:40:00 | AAPL | Stock | 19.0754 | 19.0754 | 19.0754 | 19.0754 | 2800.0 |
| 2014-03-12 06:45:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0714 | 19.0714 | 11200.0 |
| 2014-03-12 06:50:00 | AAPL | Stock | 19.0614 | 19.0614 | 19.0614 | 19.0614 | 2800.0 |
| 2014-03-12 07:00:00 | AAPL | Stock | 19.0893 | 19.09 | 19.0893 | 19.09 | 11200.0 |
| 2014-03-12 07:10:00 | AAPL | Stock | 19.105 | 19.1196 | 19.105 | 19.1196 | 11200.0 |
| 2014-03-12 07:15:00 | AAPL | Stock | 19.1293 | 19.1293 | 19.1139 | 19.1139 | 47600.0 |
| 2014-03-12 07:20:00 | AAPL | Stock | 19.1143 | 19.1143 | 19.1143 | 19.1143 | 2800.0 |
| 2014-03-12 07:30:00 | AAPL | Stock | 19.1179 | 19.1179 | 19.1179 | 19.1179 | 2800.0 |
| 2014-03-12 07:45:00 | AAPL | Stock | 19.12 | 19.12 | 19.1146 | 19.1179 | 61600.0 |
| 2014-03-12 07:50:00 | AAPL | Stock | 19.1086 | 19.1086 | 19.1086 | 19.1086 | 5600.0 |
| 2014-03-12 07:55:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.1071 | 19.1071 | 16800.0 |
| 2014-03-12 08:00:00 | AAPL | Stock | 19.0896 | 19.125 | 19.0896 | 19.09 | 16884.0 |
| 2014-03-12 08:05:00 | AAPL | Stock | 19.0968 | 19.1 | 19.0964 | 19.1 | 8400.0 |
| 2014-03-12 08:15:00 | AAPL | Stock | 19.1018 | 19.1018 | 19.1 | 19.1 | 11200.0 |
| 2014-03-12 08:20:00 | AAPL | Stock | 19.1071 | 19.1071 | 19.0971 | 19.0971 | 38500.0 |
| 2014-03-12 08:25:00 | AAPL | Stock | 19.1 | 19.1071 | 19.0893 | 19.1071 | 46760.0 |
| 2014-03-12 08:30:00 | AAPL | Stock | 19.1057 | 19.1107 | 19.0964 | 19.0964 | 33600.0 |
| 2014-03-12 08:35:00 | AAPL | Stock | 19.0964 | 19.1014 | 19.0896 | 19.0896 | 35224.0 |
| 2014-03-12 08:45:00 | AAPL | Stock | 19.0829 | 19.0829 | 19.0721 | 19.0721 | 41832.0 |
| 2014-03-12 08:50:00 | AAPL | Stock | 19.0679 | 19.0714 | 19.0646 | 19.0714 | 42252.0 |
| 2014-03-12 08:55:00 | AAPL | Stock | 19.0661 | 19.0714 | 19.0646 | 19.0646 | 81592.0 |
| 2014-03-12 09:00:00 | AAPL | Stock | 19.0714 | 19.0929 | 19.0714 | 19.0893 | 81200.0 |
| 2014-03-12 09:05:00 | AAPL | Stock | 19.0896 | 19.0896 | 19.0896 | 19.0896 | 2800.0 |
| 2014-03-12 09:10:00 | AAPL | Stock | 19.0846 | 19.0975 | 19.0818 | 19.0904 | 151228.0 |
| 2014-03-12 09:15:00 | AAPL | Stock | 19.0893 | 19.0964 | 19.0893 | 19.0964 | 33600.0 |
| 2014-03-12 09:20:00 | AAPL | Stock | 19.0964 | 19.0964 | 19.0893 | 19.0893 | 175224.0 |
| 2014-03-12 09:25:00 | AAPL | Stock | 19.0896 | 19.0996 | 19.0704 | 19.0886 | 594300.0 |
| 2014-03-12 09:30:00 | AAPL | Stock | 19.0904 | 19.1389 | 19.0386 | 19.0557 | 9003596.0 |
| 2014-03-12 09:35:00 | AAPL | Stock | 19.0504 | 19.0964 | 19.0446 | 19.0614 | 4810428.0 |
| 2014-03-12 09:40:00 | AAPL | Stock | 19.0611 | 19.0836 | 19.0464 | 19.0821 | 2842588.0 |
| 2014-03-12 09:45:00 | AAPL | Stock | 19.0761 | 19.0818 | 19.0232 | 19.0418 | 4506936.0 |
| 2014-03-12 09:50:00 | AAPL | Stock | 19.0418 | 19.0511 | 19.0071 | 19.0429 | 4061540.0 |
| 2014-03-12 09:55:00 | AAPL | Stock | 19.0441 | 19.0441 | 19.0 | 19.017 | 3302992.0 |
| 2014-03-12 10:00:00 | AAPL | Stock | 19.0196 | 19.0696 | 19.0025 | 19.0686 | 3354092.0 |
| 2014-03-12 10:05:00 | AAPL | Stock | 19.0689 | 19.0711 | 19.0432 | 19.0611 | 3422104.0 |
| 2014-03-12 10:10:00 | AAPL | Stock | 19.0625 | 19.0671 | 19.0246 | 19.0325 | 2449440.0 |
| 2014-03-12 10:15:00 | AAPL | Stock | 19.0296 | 19.0546 | 19.0293 | 19.0425 | 1882608.0 |
| 2014-03-12 10:20:00 | AAPL | Stock | 19.0443 | 19.0611 | 19.04 | 19.0446 | 2092440.0 |
| 2014-03-12 10:25:00 | AAPL | Stock | 19.0464 | 19.0468 | 19.0182 | 19.0204 | 2678620.0 |
| 2014-03-12 10:30:00 | AAPL | Stock | 19.0186 | 19.0382 | 19.0096 | 19.0304 | 2806944.0 |
| 2014-03-12 10:35:00 | AAPL | Stock | 19.0304 | 19.0439 | 19.02 | 19.0343 | 1839796.0 |
| 2014-03-12 10:40:00 | AAPL | Stock | 19.0354 | 19.0818 | 19.0321 | 19.0771 | 3105956.0 |
| 2014-03-12 10:45:00 | AAPL | Stock | 19.0779 | 19.0967 | 19.0736 | 19.085 | 4119220.0 |
| 2014-03-12 10:50:00 | AAPL | Stock | 19.0868 | 19.1125 | 19.0793 | 19.0996 | 2833600.0 |
| 2014-03-12 10:55:00 | AAPL | Stock | 19.1054 | 19.1311 | 19.0975 | 19.1311 | 3349192.0 |
| 2014-03-12 11:00:00 | AAPL | Stock | 19.1311 | 19.1336 | 19.1111 | 19.1296 | 2539824.0 |
> showing 50 of 359,903 rows — these rows as CSV