PREVIEW / stock_1min / 2023-11-20
file: by_date/stock_1min/2023/2023-11-20.parquet size: 20.8 MB rows: 1,245,339 symbols: 1,254
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-20 04:00:00 | AAPL | Stock | 189.52 | 189.52 | 189.52 | 189.52 | 100.0 |
| 2023-11-20 04:01:00 | AAPL | Stock | 189.42 | 189.42 | 189.32 | 189.33 | 2909.0 |
| 2023-11-20 04:02:00 | AAPL | Stock | 189.22 | 189.22 | 189.05 | 189.06 | 1206.0 |
| 2023-11-20 04:03:00 | AAPL | Stock | 189.02 | 189.02 | 189.0 | 189.02 | 497.0 |
| 2023-11-20 04:04:00 | AAPL | Stock | 189.03 | 189.03 | 188.92 | 189.0 | 1797.0 |
| 2023-11-20 04:05:00 | AAPL | Stock | 189.1 | 189.1 | 189.04 | 189.04 | 324.0 |
| 2023-11-20 04:06:00 | AAPL | Stock | 189.1 | 189.1 | 189.01 | 189.01 | 550.0 |
| 2023-11-20 04:07:00 | AAPL | Stock | 189.05 | 189.05 | 189.05 | 189.05 | 315.0 |
| 2023-11-20 04:08:00 | AAPL | Stock | 189.07 | 189.22 | 189.05 | 189.22 | 699.0 |
| 2023-11-20 04:09:00 | AAPL | Stock | 189.22 | 189.23 | 189.22 | 189.22 | 649.0 |
| 2023-11-20 04:10:00 | AAPL | Stock | 189.2 | 189.2 | 189.2 | 189.2 | 225.0 |
| 2023-11-20 04:11:00 | AAPL | Stock | 189.25 | 189.25 | 189.25 | 189.25 | 100.0 |
| 2023-11-20 04:12:00 | AAPL | Stock | 189.26 | 189.26 | 189.26 | 189.26 | 105.0 |
| 2023-11-20 04:13:00 | AAPL | Stock | 189.3 | 189.3 | 189.3 | 189.3 | 260.0 |
| 2023-11-20 04:16:00 | AAPL | Stock | 189.38 | 189.38 | 189.3 | 189.31 | 1748.0 |
| 2023-11-20 04:17:00 | AAPL | Stock | 189.38 | 189.38 | 189.38 | 189.38 | 100.0 |
| 2023-11-20 04:19:00 | AAPL | Stock | 189.4 | 189.4 | 189.4 | 189.4 | 230.0 |
| 2023-11-20 04:20:00 | AAPL | Stock | 189.5 | 189.5 | 189.36 | 189.36 | 1261.0 |
| 2023-11-20 04:21:00 | AAPL | Stock | 189.5 | 189.5 | 189.5 | 189.5 | 292.0 |
| 2023-11-20 04:25:00 | AAPL | Stock | 189.5 | 189.5 | 189.5 | 189.5 | 400.0 |
| 2023-11-20 04:26:00 | AAPL | Stock | 189.5 | 189.5 | 189.5 | 189.5 | 412.0 |
| 2023-11-20 04:27:00 | AAPL | Stock | 189.45 | 189.53 | 189.45 | 189.53 | 1019.0 |
| 2023-11-20 04:28:00 | AAPL | Stock | 189.55 | 189.55 | 189.55 | 189.55 | 1250.0 |
| 2023-11-20 04:30:00 | AAPL | Stock | 189.55 | 189.55 | 189.52 | 189.52 | 225.0 |
| 2023-11-20 04:31:00 | AAPL | Stock | 189.51 | 189.51 | 189.5 | 189.5 | 677.0 |
| 2023-11-20 04:33:00 | AAPL | Stock | 189.6 | 189.6 | 189.6 | 189.6 | 100.0 |
| 2023-11-20 04:34:00 | AAPL | Stock | 189.57 | 189.57 | 189.57 | 189.57 | 165.0 |
| 2023-11-20 04:35:00 | AAPL | Stock | 189.53 | 189.53 | 189.5 | 189.5 | 800.0 |
| 2023-11-20 04:38:00 | AAPL | Stock | 189.54 | 189.54 | 189.54 | 189.54 | 125.0 |
| 2023-11-20 04:41:00 | AAPL | Stock | 189.5 | 189.5 | 189.5 | 189.5 | 100.0 |
| 2023-11-20 04:47:00 | AAPL | Stock | 189.54 | 189.54 | 189.54 | 189.54 | 100.0 |
| 2023-11-20 04:50:00 | AAPL | Stock | 189.55 | 189.55 | 189.55 | 189.55 | 861.0 |
| 2023-11-20 04:52:00 | AAPL | Stock | 189.52 | 189.52 | 189.51 | 189.51 | 397.0 |
| 2023-11-20 04:53:00 | AAPL | Stock | 189.5 | 189.56 | 189.5 | 189.56 | 400.0 |
| 2023-11-20 04:55:00 | AAPL | Stock | 189.52 | 189.52 | 189.52 | 189.52 | 100.0 |
| 2023-11-20 04:57:00 | AAPL | Stock | 189.6 | 189.6 | 189.6 | 189.6 | 100.0 |
| 2023-11-20 04:59:00 | AAPL | Stock | 189.57 | 189.57 | 189.57 | 189.57 | 439.0 |
| 2023-11-20 05:01:00 | AAPL | Stock | 189.55 | 189.55 | 189.55 | 189.55 | 450.0 |
| 2023-11-20 05:07:00 | AAPL | Stock | 189.64 | 189.64 | 189.64 | 189.64 | 100.0 |
| 2023-11-20 05:08:00 | AAPL | Stock | 189.6 | 189.6 | 189.6 | 189.6 | 110.0 |
| 2023-11-20 05:11:00 | AAPL | Stock | 189.65 | 189.65 | 189.65 | 189.65 | 675.0 |
| 2023-11-20 05:13:00 | AAPL | Stock | 189.68 | 189.68 | 189.67 | 189.67 | 550.0 |
| 2023-11-20 05:14:00 | AAPL | Stock | 189.68 | 189.68 | 189.68 | 189.68 | 132.0 |
| 2023-11-20 05:15:00 | AAPL | Stock | 189.68 | 189.68 | 189.68 | 189.68 | 230.0 |
| 2023-11-20 05:18:00 | AAPL | Stock | 189.68 | 189.68 | 189.68 | 189.68 | 334.0 |
| 2023-11-20 05:20:00 | AAPL | Stock | 189.68 | 189.68 | 189.68 | 189.68 | 100.0 |
| 2023-11-20 05:22:00 | AAPL | Stock | 189.62 | 189.62 | 189.61 | 189.61 | 1914.0 |
| 2023-11-20 05:27:00 | AAPL | Stock | 189.5 | 189.51 | 189.5 | 189.51 | 1547.0 |
| 2023-11-20 05:30:00 | AAPL | Stock | 189.59 | 189.59 | 189.59 | 189.59 | 225.0 |
| 2023-11-20 05:32:00 | AAPL | Stock | 189.62 | 189.62 | 189.62 | 189.62 | 324.0 |
> showing 50 of 1,245,339 rows — these rows as CSV