PREVIEW / stock_1min / 2019-09-23
file: by_date/stock_1min/2019/2019-09-23.parquet size: 15.3 MB rows: 1,089,713 symbols: 2,168
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-09-23 04:03:00 | AAPL | Stock | 54.5625 | 54.7225 | 54.545 | 54.545 | 1716.0 |
| 2019-09-23 04:05:00 | AAPL | Stock | 54.5 | 54.5 | 54.5 | 54.5 | 480.0 |
| 2019-09-23 04:06:00 | AAPL | Stock | 54.53 | 54.53 | 54.53 | 54.53 | 800.0 |
| 2019-09-23 04:15:00 | AAPL | Stock | 54.5 | 54.5 | 54.5 | 54.5 | 800.0 |
| 2019-09-23 04:18:00 | AAPL | Stock | 54.475 | 54.475 | 54.4325 | 54.4325 | 6224.0 |
| 2019-09-23 04:19:00 | AAPL | Stock | 54.445 | 54.445 | 54.445 | 54.445 | 10268.0 |
| 2019-09-23 04:35:00 | AAPL | Stock | 54.435 | 54.435 | 54.435 | 54.435 | 4400.0 |
| 2019-09-23 04:37:00 | AAPL | Stock | 54.375 | 54.375 | 54.375 | 54.375 | 1840.0 |
| 2019-09-23 04:57:00 | AAPL | Stock | 54.355 | 54.355 | 54.355 | 54.355 | 400.0 |
| 2019-09-23 04:59:00 | AAPL | Stock | 54.35 | 54.35 | 54.35 | 54.35 | 1732.0 |
| 2019-09-23 05:00:00 | AAPL | Stock | 54.35 | 54.35 | 54.35 | 54.35 | 2800.0 |
| 2019-09-23 05:01:00 | AAPL | Stock | 54.35 | 54.3625 | 54.35 | 54.3625 | 4796.0 |
| 2019-09-23 05:03:00 | AAPL | Stock | 54.35 | 54.35 | 54.35 | 54.35 | 800.0 |
| 2019-09-23 05:57:00 | AAPL | Stock | 54.5275 | 54.5275 | 54.5275 | 54.5275 | 400.0 |
| 2019-09-23 06:20:00 | AAPL | Stock | 54.5625 | 54.5625 | 54.5625 | 54.5625 | 400.0 |
| 2019-09-23 06:30:00 | AAPL | Stock | 54.5625 | 54.5625 | 54.5625 | 54.5625 | 3996.0 |
| 2019-09-23 06:43:00 | AAPL | Stock | 54.61 | 54.61 | 54.61 | 54.61 | 920.0 |
| 2019-09-23 06:47:00 | AAPL | Stock | 54.61 | 54.6175 | 54.515 | 54.515 | 9232.0 |
| 2019-09-23 07:00:00 | AAPL | Stock | 54.65 | 54.65 | 54.65 | 54.65 | 800.0 |
| 2019-09-23 07:02:00 | AAPL | Stock | 54.6825 | 54.6825 | 54.675 | 54.675 | 1568.0 |
| 2019-09-23 07:03:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7 | 54.7125 | 4280.0 |
| 2019-09-23 07:04:00 | AAPL | Stock | 54.7125 | 54.7175 | 54.6925 | 54.7175 | 4932.0 |
| 2019-09-23 07:05:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 1600.0 |
| 2019-09-23 07:06:00 | AAPL | Stock | 54.7 | 54.7125 | 54.7 | 54.7125 | 8700.0 |
| 2019-09-23 07:07:00 | AAPL | Stock | 54.71 | 54.71 | 54.71 | 54.71 | 400.0 |
| 2019-09-23 07:08:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 400.0 |
| 2019-09-23 07:09:00 | AAPL | Stock | 54.7 | 54.7 | 54.5975 | 54.5975 | 27368.0 |
| 2019-09-23 07:10:00 | AAPL | Stock | 54.6175 | 54.625 | 54.6175 | 54.625 | 1800.0 |
| 2019-09-23 07:11:00 | AAPL | Stock | 54.6225 | 54.6225 | 54.6225 | 54.6225 | 800.0 |
| 2019-09-23 07:13:00 | AAPL | Stock | 54.5875 | 54.5875 | 54.5875 | 54.5875 | 1200.0 |
| 2019-09-23 07:14:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 1824.0 |
| 2019-09-23 07:17:00 | AAPL | Stock | 54.5875 | 54.5875 | 54.56 | 54.5625 | 25080.0 |
| 2019-09-23 07:18:00 | AAPL | Stock | 54.5625 | 54.5625 | 54.5175 | 54.555 | 4320.0 |
| 2019-09-23 07:22:00 | AAPL | Stock | 54.525 | 54.525 | 54.525 | 54.525 | 976.0 |
| 2019-09-23 07:24:00 | AAPL | Stock | 54.5925 | 54.5925 | 54.5925 | 54.5925 | 436.0 |
| 2019-09-23 07:27:00 | AAPL | Stock | 54.5625 | 54.5625 | 54.5625 | 54.5625 | 400.0 |
| 2019-09-23 07:28:00 | AAPL | Stock | 54.5875 | 54.5925 | 54.5875 | 54.5925 | 800.0 |
| 2019-09-23 07:30:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 1328.0 |
| 2019-09-23 07:31:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 1300.0 |
| 2019-09-23 07:33:00 | AAPL | Stock | 54.6125 | 54.6125 | 54.6125 | 54.6125 | 2800.0 |
| 2019-09-23 07:36:00 | AAPL | Stock | 54.595 | 54.6 | 54.5725 | 54.5725 | 6388.0 |
| 2019-09-23 07:37:00 | AAPL | Stock | 54.5725 | 54.5725 | 54.5725 | 54.5725 | 2000.0 |
| 2019-09-23 07:38:00 | AAPL | Stock | 54.575 | 54.575 | 54.5625 | 54.5625 | 8368.0 |
| 2019-09-23 07:41:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 1808.0 |
| 2019-09-23 07:42:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 1600.0 |
| 2019-09-23 07:43:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 2400.0 |
| 2019-09-23 07:46:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 400.0 |
| 2019-09-23 07:49:00 | AAPL | Stock | 54.55 | 54.55 | 54.5375 | 54.5375 | 8000.0 |
| 2019-09-23 07:50:00 | AAPL | Stock | 54.5375 | 54.5375 | 54.5375 | 54.5375 | 4000.0 |
| 2019-09-23 07:52:00 | AAPL | Stock | 54.5375 | 54.5375 | 54.5375 | 54.5375 | 1320.0 |
> showing 50 of 1,089,713 rows — these rows as CSV