PREVIEW / stock_1min / 2022-01-14
file: by_date/stock_1min/2022/2022-01-14.parquet size: 23.7 MB rows: 1,396,068 symbols: 2,249
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-14 04:00:00 | AAPL | Stock | 172.2 | 172.2 | 172.2 | 172.2 | 107.0 |
| 2022-01-14 04:01:00 | AAPL | Stock | 172.49 | 172.49 | 172.49 | 172.49 | 226.0 |
| 2022-01-14 04:03:00 | AAPL | Stock | 172.8 | 172.8 | 172.79 | 172.8 | 1245.0 |
| 2022-01-14 04:04:00 | AAPL | Stock | 172.78 | 172.78 | 172.66 | 172.66 | 2049.0 |
| 2022-01-14 04:05:00 | AAPL | Stock | 172.61 | 172.65 | 172.6 | 172.65 | 871.0 |
| 2022-01-14 04:06:00 | AAPL | Stock | 172.55 | 172.56 | 172.55 | 172.56 | 658.0 |
| 2022-01-14 04:07:00 | AAPL | Stock | 172.56 | 172.56 | 172.56 | 172.56 | 107.0 |
| 2022-01-14 04:08:00 | AAPL | Stock | 172.69 | 172.69 | 172.66 | 172.66 | 468.0 |
| 2022-01-14 04:09:00 | AAPL | Stock | 172.42 | 172.5 | 172.33 | 172.33 | 721.0 |
| 2022-01-14 04:10:00 | AAPL | Stock | 172.4 | 172.56 | 172.4 | 172.53 | 1308.0 |
| 2022-01-14 04:11:00 | AAPL | Stock | 172.55 | 172.55 | 172.55 | 172.55 | 201.0 |
| 2022-01-14 04:13:00 | AAPL | Stock | 172.55 | 172.59 | 172.55 | 172.59 | 314.0 |
| 2022-01-14 04:15:00 | AAPL | Stock | 172.66 | 172.66 | 172.66 | 172.66 | 388.0 |
| 2022-01-14 04:21:00 | AAPL | Stock | 172.75 | 172.75 | 172.75 | 172.75 | 925.0 |
| 2022-01-14 04:24:00 | AAPL | Stock | 172.77 | 172.78 | 172.77 | 172.78 | 529.0 |
| 2022-01-14 04:26:00 | AAPL | Stock | 172.49 | 172.73 | 172.41 | 172.41 | 1177.0 |
| 2022-01-14 04:28:00 | AAPL | Stock | 172.53 | 172.53 | 172.53 | 172.53 | 154.0 |
| 2022-01-14 04:29:00 | AAPL | Stock | 172.54 | 172.54 | 172.54 | 172.54 | 145.0 |
| 2022-01-14 04:32:00 | AAPL | Stock | 172.84 | 172.85 | 172.83 | 172.83 | 1879.0 |
| 2022-01-14 04:35:00 | AAPL | Stock | 172.91 | 172.91 | 172.88 | 172.88 | 733.0 |
| 2022-01-14 04:37:00 | AAPL | Stock | 172.94 | 172.94 | 172.94 | 172.94 | 150.0 |
| 2022-01-14 04:38:00 | AAPL | Stock | 172.83 | 172.83 | 172.83 | 172.83 | 371.0 |
| 2022-01-14 04:39:00 | AAPL | Stock | 172.83 | 172.83 | 172.83 | 172.83 | 300.0 |
| 2022-01-14 04:41:00 | AAPL | Stock | 172.84 | 172.84 | 172.84 | 172.84 | 150.0 |
| 2022-01-14 04:49:00 | AAPL | Stock | 172.71 | 172.71 | 172.71 | 172.71 | 100.0 |
| 2022-01-14 04:50:00 | AAPL | Stock | 172.82 | 172.82 | 172.82 | 172.82 | 100.0 |
| 2022-01-14 04:51:00 | AAPL | Stock | 172.83 | 172.83 | 172.7 | 172.7 | 250.0 |
| 2022-01-14 05:00:00 | AAPL | Stock | 172.85 | 172.85 | 172.85 | 172.85 | 100.0 |
| 2022-01-14 05:01:00 | AAPL | Stock | 172.79 | 172.79 | 172.79 | 172.79 | 100.0 |
| 2022-01-14 05:04:00 | AAPL | Stock | 172.52 | 172.52 | 172.5 | 172.5 | 707.0 |
| 2022-01-14 05:06:00 | AAPL | Stock | 172.45 | 172.45 | 172.45 | 172.45 | 131.0 |
| 2022-01-14 05:10:00 | AAPL | Stock | 172.69 | 172.72 | 172.69 | 172.72 | 1386.0 |
| 2022-01-14 05:11:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 100.0 |
| 2022-01-14 05:12:00 | AAPL | Stock | 172.8 | 172.89 | 172.8 | 172.81 | 1565.0 |
| 2022-01-14 05:13:00 | AAPL | Stock | 172.73 | 172.73 | 172.71 | 172.71 | 538.0 |
| 2022-01-14 05:15:00 | AAPL | Stock | 172.56 | 172.56 | 172.55 | 172.55 | 258.0 |
| 2022-01-14 05:18:00 | AAPL | Stock | 172.57 | 172.61 | 172.53 | 172.61 | 926.0 |
| 2022-01-14 05:20:00 | AAPL | Stock | 172.5 | 172.5 | 172.5 | 172.5 | 100.0 |
| 2022-01-14 05:23:00 | AAPL | Stock | 172.66 | 172.66 | 172.66 | 172.66 | 300.0 |
| 2022-01-14 05:26:00 | AAPL | Stock | 172.54 | 172.54 | 172.49 | 172.49 | 359.0 |
| 2022-01-14 05:27:00 | AAPL | Stock | 172.5 | 172.5 | 172.5 | 172.5 | 1936.0 |
| 2022-01-14 05:28:00 | AAPL | Stock | 172.45 | 172.45 | 172.4 | 172.45 | 1792.0 |
| 2022-01-14 05:29:00 | AAPL | Stock | 172.3 | 172.3 | 172.3 | 172.3 | 200.0 |
| 2022-01-14 05:30:00 | AAPL | Stock | 172.28 | 172.28 | 172.09 | 172.09 | 776.0 |
| 2022-01-14 05:31:00 | AAPL | Stock | 172.05 | 172.07 | 172.05 | 172.05 | 1732.0 |
| 2022-01-14 05:32:00 | AAPL | Stock | 172.2 | 172.21 | 172.2 | 172.21 | 378.0 |
| 2022-01-14 05:36:00 | AAPL | Stock | 172.08 | 172.12 | 172.02 | 172.02 | 1220.0 |
| 2022-01-14 05:37:00 | AAPL | Stock | 172.19 | 172.19 | 172.19 | 172.19 | 275.0 |
| 2022-01-14 05:38:00 | AAPL | Stock | 172.23 | 172.23 | 172.23 | 172.23 | 100.0 |
| 2022-01-14 05:39:00 | AAPL | Stock | 172.24 | 172.24 | 172.24 | 172.24 | 200.0 |
> showing 50 of 1,396,068 rows — these rows as CSV