PREVIEW / stock_1min / 2024-01-31
file: by_date/stock_1min/2024/2024-01-31.parquet size: 21.2 MB rows: 1,274,709 symbols: 1,179
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-31 04:00:00 | AAPL | Stock | 186.98 | 187.25 | 186.65 | 186.86 | 3041.0 |
| 2024-01-31 04:01:00 | AAPL | Stock | 186.86 | 186.86 | 186.71 | 186.81 | 8634.0 |
| 2024-01-31 04:02:00 | AAPL | Stock | 186.84 | 186.97 | 186.84 | 186.97 | 941.0 |
| 2024-01-31 04:03:00 | AAPL | Stock | 186.91 | 186.91 | 186.91 | 186.91 | 450.0 |
| 2024-01-31 04:04:00 | AAPL | Stock | 186.94 | 186.97 | 186.94 | 186.97 | 856.0 |
| 2024-01-31 04:05:00 | AAPL | Stock | 186.84 | 186.87 | 186.84 | 186.87 | 300.0 |
| 2024-01-31 04:06:00 | AAPL | Stock | 186.89 | 187.0 | 186.89 | 187.0 | 2428.0 |
| 2024-01-31 04:07:00 | AAPL | Stock | 187.0 | 187.0 | 187.0 | 187.0 | 100.0 |
| 2024-01-31 04:09:00 | AAPL | Stock | 187.06 | 187.06 | 187.06 | 187.06 | 100.0 |
| 2024-01-31 04:10:00 | AAPL | Stock | 187.0 | 187.0 | 187.0 | 187.0 | 100.0 |
| 2024-01-31 04:15:00 | AAPL | Stock | 186.82 | 186.82 | 186.73 | 186.73 | 1050.0 |
| 2024-01-31 04:16:00 | AAPL | Stock | 186.72 | 186.72 | 186.72 | 186.72 | 250.0 |
| 2024-01-31 04:17:00 | AAPL | Stock | 186.61 | 186.61 | 186.52 | 186.52 | 1696.0 |
| 2024-01-31 04:18:00 | AAPL | Stock | 186.5 | 186.5 | 186.5 | 186.5 | 100.0 |
| 2024-01-31 04:19:00 | AAPL | Stock | 186.43 | 186.43 | 186.38 | 186.38 | 649.0 |
| 2024-01-31 04:20:00 | AAPL | Stock | 186.4 | 186.4 | 186.31 | 186.31 | 604.0 |
| 2024-01-31 04:21:00 | AAPL | Stock | 186.31 | 186.31 | 186.3 | 186.3 | 1303.0 |
| 2024-01-31 04:22:00 | AAPL | Stock | 186.41 | 186.52 | 186.39 | 186.51 | 790.0 |
| 2024-01-31 04:24:00 | AAPL | Stock | 186.47 | 186.47 | 186.47 | 186.47 | 150.0 |
| 2024-01-31 04:26:00 | AAPL | Stock | 186.41 | 186.41 | 186.41 | 186.41 | 150.0 |
| 2024-01-31 04:30:00 | AAPL | Stock | 186.41 | 186.41 | 186.41 | 186.41 | 207.0 |
| 2024-01-31 04:32:00 | AAPL | Stock | 186.39 | 186.39 | 186.39 | 186.39 | 200.0 |
| 2024-01-31 04:34:00 | AAPL | Stock | 186.32 | 186.32 | 186.32 | 186.32 | 100.0 |
| 2024-01-31 04:36:00 | AAPL | Stock | 186.39 | 186.39 | 186.39 | 186.39 | 100.0 |
| 2024-01-31 04:37:00 | AAPL | Stock | 186.3 | 186.3 | 186.3 | 186.3 | 109.0 |
| 2024-01-31 04:39:00 | AAPL | Stock | 186.33 | 186.33 | 186.33 | 186.33 | 150.0 |
| 2024-01-31 04:40:00 | AAPL | Stock | 186.34 | 186.34 | 186.34 | 186.34 | 400.0 |
| 2024-01-31 04:44:00 | AAPL | Stock | 186.41 | 186.5 | 186.41 | 186.5 | 746.0 |
| 2024-01-31 04:46:00 | AAPL | Stock | 186.4 | 186.4 | 186.36 | 186.36 | 200.0 |
| 2024-01-31 04:47:00 | AAPL | Stock | 186.4 | 186.4 | 186.4 | 186.4 | 100.0 |
| 2024-01-31 04:48:00 | AAPL | Stock | 186.41 | 186.41 | 186.41 | 186.41 | 100.0 |
| 2024-01-31 04:49:00 | AAPL | Stock | 186.49 | 186.5 | 186.49 | 186.5 | 1130.0 |
| 2024-01-31 04:53:00 | AAPL | Stock | 186.7 | 186.71 | 186.7 | 186.71 | 340.0 |
| 2024-01-31 04:57:00 | AAPL | Stock | 186.68 | 186.68 | 186.68 | 186.68 | 250.0 |
| 2024-01-31 05:08:00 | AAPL | Stock | 186.7 | 186.7 | 186.7 | 186.7 | 2461.0 |
| 2024-01-31 05:10:00 | AAPL | Stock | 186.72 | 186.72 | 186.72 | 186.72 | 337.0 |
| 2024-01-31 05:13:00 | AAPL | Stock | 186.73 | 186.73 | 186.73 | 186.73 | 120.0 |
| 2024-01-31 05:14:00 | AAPL | Stock | 186.75 | 186.76 | 186.75 | 186.76 | 343.0 |
| 2024-01-31 05:16:00 | AAPL | Stock | 186.7 | 186.7 | 186.7 | 186.7 | 501.0 |
| 2024-01-31 05:24:00 | AAPL | Stock | 186.71 | 186.71 | 186.71 | 186.71 | 371.0 |
| 2024-01-31 05:26:00 | AAPL | Stock | 186.72 | 186.72 | 186.72 | 186.72 | 127.0 |
| 2024-01-31 05:29:00 | AAPL | Stock | 186.91 | 186.91 | 186.91 | 186.91 | 248.0 |
| 2024-01-31 05:31:00 | AAPL | Stock | 186.88 | 186.88 | 186.88 | 186.88 | 469.0 |
| 2024-01-31 05:33:00 | AAPL | Stock | 186.85 | 186.85 | 186.85 | 186.85 | 249.0 |
| 2024-01-31 05:40:00 | AAPL | Stock | 186.81 | 186.81 | 186.81 | 186.81 | 200.0 |
| 2024-01-31 05:44:00 | AAPL | Stock | 186.79 | 186.79 | 186.79 | 186.79 | 183.0 |
| 2024-01-31 05:46:00 | AAPL | Stock | 186.8 | 186.85 | 186.8 | 186.85 | 800.0 |
| 2024-01-31 05:47:00 | AAPL | Stock | 186.85 | 186.85 | 186.85 | 186.85 | 449.0 |
| 2024-01-31 05:48:00 | AAPL | Stock | 186.85 | 186.89 | 186.85 | 186.89 | 250.0 |
| 2024-01-31 05:49:00 | AAPL | Stock | 186.85 | 186.85 | 186.85 | 186.85 | 200.0 |
> showing 50 of 1,274,709 rows — these rows as CSV