PREVIEW / stock_1min / 2011-12-21
file: by_date/stock_1min/2011/2011-12-21.parquet size: 12.8 MB rows: 960,562 symbols: 2,887
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-21 04:02:00 | AAPL | Stock | 14.1771 | 14.1771 | 14.1771 | 14.1771 | 5600.0 |
| 2011-12-21 04:16:00 | AAPL | Stock | 14.2071 | 14.2071 | 14.2071 | 14.2071 | 2800.0 |
| 2011-12-21 04:47:00 | AAPL | Stock | 14.1829 | 14.1829 | 14.1829 | 14.1829 | 7000.0 |
| 2011-12-21 05:22:00 | AAPL | Stock | 14.2036 | 14.2036 | 14.2036 | 14.2036 | 2800.0 |
| 2011-12-21 05:23:00 | AAPL | Stock | 14.2036 | 14.2036 | 14.2036 | 14.2036 | 10080.0 |
| 2011-12-21 05:25:00 | AAPL | Stock | 14.2032 | 14.2032 | 14.2032 | 14.2032 | 5320.0 |
| 2011-12-21 06:01:00 | AAPL | Stock | 14.2032 | 14.2032 | 14.2032 | 14.2032 | 5600.0 |
| 2011-12-21 06:26:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-12-21 06:28:00 | AAPL | Stock | 14.1786 | 14.1786 | 14.1786 | 14.1786 | 2800.0 |
| 2011-12-21 06:35:00 | AAPL | Stock | 14.1582 | 14.1582 | 14.1582 | 14.1582 | 2800.0 |
| 2011-12-21 06:37:00 | AAPL | Stock | 14.1093 | 14.1204 | 14.1093 | 14.1204 | 5600.0 |
| 2011-12-21 06:39:00 | AAPL | Stock | 14.1 | 14.1 | 14.0993 | 14.0993 | 8400.0 |
| 2011-12-21 06:41:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 2800.0 |
| 2011-12-21 07:02:00 | AAPL | Stock | 14.1289 | 14.1289 | 14.1289 | 14.1289 | 2800.0 |
| 2011-12-21 07:03:00 | AAPL | Stock | 14.1357 | 14.1357 | 14.1357 | 14.1357 | 2800.0 |
| 2011-12-21 07:09:00 | AAPL | Stock | 14.1289 | 14.1379 | 14.1289 | 14.1379 | 18228.0 |
| 2011-12-21 07:11:00 | AAPL | Stock | 14.1404 | 14.1404 | 14.1404 | 14.1404 | 2800.0 |
| 2011-12-21 07:16:00 | AAPL | Stock | 14.1393 | 14.1407 | 14.1393 | 14.1407 | 8400.0 |
| 2011-12-21 07:21:00 | AAPL | Stock | 14.1421 | 14.1421 | 14.1421 | 14.1421 | 2800.0 |
| 2011-12-21 07:24:00 | AAPL | Stock | 14.1418 | 14.1418 | 14.1418 | 14.1418 | 28000.0 |
| 2011-12-21 07:25:00 | AAPL | Stock | 14.1418 | 14.1421 | 14.1418 | 14.1421 | 59612.0 |
| 2011-12-21 07:26:00 | AAPL | Stock | 14.1596 | 14.1596 | 14.1589 | 14.1596 | 17388.0 |
| 2011-12-21 07:29:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 22400.0 |
| 2011-12-21 07:33:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 7812.0 |
| 2011-12-21 07:34:00 | AAPL | Stock | 14.1296 | 14.1296 | 14.1296 | 14.1296 | 2800.0 |
| 2011-12-21 07:35:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 2800.0 |
| 2011-12-21 07:37:00 | AAPL | Stock | 14.1368 | 14.1368 | 14.1368 | 14.1368 | 2800.0 |
| 2011-12-21 07:39:00 | AAPL | Stock | 14.1421 | 14.1421 | 14.1421 | 14.1421 | 4200.0 |
| 2011-12-21 07:41:00 | AAPL | Stock | 14.1518 | 14.1518 | 14.1518 | 14.1518 | 2800.0 |
| 2011-12-21 07:43:00 | AAPL | Stock | 14.1318 | 14.1332 | 14.1318 | 14.1318 | 11900.0 |
| 2011-12-21 07:44:00 | AAPL | Stock | 14.1275 | 14.1304 | 14.1257 | 14.1304 | 40600.0 |
| 2011-12-21 07:46:00 | AAPL | Stock | 14.1196 | 14.1196 | 14.1071 | 14.1071 | 56000.0 |
| 2011-12-21 07:48:00 | AAPL | Stock | 14.0982 | 14.0982 | 14.0982 | 14.0982 | 8400.0 |
| 2011-12-21 07:50:00 | AAPL | Stock | 14.1246 | 14.1246 | 14.1246 | 14.1246 | 2800.0 |
| 2011-12-21 07:51:00 | AAPL | Stock | 14.1082 | 14.1082 | 14.1075 | 14.1075 | 22400.0 |
| 2011-12-21 07:53:00 | AAPL | Stock | 14.1175 | 14.1236 | 14.1175 | 14.1236 | 56000.0 |
| 2011-12-21 07:54:00 | AAPL | Stock | 14.1236 | 14.1268 | 14.1196 | 14.1196 | 19600.0 |
| 2011-12-21 08:00:00 | AAPL | Stock | 14.135 | 14.135 | 14.125 | 14.125 | 35560.0 |
| 2011-12-21 08:01:00 | AAPL | Stock | 14.1239 | 14.1239 | 14.1196 | 14.1196 | 18060.0 |
| 2011-12-21 08:02:00 | AAPL | Stock | 14.1196 | 14.1196 | 14.1179 | 14.1179 | 25340.0 |
| 2011-12-21 08:03:00 | AAPL | Stock | 14.125 | 14.1282 | 14.125 | 14.1282 | 11200.0 |
| 2011-12-21 08:04:00 | AAPL | Stock | 14.1282 | 14.1282 | 14.1129 | 14.1129 | 9520.0 |
| 2011-12-21 08:05:00 | AAPL | Stock | 14.1129 | 14.1129 | 14.1 | 14.1 | 141316.0 |
| 2011-12-21 08:06:00 | AAPL | Stock | 14.0989 | 14.1 | 14.0761 | 14.0893 | 60760.0 |
| 2011-12-21 08:07:00 | AAPL | Stock | 14.1014 | 14.1036 | 14.0929 | 14.0929 | 16800.0 |
| 2011-12-21 08:09:00 | AAPL | Stock | 14.0929 | 14.0929 | 14.0836 | 14.0893 | 16800.0 |
| 2011-12-21 08:10:00 | AAPL | Stock | 14.0839 | 14.0839 | 14.0825 | 14.0825 | 11200.0 |
| 2011-12-21 08:13:00 | AAPL | Stock | 14.0825 | 14.0825 | 14.0825 | 14.0825 | 6860.0 |
| 2011-12-21 08:14:00 | AAPL | Stock | 14.0839 | 14.0839 | 14.0771 | 14.0807 | 88200.0 |
| 2011-12-21 08:15:00 | AAPL | Stock | 14.0754 | 14.0779 | 14.0689 | 14.0779 | 149800.0 |
> showing 50 of 960,562 rows — these rows as CSV