PREVIEW / stock_1min / 2024-08-23
file: by_date/stock_1min/2024/2024-08-23.parquet size: 19.9 MB rows: 1,202,131 symbols: 833
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-08-23 04:00:00 | AAPL | Stock | 225.5 | 225.5 | 225.11 | 225.11 | 703.0 |
| 2024-08-23 04:01:00 | AAPL | Stock | 225.14 | 225.14 | 225.14 | 225.14 | 495.0 |
| 2024-08-23 04:02:00 | AAPL | Stock | 225.16 | 225.27 | 225.16 | 225.27 | 1760.0 |
| 2024-08-23 04:03:00 | AAPL | Stock | 225.28 | 225.39 | 225.28 | 225.39 | 426.0 |
| 2024-08-23 04:05:00 | AAPL | Stock | 225.4 | 225.4 | 225.4 | 225.4 | 100.0 |
| 2024-08-23 04:06:00 | AAPL | Stock | 225.41 | 225.46 | 225.39 | 225.46 | 390.0 |
| 2024-08-23 04:07:00 | AAPL | Stock | 225.4 | 225.4 | 225.4 | 225.4 | 100.0 |
| 2024-08-23 04:09:00 | AAPL | Stock | 225.49 | 225.49 | 225.49 | 225.49 | 100.0 |
| 2024-08-23 04:14:00 | AAPL | Stock | 225.6 | 225.6 | 225.6 | 225.6 | 100.0 |
| 2024-08-23 04:17:00 | AAPL | Stock | 225.6 | 225.6 | 225.6 | 225.6 | 100.0 |
| 2024-08-23 04:18:00 | AAPL | Stock | 225.6 | 225.6 | 225.6 | 225.6 | 475.0 |
| 2024-08-23 04:26:00 | AAPL | Stock | 225.57 | 225.57 | 225.57 | 225.57 | 415.0 |
| 2024-08-23 04:40:00 | AAPL | Stock | 225.55 | 225.55 | 225.55 | 225.55 | 100.0 |
| 2024-08-23 04:47:00 | AAPL | Stock | 225.6 | 225.6 | 225.6 | 225.6 | 349.0 |
| 2024-08-23 04:51:00 | AAPL | Stock | 225.65 | 225.65 | 225.65 | 225.65 | 200.0 |
| 2024-08-23 05:02:00 | AAPL | Stock | 225.71 | 225.71 | 225.71 | 225.71 | 100.0 |
| 2024-08-23 05:03:00 | AAPL | Stock | 225.63 | 225.63 | 225.63 | 225.63 | 100.0 |
| 2024-08-23 05:09:00 | AAPL | Stock | 225.64 | 225.64 | 225.64 | 225.64 | 100.0 |
| 2024-08-23 05:24:00 | AAPL | Stock | 225.65 | 225.66 | 225.5 | 225.5 | 1595.0 |
| 2024-08-23 05:29:00 | AAPL | Stock | 225.66 | 225.66 | 225.66 | 225.66 | 100.0 |
| 2024-08-23 05:30:00 | AAPL | Stock | 225.66 | 225.68 | 225.66 | 225.68 | 200.0 |
| 2024-08-23 05:37:00 | AAPL | Stock | 225.7 | 225.7 | 225.7 | 225.7 | 110.0 |
| 2024-08-23 05:42:00 | AAPL | Stock | 225.75 | 225.75 | 225.75 | 225.75 | 122.0 |
| 2024-08-23 05:43:00 | AAPL | Stock | 225.7 | 225.7 | 225.7 | 225.7 | 200.0 |
| 2024-08-23 05:46:00 | AAPL | Stock | 225.5 | 225.5 | 225.5 | 225.5 | 100.0 |
| 2024-08-23 05:48:00 | AAPL | Stock | 225.5 | 225.5 | 225.5 | 225.5 | 100.0 |
| 2024-08-23 05:52:00 | AAPL | Stock | 225.7 | 225.7 | 225.7 | 225.7 | 137.0 |
| 2024-08-23 06:00:00 | AAPL | Stock | 225.65 | 225.65 | 225.65 | 225.65 | 100.0 |
| 2024-08-23 06:15:00 | AAPL | Stock | 225.72 | 225.72 | 225.72 | 225.72 | 600.0 |
| 2024-08-23 06:22:00 | AAPL | Stock | 225.71 | 225.71 | 225.69 | 225.69 | 400.0 |
| 2024-08-23 06:32:00 | AAPL | Stock | 225.57 | 225.57 | 225.57 | 225.57 | 100.0 |
| 2024-08-23 06:41:00 | AAPL | Stock | 225.77 | 225.77 | 225.77 | 225.77 | 122.0 |
| 2024-08-23 06:43:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 100.0 |
| 2024-08-23 06:44:00 | AAPL | Stock | 225.8 | 225.89 | 225.8 | 225.86 | 392.0 |
| 2024-08-23 06:48:00 | AAPL | Stock | 225.89 | 225.89 | 225.89 | 225.89 | 100.0 |
| 2024-08-23 06:52:00 | AAPL | Stock | 225.84 | 225.84 | 225.84 | 225.84 | 913.0 |
| 2024-08-23 06:58:00 | AAPL | Stock | 225.96 | 225.96 | 225.96 | 225.96 | 101.0 |
| 2024-08-23 07:00:00 | AAPL | Stock | 225.87 | 225.87 | 225.83 | 225.85 | 3252.0 |
| 2024-08-23 07:01:00 | AAPL | Stock | 225.93 | 225.93 | 225.93 | 225.93 | 149.0 |
| 2024-08-23 07:02:00 | AAPL | Stock | 225.89 | 225.9 | 225.89 | 225.9 | 540.0 |
| 2024-08-23 07:05:00 | AAPL | Stock | 225.9 | 225.99 | 225.9 | 225.95 | 719.0 |
| 2024-08-23 07:06:00 | AAPL | Stock | 225.99 | 226.0 | 225.99 | 226.0 | 1564.0 |
| 2024-08-23 07:07:00 | AAPL | Stock | 226.0 | 226.0 | 226.0 | 226.0 | 254.0 |
| 2024-08-23 07:08:00 | AAPL | Stock | 226.01 | 226.01 | 226.01 | 226.01 | 100.0 |
| 2024-08-23 07:10:00 | AAPL | Stock | 226.07 | 226.08 | 226.07 | 226.08 | 280.0 |
| 2024-08-23 07:13:00 | AAPL | Stock | 226.08 | 226.08 | 226.0 | 226.0 | 606.0 |
| 2024-08-23 07:14:00 | AAPL | Stock | 226.0 | 226.0 | 226.0 | 226.0 | 153.0 |
| 2024-08-23 07:19:00 | AAPL | Stock | 225.97 | 225.97 | 225.97 | 225.97 | 299.0 |
| 2024-08-23 07:20:00 | AAPL | Stock | 225.91 | 225.91 | 225.91 | 225.91 | 161.0 |
| 2024-08-23 07:21:00 | AAPL | Stock | 225.95 | 225.95 | 225.95 | 225.95 | 473.0 |
> showing 50 of 1,202,131 rows — these rows as CSV