PREVIEW / stock_5min / 2014-02-05
file: by_date/stock_5min/2014/2014-02-05.parquet size: 5.5 MB rows: 366,165 symbols: 3,536
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-02-05 04:15:00 | AAPL | Stock | 18.1786 | 18.1786 | 18.1786 | 18.1786 | 2800.0 |
| 2014-02-05 05:00:00 | AAPL | Stock | 18.1646 | 18.1646 | 18.1646 | 18.1646 | 5600.0 |
| 2014-02-05 05:10:00 | AAPL | Stock | 18.1596 | 18.1596 | 18.1596 | 18.1596 | 5600.0 |
| 2014-02-05 05:15:00 | AAPL | Stock | 18.1575 | 18.1575 | 18.1575 | 18.1575 | 2800.0 |
| 2014-02-05 05:25:00 | AAPL | Stock | 18.17 | 18.17 | 18.17 | 18.17 | 2800.0 |
| 2014-02-05 06:05:00 | AAPL | Stock | 18.1089 | 18.1143 | 18.1071 | 18.1143 | 56588.0 |
| 2014-02-05 06:20:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 2800.0 |
| 2014-02-05 06:40:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2014-02-05 06:45:00 | AAPL | Stock | 18.1161 | 18.1161 | 18.1161 | 18.1161 | 2800.0 |
| 2014-02-05 07:00:00 | AAPL | Stock | 18.1143 | 18.1143 | 18.1143 | 18.1143 | 17976.0 |
| 2014-02-05 07:05:00 | AAPL | Stock | 18.1107 | 18.1407 | 18.1107 | 18.1407 | 9016.0 |
| 2014-02-05 07:10:00 | AAPL | Stock | 18.1143 | 18.1143 | 18.1143 | 18.1143 | 2800.0 |
| 2014-02-05 07:15:00 | AAPL | Stock | 18.1125 | 18.1125 | 18.1121 | 18.1121 | 5600.0 |
| 2014-02-05 07:35:00 | AAPL | Stock | 18.1143 | 18.125 | 18.1143 | 18.125 | 19600.0 |
| 2014-02-05 07:40:00 | AAPL | Stock | 18.115 | 18.115 | 18.1143 | 18.1143 | 8400.0 |
| 2014-02-05 07:50:00 | AAPL | Stock | 18.1071 | 18.1143 | 18.0893 | 18.0893 | 28476.0 |
| 2014-02-05 07:55:00 | AAPL | Stock | 18.0882 | 18.0882 | 18.0882 | 18.0882 | 2800.0 |
| 2014-02-05 08:00:00 | AAPL | Stock | 18.0993 | 18.125 | 18.0896 | 18.0896 | 127596.0 |
| 2014-02-05 08:05:00 | AAPL | Stock | 18.0893 | 18.1071 | 18.0857 | 18.0929 | 234500.0 |
| 2014-02-05 08:10:00 | AAPL | Stock | 18.0929 | 18.1068 | 18.0843 | 18.0957 | 172200.0 |
| 2014-02-05 08:15:00 | AAPL | Stock | 18.1054 | 18.1393 | 18.0896 | 18.0896 | 158704.0 |
| 2014-02-05 08:20:00 | AAPL | Stock | 18.0918 | 18.1054 | 18.0382 | 18.0429 | 267792.0 |
| 2014-02-05 08:25:00 | AAPL | Stock | 18.05 | 18.1032 | 18.0446 | 18.0625 | 109368.0 |
| 2014-02-05 08:30:00 | AAPL | Stock | 18.0636 | 18.0696 | 18.0539 | 18.0571 | 149156.0 |
| 2014-02-05 08:35:00 | AAPL | Stock | 18.0579 | 18.0714 | 18.0554 | 18.0714 | 148960.0 |
| 2014-02-05 08:40:00 | AAPL | Stock | 18.0804 | 18.0854 | 18.0804 | 18.0846 | 9800.0 |
| 2014-02-05 08:45:00 | AAPL | Stock | 18.0846 | 18.1025 | 18.0843 | 18.0957 | 25200.0 |
| 2014-02-05 08:50:00 | AAPL | Stock | 18.1025 | 18.1214 | 18.1014 | 18.1207 | 159124.0 |
| 2014-02-05 08:55:00 | AAPL | Stock | 18.1279 | 18.1279 | 18.1179 | 18.125 | 45220.0 |
| 2014-02-05 09:00:00 | AAPL | Stock | 18.1264 | 18.1357 | 18.1221 | 18.1243 | 130060.0 |
| 2014-02-05 09:05:00 | AAPL | Stock | 18.1243 | 18.1243 | 18.1179 | 18.1179 | 27972.0 |
| 2014-02-05 09:10:00 | AAPL | Stock | 18.1139 | 18.1296 | 18.1139 | 18.1296 | 18172.0 |
| 2014-02-05 09:15:00 | AAPL | Stock | 18.1189 | 18.1375 | 18.1182 | 18.1318 | 100156.0 |
| 2014-02-05 09:20:00 | AAPL | Stock | 18.1357 | 18.1357 | 18.1146 | 18.1146 | 46200.0 |
| 2014-02-05 09:25:00 | AAPL | Stock | 18.1711 | 18.1711 | 18.0836 | 18.0836 | 181020.0 |
| 2014-02-05 09:30:00 | AAPL | Stock | 18.0904 | 18.1682 | 18.0804 | 18.1586 | 9924656.0 |
| 2014-02-05 09:35:00 | AAPL | Stock | 18.16 | 18.2454 | 18.1572 | 18.24 | 9971080.0 |
| 2014-02-05 09:40:00 | AAPL | Stock | 18.2379 | 18.2417 | 18.2 | 18.2221 | 5523672.0 |
| 2014-02-05 09:45:00 | AAPL | Stock | 18.2193 | 18.2357 | 18.1879 | 18.1968 | 5825848.0 |
| 2014-02-05 09:50:00 | AAPL | Stock | 18.1996 | 18.2071 | 18.1679 | 18.1905 | 4379984.0 |
| 2014-02-05 09:55:00 | AAPL | Stock | 18.1904 | 18.1991 | 18.1704 | 18.1786 | 3158792.0 |
| 2014-02-05 10:00:00 | AAPL | Stock | 18.1786 | 18.2693 | 18.1743 | 18.2629 | 9023616.0 |
| 2014-02-05 10:05:00 | AAPL | Stock | 18.2646 | 18.2946 | 18.259 | 18.2679 | 6264944.0 |
| 2014-02-05 10:10:00 | AAPL | Stock | 18.2696 | 18.2814 | 18.2275 | 18.2311 | 5844412.0 |
| 2014-02-05 10:15:00 | AAPL | Stock | 18.2321 | 18.2461 | 18.1768 | 18.18 | 6247080.0 |
| 2014-02-05 10:20:00 | AAPL | Stock | 18.1854 | 18.2046 | 18.1471 | 18.1493 | 4529616.0 |
| 2014-02-05 10:25:00 | AAPL | Stock | 18.1496 | 18.2061 | 18.14 | 18.2011 | 6179348.0 |
| 2014-02-05 10:30:00 | AAPL | Stock | 18.1979 | 18.2343 | 18.1682 | 18.2274 | 4007920.0 |
| 2014-02-05 10:35:00 | AAPL | Stock | 18.2279 | 18.2529 | 18.2157 | 18.2175 | 4038020.0 |
| 2014-02-05 10:40:00 | AAPL | Stock | 18.2179 | 18.2446 | 18.2161 | 18.2293 | 3441144.0 |
> showing 50 of 366,165 rows — these rows as CSV