PREVIEW / stock_1min / 2017-06-01
file: by_date/stock_1min/2017/2017-06-01.parquet size: 15.0 MB rows: 1,081,116 symbols: 2,511
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-06-01 04:01:00 | AAPL | Stock | 38.25 | 38.25 | 38.25 | 38.25 | 2800.0 |
| 2017-06-01 04:14:00 | AAPL | Stock | 38.2875 | 38.3 | 38.2875 | 38.3 | 4400.0 |
| 2017-06-01 04:29:00 | AAPL | Stock | 38.3225 | 38.325 | 38.3225 | 38.325 | 2400.0 |
| 2017-06-01 04:36:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 800.0 |
| 2017-06-01 04:37:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 3600.0 |
| 2017-06-01 05:42:00 | AAPL | Stock | 38.35 | 38.35 | 38.35 | 38.35 | 2980.0 |
| 2017-06-01 05:43:00 | AAPL | Stock | 38.35 | 38.35 | 38.35 | 38.35 | 2400.0 |
| 2017-06-01 07:04:00 | AAPL | Stock | 38.345 | 38.345 | 38.345 | 38.345 | 1200.0 |
| 2017-06-01 07:05:00 | AAPL | Stock | 38.335 | 38.3375 | 38.335 | 38.3375 | 2584.0 |
| 2017-06-01 07:07:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 400.0 |
| 2017-06-01 07:09:00 | AAPL | Stock | 38.345 | 38.345 | 38.3425 | 38.3425 | 5600.0 |
| 2017-06-01 07:10:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 800.0 |
| 2017-06-01 07:19:00 | AAPL | Stock | 38.325 | 38.325 | 38.3225 | 38.3225 | 1484.0 |
| 2017-06-01 07:24:00 | AAPL | Stock | 38.3125 | 38.3125 | 38.3125 | 38.3125 | 400.0 |
| 2017-06-01 07:47:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 400.0 |
| 2017-06-01 07:49:00 | AAPL | Stock | 38.2975 | 38.31 | 38.2975 | 38.31 | 1720.0 |
| 2017-06-01 07:53:00 | AAPL | Stock | 38.2875 | 38.2875 | 38.2875 | 38.2875 | 400.0 |
| 2017-06-01 08:00:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.28 | 38.3 | 18992.0 |
| 2017-06-01 08:01:00 | AAPL | Stock | 38.28 | 38.28 | 38.28 | 38.28 | 20000.0 |
| 2017-06-01 08:02:00 | AAPL | Stock | 38.19 | 38.19 | 38.19 | 38.19 | 119936.0 |
| 2017-06-01 08:09:00 | AAPL | Stock | 38.2875 | 38.2875 | 38.2875 | 38.2875 | 8400.0 |
| 2017-06-01 08:10:00 | AAPL | Stock | 38.31 | 38.31 | 38.31 | 38.31 | 9840.0 |
| 2017-06-01 08:15:00 | AAPL | Stock | 38.31 | 38.31 | 38.31 | 38.31 | 448.0 |
| 2017-06-01 08:16:00 | AAPL | Stock | 38.31 | 38.33 | 38.31 | 38.33 | 11148.0 |
| 2017-06-01 08:18:00 | AAPL | Stock | 38.3325 | 38.335 | 38.3325 | 38.335 | 9820.0 |
| 2017-06-01 08:20:00 | AAPL | Stock | 38.335 | 38.335 | 38.335 | 38.335 | 1400.0 |
| 2017-06-01 08:21:00 | AAPL | Stock | 38.335 | 38.3375 | 38.335 | 38.3375 | 7036.0 |
| 2017-06-01 08:25:00 | AAPL | Stock | 38.3375 | 38.34 | 38.3375 | 38.34 | 4400.0 |
| 2017-06-01 08:26:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 800.0 |
| 2017-06-01 08:27:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 400.0 |
| 2017-06-01 08:29:00 | AAPL | Stock | 38.3475 | 38.3475 | 38.3475 | 38.3475 | 632.0 |
| 2017-06-01 08:30:00 | AAPL | Stock | 38.3475 | 38.3475 | 38.3475 | 38.3475 | 800.0 |
| 2017-06-01 08:32:00 | AAPL | Stock | 38.335 | 38.335 | 38.33 | 38.33 | 800.0 |
| 2017-06-01 08:33:00 | AAPL | Stock | 38.33 | 38.33 | 38.33 | 38.33 | 800.0 |
| 2017-06-01 08:36:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 400.0 |
| 2017-06-01 08:37:00 | AAPL | Stock | 38.3325 | 38.3475 | 38.3325 | 38.3475 | 2800.0 |
| 2017-06-01 08:39:00 | AAPL | Stock | 38.325 | 38.325 | 38.325 | 38.325 | 400.0 |
| 2017-06-01 08:40:00 | AAPL | Stock | 38.315 | 38.315 | 38.315 | 38.315 | 800.0 |
| 2017-06-01 08:41:00 | AAPL | Stock | 38.315 | 38.315 | 38.315 | 38.315 | 588.0 |
| 2017-06-01 08:44:00 | AAPL | Stock | 38.315 | 38.315 | 38.3125 | 38.3125 | 12072.0 |
| 2017-06-01 08:46:00 | AAPL | Stock | 38.3125 | 38.3125 | 38.3125 | 38.3125 | 2000.0 |
| 2017-06-01 08:48:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 4008.0 |
| 2017-06-01 08:55:00 | AAPL | Stock | 38.3025 | 38.3025 | 38.275 | 38.275 | 19436.0 |
| 2017-06-01 08:56:00 | AAPL | Stock | 38.275 | 38.3125 | 38.2675 | 38.2675 | 14768.0 |
| 2017-06-01 09:03:00 | AAPL | Stock | 38.315 | 38.3175 | 38.315 | 38.315 | 1200.0 |
| 2017-06-01 09:09:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.3075 | 38.3075 | 480.0 |
| 2017-06-01 09:10:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.3075 | 38.3075 | 424.0 |
| 2017-06-01 09:11:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 2000.0 |
| 2017-06-01 09:13:00 | AAPL | Stock | 38.3025 | 38.3025 | 38.3025 | 38.3025 | 520.0 |
| 2017-06-01 09:16:00 | AAPL | Stock | 38.2925 | 38.2925 | 38.2925 | 38.2925 | 400.0 |
> showing 50 of 1,081,116 rows — these rows as CSV