PREVIEW / stock_1min / 2021-08-19
file: by_date/stock_1min/2021/2021-08-19.parquet size: 23.9 MB rows: 1,401,844 symbols: 2,395
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 |
|---|---|---|---|---|---|---|---|
| 2021-08-19 04:00:00 | AAPL | Stock | 145.66 | 145.66 | 145.04 | 145.35 | 8231.0 |
| 2021-08-19 04:01:00 | AAPL | Stock | 145.3 | 145.36 | 145.1 | 145.22 | 1475.0 |
| 2021-08-19 04:02:00 | AAPL | Stock | 145.23 | 145.23 | 145.2 | 145.2 | 452.0 |
| 2021-08-19 04:03:00 | AAPL | Stock | 145.1 | 145.1 | 144.84 | 144.84 | 2768.0 |
| 2021-08-19 04:04:00 | AAPL | Stock | 144.66 | 144.76 | 144.45 | 144.6 | 3985.0 |
| 2021-08-19 04:05:00 | AAPL | Stock | 144.69 | 144.71 | 144.6 | 144.65 | 9874.0 |
| 2021-08-19 04:06:00 | AAPL | Stock | 144.61 | 144.71 | 144.61 | 144.71 | 448.0 |
| 2021-08-19 04:07:00 | AAPL | Stock | 144.69 | 144.71 | 144.69 | 144.71 | 253.0 |
| 2021-08-19 04:08:00 | AAPL | Stock | 144.74 | 144.77 | 144.74 | 144.77 | 1992.0 |
| 2021-08-19 04:09:00 | AAPL | Stock | 144.85 | 144.97 | 144.85 | 144.97 | 1176.0 |
| 2021-08-19 04:10:00 | AAPL | Stock | 144.84 | 144.84 | 144.84 | 144.84 | 402.0 |
| 2021-08-19 04:11:00 | AAPL | Stock | 144.84 | 144.84 | 144.84 | 144.84 | 100.0 |
| 2021-08-19 04:12:00 | AAPL | Stock | 144.81 | 144.88 | 144.81 | 144.88 | 674.0 |
| 2021-08-19 04:13:00 | AAPL | Stock | 144.84 | 144.84 | 144.67 | 144.67 | 3593.0 |
| 2021-08-19 04:14:00 | AAPL | Stock | 144.71 | 144.75 | 144.71 | 144.75 | 936.0 |
| 2021-08-19 04:15:00 | AAPL | Stock | 144.56 | 144.56 | 144.52 | 144.52 | 1079.0 |
| 2021-08-19 04:16:00 | AAPL | Stock | 144.54 | 144.55 | 144.53 | 144.53 | 405.0 |
| 2021-08-19 04:17:00 | AAPL | Stock | 144.52 | 144.52 | 144.45 | 144.45 | 1027.0 |
| 2021-08-19 04:18:00 | AAPL | Stock | 144.5 | 144.56 | 144.5 | 144.56 | 1568.0 |
| 2021-08-19 04:19:00 | AAPL | Stock | 144.56 | 144.57 | 144.56 | 144.57 | 218.0 |
| 2021-08-19 04:20:00 | AAPL | Stock | 144.51 | 144.51 | 144.51 | 144.51 | 893.0 |
| 2021-08-19 04:21:00 | AAPL | Stock | 144.5 | 144.6 | 144.5 | 144.59 | 1501.0 |
| 2021-08-19 04:23:00 | AAPL | Stock | 144.58 | 144.58 | 144.51 | 144.51 | 813.0 |
| 2021-08-19 04:24:00 | AAPL | Stock | 144.51 | 144.52 | 144.51 | 144.52 | 400.0 |
| 2021-08-19 04:26:00 | AAPL | Stock | 144.5 | 144.5 | 144.5 | 144.5 | 200.0 |
| 2021-08-19 04:27:00 | AAPL | Stock | 144.46 | 144.46 | 144.38 | 144.45 | 1117.0 |
| 2021-08-19 04:28:00 | AAPL | Stock | 144.42 | 144.42 | 144.38 | 144.38 | 862.0 |
| 2021-08-19 04:29:00 | AAPL | Stock | 144.4 | 144.4 | 144.39 | 144.39 | 515.0 |
| 2021-08-19 04:30:00 | AAPL | Stock | 144.5 | 144.5 | 144.5 | 144.5 | 4655.0 |
| 2021-08-19 04:32:00 | AAPL | Stock | 144.48 | 144.55 | 144.48 | 144.5 | 567.0 |
| 2021-08-19 04:33:00 | AAPL | Stock | 144.54 | 144.55 | 144.52 | 144.52 | 602.0 |
| 2021-08-19 04:35:00 | AAPL | Stock | 144.55 | 144.55 | 144.55 | 144.55 | 100.0 |
| 2021-08-19 04:36:00 | AAPL | Stock | 144.53 | 144.55 | 144.53 | 144.53 | 1686.0 |
| 2021-08-19 04:37:00 | AAPL | Stock | 144.56 | 144.56 | 144.56 | 144.56 | 2000.0 |
| 2021-08-19 04:39:00 | AAPL | Stock | 144.64 | 144.65 | 144.62 | 144.65 | 1272.0 |
| 2021-08-19 04:40:00 | AAPL | Stock | 144.68 | 144.68 | 144.66 | 144.66 | 940.0 |
| 2021-08-19 04:41:00 | AAPL | Stock | 144.6 | 144.6 | 144.55 | 144.56 | 2212.0 |
| 2021-08-19 04:42:00 | AAPL | Stock | 144.53 | 144.53 | 144.53 | 144.53 | 700.0 |
| 2021-08-19 04:43:00 | AAPL | Stock | 144.53 | 144.57 | 144.53 | 144.55 | 3554.0 |
| 2021-08-19 04:44:00 | AAPL | Stock | 144.57 | 144.65 | 144.57 | 144.6 | 1926.0 |
| 2021-08-19 04:45:00 | AAPL | Stock | 144.63 | 144.65 | 144.63 | 144.65 | 2185.0 |
| 2021-08-19 04:46:00 | AAPL | Stock | 144.67 | 144.67 | 144.6 | 144.61 | 1922.0 |
| 2021-08-19 04:47:00 | AAPL | Stock | 144.6 | 144.61 | 144.51 | 144.51 | 1261.0 |
| 2021-08-19 04:49:00 | AAPL | Stock | 144.4 | 144.41 | 144.4 | 144.41 | 902.0 |
| 2021-08-19 04:50:00 | AAPL | Stock | 144.42 | 144.42 | 144.42 | 144.42 | 735.0 |
| 2021-08-19 04:51:00 | AAPL | Stock | 144.42 | 144.5 | 144.42 | 144.5 | 471.0 |
| 2021-08-19 04:52:00 | AAPL | Stock | 144.39 | 144.42 | 144.35 | 144.35 | 1179.0 |
| 2021-08-19 04:53:00 | AAPL | Stock | 144.31 | 144.31 | 144.29 | 144.29 | 1306.0 |
| 2021-08-19 04:54:00 | AAPL | Stock | 144.29 | 144.31 | 144.24 | 144.3 | 3210.0 |
| 2021-08-19 04:55:00 | AAPL | Stock | 144.43 | 144.43 | 144.4 | 144.43 | 845.0 |
> showing 50 of 1,401,844 rows — these rows as CSV