PREVIEW / stock_1min / 2013-07-05
file: by_date/stock_1min/2013/2013-07-05.parquet size: 12.6 MB rows: 939,471 symbols: 2,828
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-07-05 04:05:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1429 | 15.1429 | 2800.0 |
| 2013-07-05 04:58:00 | AAPL | Stock | 15.1632 | 15.1632 | 15.1632 | 15.1632 | 2800.0 |
| 2013-07-05 05:23:00 | AAPL | Stock | 15.1571 | 15.1571 | 15.1571 | 15.1571 | 2800.0 |
| 2013-07-05 06:03:00 | AAPL | Stock | 15.1393 | 15.1393 | 15.1393 | 15.1393 | 6300.0 |
| 2013-07-05 06:04:00 | AAPL | Stock | 15.1425 | 15.1429 | 15.1425 | 15.1429 | 16800.0 |
| 2013-07-05 06:08:00 | AAPL | Stock | 15.1357 | 15.1357 | 15.1357 | 15.1357 | 11592.0 |
| 2013-07-05 06:15:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.1554 | 15.1554 | 2800.0 |
| 2013-07-05 06:19:00 | AAPL | Stock | 15.1554 | 15.1554 | 15.1554 | 15.1554 | 2800.0 |
| 2013-07-05 06:23:00 | AAPL | Stock | 15.1554 | 15.1571 | 15.1554 | 15.1571 | 5600.0 |
| 2013-07-05 06:29:00 | AAPL | Stock | 15.1761 | 15.1761 | 15.1761 | 15.1761 | 5712.0 |
| 2013-07-05 06:34:00 | AAPL | Stock | 15.1507 | 15.1507 | 15.1429 | 15.1429 | 11200.0 |
| 2013-07-05 06:44:00 | AAPL | Stock | 15.1357 | 15.1357 | 15.1221 | 15.1221 | 8400.0 |
| 2013-07-05 06:45:00 | AAPL | Stock | 15.1118 | 15.1118 | 15.1118 | 15.1118 | 2800.0 |
| 2013-07-05 07:02:00 | AAPL | Stock | 15.1143 | 15.1143 | 15.1143 | 15.1143 | 2800.0 |
| 2013-07-05 07:04:00 | AAPL | Stock | 15.1293 | 15.1293 | 15.1293 | 15.1293 | 5600.0 |
| 2013-07-05 07:06:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 2800.0 |
| 2013-07-05 07:07:00 | AAPL | Stock | 15.1339 | 15.1339 | 15.1339 | 15.1339 | 2800.0 |
| 2013-07-05 07:08:00 | AAPL | Stock | 15.1339 | 15.1339 | 15.1339 | 15.1339 | 2800.0 |
| 2013-07-05 07:09:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 5600.0 |
| 2013-07-05 07:12:00 | AAPL | Stock | 15.1304 | 15.1304 | 15.1304 | 15.1304 | 2800.0 |
| 2013-07-05 07:13:00 | AAPL | Stock | 15.1296 | 15.1429 | 15.1296 | 15.1429 | 8400.0 |
| 2013-07-05 07:14:00 | AAPL | Stock | 15.1429 | 15.1429 | 15.1425 | 15.1425 | 14000.0 |
| 2013-07-05 07:17:00 | AAPL | Stock | 15.1375 | 15.1711 | 15.1296 | 15.1711 | 66640.0 |
| 2013-07-05 07:18:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 5600.0 |
| 2013-07-05 07:19:00 | AAPL | Stock | 15.1539 | 15.1539 | 15.1482 | 15.1482 | 5600.0 |
| 2013-07-05 07:21:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1518 | 15.1518 | 2800.0 |
| 2013-07-05 07:29:00 | AAPL | Stock | 15.1586 | 15.1586 | 15.1586 | 15.1586 | 2800.0 |
| 2013-07-05 07:30:00 | AAPL | Stock | 15.1464 | 15.1464 | 15.1464 | 15.1464 | 6636.0 |
| 2013-07-05 07:31:00 | AAPL | Stock | 15.1586 | 15.1586 | 15.1586 | 15.1586 | 3276.0 |
| 2013-07-05 07:40:00 | AAPL | Stock | 15.1507 | 15.1507 | 15.1507 | 15.1507 | 5600.0 |
| 2013-07-05 07:41:00 | AAPL | Stock | 15.1507 | 15.1507 | 15.1507 | 15.1507 | 5600.0 |
| 2013-07-05 07:42:00 | AAPL | Stock | 15.1496 | 15.15 | 15.1496 | 15.15 | 8400.0 |
| 2013-07-05 07:43:00 | AAPL | Stock | 15.1518 | 15.1518 | 15.1496 | 15.1496 | 8400.0 |
| 2013-07-05 07:50:00 | AAPL | Stock | 15.1496 | 15.1496 | 15.1496 | 15.1496 | 2800.0 |
| 2013-07-05 07:51:00 | AAPL | Stock | 15.1496 | 15.1496 | 15.1429 | 15.1429 | 25900.0 |
| 2013-07-05 07:54:00 | AAPL | Stock | 15.135 | 15.135 | 15.1246 | 15.1246 | 37800.0 |
| 2013-07-05 07:55:00 | AAPL | Stock | 15.125 | 15.125 | 15.125 | 15.125 | 21840.0 |
| 2013-07-05 07:56:00 | AAPL | Stock | 15.1214 | 15.1232 | 15.1214 | 15.1232 | 5600.0 |
| 2013-07-05 07:57:00 | AAPL | Stock | 15.1179 | 15.1179 | 15.0929 | 15.1057 | 57596.0 |
| 2013-07-05 07:59:00 | AAPL | Stock | 15.1057 | 15.1057 | 15.1057 | 15.1057 | 2800.0 |
| 2013-07-05 08:00:00 | AAPL | Stock | 15.1161 | 15.1589 | 15.1014 | 15.1161 | 121464.0 |
| 2013-07-05 08:01:00 | AAPL | Stock | 15.1179 | 15.125 | 15.1179 | 15.125 | 14000.0 |
| 2013-07-05 08:02:00 | AAPL | Stock | 14.9093 | 14.9093 | 14.9093 | 14.9093 | 26292.0 |
| 2013-07-05 08:03:00 | AAPL | Stock | 15.1357 | 15.1357 | 15.1357 | 15.1357 | 2800.0 |
| 2013-07-05 08:04:00 | AAPL | Stock | 15.1339 | 15.1357 | 15.1339 | 15.1339 | 20300.0 |
| 2013-07-05 08:05:00 | AAPL | Stock | 15.1268 | 15.1268 | 15.1268 | 15.1268 | 3500.0 |
| 2013-07-05 08:06:00 | AAPL | Stock | 15.135 | 15.1357 | 15.1339 | 15.1346 | 29400.0 |
| 2013-07-05 08:07:00 | AAPL | Stock | 15.1339 | 15.1357 | 15.1282 | 15.1357 | 26376.0 |
| 2013-07-05 08:08:00 | AAPL | Stock | 15.1293 | 15.1339 | 15.1293 | 15.1339 | 23212.0 |
| 2013-07-05 08:09:00 | AAPL | Stock | 15.1293 | 15.1293 | 15.11 | 15.1232 | 75880.0 |
> showing 50 of 939,471 rows — these rows as CSV