PREVIEW / stock_1min / 2019-01-23
file: by_date/stock_1min/2019/2019-01-23.parquet size: 15.2 MB rows: 1,080,583 symbols: 2,250
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-23 04:34:00 | AAPL | Stock | 38.4475 | 38.4475 | 38.4475 | 38.4475 | 796.0 |
| 2019-01-23 04:59:00 | AAPL | Stock | 38.4475 | 38.4475 | 38.4475 | 38.4475 | 516.0 |
| 2019-01-23 06:08:00 | AAPL | Stock | 38.435 | 38.4875 | 38.435 | 38.4875 | 1120.0 |
| 2019-01-23 06:18:00 | AAPL | Stock | 38.485 | 38.485 | 38.47 | 38.47 | 1200.0 |
| 2019-01-23 06:19:00 | AAPL | Stock | 38.4175 | 38.4175 | 38.4125 | 38.4125 | 2400.0 |
| 2019-01-23 06:22:00 | AAPL | Stock | 38.4 | 38.4 | 38.4 | 38.4 | 2380.0 |
| 2019-01-23 06:50:00 | AAPL | Stock | 38.425 | 38.4725 | 38.425 | 38.4725 | 2800.0 |
| 2019-01-23 06:51:00 | AAPL | Stock | 38.45 | 38.45 | 38.45 | 38.45 | 400.0 |
| 2019-01-23 06:52:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 7768.0 |
| 2019-01-23 06:59:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 940.0 |
| 2019-01-23 07:00:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 6036.0 |
| 2019-01-23 07:01:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 1200.0 |
| 2019-01-23 07:02:00 | AAPL | Stock | 38.5025 | 38.5025 | 38.5025 | 38.5025 | 400.0 |
| 2019-01-23 07:03:00 | AAPL | Stock | 38.4875 | 38.4875 | 38.4875 | 38.4875 | 4000.0 |
| 2019-01-23 07:04:00 | AAPL | Stock | 38.5125 | 38.5225 | 38.5125 | 38.5225 | 1440.0 |
| 2019-01-23 07:12:00 | AAPL | Stock | 38.5375 | 38.5475 | 38.5375 | 38.5425 | 20600.0 |
| 2019-01-23 07:13:00 | AAPL | Stock | 38.5425 | 38.5425 | 38.5425 | 38.5425 | 1200.0 |
| 2019-01-23 07:14:00 | AAPL | Stock | 38.5425 | 38.5425 | 38.5175 | 38.5175 | 3200.0 |
| 2019-01-23 07:15:00 | AAPL | Stock | 38.545 | 38.545 | 38.545 | 38.545 | 1200.0 |
| 2019-01-23 07:16:00 | AAPL | Stock | 38.585 | 38.5875 | 38.585 | 38.5875 | 1200.0 |
| 2019-01-23 07:17:00 | AAPL | Stock | 38.575 | 38.575 | 38.575 | 38.575 | 400.0 |
| 2019-01-23 07:18:00 | AAPL | Stock | 38.54 | 38.57 | 38.525 | 38.57 | 4000.0 |
| 2019-01-23 07:19:00 | AAPL | Stock | 38.57 | 38.57 | 38.57 | 38.57 | 400.0 |
| 2019-01-23 07:20:00 | AAPL | Stock | 38.54 | 38.54 | 38.54 | 38.54 | 1180.0 |
| 2019-01-23 07:23:00 | AAPL | Stock | 38.55 | 38.55 | 38.55 | 38.55 | 780.0 |
| 2019-01-23 07:24:00 | AAPL | Stock | 38.575 | 38.575 | 38.575 | 38.575 | 3200.0 |
| 2019-01-23 07:26:00 | AAPL | Stock | 38.575 | 38.575 | 38.575 | 38.575 | 584.0 |
| 2019-01-23 07:30:00 | AAPL | Stock | 38.575 | 38.5875 | 38.575 | 38.5875 | 4600.0 |
| 2019-01-23 07:31:00 | AAPL | Stock | 38.58 | 38.5875 | 38.5675 | 38.5675 | 4192.0 |
| 2019-01-23 07:32:00 | AAPL | Stock | 38.575 | 38.575 | 38.575 | 38.575 | 400.0 |
| 2019-01-23 07:33:00 | AAPL | Stock | 38.5675 | 38.5675 | 38.5625 | 38.5625 | 1192.0 |
| 2019-01-23 07:36:00 | AAPL | Stock | 38.5675 | 38.5775 | 38.5675 | 38.5775 | 5220.0 |
| 2019-01-23 07:41:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 400.0 |
| 2019-01-23 07:48:00 | AAPL | Stock | 38.5625 | 38.5625 | 38.5625 | 38.5625 | 400.0 |
| 2019-01-23 07:49:00 | AAPL | Stock | 38.515 | 38.515 | 38.5075 | 38.5075 | 1316.0 |
| 2019-01-23 07:50:00 | AAPL | Stock | 38.5575 | 38.56 | 38.5125 | 38.5125 | 5324.0 |
| 2019-01-23 07:51:00 | AAPL | Stock | 38.515 | 38.515 | 38.515 | 38.515 | 404.0 |
| 2019-01-23 07:52:00 | AAPL | Stock | 38.5325 | 38.5325 | 38.5325 | 38.5325 | 400.0 |
| 2019-01-23 07:55:00 | AAPL | Stock | 38.525 | 38.5325 | 38.525 | 38.5325 | 800.0 |
| 2019-01-23 07:56:00 | AAPL | Stock | 38.5375 | 38.5375 | 38.5375 | 38.5375 | 800.0 |
| 2019-01-23 07:57:00 | AAPL | Stock | 38.5375 | 38.5375 | 38.5375 | 38.5375 | 400.0 |
| 2019-01-23 07:58:00 | AAPL | Stock | 38.5275 | 38.5275 | 38.5225 | 38.5275 | 6000.0 |
| 2019-01-23 07:59:00 | AAPL | Stock | 38.5275 | 38.5275 | 38.5275 | 38.5275 | 888.0 |
| 2019-01-23 08:00:00 | AAPL | Stock | 38.5 | 38.595 | 38.5 | 38.5375 | 45228.0 |
| 2019-01-23 08:01:00 | AAPL | Stock | 38.5275 | 38.5598 | 38.5275 | 38.5598 | 6712.0 |
| 2019-01-23 08:02:00 | AAPL | Stock | 38.54 | 38.56 | 38.54 | 38.55 | 4220.0 |
| 2019-01-23 08:04:00 | AAPL | Stock | 38.55 | 38.55 | 38.55 | 38.55 | 800.0 |
| 2019-01-23 08:05:00 | AAPL | Stock | 38.5425 | 38.5425 | 38.5425 | 38.5425 | 400.0 |
| 2019-01-23 08:06:00 | AAPL | Stock | 38.5425 | 38.5425 | 38.5425 | 38.5425 | 2000.0 |
| 2019-01-23 08:07:00 | AAPL | Stock | 38.53 | 38.5575 | 38.53 | 38.5575 | 800.0 |
> showing 50 of 1,080,583 rows — these rows as CSV