PREVIEW / stock_1min / 2013-02-12
file: by_date/stock_1min/2013/2013-02-12.parquet size: 12.8 MB rows: 941,842 symbols: 2,821
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-02-12 04:25:00 | AAPL | Stock | 17.1246 | 17.1246 | 17.1246 | 17.1246 | 2800.0 |
| 2013-02-12 05:43:00 | AAPL | Stock | 17.1071 | 17.1071 | 17.1071 | 17.1071 | 3612.0 |
| 2013-02-12 05:50:00 | AAPL | Stock | 17.1375 | 17.1414 | 17.1375 | 17.1414 | 8400.0 |
| 2013-02-12 05:51:00 | AAPL | Stock | 17.1389 | 17.15 | 17.1389 | 17.15 | 25200.0 |
| 2013-02-12 06:13:00 | AAPL | Stock | 17.1714 | 17.1714 | 17.1714 | 17.1714 | 2800.0 |
| 2013-02-12 06:19:00 | AAPL | Stock | 17.1589 | 17.1589 | 17.1429 | 17.1429 | 14000.0 |
| 2013-02-12 06:24:00 | AAPL | Stock | 17.1482 | 17.1482 | 17.1464 | 17.1464 | 5600.0 |
| 2013-02-12 06:32:00 | AAPL | Stock | 17.1689 | 17.1689 | 17.1689 | 17.1689 | 5600.0 |
| 2013-02-12 06:38:00 | AAPL | Stock | 17.1511 | 17.1511 | 17.1429 | 17.1429 | 29428.0 |
| 2013-02-12 06:40:00 | AAPL | Stock | 17.1304 | 17.1304 | 17.1304 | 17.1304 | 2800.0 |
| 2013-02-12 06:43:00 | AAPL | Stock | 17.1304 | 17.1304 | 17.1304 | 17.1304 | 2800.0 |
| 2013-02-12 06:45:00 | AAPL | Stock | 17.1375 | 17.1375 | 17.1375 | 17.1375 | 2800.0 |
| 2013-02-12 06:48:00 | AAPL | Stock | 17.1371 | 17.1371 | 17.1371 | 17.1371 | 2800.0 |
| 2013-02-12 06:49:00 | AAPL | Stock | 17.1371 | 17.1371 | 17.1371 | 17.1371 | 2800.0 |
| 2013-02-12 06:54:00 | AAPL | Stock | 17.1161 | 17.1161 | 17.1071 | 17.1071 | 22400.0 |
| 2013-02-12 06:56:00 | AAPL | Stock | 17.1071 | 17.1071 | 17.1071 | 17.1071 | 2800.0 |
| 2013-02-12 07:01:00 | AAPL | Stock | 17.0907 | 17.0964 | 17.0893 | 17.0964 | 14000.0 |
| 2013-02-12 07:02:00 | AAPL | Stock | 17.0893 | 17.0893 | 17.0893 | 17.0893 | 8400.0 |
| 2013-02-12 07:03:00 | AAPL | Stock | 17.0996 | 17.1036 | 17.0996 | 17.1036 | 5600.0 |
| 2013-02-12 07:06:00 | AAPL | Stock | 17.1 | 17.1 | 17.1 | 17.1 | 2800.0 |
| 2013-02-12 07:08:00 | AAPL | Stock | 17.1029 | 17.1029 | 17.1029 | 17.1029 | 2800.0 |
| 2013-02-12 07:09:00 | AAPL | Stock | 17.1036 | 17.1036 | 17.1036 | 17.1036 | 2800.0 |
| 2013-02-12 07:13:00 | AAPL | Stock | 17.1143 | 17.1143 | 17.1143 | 17.1143 | 5600.0 |
| 2013-02-12 07:17:00 | AAPL | Stock | 17.1036 | 17.1036 | 17.1036 | 17.1036 | 2800.0 |
| 2013-02-12 07:18:00 | AAPL | Stock | 17.1 | 17.1 | 17.1 | 17.1 | 5600.0 |
| 2013-02-12 07:23:00 | AAPL | Stock | 17.0929 | 17.0929 | 17.0893 | 17.0893 | 8400.0 |
| 2013-02-12 07:25:00 | AAPL | Stock | 17.0929 | 17.0929 | 17.0929 | 17.0929 | 2800.0 |
| 2013-02-12 07:26:00 | AAPL | Stock | 17.1064 | 17.1064 | 17.1064 | 17.1064 | 3724.0 |
| 2013-02-12 07:30:00 | AAPL | Stock | 17.1071 | 17.1143 | 17.1071 | 17.1143 | 24080.0 |
| 2013-02-12 07:36:00 | AAPL | Stock | 17.1071 | 17.1071 | 17.1071 | 17.1071 | 3416.0 |
| 2013-02-12 07:37:00 | AAPL | Stock | 17.1082 | 17.1232 | 17.1082 | 17.1232 | 36848.0 |
| 2013-02-12 07:41:00 | AAPL | Stock | 17.1339 | 17.1339 | 17.1321 | 17.1321 | 19600.0 |
| 2013-02-12 07:42:00 | AAPL | Stock | 17.1321 | 17.1332 | 17.1321 | 17.1332 | 14560.0 |
| 2013-02-12 07:43:00 | AAPL | Stock | 17.1568 | 17.16 | 17.1568 | 17.16 | 24724.0 |
| 2013-02-12 07:44:00 | AAPL | Stock | 17.1582 | 17.1593 | 17.1582 | 17.1582 | 16800.0 |
| 2013-02-12 07:45:00 | AAPL | Stock | 17.1629 | 17.1629 | 17.1582 | 17.1582 | 52192.0 |
| 2013-02-12 07:46:00 | AAPL | Stock | 17.1586 | 17.1586 | 17.1582 | 17.1586 | 8400.0 |
| 2013-02-12 07:47:00 | AAPL | Stock | 17.1582 | 17.1664 | 17.1582 | 17.1664 | 92400.0 |
| 2013-02-12 07:49:00 | AAPL | Stock | 17.15 | 17.15 | 17.1429 | 17.1429 | 10612.0 |
| 2013-02-12 07:50:00 | AAPL | Stock | 17.1361 | 17.1361 | 17.1361 | 17.1361 | 8400.0 |
| 2013-02-12 07:52:00 | AAPL | Stock | 17.1361 | 17.1361 | 17.1361 | 17.1361 | 2800.0 |
| 2013-02-12 07:54:00 | AAPL | Stock | 17.1429 | 17.1429 | 17.1429 | 17.1429 | 11844.0 |
| 2013-02-12 07:56:00 | AAPL | Stock | 17.1396 | 17.1396 | 17.1396 | 17.1396 | 19600.0 |
| 2013-02-12 07:59:00 | AAPL | Stock | 17.1414 | 17.1436 | 17.1414 | 17.1436 | 32200.0 |
| 2013-02-12 08:00:00 | AAPL | Stock | 17.1429 | 17.1607 | 17.0946 | 17.1404 | 146328.0 |
| 2013-02-12 08:01:00 | AAPL | Stock | 17.1275 | 17.1275 | 17.1218 | 17.1218 | 16800.0 |
| 2013-02-12 08:02:00 | AAPL | Stock | 17.1154 | 17.1196 | 17.1096 | 17.1096 | 19600.0 |
| 2013-02-12 08:03:00 | AAPL | Stock | 17.1104 | 17.1104 | 17.0964 | 17.0964 | 16548.0 |
| 2013-02-12 08:04:00 | AAPL | Stock | 17.1039 | 17.1039 | 17.1 | 17.1 | 22400.0 |
| 2013-02-12 08:05:00 | AAPL | Stock | 17.0957 | 17.0982 | 17.0957 | 17.0964 | 14000.0 |
> showing 50 of 941,842 rows — these rows as CSV