PREVIEW / stock_1min / 2018-09-26
file: by_date/stock_1min/2018/2018-09-26.parquet size: 15.3 MB rows: 1,070,594 symbols: 2,333
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-26 04:00:00 | AAPL | Stock | 55.675 | 55.745 | 55.675 | 55.745 | 872.0 |
| 2018-09-26 04:09:00 | AAPL | Stock | 55.6875 | 55.6875 | 55.6875 | 55.6875 | 400.0 |
| 2018-09-26 04:34:00 | AAPL | Stock | 55.7 | 55.7 | 55.7 | 55.7 | 2600.0 |
| 2018-09-26 04:35:00 | AAPL | Stock | 55.6775 | 55.6775 | 55.6775 | 55.6775 | 400.0 |
| 2018-09-26 04:40:00 | AAPL | Stock | 55.7375 | 55.7375 | 55.7375 | 55.7375 | 400.0 |
| 2018-09-26 05:02:00 | AAPL | Stock | 55.6625 | 55.6625 | 55.6625 | 55.6625 | 400.0 |
| 2018-09-26 05:25:00 | AAPL | Stock | 55.665 | 55.665 | 55.665 | 55.665 | 1600.0 |
| 2018-09-26 06:09:00 | AAPL | Stock | 55.7375 | 55.7475 | 55.7375 | 55.7425 | 1600.0 |
| 2018-09-26 06:16:00 | AAPL | Stock | 55.7475 | 55.7475 | 55.7475 | 55.7475 | 1800.0 |
| 2018-09-26 06:37:00 | AAPL | Stock | 55.7 | 55.7 | 55.7 | 55.7 | 400.0 |
| 2018-09-26 06:46:00 | AAPL | Stock | 55.695 | 55.7 | 55.695 | 55.7 | 10648.0 |
| 2018-09-26 06:48:00 | AAPL | Stock | 55.655 | 55.655 | 55.6525 | 55.6525 | 2000.0 |
| 2018-09-26 06:49:00 | AAPL | Stock | 55.6625 | 55.6625 | 55.58 | 55.58 | 5360.0 |
| 2018-09-26 06:50:00 | AAPL | Stock | 55.58 | 55.58 | 55.5075 | 55.5075 | 4400.0 |
| 2018-09-26 06:57:00 | AAPL | Stock | 55.495 | 55.495 | 55.495 | 55.495 | 400.0 |
| 2018-09-26 07:00:00 | AAPL | Stock | 55.4975 | 55.5725 | 55.4975 | 55.57 | 34152.0 |
| 2018-09-26 07:04:00 | AAPL | Stock | 55.51 | 55.51 | 55.5075 | 55.5075 | 800.0 |
| 2018-09-26 07:05:00 | AAPL | Stock | 55.5075 | 55.5075 | 55.5025 | 55.5025 | 2660.0 |
| 2018-09-26 07:06:00 | AAPL | Stock | 55.5025 | 55.505 | 55.5025 | 55.505 | 5852.0 |
| 2018-09-26 07:07:00 | AAPL | Stock | 55.53 | 55.53 | 55.53 | 55.53 | 400.0 |
| 2018-09-26 07:08:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 400.0 |
| 2018-09-26 07:10:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 400.0 |
| 2018-09-26 07:14:00 | AAPL | Stock | 55.57 | 55.57 | 55.57 | 55.57 | 1300.0 |
| 2018-09-26 07:15:00 | AAPL | Stock | 55.5375 | 55.5375 | 55.525 | 55.525 | 7140.0 |
| 2018-09-26 07:16:00 | AAPL | Stock | 55.5275 | 55.56 | 55.5 | 55.5 | 8024.0 |
| 2018-09-26 07:17:00 | AAPL | Stock | 55.5 | 55.5025 | 55.47 | 55.5025 | 8732.0 |
| 2018-09-26 07:19:00 | AAPL | Stock | 55.5175 | 55.5175 | 55.515 | 55.515 | 1856.0 |
| 2018-09-26 07:20:00 | AAPL | Stock | 55.515 | 55.515 | 55.515 | 55.515 | 1200.0 |
| 2018-09-26 07:21:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 400.0 |
| 2018-09-26 07:24:00 | AAPL | Stock | 55.515 | 55.53 | 55.5125 | 55.53 | 4608.0 |
| 2018-09-26 07:25:00 | AAPL | Stock | 55.53 | 55.53 | 55.53 | 55.53 | 656.0 |
| 2018-09-26 07:26:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 400.0 |
| 2018-09-26 07:28:00 | AAPL | Stock | 55.5325 | 55.5325 | 55.5325 | 55.5325 | 656.0 |
| 2018-09-26 07:29:00 | AAPL | Stock | 55.505 | 55.505 | 55.505 | 55.505 | 400.0 |
| 2018-09-26 07:30:00 | AAPL | Stock | 55.51 | 55.53 | 55.5 | 55.5 | 4464.0 |
| 2018-09-26 07:31:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 3200.0 |
| 2018-09-26 07:32:00 | AAPL | Stock | 55.525 | 55.525 | 55.5025 | 55.5025 | 800.0 |
| 2018-09-26 07:37:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 3928.0 |
| 2018-09-26 07:38:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 2184.0 |
| 2018-09-26 07:42:00 | AAPL | Stock | 55.52 | 55.5225 | 55.52 | 55.5225 | 2000.0 |
| 2018-09-26 07:43:00 | AAPL | Stock | 55.5175 | 55.5175 | 55.5175 | 55.5175 | 460.0 |
| 2018-09-26 07:44:00 | AAPL | Stock | 55.5 | 55.5 | 55.475 | 55.475 | 6416.0 |
| 2018-09-26 07:46:00 | AAPL | Stock | 55.4725 | 55.475 | 55.45 | 55.45 | 9744.0 |
| 2018-09-26 07:47:00 | AAPL | Stock | 55.4475 | 55.4475 | 55.4475 | 55.4475 | 400.0 |
| 2018-09-26 07:49:00 | AAPL | Stock | 55.45 | 55.45 | 55.44 | 55.44 | 3484.0 |
| 2018-09-26 07:50:00 | AAPL | Stock | 55.4375 | 55.4375 | 55.4325 | 55.4325 | 800.0 |
| 2018-09-26 07:51:00 | AAPL | Stock | 55.4325 | 55.45 | 55.4125 | 55.44 | 10468.0 |
| 2018-09-26 07:52:00 | AAPL | Stock | 55.4325 | 55.4325 | 55.4325 | 55.4325 | 400.0 |
| 2018-09-26 07:53:00 | AAPL | Stock | 55.465 | 55.475 | 55.465 | 55.475 | 9216.0 |
| 2018-09-26 07:56:00 | AAPL | Stock | 55.475 | 55.475 | 55.475 | 55.475 | 644.0 |
> showing 50 of 1,070,594 rows — these rows as CSV