PREVIEW / stock_1min / 2017-02-28
file: by_date/stock_1min/2017/2017-02-28.parquet size: 15.3 MB rows: 1,096,735 symbols: 2,562
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-28 04:02:00 | AAPL | Stock | 34.2675 | 34.2675 | 34.21 | 34.21 | 2000.0 |
| 2017-02-28 05:14:00 | AAPL | Stock | 34.2875 | 34.2875 | 34.2875 | 34.2875 | 400.0 |
| 2017-02-28 05:16:00 | AAPL | Stock | 34.3 | 34.325 | 34.2875 | 34.325 | 13072.0 |
| 2017-02-28 05:17:00 | AAPL | Stock | 34.325 | 34.325 | 34.3125 | 34.3125 | 8264.0 |
| 2017-02-28 05:23:00 | AAPL | Stock | 34.285 | 34.285 | 34.285 | 34.285 | 8000.0 |
| 2017-02-28 05:58:00 | AAPL | Stock | 34.3125 | 34.3175 | 34.3125 | 34.3175 | 3596.0 |
| 2017-02-28 06:01:00 | AAPL | Stock | 34.3175 | 34.325 | 34.3175 | 34.3175 | 6916.0 |
| 2017-02-28 06:02:00 | AAPL | Stock | 34.325 | 34.325 | 34.325 | 34.325 | 2000.0 |
| 2017-02-28 06:09:00 | AAPL | Stock | 34.325 | 34.325 | 34.325 | 34.325 | 4000.0 |
| 2017-02-28 06:43:00 | AAPL | Stock | 34.3 | 34.3 | 34.3 | 34.3 | 2740.0 |
| 2017-02-28 06:44:00 | AAPL | Stock | 34.2875 | 34.2875 | 34.2875 | 34.2875 | 2000.0 |
| 2017-02-28 06:45:00 | AAPL | Stock | 34.3 | 34.3 | 34.3 | 34.3 | 800.0 |
| 2017-02-28 06:48:00 | AAPL | Stock | 34.3075 | 34.3075 | 34.3075 | 34.3075 | 400.0 |
| 2017-02-28 07:00:00 | AAPL | Stock | 34.3 | 34.3 | 34.3 | 34.3 | 400.0 |
| 2017-02-28 07:01:00 | AAPL | Stock | 34.2875 | 34.2875 | 34.285 | 34.285 | 3592.0 |
| 2017-02-28 07:04:00 | AAPL | Stock | 34.2875 | 34.2875 | 34.2875 | 34.2875 | 14000.0 |
| 2017-02-28 07:05:00 | AAPL | Stock | 34.285 | 34.2925 | 34.285 | 34.2925 | 812.0 |
| 2017-02-28 07:07:00 | AAPL | Stock | 34.2925 | 34.295 | 34.2925 | 34.295 | 2520.0 |
| 2017-02-28 07:10:00 | AAPL | Stock | 34.3 | 34.3 | 34.3 | 34.3 | 2952.0 |
| 2017-02-28 07:11:00 | AAPL | Stock | 34.3 | 34.3 | 34.285 | 34.285 | 7760.0 |
| 2017-02-28 07:12:00 | AAPL | Stock | 34.2875 | 34.2875 | 34.2875 | 34.2875 | 8000.0 |
| 2017-02-28 07:21:00 | AAPL | Stock | 34.285 | 34.285 | 34.285 | 34.285 | 400.0 |
| 2017-02-28 07:28:00 | AAPL | Stock | 34.29 | 34.29 | 34.29 | 34.29 | 400.0 |
| 2017-02-28 07:31:00 | AAPL | Stock | 34.29 | 34.29 | 34.29 | 34.29 | 600.0 |
| 2017-02-28 07:32:00 | AAPL | Stock | 34.2875 | 34.2975 | 34.2875 | 34.2975 | 7352.0 |
| 2017-02-28 07:35:00 | AAPL | Stock | 34.3 | 34.3 | 34.3 | 34.3 | 3600.0 |
| 2017-02-28 07:37:00 | AAPL | Stock | 34.2975 | 34.3 | 34.2975 | 34.3 | 6264.0 |
| 2017-02-28 07:41:00 | AAPL | Stock | 34.3025 | 34.3025 | 34.275 | 34.275 | 10100.0 |
| 2017-02-28 07:51:00 | AAPL | Stock | 34.2975 | 34.2975 | 34.2975 | 34.2975 | 400.0 |
| 2017-02-28 08:00:00 | AAPL | Stock | 34.305 | 34.3075 | 34.2775 | 34.2975 | 60200.0 |
| 2017-02-28 08:02:00 | AAPL | Stock | 34.29 | 34.29 | 34.2875 | 34.2875 | 9200.0 |
| 2017-02-28 08:03:00 | AAPL | Stock | 34.285 | 34.285 | 34.285 | 34.285 | 18400.0 |
| 2017-02-28 08:04:00 | AAPL | Stock | 34.28 | 34.28 | 34.2775 | 34.28 | 8400.0 |
| 2017-02-28 08:06:00 | AAPL | Stock | 34.2875 | 34.2925 | 34.2875 | 34.2925 | 32740.0 |
| 2017-02-28 08:07:00 | AAPL | Stock | 34.2925 | 34.3075 | 34.2925 | 34.3075 | 5200.0 |
| 2017-02-28 08:08:00 | AAPL | Stock | 34.305 | 34.305 | 34.2875 | 34.2875 | 9200.0 |
| 2017-02-28 08:09:00 | AAPL | Stock | 34.2875 | 34.2875 | 34.2825 | 34.2825 | 6884.0 |
| 2017-02-28 08:10:00 | AAPL | Stock | 34.2925 | 34.2925 | 34.2925 | 34.2925 | 560.0 |
| 2017-02-28 08:11:00 | AAPL | Stock | 34.2925 | 34.2925 | 34.2925 | 34.2925 | 7960.0 |
| 2017-02-28 08:12:00 | AAPL | Stock | 34.2925 | 34.2925 | 34.2925 | 34.2925 | 400.0 |
| 2017-02-28 08:13:00 | AAPL | Stock | 34.2925 | 34.2925 | 34.2925 | 34.2925 | 3200.0 |
| 2017-02-28 08:14:00 | AAPL | Stock | 34.2925 | 34.2925 | 34.2925 | 34.2925 | 400.0 |
| 2017-02-28 08:16:00 | AAPL | Stock | 34.28 | 34.28 | 34.2775 | 34.2775 | 6792.0 |
| 2017-02-28 08:19:00 | AAPL | Stock | 34.2775 | 34.2775 | 34.2375 | 34.25 | 45940.0 |
| 2017-02-28 08:20:00 | AAPL | Stock | 34.25 | 34.25 | 34.25 | 34.25 | 1584.0 |
| 2017-02-28 08:21:00 | AAPL | Stock | 34.25 | 34.25 | 34.25 | 34.25 | 33260.0 |
| 2017-02-28 08:23:00 | AAPL | Stock | 34.2725 | 34.275 | 34.25 | 34.2525 | 8000.0 |
| 2017-02-28 08:28:00 | AAPL | Stock | 34.2725 | 34.2725 | 34.2725 | 34.2725 | 1800.0 |
| 2017-02-28 08:35:00 | AAPL | Stock | 34.265 | 34.265 | 34.265 | 34.265 | 440.0 |
| 2017-02-28 08:37:00 | AAPL | Stock | 34.2575 | 34.2575 | 34.2525 | 34.2525 | 4000.0 |
> showing 50 of 1,096,735 rows — these rows as CSV