PREVIEW / stock_1min / 2022-11-16
file: by_date/stock_1min/2022/2022-11-16.parquet size: 20.6 MB rows: 1,289,363 symbols: 1,865
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-11-16 04:00:00 | AAPL | Stock | 150.25 | 150.28 | 149.75 | 150.01 | 11821.0 |
| 2022-11-16 04:01:00 | AAPL | Stock | 150.01 | 150.01 | 150.01 | 150.01 | 100.0 |
| 2022-11-16 04:02:00 | AAPL | Stock | 150.05 | 150.05 | 149.92 | 150.0 | 10849.0 |
| 2022-11-16 04:03:00 | AAPL | Stock | 150.01 | 150.02 | 150.01 | 150.01 | 567.0 |
| 2022-11-16 04:04:00 | AAPL | Stock | 150.01 | 150.01 | 150.01 | 150.01 | 100.0 |
| 2022-11-16 04:06:00 | AAPL | Stock | 149.94 | 149.94 | 149.87 | 149.87 | 918.0 |
| 2022-11-16 04:07:00 | AAPL | Stock | 149.83 | 149.83 | 149.83 | 149.83 | 133.0 |
| 2022-11-16 04:09:00 | AAPL | Stock | 149.89 | 149.9 | 149.89 | 149.9 | 345.0 |
| 2022-11-16 04:11:00 | AAPL | Stock | 149.89 | 149.89 | 149.79 | 149.79 | 5453.0 |
| 2022-11-16 04:12:00 | AAPL | Stock | 149.86 | 149.86 | 149.78 | 149.8 | 5868.0 |
| 2022-11-16 04:13:00 | AAPL | Stock | 149.81 | 149.92 | 149.79 | 149.92 | 4403.0 |
| 2022-11-16 04:14:00 | AAPL | Stock | 149.88 | 149.88 | 149.88 | 149.88 | 200.0 |
| 2022-11-16 04:15:00 | AAPL | Stock | 149.9 | 149.9 | 149.9 | 149.9 | 100.0 |
| 2022-11-16 04:17:00 | AAPL | Stock | 149.88 | 149.91 | 149.88 | 149.91 | 897.0 |
| 2022-11-16 04:18:00 | AAPL | Stock | 149.89 | 149.89 | 149.89 | 149.89 | 100.0 |
| 2022-11-16 04:21:00 | AAPL | Stock | 149.94 | 149.94 | 149.93 | 149.93 | 266.0 |
| 2022-11-16 04:23:00 | AAPL | Stock | 149.95 | 149.98 | 149.95 | 149.98 | 453.0 |
| 2022-11-16 04:24:00 | AAPL | Stock | 149.98 | 149.98 | 149.98 | 149.98 | 100.0 |
| 2022-11-16 04:25:00 | AAPL | Stock | 149.9 | 149.97 | 149.9 | 149.96 | 7884.0 |
| 2022-11-16 04:26:00 | AAPL | Stock | 149.96 | 149.96 | 149.93 | 149.93 | 300.0 |
| 2022-11-16 04:27:00 | AAPL | Stock | 149.93 | 149.93 | 149.92 | 149.92 | 585.0 |
| 2022-11-16 04:28:00 | AAPL | Stock | 149.89 | 149.89 | 149.89 | 149.89 | 100.0 |
| 2022-11-16 04:29:00 | AAPL | Stock | 149.87 | 149.88 | 149.86 | 149.87 | 1143.0 |
| 2022-11-16 04:30:00 | AAPL | Stock | 149.87 | 149.87 | 149.87 | 149.87 | 245.0 |
| 2022-11-16 04:31:00 | AAPL | Stock | 149.82 | 149.83 | 149.76 | 149.76 | 7900.0 |
| 2022-11-16 04:32:00 | AAPL | Stock | 149.8 | 149.8 | 149.8 | 149.8 | 407.0 |
| 2022-11-16 04:39:00 | AAPL | Stock | 149.89 | 149.89 | 149.89 | 149.89 | 100.0 |
| 2022-11-16 04:41:00 | AAPL | Stock | 149.96 | 150.05 | 149.96 | 150.05 | 11676.0 |
| 2022-11-16 04:44:00 | AAPL | Stock | 150.1 | 150.1 | 150.1 | 150.1 | 300.0 |
| 2022-11-16 04:48:00 | AAPL | Stock | 150.07 | 150.1 | 150.07 | 150.09 | 1053.0 |
| 2022-11-16 04:49:00 | AAPL | Stock | 150.1 | 150.1 | 150.09 | 150.09 | 200.0 |
| 2022-11-16 04:51:00 | AAPL | Stock | 150.1 | 150.1 | 150.09 | 150.09 | 1051.0 |
| 2022-11-16 04:52:00 | AAPL | Stock | 150.07 | 150.07 | 149.97 | 149.97 | 5565.0 |
| 2022-11-16 04:53:00 | AAPL | Stock | 149.97 | 149.97 | 149.97 | 149.97 | 550.0 |
| 2022-11-16 04:54:00 | AAPL | Stock | 150.06 | 150.06 | 150.05 | 150.05 | 300.0 |
| 2022-11-16 04:56:00 | AAPL | Stock | 150.09 | 150.09 | 150.09 | 150.09 | 100.0 |
| 2022-11-16 04:58:00 | AAPL | Stock | 150.13 | 150.13 | 150.13 | 150.13 | 141.0 |
| 2022-11-16 04:59:00 | AAPL | Stock | 150.1 | 150.1 | 150.09 | 150.09 | 1200.0 |
| 2022-11-16 05:00:00 | AAPL | Stock | 150.12 | 150.12 | 150.12 | 150.12 | 100.0 |
| 2022-11-16 05:01:00 | AAPL | Stock | 150.15 | 150.15 | 150.15 | 150.15 | 100.0 |
| 2022-11-16 05:02:00 | AAPL | Stock | 150.16 | 150.18 | 150.16 | 150.16 | 786.0 |
| 2022-11-16 05:04:00 | AAPL | Stock | 150.17 | 150.2 | 150.17 | 150.2 | 425.0 |
| 2022-11-16 05:05:00 | AAPL | Stock | 150.3 | 150.3 | 150.29 | 150.3 | 800.0 |
| 2022-11-16 05:06:00 | AAPL | Stock | 150.3 | 150.31 | 150.3 | 150.3 | 520.0 |
| 2022-11-16 05:07:00 | AAPL | Stock | 150.3 | 150.3 | 150.29 | 150.29 | 400.0 |
| 2022-11-16 05:08:00 | AAPL | Stock | 150.34 | 150.34 | 150.33 | 150.33 | 290.0 |
| 2022-11-16 05:11:00 | AAPL | Stock | 150.46 | 150.46 | 150.46 | 150.46 | 168.0 |
| 2022-11-16 05:12:00 | AAPL | Stock | 150.56 | 150.56 | 150.55 | 150.55 | 200.0 |
| 2022-11-16 05:13:00 | AAPL | Stock | 150.55 | 150.57 | 150.55 | 150.55 | 526.0 |
| 2022-11-16 05:14:00 | AAPL | Stock | 150.56 | 150.56 | 150.55 | 150.55 | 416.0 |
> showing 50 of 1,289,363 rows — these rows as CSV