PREVIEW / stock_1min / 2014-02-07
file: by_date/stock_1min/2014/2014-02-07.parquet size: 14.7 MB rows: 1,065,386 symbols: 2,858
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-07 04:00:00 | AAPL | Stock | 18.3893 | 18.5382 | 18.3893 | 18.5 | 60900.0 |
| 2014-02-07 04:01:00 | AAPL | Stock | 18.4946 | 18.5 | 18.4946 | 18.5 | 22400.0 |
| 2014-02-07 04:02:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 11200.0 |
| 2014-02-07 04:06:00 | AAPL | Stock | 18.5675 | 18.5714 | 18.5675 | 18.5714 | 10304.0 |
| 2014-02-07 04:07:00 | AAPL | Stock | 18.5679 | 18.5714 | 18.5679 | 18.5714 | 30324.0 |
| 2014-02-07 04:17:00 | AAPL | Stock | 18.6239 | 18.6239 | 18.6239 | 18.6239 | 2800.0 |
| 2014-02-07 04:18:00 | AAPL | Stock | 18.6118 | 18.6118 | 18.6114 | 18.6114 | 19600.0 |
| 2014-02-07 04:24:00 | AAPL | Stock | 18.5939 | 18.6004 | 18.5939 | 18.6004 | 5600.0 |
| 2014-02-07 04:34:00 | AAPL | Stock | 18.6414 | 18.6429 | 18.6414 | 18.6429 | 8400.0 |
| 2014-02-07 04:36:00 | AAPL | Stock | 18.6571 | 18.6571 | 18.6571 | 18.6571 | 5600.0 |
| 2014-02-07 04:37:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 2800.0 |
| 2014-02-07 04:39:00 | AAPL | Stock | 18.6461 | 18.6461 | 18.6461 | 18.6461 | 2800.0 |
| 2014-02-07 04:47:00 | AAPL | Stock | 18.65 | 18.65 | 18.65 | 18.65 | 5908.0 |
| 2014-02-07 04:48:00 | AAPL | Stock | 18.6732 | 18.6904 | 18.6732 | 18.6732 | 16100.0 |
| 2014-02-07 04:51:00 | AAPL | Stock | 18.6968 | 18.6968 | 18.6968 | 18.6968 | 3444.0 |
| 2014-02-07 04:52:00 | AAPL | Stock | 18.6964 | 18.6982 | 18.6964 | 18.6982 | 5600.0 |
| 2014-02-07 04:53:00 | AAPL | Stock | 18.6971 | 18.7107 | 18.6929 | 18.6929 | 25200.0 |
| 2014-02-07 04:56:00 | AAPL | Stock | 18.6832 | 18.6832 | 18.6832 | 18.6832 | 5600.0 |
| 2014-02-07 04:59:00 | AAPL | Stock | 18.6561 | 18.6561 | 18.6561 | 18.6561 | 2800.0 |
| 2014-02-07 05:01:00 | AAPL | Stock | 18.6632 | 18.6632 | 18.6632 | 18.6632 | 16800.0 |
| 2014-02-07 05:05:00 | AAPL | Stock | 18.6539 | 18.6539 | 18.6539 | 18.6539 | 2800.0 |
| 2014-02-07 05:10:00 | AAPL | Stock | 18.6521 | 18.6521 | 18.6521 | 18.6521 | 2800.0 |
| 2014-02-07 05:11:00 | AAPL | Stock | 18.6521 | 18.6521 | 18.6521 | 18.6521 | 2800.0 |
| 2014-02-07 05:15:00 | AAPL | Stock | 18.6721 | 18.6721 | 18.6721 | 18.6721 | 2800.0 |
| 2014-02-07 05:22:00 | AAPL | Stock | 18.7107 | 18.7107 | 18.7107 | 18.7107 | 5600.0 |
| 2014-02-07 05:23:00 | AAPL | Stock | 18.7107 | 18.7107 | 18.7107 | 18.7107 | 2800.0 |
| 2014-02-07 05:24:00 | AAPL | Stock | 18.7107 | 18.7107 | 18.7107 | 18.7107 | 2800.0 |
| 2014-02-07 05:26:00 | AAPL | Stock | 18.7161 | 18.7161 | 18.7161 | 18.7161 | 5600.0 |
| 2014-02-07 05:27:00 | AAPL | Stock | 18.7161 | 18.7161 | 18.7161 | 18.7161 | 2800.0 |
| 2014-02-07 05:28:00 | AAPL | Stock | 18.7314 | 18.7314 | 18.7314 | 18.7314 | 2800.0 |
| 2014-02-07 05:30:00 | AAPL | Stock | 18.7218 | 18.7218 | 18.7218 | 18.7218 | 11200.0 |
| 2014-02-07 05:32:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2014-02-07 05:33:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2014-02-07 05:37:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2014-02-07 05:41:00 | AAPL | Stock | 18.7214 | 18.7214 | 18.7214 | 18.7214 | 2800.0 |
| 2014-02-07 05:48:00 | AAPL | Stock | 18.7146 | 18.7146 | 18.7071 | 18.7071 | 23492.0 |
| 2014-02-07 05:50:00 | AAPL | Stock | 18.7054 | 18.7054 | 18.6979 | 18.6979 | 14000.0 |
| 2014-02-07 05:52:00 | AAPL | Stock | 18.7071 | 18.7071 | 18.7071 | 18.7071 | 2800.0 |
| 2014-02-07 05:53:00 | AAPL | Stock | 18.7071 | 18.7071 | 18.7071 | 18.7071 | 2800.0 |
| 2014-02-07 05:59:00 | AAPL | Stock | 18.7232 | 18.7232 | 18.7232 | 18.7232 | 2800.0 |
| 2014-02-07 06:00:00 | AAPL | Stock | 18.7189 | 18.7189 | 18.7143 | 18.7143 | 5600.0 |
| 2014-02-07 06:01:00 | AAPL | Stock | 18.7143 | 18.7146 | 18.6979 | 18.6979 | 39200.0 |
| 2014-02-07 06:02:00 | AAPL | Stock | 18.7104 | 18.7104 | 18.7104 | 18.7104 | 8400.0 |
| 2014-02-07 06:04:00 | AAPL | Stock | 18.7111 | 18.7304 | 18.7111 | 18.7304 | 14840.0 |
| 2014-02-07 06:06:00 | AAPL | Stock | 18.7071 | 18.7464 | 18.7071 | 18.7357 | 134820.0 |
| 2014-02-07 06:07:00 | AAPL | Stock | 18.7321 | 18.7679 | 18.7321 | 18.7443 | 67480.0 |
| 2014-02-07 06:08:00 | AAPL | Stock | 18.7357 | 18.7357 | 18.7357 | 18.7357 | 14000.0 |
| 2014-02-07 06:11:00 | AAPL | Stock | 18.7396 | 18.7396 | 18.7396 | 18.7396 | 2800.0 |
| 2014-02-07 06:12:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 2800.0 |
| 2014-02-07 06:13:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7321 | 18.7321 | 5600.0 |
> showing 50 of 1,065,386 rows — these rows as CSV