PREVIEW / stock_1min / 2014-09-26
file: by_date/stock_1min/2014/2014-09-26.parquet size: 13.8 MB rows: 1,019,932 symbols: 2,899
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-09-26 04:00:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.4675 | 24.5 | 9200.0 |
| 2014-09-26 04:02:00 | AAPL | Stock | 24.5075 | 24.5075 | 24.5075 | 24.5075 | 400.0 |
| 2014-09-26 04:03:00 | AAPL | Stock | 24.5125 | 24.5225 | 24.5125 | 24.5225 | 4008.0 |
| 2014-09-26 04:05:00 | AAPL | Stock | 24.4975 | 24.4975 | 24.4975 | 24.4975 | 400.0 |
| 2014-09-26 04:10:00 | AAPL | Stock | 24.4875 | 24.4875 | 24.4875 | 24.4875 | 400.0 |
| 2014-09-26 04:11:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 1600.0 |
| 2014-09-26 04:31:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 1572.0 |
| 2014-09-26 04:32:00 | AAPL | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 2000.0 |
| 2014-09-26 04:37:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 800.0 |
| 2014-09-26 04:38:00 | AAPL | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 1600.0 |
| 2014-09-26 04:48:00 | AAPL | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 1600.0 |
| 2014-09-26 04:49:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 13228.0 |
| 2014-09-26 04:54:00 | AAPL | Stock | 24.52 | 24.52 | 24.52 | 24.52 | 560.0 |
| 2014-09-26 05:01:00 | AAPL | Stock | 24.5175 | 24.5175 | 24.5175 | 24.5175 | 400.0 |
| 2014-09-26 05:02:00 | AAPL | Stock | 24.5175 | 24.5175 | 24.5175 | 24.5175 | 400.0 |
| 2014-09-26 05:03:00 | AAPL | Stock | 24.4925 | 24.4925 | 24.4925 | 24.4925 | 400.0 |
| 2014-09-26 05:05:00 | AAPL | Stock | 24.5175 | 24.5175 | 24.5175 | 24.5175 | 1136.0 |
| 2014-09-26 05:13:00 | AAPL | Stock | 24.525 | 24.525 | 24.525 | 24.525 | 2800.0 |
| 2014-09-26 05:16:00 | AAPL | Stock | 24.5175 | 24.525 | 24.5175 | 24.525 | 3040.0 |
| 2014-09-26 05:17:00 | AAPL | Stock | 24.565 | 24.565 | 24.565 | 24.565 | 2000.0 |
| 2014-09-26 05:18:00 | AAPL | Stock | 24.5675 | 24.5775 | 24.5675 | 24.5775 | 2056.0 |
| 2014-09-26 05:19:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 3256.0 |
| 2014-09-26 05:31:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 2000.0 |
| 2014-09-26 05:32:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 1544.0 |
| 2014-09-26 05:35:00 | AAPL | Stock | 24.6225 | 24.6225 | 24.6225 | 24.6225 | 800.0 |
| 2014-09-26 05:36:00 | AAPL | Stock | 24.6225 | 24.6225 | 24.6225 | 24.6225 | 400.0 |
| 2014-09-26 05:37:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 400.0 |
| 2014-09-26 05:40:00 | AAPL | Stock | 24.6575 | 24.6575 | 24.6575 | 24.6575 | 400.0 |
| 2014-09-26 05:41:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 4800.0 |
| 2014-09-26 05:42:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 3200.0 |
| 2014-09-26 05:43:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 1960.0 |
| 2014-09-26 05:44:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 2000.0 |
| 2014-09-26 05:48:00 | AAPL | Stock | 24.655 | 24.655 | 24.65 | 24.65 | 3656.0 |
| 2014-09-26 05:49:00 | AAPL | Stock | 24.6275 | 24.6275 | 24.6275 | 24.6275 | 2000.0 |
| 2014-09-26 05:51:00 | AAPL | Stock | 24.69 | 24.69 | 24.69 | 24.69 | 7556.0 |
| 2014-09-26 05:52:00 | AAPL | Stock | 24.6775 | 24.6775 | 24.6775 | 24.6775 | 4800.0 |
| 2014-09-26 06:00:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 600.0 |
| 2014-09-26 06:01:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 400.0 |
| 2014-09-26 06:02:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.64 | 24.6725 | 6400.0 |
| 2014-09-26 06:03:00 | AAPL | Stock | 24.64 | 24.6725 | 24.64 | 24.6725 | 4712.0 |
| 2014-09-26 06:05:00 | AAPL | Stock | 24.675 | 24.675 | 24.64 | 24.64 | 4000.0 |
| 2014-09-26 06:07:00 | AAPL | Stock | 24.6625 | 24.6625 | 24.6625 | 24.6625 | 400.0 |
| 2014-09-26 06:08:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 2000.0 |
| 2014-09-26 06:10:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 2288.0 |
| 2014-09-26 06:11:00 | AAPL | Stock | 24.6075 | 24.6075 | 24.6 | 24.6075 | 19600.0 |
| 2014-09-26 06:17:00 | AAPL | Stock | 24.6225 | 24.625 | 24.6225 | 24.625 | 6408.0 |
| 2014-09-26 06:18:00 | AAPL | Stock | 24.5775 | 24.625 | 24.5775 | 24.625 | 800.0 |
| 2014-09-26 06:20:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 800.0 |
| 2014-09-26 06:23:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 20000.0 |
| 2014-09-26 06:24:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 520.0 |
> showing 50 of 1,019,932 rows — these rows as CSV