PREVIEW / stock_1min / 2018-09-13
file: by_date/stock_1min/2018/2018-09-13.parquet size: 14.7 MB rows: 1,043,842 symbols: 2,332
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-13 04:00:00 | AAPL | Stock | 55.425 | 55.425 | 55.375 | 55.375 | 1620.0 |
| 2018-09-13 04:02:00 | AAPL | Stock | 55.45 | 55.45 | 55.45 | 55.45 | 800.0 |
| 2018-09-13 04:12:00 | AAPL | Stock | 55.4875 | 55.4875 | 55.4875 | 55.4875 | 3788.0 |
| 2018-09-13 04:13:00 | AAPL | Stock | 55.4875 | 55.5 | 55.4875 | 55.5 | 5540.0 |
| 2018-09-13 04:18:00 | AAPL | Stock | 55.5 | 55.5 | 55.5 | 55.5 | 784.0 |
| 2018-09-13 04:35:00 | AAPL | Stock | 55.5 | 55.5 | 55.4975 | 55.4975 | 860.0 |
| 2018-09-13 04:49:00 | AAPL | Stock | 55.4375 | 55.4375 | 55.4375 | 55.4375 | 800.0 |
| 2018-09-13 04:51:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 1200.0 |
| 2018-09-13 04:52:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 12000.0 |
| 2018-09-13 04:59:00 | AAPL | Stock | 55.4975 | 55.4975 | 55.4975 | 55.4975 | 800.0 |
| 2018-09-13 05:06:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 3744.0 |
| 2018-09-13 05:07:00 | AAPL | Stock | 55.4625 | 55.5 | 55.4625 | 55.4625 | 8332.0 |
| 2018-09-13 05:20:00 | AAPL | Stock | 55.5 | 55.5 | 55.4625 | 55.4625 | 6784.0 |
| 2018-09-13 05:21:00 | AAPL | Stock | 55.4625 | 55.4625 | 55.4625 | 55.4625 | 400.0 |
| 2018-09-13 05:22:00 | AAPL | Stock | 55.425 | 55.425 | 55.425 | 55.425 | 3200.0 |
| 2018-09-13 05:27:00 | AAPL | Stock | 55.46 | 55.46 | 55.46 | 55.46 | 680.0 |
| 2018-09-13 05:28:00 | AAPL | Stock | 55.3875 | 55.4 | 55.3875 | 55.3875 | 2000.0 |
| 2018-09-13 05:33:00 | AAPL | Stock | 55.375 | 55.38 | 55.375 | 55.375 | 44800.0 |
| 2018-09-13 05:34:00 | AAPL | Stock | 55.2525 | 55.255 | 55.25 | 55.25 | 2716.0 |
| 2018-09-13 05:36:00 | AAPL | Stock | 55.35 | 55.35 | 55.35 | 55.35 | 800.0 |
| 2018-09-13 05:37:00 | AAPL | Stock | 55.35 | 55.35 | 55.3325 | 55.3325 | 3000.0 |
| 2018-09-13 05:38:00 | AAPL | Stock | 55.385 | 55.385 | 55.385 | 55.385 | 4000.0 |
| 2018-09-13 05:39:00 | AAPL | Stock | 55.385 | 55.385 | 55.35 | 55.35 | 11380.0 |
| 2018-09-13 05:40:00 | AAPL | Stock | 55.3375 | 55.3375 | 55.325 | 55.325 | 14292.0 |
| 2018-09-13 05:42:00 | AAPL | Stock | 55.3275 | 55.3275 | 55.325 | 55.325 | 3620.0 |
| 2018-09-13 05:44:00 | AAPL | Stock | 55.325 | 55.325 | 55.325 | 55.325 | 760.0 |
| 2018-09-13 05:47:00 | AAPL | Stock | 55.35 | 55.35 | 55.35 | 55.35 | 4000.0 |
| 2018-09-13 05:49:00 | AAPL | Stock | 55.35 | 55.35 | 55.325 | 55.325 | 7148.0 |
| 2018-09-13 05:50:00 | AAPL | Stock | 55.3225 | 55.3225 | 55.3225 | 55.3225 | 3000.0 |
| 2018-09-13 05:51:00 | AAPL | Stock | 55.325 | 55.325 | 55.325 | 55.325 | 1396.0 |
| 2018-09-13 06:01:00 | AAPL | Stock | 55.375 | 55.4 | 55.375 | 55.4 | 2600.0 |
| 2018-09-13 06:05:00 | AAPL | Stock | 55.43 | 55.43 | 55.43 | 55.43 | 1120.0 |
| 2018-09-13 06:08:00 | AAPL | Stock | 55.43 | 55.43 | 55.43 | 55.43 | 800.0 |
| 2018-09-13 06:10:00 | AAPL | Stock | 55.4 | 55.4 | 55.4 | 55.4 | 800.0 |
| 2018-09-13 06:17:00 | AAPL | Stock | 55.435 | 55.46 | 55.43 | 55.4525 | 12072.0 |
| 2018-09-13 06:20:00 | AAPL | Stock | 55.4375 | 55.4375 | 55.4375 | 55.4375 | 820.0 |
| 2018-09-13 06:21:00 | AAPL | Stock | 55.4625 | 55.465 | 55.4625 | 55.465 | 4516.0 |
| 2018-09-13 06:25:00 | AAPL | Stock | 55.4925 | 55.4975 | 55.4925 | 55.4975 | 3772.0 |
| 2018-09-13 06:26:00 | AAPL | Stock | 55.495 | 55.495 | 55.495 | 55.495 | 724.0 |
| 2018-09-13 06:27:00 | AAPL | Stock | 55.4975 | 55.4975 | 55.4975 | 55.4975 | 4656.0 |
| 2018-09-13 06:38:00 | AAPL | Stock | 55.525 | 55.525 | 55.525 | 55.525 | 400.0 |
| 2018-09-13 06:39:00 | AAPL | Stock | 55.53 | 55.53 | 55.525 | 55.525 | 1600.0 |
| 2018-09-13 06:43:00 | AAPL | Stock | 55.55 | 55.575 | 55.55 | 55.575 | 1492.0 |
| 2018-09-13 06:46:00 | AAPL | Stock | 55.5925 | 55.6 | 55.5925 | 55.5925 | 1256.0 |
| 2018-09-13 06:50:00 | AAPL | Stock | 55.575 | 55.575 | 55.575 | 55.575 | 800.0 |
| 2018-09-13 06:51:00 | AAPL | Stock | 55.575 | 55.575 | 55.575 | 55.575 | 400.0 |
| 2018-09-13 06:53:00 | AAPL | Stock | 55.565 | 55.565 | 55.565 | 55.565 | 400.0 |
| 2018-09-13 06:54:00 | AAPL | Stock | 55.5775 | 55.625 | 55.5775 | 55.625 | 22124.0 |
| 2018-09-13 06:56:00 | AAPL | Stock | 55.625 | 55.625 | 55.625 | 55.625 | 1120.0 |
| 2018-09-13 06:59:00 | AAPL | Stock | 55.6175 | 55.6175 | 55.6175 | 55.6175 | 1200.0 |
> showing 50 of 1,043,842 rows — these rows as CSV