PREVIEW / stock_1min / 2022-07-08
file: by_date/stock_1min/2022/2022-07-08.parquet size: 20.6 MB rows: 1,278,020 symbols: 2,046
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-07-08 04:00:00 | AAPL | Stock | 145.74 | 145.86 | 145.74 | 145.86 | 617.0 |
| 2022-07-08 04:02:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 144.0 |
| 2022-07-08 04:05:00 | AAPL | Stock | 145.73 | 145.75 | 145.73 | 145.75 | 240.0 |
| 2022-07-08 04:07:00 | AAPL | Stock | 145.73 | 145.8 | 145.73 | 145.8 | 932.0 |
| 2022-07-08 04:08:00 | AAPL | Stock | 145.74 | 145.74 | 145.74 | 145.74 | 100.0 |
| 2022-07-08 04:09:00 | AAPL | Stock | 145.75 | 145.75 | 145.75 | 145.75 | 100.0 |
| 2022-07-08 04:13:00 | AAPL | Stock | 145.72 | 145.72 | 145.72 | 145.72 | 200.0 |
| 2022-07-08 04:15:00 | AAPL | Stock | 145.71 | 145.71 | 145.71 | 145.71 | 150.0 |
| 2022-07-08 04:20:00 | AAPL | Stock | 145.51 | 145.51 | 145.51 | 145.51 | 100.0 |
| 2022-07-08 04:21:00 | AAPL | Stock | 145.53 | 145.53 | 145.51 | 145.51 | 900.0 |
| 2022-07-08 04:22:00 | AAPL | Stock | 145.52 | 145.52 | 145.52 | 145.52 | 100.0 |
| 2022-07-08 04:23:00 | AAPL | Stock | 145.65 | 145.66 | 145.65 | 145.66 | 448.0 |
| 2022-07-08 04:27:00 | AAPL | Stock | 145.52 | 145.52 | 145.5 | 145.52 | 348.0 |
| 2022-07-08 04:28:00 | AAPL | Stock | 145.51 | 145.51 | 145.5 | 145.5 | 1336.0 |
| 2022-07-08 04:31:00 | AAPL | Stock | 145.35 | 145.35 | 145.35 | 145.35 | 120.0 |
| 2022-07-08 04:36:00 | AAPL | Stock | 145.35 | 145.35 | 145.34 | 145.34 | 208.0 |
| 2022-07-08 04:38:00 | AAPL | Stock | 145.33 | 145.33 | 145.3 | 145.3 | 948.0 |
| 2022-07-08 04:39:00 | AAPL | Stock | 145.33 | 145.33 | 145.33 | 145.33 | 100.0 |
| 2022-07-08 04:43:00 | AAPL | Stock | 145.39 | 145.4 | 145.39 | 145.4 | 844.0 |
| 2022-07-08 04:44:00 | AAPL | Stock | 145.33 | 145.33 | 145.33 | 145.33 | 1566.0 |
| 2022-07-08 04:46:00 | AAPL | Stock | 145.36 | 145.36 | 145.36 | 145.36 | 501.0 |
| 2022-07-08 04:51:00 | AAPL | Stock | 145.55 | 145.55 | 145.55 | 145.55 | 100.0 |
| 2022-07-08 04:52:00 | AAPL | Stock | 145.59 | 145.59 | 145.59 | 145.59 | 378.0 |
| 2022-07-08 04:53:00 | AAPL | Stock | 145.59 | 145.59 | 145.59 | 145.59 | 480.0 |
| 2022-07-08 04:59:00 | AAPL | Stock | 145.47 | 145.47 | 145.47 | 145.47 | 245.0 |
| 2022-07-08 05:02:00 | AAPL | Stock | 145.36 | 145.36 | 145.35 | 145.35 | 350.0 |
| 2022-07-08 05:04:00 | AAPL | Stock | 145.34 | 145.34 | 145.34 | 145.34 | 295.0 |
| 2022-07-08 05:05:00 | AAPL | Stock | 145.35 | 145.35 | 145.34 | 145.35 | 300.0 |
| 2022-07-08 05:07:00 | AAPL | Stock | 145.33 | 145.33 | 145.33 | 145.33 | 101.0 |
| 2022-07-08 05:08:00 | AAPL | Stock | 145.27 | 145.27 | 145.19 | 145.2 | 1770.0 |
| 2022-07-08 05:09:00 | AAPL | Stock | 145.19 | 145.19 | 145.19 | 145.19 | 2000.0 |
| 2022-07-08 05:10:00 | AAPL | Stock | 145.22 | 145.22 | 145.19 | 145.19 | 440.0 |
| 2022-07-08 05:12:00 | AAPL | Stock | 145.22 | 145.22 | 145.22 | 145.22 | 107.0 |
| 2022-07-08 05:18:00 | AAPL | Stock | 145.25 | 145.25 | 145.25 | 145.25 | 437.0 |
| 2022-07-08 05:27:00 | AAPL | Stock | 145.32 | 145.32 | 145.32 | 145.32 | 491.0 |
| 2022-07-08 05:29:00 | AAPL | Stock | 145.32 | 145.32 | 145.3 | 145.3 | 658.0 |
| 2022-07-08 05:33:00 | AAPL | Stock | 145.4 | 145.4 | 145.4 | 145.4 | 264.0 |
| 2022-07-08 05:40:00 | AAPL | Stock | 145.42 | 145.42 | 145.42 | 145.42 | 127.0 |
| 2022-07-08 05:44:00 | AAPL | Stock | 145.51 | 145.51 | 145.51 | 145.51 | 445.0 |
| 2022-07-08 05:45:00 | AAPL | Stock | 145.51 | 145.51 | 145.46 | 145.46 | 244.0 |
| 2022-07-08 05:46:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 100.0 |
| 2022-07-08 05:48:00 | AAPL | Stock | 145.46 | 145.46 | 145.46 | 145.46 | 100.0 |
| 2022-07-08 05:50:00 | AAPL | Stock | 145.43 | 145.43 | 145.43 | 145.43 | 100.0 |
| 2022-07-08 05:51:00 | AAPL | Stock | 145.41 | 145.41 | 145.41 | 145.41 | 725.0 |
| 2022-07-08 05:57:00 | AAPL | Stock | 145.49 | 145.49 | 145.49 | 145.49 | 308.0 |
| 2022-07-08 05:58:00 | AAPL | Stock | 145.5 | 145.51 | 145.49 | 145.51 | 300.0 |
| 2022-07-08 06:02:00 | AAPL | Stock | 145.51 | 145.51 | 145.51 | 145.51 | 100.0 |
| 2022-07-08 06:06:00 | AAPL | Stock | 145.49 | 145.49 | 145.49 | 145.49 | 100.0 |
| 2022-07-08 06:10:00 | AAPL | Stock | 145.56 | 145.56 | 145.56 | 145.56 | 106.0 |
| 2022-07-08 06:12:00 | AAPL | Stock | 145.58 | 145.58 | 145.58 | 145.58 | 209.0 |
> showing 50 of 1,278,020 rows — these rows as CSV