PREVIEW / stock_1min / 2023-06-27
file: by_date/stock_1min/2023/2023-06-27.parquet size: 20.7 MB rows: 1,276,568 symbols: 1,492
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-06-27 04:08:00 | AAPL | Stock | 185.85 | 185.9 | 185.85 | 185.9 | 647.0 |
| 2023-06-27 04:09:00 | AAPL | Stock | 185.9 | 185.9 | 185.89 | 185.89 | 463.0 |
| 2023-06-27 04:10:00 | AAPL | Stock | 185.88 | 185.89 | 185.85 | 185.85 | 823.0 |
| 2023-06-27 04:11:00 | AAPL | Stock | 185.88 | 185.9 | 185.88 | 185.9 | 233.0 |
| 2023-06-27 04:17:00 | AAPL | Stock | 186.0 | 186.0 | 186.0 | 186.0 | 150.0 |
| 2023-06-27 04:18:00 | AAPL | Stock | 186.15 | 186.15 | 186.15 | 186.15 | 446.0 |
| 2023-06-27 04:22:00 | AAPL | Stock | 186.1 | 186.1 | 186.1 | 186.1 | 146.0 |
| 2023-06-27 04:26:00 | AAPL | Stock | 186.0 | 186.01 | 185.99 | 186.01 | 319.0 |
| 2023-06-27 04:29:00 | AAPL | Stock | 186.01 | 186.01 | 186.01 | 186.01 | 144.0 |
| 2023-06-27 04:30:00 | AAPL | Stock | 185.95 | 185.97 | 185.95 | 185.97 | 2724.0 |
| 2023-06-27 04:31:00 | AAPL | Stock | 185.85 | 185.85 | 185.85 | 185.85 | 148.0 |
| 2023-06-27 04:32:00 | AAPL | Stock | 185.75 | 185.75 | 185.75 | 185.75 | 176.0 |
| 2023-06-27 04:38:00 | AAPL | Stock | 185.65 | 185.65 | 185.65 | 185.65 | 100.0 |
| 2023-06-27 04:40:00 | AAPL | Stock | 185.69 | 185.69 | 185.65 | 185.65 | 583.0 |
| 2023-06-27 05:12:00 | AAPL | Stock | 185.81 | 185.81 | 185.81 | 185.81 | 227.0 |
| 2023-06-27 05:14:00 | AAPL | Stock | 185.97 | 185.97 | 185.97 | 185.97 | 107.0 |
| 2023-06-27 05:17:00 | AAPL | Stock | 185.88 | 185.88 | 185.88 | 185.88 | 100.0 |
| 2023-06-27 05:21:00 | AAPL | Stock | 185.93 | 185.93 | 185.93 | 185.93 | 657.0 |
| 2023-06-27 05:24:00 | AAPL | Stock | 185.85 | 185.85 | 185.85 | 185.85 | 140.0 |
| 2023-06-27 05:29:00 | AAPL | Stock | 185.93 | 185.93 | 185.93 | 185.93 | 100.0 |
| 2023-06-27 05:41:00 | AAPL | Stock | 185.87 | 185.87 | 185.87 | 185.87 | 100.0 |
| 2023-06-27 05:46:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 113.0 |
| 2023-06-27 05:57:00 | AAPL | Stock | 185.81 | 185.81 | 185.81 | 185.81 | 432.0 |
| 2023-06-27 06:07:00 | AAPL | Stock | 185.7 | 185.7 | 185.7 | 185.7 | 100.0 |
| 2023-06-27 06:28:00 | AAPL | Stock | 185.72 | 185.72 | 185.72 | 185.72 | 119.0 |
| 2023-06-27 06:36:00 | AAPL | Stock | 185.81 | 185.81 | 185.81 | 185.81 | 387.0 |
| 2023-06-27 06:37:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 784.0 |
| 2023-06-27 06:50:00 | AAPL | Stock | 185.88 | 185.88 | 185.88 | 185.88 | 331.0 |
| 2023-06-27 06:51:00 | AAPL | Stock | 185.83 | 185.83 | 185.83 | 185.83 | 389.0 |
| 2023-06-27 06:56:00 | AAPL | Stock | 185.83 | 185.83 | 185.83 | 185.83 | 100.0 |
| 2023-06-27 07:00:00 | AAPL | Stock | 185.8 | 185.81 | 185.79 | 185.8 | 2121.0 |
| 2023-06-27 07:01:00 | AAPL | Stock | 185.82 | 185.82 | 185.82 | 185.82 | 300.0 |
| 2023-06-27 07:02:00 | AAPL | Stock | 185.8 | 185.8 | 185.75 | 185.75 | 1051.0 |
| 2023-06-27 07:04:00 | AAPL | Stock | 185.78 | 185.79 | 185.74 | 185.74 | 715.0 |
| 2023-06-27 07:06:00 | AAPL | Stock | 185.75 | 185.75 | 185.75 | 185.75 | 100.0 |
| 2023-06-27 07:08:00 | AAPL | Stock | 185.75 | 185.75 | 185.75 | 185.75 | 400.0 |
| 2023-06-27 07:09:00 | AAPL | Stock | 185.79 | 185.81 | 185.79 | 185.8 | 2586.0 |
| 2023-06-27 07:14:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 1140.0 |
| 2023-06-27 07:15:00 | AAPL | Stock | 185.84 | 185.86 | 185.84 | 185.86 | 1229.0 |
| 2023-06-27 07:18:00 | AAPL | Stock | 185.75 | 185.75 | 185.75 | 185.75 | 143.0 |
| 2023-06-27 07:19:00 | AAPL | Stock | 185.7 | 185.7 | 185.7 | 185.7 | 950.0 |
| 2023-06-27 07:20:00 | AAPL | Stock | 185.68 | 185.68 | 185.67 | 185.68 | 1042.0 |
| 2023-06-27 07:21:00 | AAPL | Stock | 185.72 | 185.72 | 185.72 | 185.72 | 910.0 |
| 2023-06-27 07:24:00 | AAPL | Stock | 185.65 | 185.65 | 185.64 | 185.64 | 200.0 |
| 2023-06-27 07:28:00 | AAPL | Stock | 185.7 | 185.7 | 185.7 | 185.7 | 1720.0 |
| 2023-06-27 07:30:00 | AAPL | Stock | 185.64 | 185.64 | 185.64 | 185.64 | 199.0 |
| 2023-06-27 07:31:00 | AAPL | Stock | 185.65 | 185.65 | 185.65 | 185.65 | 2029.0 |
| 2023-06-27 07:32:00 | AAPL | Stock | 185.65 | 185.65 | 185.65 | 185.65 | 152.0 |
| 2023-06-27 07:33:00 | AAPL | Stock | 185.6 | 185.6 | 185.6 | 185.6 | 169.0 |
| 2023-06-27 07:34:00 | AAPL | Stock | 185.6 | 185.6 | 185.58 | 185.58 | 891.0 |
> showing 50 of 1,276,568 rows — these rows as CSV