PREVIEW / stock_1min / 2014-08-27
file: by_date/stock_1min/2014/2014-08-27.parquet size: 13.4 MB rows: 988,160 symbols: 2,910
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-08-27 04:00:00 | AAPL | Stock | 25.2725 | 25.2725 | 25.2725 | 25.2725 | 400.0 |
| 2014-08-27 05:02:00 | AAPL | Stock | 25.3175 | 25.3175 | 25.3175 | 25.3175 | 400.0 |
| 2014-08-27 05:03:00 | AAPL | Stock | 25.32 | 25.32 | 25.32 | 25.32 | 400.0 |
| 2014-08-27 05:26:00 | AAPL | Stock | 25.325 | 25.325 | 25.325 | 25.325 | 400.0 |
| 2014-08-27 05:42:00 | AAPL | Stock | 25.3225 | 25.325 | 25.3225 | 25.325 | 800.0 |
| 2014-08-27 05:44:00 | AAPL | Stock | 25.33 | 25.33 | 25.33 | 25.33 | 400.0 |
| 2014-08-27 05:47:00 | AAPL | Stock | 25.325 | 25.325 | 25.325 | 25.325 | 400.0 |
| 2014-08-27 06:01:00 | AAPL | Stock | 25.2925 | 25.2925 | 25.2925 | 25.2925 | 400.0 |
| 2014-08-27 06:56:00 | AAPL | Stock | 25.315 | 25.315 | 25.315 | 25.315 | 400.0 |
| 2014-08-27 07:00:00 | AAPL | Stock | 25.32 | 25.32 | 25.295 | 25.295 | 5200.0 |
| 2014-08-27 07:02:00 | AAPL | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 800.0 |
| 2014-08-27 07:03:00 | AAPL | Stock | 25.2975 | 25.2975 | 25.2975 | 25.2975 | 600.0 |
| 2014-08-27 07:11:00 | AAPL | Stock | 25.3075 | 25.3075 | 25.29 | 25.29 | 13892.0 |
| 2014-08-27 07:13:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.2825 | 25.2825 | 600.0 |
| 2014-08-27 07:14:00 | AAPL | Stock | 25.29 | 25.2925 | 25.29 | 25.2925 | 4000.0 |
| 2014-08-27 07:15:00 | AAPL | Stock | 25.295 | 25.295 | 25.295 | 25.295 | 6708.0 |
| 2014-08-27 07:16:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 400.0 |
| 2014-08-27 07:26:00 | AAPL | Stock | 25.3075 | 25.3075 | 25.3075 | 25.3075 | 400.0 |
| 2014-08-27 07:29:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 8552.0 |
| 2014-08-27 07:30:00 | AAPL | Stock | 25.3125 | 25.3125 | 25.3125 | 25.3125 | 4900.0 |
| 2014-08-27 07:32:00 | AAPL | Stock | 25.295 | 25.3 | 25.2925 | 25.2925 | 3600.0 |
| 2014-08-27 07:34:00 | AAPL | Stock | 25.2875 | 25.2875 | 25.2875 | 25.2875 | 2500.0 |
| 2014-08-27 07:36:00 | AAPL | Stock | 25.2925 | 25.2925 | 25.2925 | 25.2925 | 6800.0 |
| 2014-08-27 07:39:00 | AAPL | Stock | 25.29 | 25.29 | 25.2875 | 25.2875 | 1240.0 |
| 2014-08-27 07:40:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 400.0 |
| 2014-08-27 07:41:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.2825 | 25.2825 | 9336.0 |
| 2014-08-27 07:43:00 | AAPL | Stock | 25.2875 | 25.2875 | 25.2875 | 25.2875 | 800.0 |
| 2014-08-27 07:46:00 | AAPL | Stock | 25.2875 | 25.29 | 25.2875 | 25.29 | 4000.0 |
| 2014-08-27 07:48:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 3200.0 |
| 2014-08-27 07:49:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.2825 | 25.2825 | 3600.0 |
| 2014-08-27 07:50:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.275 | 25.275 | 2000.0 |
| 2014-08-27 07:51:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 4800.0 |
| 2014-08-27 07:55:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 700.0 |
| 2014-08-27 07:57:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 800.0 |
| 2014-08-27 07:59:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.28 | 25.28 | 4800.0 |
| 2014-08-27 08:00:00 | AAPL | Stock | 25.2825 | 25.3125 | 25.2225 | 25.285 | 71284.0 |
| 2014-08-27 08:02:00 | AAPL | Stock | 25.2825 | 25.2875 | 25.2825 | 25.2875 | 3400.0 |
| 2014-08-27 08:03:00 | AAPL | Stock | 25.2825 | 25.2875 | 25.2825 | 25.2825 | 4800.0 |
| 2014-08-27 08:04:00 | AAPL | Stock | 25.2775 | 25.2775 | 25.2625 | 25.2625 | 10180.0 |
| 2014-08-27 08:05:00 | AAPL | Stock | 25.27 | 25.275 | 25.27 | 25.275 | 9200.0 |
| 2014-08-27 08:06:00 | AAPL | Stock | 25.275 | 25.275 | 25.2725 | 25.2725 | 800.0 |
| 2014-08-27 08:07:00 | AAPL | Stock | 25.285 | 25.2875 | 25.285 | 25.285 | 10400.0 |
| 2014-08-27 08:08:00 | AAPL | Stock | 25.2775 | 25.285 | 25.275 | 25.285 | 6800.0 |
| 2014-08-27 08:09:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 480.0 |
| 2014-08-27 08:11:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 3200.0 |
| 2014-08-27 08:12:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.2825 | 25.2825 | 1200.0 |
| 2014-08-27 08:13:00 | AAPL | Stock | 25.285 | 25.2875 | 25.2825 | 25.2875 | 17744.0 |
| 2014-08-27 08:14:00 | AAPL | Stock | 25.2825 | 25.2825 | 25.2775 | 25.2775 | 9336.0 |
| 2014-08-27 08:15:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 4000.0 |
| 2014-08-27 08:16:00 | AAPL | Stock | 25.285 | 25.285 | 25.285 | 25.285 | 1200.0 |
> showing 50 of 988,160 rows — these rows as CSV