PREVIEW / stock_1min / 2020-08-27
file: by_date/stock_1min/2020/2020-08-27.parquet size: 19.9 MB rows: 1,240,913 symbols: 2,067
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-27 04:00:00 | AAPL | Stock | 126.5275 | 126.5925 | 126.5275 | 126.5925 | 3064.0 |
| 2020-08-27 04:04:00 | AAPL | Stock | 126.6 | 126.645 | 126.6 | 126.645 | 916.0 |
| 2020-08-27 04:05:00 | AAPL | Stock | 126.6 | 126.625 | 126.5 | 126.5 | 6660.0 |
| 2020-08-27 04:06:00 | AAPL | Stock | 126.43 | 126.4325 | 126.43 | 126.43 | 3832.0 |
| 2020-08-27 04:09:00 | AAPL | Stock | 126.4625 | 126.4625 | 126.4625 | 126.4625 | 624.0 |
| 2020-08-27 04:21:00 | AAPL | Stock | 126.3825 | 126.3825 | 126.3825 | 126.3825 | 400.0 |
| 2020-08-27 04:26:00 | AAPL | Stock | 126.425 | 126.425 | 126.425 | 126.425 | 400.0 |
| 2020-08-27 04:46:00 | AAPL | Stock | 126.4175 | 126.48 | 126.4175 | 126.48 | 1512.0 |
| 2020-08-27 04:50:00 | AAPL | Stock | 126.4225 | 126.4225 | 126.4225 | 126.4225 | 400.0 |
| 2020-08-27 04:52:00 | AAPL | Stock | 126.4225 | 126.4225 | 126.4225 | 126.4225 | 400.0 |
| 2020-08-27 05:00:00 | AAPL | Stock | 126.36 | 126.36 | 126.36 | 126.36 | 1200.0 |
| 2020-08-27 05:03:00 | AAPL | Stock | 126.2575 | 126.2575 | 126.2575 | 126.2575 | 400.0 |
| 2020-08-27 05:06:00 | AAPL | Stock | 126.2575 | 126.2575 | 126.2575 | 126.2575 | 400.0 |
| 2020-08-27 05:19:00 | AAPL | Stock | 126.2025 | 126.2025 | 126.155 | 126.155 | 4112.0 |
| 2020-08-27 05:21:00 | AAPL | Stock | 126.1175 | 126.12 | 126.1175 | 126.12 | 1200.0 |
| 2020-08-27 05:26:00 | AAPL | Stock | 126.05 | 126.05 | 126.05 | 126.05 | 728.0 |
| 2020-08-27 05:28:00 | AAPL | Stock | 126.005 | 126.005 | 126.005 | 126.005 | 400.0 |
| 2020-08-27 05:35:00 | AAPL | Stock | 126.245 | 126.26 | 126.245 | 126.26 | 800.0 |
| 2020-08-27 05:45:00 | AAPL | Stock | 126.225 | 126.225 | 126.225 | 126.225 | 640.0 |
| 2020-08-27 05:46:00 | AAPL | Stock | 126.245 | 126.2475 | 126.245 | 126.2475 | 800.0 |
| 2020-08-27 05:51:00 | AAPL | Stock | 126.25 | 126.25 | 126.2075 | 126.2075 | 800.0 |
| 2020-08-27 05:52:00 | AAPL | Stock | 126.245 | 126.245 | 126.245 | 126.245 | 1360.0 |
| 2020-08-27 05:55:00 | AAPL | Stock | 126.285 | 126.325 | 126.285 | 126.325 | 812.0 |
| 2020-08-27 06:00:00 | AAPL | Stock | 126.325 | 126.325 | 126.325 | 126.325 | 5296.0 |
| 2020-08-27 06:05:00 | AAPL | Stock | 126.2925 | 126.2925 | 126.2925 | 126.2925 | 800.0 |
| 2020-08-27 06:13:00 | AAPL | Stock | 126.37 | 126.37 | 126.37 | 126.37 | 400.0 |
| 2020-08-27 06:17:00 | AAPL | Stock | 126.325 | 126.325 | 126.325 | 126.325 | 408.0 |
| 2020-08-27 06:21:00 | AAPL | Stock | 126.325 | 126.325 | 126.325 | 126.325 | 588.0 |
| 2020-08-27 06:28:00 | AAPL | Stock | 126.305 | 126.305 | 126.305 | 126.305 | 400.0 |
| 2020-08-27 06:29:00 | AAPL | Stock | 126.3625 | 126.3625 | 126.3625 | 126.3625 | 652.0 |
| 2020-08-27 06:30:00 | AAPL | Stock | 126.355 | 126.355 | 126.35 | 126.35 | 904.0 |
| 2020-08-27 06:38:00 | AAPL | Stock | 126.3575 | 126.3575 | 126.3575 | 126.3575 | 1212.0 |
| 2020-08-27 06:39:00 | AAPL | Stock | 126.375 | 126.375 | 126.375 | 126.375 | 7128.0 |
| 2020-08-27 06:49:00 | AAPL | Stock | 126.375 | 126.375 | 126.375 | 126.375 | 640.0 |
| 2020-08-27 06:54:00 | AAPL | Stock | 126.35 | 126.35 | 126.35 | 126.35 | 600.0 |
| 2020-08-27 06:59:00 | AAPL | Stock | 126.375 | 126.375 | 126.375 | 126.375 | 6584.0 |
| 2020-08-27 07:00:00 | AAPL | Stock | 126.375 | 126.375 | 126.29 | 126.3525 | 19628.0 |
| 2020-08-27 07:01:00 | AAPL | Stock | 126.4025 | 126.4375 | 126.4025 | 126.4375 | 5116.0 |
| 2020-08-27 07:02:00 | AAPL | Stock | 126.35 | 126.5075 | 126.345 | 126.5075 | 15924.0 |
| 2020-08-27 07:03:00 | AAPL | Stock | 126.5225 | 126.56 | 126.4975 | 126.56 | 20552.0 |
| 2020-08-27 07:04:00 | AAPL | Stock | 126.5025 | 126.5875 | 126.4975 | 126.5875 | 11020.0 |
| 2020-08-27 07:05:00 | AAPL | Stock | 126.55 | 126.575 | 126.54 | 126.54 | 3516.0 |
| 2020-08-27 07:06:00 | AAPL | Stock | 126.55 | 126.55 | 126.55 | 126.55 | 400.0 |
| 2020-08-27 07:07:00 | AAPL | Stock | 126.5625 | 126.575 | 126.5625 | 126.575 | 2796.0 |
| 2020-08-27 07:08:00 | AAPL | Stock | 126.5725 | 126.595 | 126.5725 | 126.595 | 12348.0 |
| 2020-08-27 07:09:00 | AAPL | Stock | 126.595 | 126.595 | 126.595 | 126.595 | 460.0 |
| 2020-08-27 07:10:00 | AAPL | Stock | 126.625 | 126.8 | 126.625 | 126.7375 | 24488.0 |
| 2020-08-27 07:12:00 | AAPL | Stock | 126.7625 | 126.85 | 126.755 | 126.8475 | 7500.0 |
| 2020-08-27 07:13:00 | AAPL | Stock | 126.825 | 126.875 | 126.8 | 126.8675 | 16896.0 |
| 2020-08-27 07:14:00 | AAPL | Stock | 126.875 | 126.9 | 126.8 | 126.9 | 17144.0 |
> showing 50 of 1,240,913 rows — these rows as CSV