PREVIEW / stock_1min / 2014-01-31
file: by_date/stock_1min/2014/2014-01-31.parquet size: 14.9 MB rows: 1,072,183 symbols: 2,859
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-01-31 04:37:00 | AAPL | Stock | 17.7821 | 17.7821 | 17.7821 | 17.7821 | 2800.0 |
| 2014-01-31 04:38:00 | AAPL | Stock | 17.7821 | 17.7821 | 17.7821 | 17.7821 | 2800.0 |
| 2014-01-31 04:42:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 2800.0 |
| 2014-01-31 04:43:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 2800.0 |
| 2014-01-31 04:47:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 8400.0 |
| 2014-01-31 04:49:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 11368.0 |
| 2014-01-31 04:54:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 19600.0 |
| 2014-01-31 05:04:00 | AAPL | Stock | 17.7786 | 17.7786 | 17.7561 | 17.7561 | 11340.0 |
| 2014-01-31 05:05:00 | AAPL | Stock | 17.7561 | 17.7561 | 17.7561 | 17.7561 | 5460.0 |
| 2014-01-31 05:16:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 2800.0 |
| 2014-01-31 05:29:00 | AAPL | Stock | 17.7061 | 17.7061 | 17.7 | 17.7 | 5600.0 |
| 2014-01-31 05:30:00 | AAPL | Stock | 17.7 | 17.7 | 17.7 | 17.7 | 5600.0 |
| 2014-01-31 05:31:00 | AAPL | Stock | 17.7039 | 17.7039 | 17.7039 | 17.7039 | 2800.0 |
| 2014-01-31 05:36:00 | AAPL | Stock | 17.7261 | 17.7261 | 17.7261 | 17.7261 | 2800.0 |
| 2014-01-31 05:47:00 | AAPL | Stock | 17.7543 | 17.7543 | 17.7543 | 17.7543 | 2800.0 |
| 2014-01-31 05:57:00 | AAPL | Stock | 17.7329 | 17.7329 | 17.7329 | 17.7329 | 2800.0 |
| 2014-01-31 05:59:00 | AAPL | Stock | 17.6893 | 17.6893 | 17.6875 | 17.6875 | 13860.0 |
| 2014-01-31 06:09:00 | AAPL | Stock | 17.7529 | 17.7543 | 17.7529 | 17.7543 | 5600.0 |
| 2014-01-31 06:15:00 | AAPL | Stock | 17.7571 | 17.7679 | 17.7571 | 17.7679 | 25200.0 |
| 2014-01-31 06:32:00 | AAPL | Stock | 17.7571 | 17.7571 | 17.7571 | 17.7571 | 8400.0 |
| 2014-01-31 06:33:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2014-01-31 06:35:00 | AAPL | Stock | 17.7411 | 17.7411 | 17.7407 | 17.7407 | 16940.0 |
| 2014-01-31 06:37:00 | AAPL | Stock | 17.7446 | 17.7446 | 17.7339 | 17.7429 | 22400.0 |
| 2014-01-31 06:38:00 | AAPL | Stock | 17.7332 | 17.7332 | 17.7332 | 17.7332 | 14000.0 |
| 2014-01-31 06:39:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7146 | 17.7146 | 23800.0 |
| 2014-01-31 06:44:00 | AAPL | Stock | 17.7057 | 17.7057 | 17.6875 | 17.6875 | 56000.0 |
| 2014-01-31 06:48:00 | AAPL | Stock | 17.7036 | 17.7036 | 17.7036 | 17.7036 | 5600.0 |
| 2014-01-31 06:49:00 | AAPL | Stock | 17.7036 | 17.7036 | 17.6982 | 17.6982 | 6692.0 |
| 2014-01-31 06:50:00 | AAPL | Stock | 17.6996 | 17.6996 | 17.6996 | 17.6996 | 6048.0 |
| 2014-01-31 06:54:00 | AAPL | Stock | 17.7182 | 17.7182 | 17.7146 | 17.7146 | 10780.0 |
| 2014-01-31 06:55:00 | AAPL | Stock | 17.6989 | 17.6989 | 17.6989 | 17.6989 | 2800.0 |
| 2014-01-31 07:03:00 | AAPL | Stock | 17.7268 | 17.7268 | 17.7268 | 17.7268 | 2800.0 |
| 2014-01-31 07:07:00 | AAPL | Stock | 17.7218 | 17.7218 | 17.7218 | 17.7218 | 5600.0 |
| 2014-01-31 07:10:00 | AAPL | Stock | 17.7154 | 17.7154 | 17.7154 | 17.7154 | 2800.0 |
| 2014-01-31 07:12:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 4200.0 |
| 2014-01-31 07:13:00 | AAPL | Stock | 17.7125 | 17.7143 | 17.7125 | 17.7143 | 30688.0 |
| 2014-01-31 07:14:00 | AAPL | Stock | 17.705 | 17.705 | 17.7039 | 17.7039 | 11200.0 |
| 2014-01-31 07:15:00 | AAPL | Stock | 17.7104 | 17.7104 | 17.7104 | 17.7104 | 2800.0 |
| 2014-01-31 07:16:00 | AAPL | Stock | 17.7118 | 17.7143 | 17.7118 | 17.7143 | 11900.0 |
| 2014-01-31 07:20:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 7308.0 |
| 2014-01-31 07:23:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7232 | 17.7232 | 11200.0 |
| 2014-01-31 07:25:00 | AAPL | Stock | 17.7482 | 17.75 | 17.7482 | 17.75 | 19600.0 |
| 2014-01-31 07:26:00 | AAPL | Stock | 17.7589 | 17.7661 | 17.7589 | 17.7589 | 14000.0 |
| 2014-01-31 07:28:00 | AAPL | Stock | 17.7679 | 17.7714 | 17.7679 | 17.7714 | 11480.0 |
| 2014-01-31 07:30:00 | AAPL | Stock | 17.7607 | 17.7607 | 17.7607 | 17.7607 | 2800.0 |
| 2014-01-31 07:32:00 | AAPL | Stock | 17.7589 | 17.7589 | 17.7579 | 17.7579 | 5600.0 |
| 2014-01-31 07:33:00 | AAPL | Stock | 17.7607 | 17.7607 | 17.7543 | 17.7543 | 8400.0 |
| 2014-01-31 07:34:00 | AAPL | Stock | 17.7636 | 17.7643 | 17.7636 | 17.7643 | 9548.0 |
| 2014-01-31 07:35:00 | AAPL | Stock | 17.7589 | 17.7589 | 17.75 | 17.75 | 31248.0 |
| 2014-01-31 07:36:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 8400.0 |
> showing 50 of 1,072,183 rows — these rows as CSV