PREVIEW / stock_1min / 2013-01-23
file: by_date/stock_1min/2013/2013-01-23.parquet size: 13.0 MB rows: 960,804 symbols: 2,831
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-01-23 04:01:00 | AAPL | Stock | 18.1143 | 18.1143 | 18.1143 | 18.1143 | 5600.0 |
| 2013-01-23 04:06:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1071 | 18.1071 | 2800.0 |
| 2013-01-23 04:09:00 | AAPL | Stock | 18.0939 | 18.0939 | 18.0939 | 18.0939 | 2800.0 |
| 2013-01-23 04:21:00 | AAPL | Stock | 18.1211 | 18.1211 | 18.1211 | 18.1211 | 2800.0 |
| 2013-01-23 04:23:00 | AAPL | Stock | 18.125 | 18.125 | 18.1225 | 18.1225 | 5600.0 |
| 2013-01-23 04:29:00 | AAPL | Stock | 18.1225 | 18.1225 | 18.1225 | 18.1225 | 2800.0 |
| 2013-01-23 05:01:00 | AAPL | Stock | 18.1164 | 18.1164 | 18.1164 | 18.1164 | 2800.0 |
| 2013-01-23 05:21:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2013-01-23 05:24:00 | AAPL | Stock | 18.1286 | 18.1286 | 18.125 | 18.125 | 5600.0 |
| 2013-01-23 05:39:00 | AAPL | Stock | 18.1264 | 18.1264 | 18.1264 | 18.1264 | 10080.0 |
| 2013-01-23 05:40:00 | AAPL | Stock | 18.1268 | 18.1268 | 18.1268 | 18.1268 | 2800.0 |
| 2013-01-23 05:46:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 2800.0 |
| 2013-01-23 05:50:00 | AAPL | Stock | 18.1246 | 18.1246 | 18.1246 | 18.1246 | 5600.0 |
| 2013-01-23 05:54:00 | AAPL | Stock | 18.125 | 18.1268 | 18.125 | 18.125 | 12600.0 |
| 2013-01-23 06:04:00 | AAPL | Stock | 18.1268 | 18.1268 | 18.125 | 18.125 | 8400.0 |
| 2013-01-23 06:07:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 2800.0 |
| 2013-01-23 06:08:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 2800.0 |
| 2013-01-23 06:14:00 | AAPL | Stock | 18.1268 | 18.1268 | 18.1268 | 18.1268 | 2800.0 |
| 2013-01-23 06:24:00 | AAPL | Stock | 18.1275 | 18.1275 | 18.1275 | 18.1275 | 6300.0 |
| 2013-01-23 06:33:00 | AAPL | Stock | 18.1307 | 18.1307 | 18.1307 | 18.1307 | 2800.0 |
| 2013-01-23 06:36:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2013-01-23 06:45:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2013-01-23 06:51:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2013-01-23 06:55:00 | AAPL | Stock | 18.1393 | 18.1393 | 18.1393 | 18.1393 | 2800.0 |
| 2013-01-23 07:01:00 | AAPL | Stock | 18.1571 | 18.1571 | 18.1571 | 18.1571 | 2800.0 |
| 2013-01-23 07:02:00 | AAPL | Stock | 18.1554 | 18.1775 | 18.1554 | 18.1775 | 8400.0 |
| 2013-01-23 07:03:00 | AAPL | Stock | 18.15 | 18.15 | 18.1429 | 18.1429 | 11200.0 |
| 2013-01-23 07:04:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2013-01-23 07:05:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 2800.0 |
| 2013-01-23 07:06:00 | AAPL | Stock | 18.1429 | 18.15 | 18.1429 | 18.15 | 28140.0 |
| 2013-01-23 07:07:00 | AAPL | Stock | 18.1564 | 18.1571 | 18.1564 | 18.1571 | 14000.0 |
| 2013-01-23 07:08:00 | AAPL | Stock | 18.1593 | 18.1593 | 18.1536 | 18.1536 | 11200.0 |
| 2013-01-23 07:09:00 | AAPL | Stock | 18.1504 | 18.1536 | 18.1504 | 18.1536 | 14000.0 |
| 2013-01-23 07:11:00 | AAPL | Stock | 18.1436 | 18.1436 | 18.1429 | 18.1429 | 32340.0 |
| 2013-01-23 07:14:00 | AAPL | Stock | 18.1396 | 18.1429 | 18.1396 | 18.1429 | 5600.0 |
| 2013-01-23 07:17:00 | AAPL | Stock | 18.1336 | 18.1346 | 18.1336 | 18.1346 | 11200.0 |
| 2013-01-23 07:18:00 | AAPL | Stock | 18.1336 | 18.1589 | 18.1336 | 18.1589 | 27020.0 |
| 2013-01-23 07:19:00 | AAPL | Stock | 18.1536 | 18.1536 | 18.1536 | 18.1536 | 5600.0 |
| 2013-01-23 07:23:00 | AAPL | Stock | 18.1582 | 18.1589 | 18.1454 | 18.1454 | 19600.0 |
| 2013-01-23 07:24:00 | AAPL | Stock | 18.1521 | 18.1521 | 18.1521 | 18.1521 | 5600.0 |
| 2013-01-23 07:25:00 | AAPL | Stock | 18.1521 | 18.1521 | 18.1479 | 18.1479 | 8400.0 |
| 2013-01-23 07:26:00 | AAPL | Stock | 18.1471 | 18.1471 | 18.1471 | 18.1471 | 2800.0 |
| 2013-01-23 07:27:00 | AAPL | Stock | 18.1479 | 18.1525 | 18.1479 | 18.1525 | 8624.0 |
| 2013-01-23 07:28:00 | AAPL | Stock | 18.1518 | 18.1525 | 18.1518 | 18.1521 | 22624.0 |
| 2013-01-23 07:29:00 | AAPL | Stock | 18.1514 | 18.1589 | 18.1514 | 18.1589 | 57176.0 |
| 2013-01-23 07:30:00 | AAPL | Stock | 18.1586 | 18.1596 | 18.1543 | 18.1543 | 41916.0 |
| 2013-01-23 07:31:00 | AAPL | Stock | 18.1536 | 18.1543 | 18.1525 | 18.1525 | 13636.0 |
| 2013-01-23 07:32:00 | AAPL | Stock | 18.1486 | 18.1486 | 18.1486 | 18.1486 | 11200.0 |
| 2013-01-23 07:34:00 | AAPL | Stock | 18.1443 | 18.1443 | 18.1443 | 18.1443 | 3052.0 |
| 2013-01-23 07:36:00 | AAPL | Stock | 18.1471 | 18.1471 | 18.1464 | 18.1464 | 9800.0 |
> showing 50 of 960,804 rows — these rows as CSV