PREVIEW / stock_1min / 2013-06-03
file: by_date/stock_1min/2013/2013-06-03.parquet size: 15.1 MB rows: 1,095,791 symbols: 2,844
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-06-03 04:13:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0261 | 16.0261 | 11200.0 |
| 2013-06-03 04:15:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 2800.0 |
| 2013-06-03 04:49:00 | AAPL | Stock | 16.0214 | 16.0214 | 16.0214 | 16.0214 | 5600.0 |
| 2013-06-03 05:10:00 | AAPL | Stock | 16.0136 | 16.0136 | 16.0136 | 16.0136 | 2800.0 |
| 2013-06-03 05:12:00 | AAPL | Stock | 16.0339 | 16.0339 | 16.0339 | 16.0339 | 2800.0 |
| 2013-06-03 05:19:00 | AAPL | Stock | 16.0357 | 16.0357 | 16.0357 | 16.0357 | 2800.0 |
| 2013-06-03 05:21:00 | AAPL | Stock | 16.0321 | 16.0321 | 16.0321 | 16.0321 | 2800.0 |
| 2013-06-03 05:54:00 | AAPL | Stock | 16.0696 | 16.0714 | 16.0696 | 16.0714 | 30800.0 |
| 2013-06-03 05:58:00 | AAPL | Stock | 16.0786 | 16.0786 | 16.0786 | 16.0786 | 8400.0 |
| 2013-06-03 06:16:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 2800.0 |
| 2013-06-03 06:25:00 | AAPL | Stock | 16.0714 | 16.0714 | 16.0714 | 16.0714 | 5600.0 |
| 2013-06-03 06:31:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 2800.0 |
| 2013-06-03 06:37:00 | AAPL | Stock | 16.0893 | 16.0893 | 16.0893 | 16.0893 | 5600.0 |
| 2013-06-03 06:39:00 | AAPL | Stock | 16.0996 | 16.0996 | 16.0996 | 16.0996 | 2800.0 |
| 2013-06-03 06:46:00 | AAPL | Stock | 16.1061 | 16.1354 | 16.1061 | 16.1354 | 14616.0 |
| 2013-06-03 07:01:00 | AAPL | Stock | 16.1357 | 16.1418 | 16.1357 | 16.1418 | 5600.0 |
| 2013-06-03 07:02:00 | AAPL | Stock | 16.155 | 16.1596 | 16.155 | 16.1596 | 12768.0 |
| 2013-06-03 07:04:00 | AAPL | Stock | 16.1432 | 16.1432 | 16.1429 | 16.1429 | 8400.0 |
| 2013-06-03 07:05:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 4200.0 |
| 2013-06-03 07:06:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 11200.0 |
| 2013-06-03 07:07:00 | AAPL | Stock | 16.1446 | 16.1446 | 16.1429 | 16.1429 | 19600.0 |
| 2013-06-03 07:10:00 | AAPL | Stock | 16.1446 | 16.1446 | 16.1446 | 16.1446 | 2828.0 |
| 2013-06-03 07:11:00 | AAPL | Stock | 16.1518 | 16.1518 | 16.1518 | 16.1518 | 2800.0 |
| 2013-06-03 07:12:00 | AAPL | Stock | 16.1571 | 16.1571 | 16.1571 | 16.1571 | 21000.0 |
| 2013-06-03 07:17:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 2800.0 |
| 2013-06-03 07:19:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 2800.0 |
| 2013-06-03 07:20:00 | AAPL | Stock | 16.1429 | 16.1439 | 16.1425 | 16.1439 | 156352.0 |
| 2013-06-03 07:21:00 | AAPL | Stock | 16.1446 | 16.1464 | 16.1446 | 16.1464 | 8400.0 |
| 2013-06-03 07:22:00 | AAPL | Stock | 16.1464 | 16.1464 | 16.1464 | 16.1464 | 5600.0 |
| 2013-06-03 07:23:00 | AAPL | Stock | 16.1461 | 16.1464 | 16.1461 | 16.1464 | 8400.0 |
| 2013-06-03 07:24:00 | AAPL | Stock | 16.1464 | 16.1464 | 16.1464 | 16.1464 | 16912.0 |
| 2013-06-03 07:25:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 2800.0 |
| 2013-06-03 07:27:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 11312.0 |
| 2013-06-03 07:29:00 | AAPL | Stock | 16.1429 | 16.1518 | 16.1429 | 16.1518 | 152516.0 |
| 2013-06-03 07:31:00 | AAPL | Stock | 16.1546 | 16.1643 | 16.1546 | 16.1643 | 100800.0 |
| 2013-06-03 07:32:00 | AAPL | Stock | 16.1643 | 16.1643 | 16.1629 | 16.1639 | 86912.0 |
| 2013-06-03 07:33:00 | AAPL | Stock | 16.1679 | 16.1679 | 16.1629 | 16.1646 | 19600.0 |
| 2013-06-03 07:34:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.1607 | 16.1607 | 2800.0 |
| 2013-06-03 07:36:00 | AAPL | Stock | 16.1621 | 16.1643 | 16.1621 | 16.1643 | 8400.0 |
| 2013-06-03 07:38:00 | AAPL | Stock | 16.1539 | 16.1639 | 16.1496 | 16.1639 | 47600.0 |
| 2013-06-03 07:39:00 | AAPL | Stock | 16.1618 | 16.1643 | 16.1618 | 16.1643 | 28000.0 |
| 2013-06-03 07:40:00 | AAPL | Stock | 16.1536 | 16.1536 | 16.1536 | 16.1536 | 2800.0 |
| 2013-06-03 07:42:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.15 | 16.15 | 6048.0 |
| 2013-06-03 07:43:00 | AAPL | Stock | 16.1468 | 16.1532 | 16.1429 | 16.1429 | 42980.0 |
| 2013-06-03 07:44:00 | AAPL | Stock | 16.1414 | 16.1425 | 16.1414 | 16.1425 | 5600.0 |
| 2013-06-03 07:46:00 | AAPL | Stock | 16.1429 | 16.15 | 16.1429 | 16.1429 | 61964.0 |
| 2013-06-03 07:47:00 | AAPL | Stock | 16.15 | 16.15 | 16.15 | 16.15 | 25200.0 |
| 2013-06-03 07:48:00 | AAPL | Stock | 16.1429 | 16.15 | 16.1429 | 16.15 | 14000.0 |
| 2013-06-03 07:50:00 | AAPL | Stock | 16.15 | 16.15 | 16.1429 | 16.1429 | 72380.0 |
| 2013-06-03 07:51:00 | AAPL | Stock | 16.1425 | 16.1429 | 16.1425 | 16.1425 | 16800.0 |
> showing 50 of 1,095,791 rows — these rows as CSV