PREVIEW / stock_1min / 2025-09-18
file: by_date/stock_1min/2025/2025-09-18.parquet size: 25.6 MB rows: 1,457,872 symbols: 311
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 |
|---|---|---|---|---|---|---|---|
| 2025-09-18 04:00:00 | AAPL | Stock | 240.7 | 240.7 | 240.0 | 240.7 | 1180.0 |
| 2025-09-18 04:01:00 | AAPL | Stock | 240.59 | 240.59 | 240.59 | 240.59 | 100.0 |
| 2025-09-18 04:02:00 | AAPL | Stock | 240.69 | 240.69 | 240.55 | 240.55 | 319.0 |
| 2025-09-18 04:04:00 | AAPL | Stock | 240.71 | 240.71 | 240.71 | 240.71 | 100.0 |
| 2025-09-18 04:06:00 | AAPL | Stock | 240.79 | 240.79 | 240.75 | 240.75 | 500.0 |
| 2025-09-18 04:07:00 | AAPL | Stock | 240.65 | 240.65 | 240.6 | 240.6 | 350.0 |
| 2025-09-18 04:09:00 | AAPL | Stock | 240.66 | 240.66 | 240.66 | 240.66 | 100.0 |
| 2025-09-18 04:10:00 | AAPL | Stock | 240.64 | 240.64 | 240.64 | 240.64 | 100.0 |
| 2025-09-18 04:11:00 | AAPL | Stock | 240.71 | 240.71 | 240.71 | 240.71 | 100.0 |
| 2025-09-18 04:12:00 | AAPL | Stock | 240.71 | 240.73 | 240.71 | 240.73 | 1701.0 |
| 2025-09-18 04:13:00 | AAPL | Stock | 240.64 | 240.64 | 240.6 | 240.6 | 980.0 |
| 2025-09-18 04:14:00 | AAPL | Stock | 240.62 | 240.62 | 240.57 | 240.57 | 300.0 |
| 2025-09-18 04:15:00 | AAPL | Stock | 240.51 | 240.51 | 240.51 | 240.51 | 150.0 |
| 2025-09-18 04:16:00 | AAPL | Stock | 240.56 | 240.56 | 240.56 | 240.56 | 205.0 |
| 2025-09-18 04:17:00 | AAPL | Stock | 240.61 | 240.78 | 240.61 | 240.77 | 2413.0 |
| 2025-09-18 04:18:00 | AAPL | Stock | 240.83 | 240.83 | 240.83 | 240.83 | 216.0 |
| 2025-09-18 04:19:00 | AAPL | Stock | 240.57 | 240.57 | 240.57 | 240.57 | 113.0 |
| 2025-09-18 04:23:00 | AAPL | Stock | 240.64 | 240.7 | 240.64 | 240.7 | 865.0 |
| 2025-09-18 04:26:00 | AAPL | Stock | 240.64 | 240.64 | 240.63 | 240.63 | 350.0 |
| 2025-09-18 04:28:00 | AAPL | Stock | 240.67 | 240.67 | 240.65 | 240.65 | 261.0 |
| 2025-09-18 04:29:00 | AAPL | Stock | 240.68 | 240.68 | 240.59 | 240.59 | 469.0 |
| 2025-09-18 04:30:00 | AAPL | Stock | 240.61 | 240.61 | 240.54 | 240.54 | 1439.0 |
| 2025-09-18 04:33:00 | AAPL | Stock | 240.55 | 240.58 | 240.55 | 240.58 | 310.0 |
| 2025-09-18 04:38:00 | AAPL | Stock | 240.51 | 240.58 | 240.51 | 240.58 | 766.0 |
| 2025-09-18 04:39:00 | AAPL | Stock | 240.58 | 240.64 | 240.58 | 240.59 | 1172.0 |
| 2025-09-18 04:47:00 | AAPL | Stock | 240.68 | 240.68 | 240.68 | 240.68 | 111.0 |
| 2025-09-18 04:48:00 | AAPL | Stock | 240.74 | 240.74 | 240.74 | 240.74 | 1440.0 |
| 2025-09-18 04:49:00 | AAPL | Stock | 240.79 | 240.79 | 240.78 | 240.78 | 300.0 |
| 2025-09-18 04:50:00 | AAPL | Stock | 240.79 | 240.8 | 240.79 | 240.8 | 941.0 |
| 2025-09-18 04:51:00 | AAPL | Stock | 240.9 | 240.95 | 240.89 | 240.95 | 1182.0 |
| 2025-09-18 04:52:00 | AAPL | Stock | 240.97 | 240.98 | 240.9 | 240.9 | 3660.0 |
| 2025-09-18 04:54:00 | AAPL | Stock | 240.86 | 240.9 | 240.85 | 240.9 | 537.0 |
| 2025-09-18 04:55:00 | AAPL | Stock | 240.87 | 240.87 | 240.86 | 240.86 | 450.0 |
| 2025-09-18 04:57:00 | AAPL | Stock | 240.85 | 240.86 | 240.85 | 240.86 | 4745.0 |
| 2025-09-18 04:58:00 | AAPL | Stock | 240.88 | 240.9 | 240.88 | 240.9 | 830.0 |
| 2025-09-18 05:00:00 | AAPL | Stock | 240.9 | 240.93 | 240.9 | 240.93 | 970.0 |
| 2025-09-18 05:01:00 | AAPL | Stock | 240.85 | 240.85 | 240.76 | 240.76 | 400.0 |
| 2025-09-18 05:02:00 | AAPL | Stock | 240.79 | 240.79 | 240.79 | 240.79 | 121.0 |
| 2025-09-18 05:03:00 | AAPL | Stock | 240.87 | 240.87 | 240.87 | 240.87 | 100.0 |
| 2025-09-18 05:05:00 | AAPL | Stock | 240.81 | 240.85 | 240.81 | 240.85 | 200.0 |
| 2025-09-18 05:06:00 | AAPL | Stock | 240.85 | 240.85 | 240.8 | 240.81 | 420.0 |
| 2025-09-18 05:07:00 | AAPL | Stock | 240.81 | 240.82 | 240.81 | 240.82 | 291.0 |
| 2025-09-18 05:08:00 | AAPL | Stock | 240.81 | 240.82 | 240.81 | 240.82 | 200.0 |
| 2025-09-18 05:09:00 | AAPL | Stock | 240.82 | 240.82 | 240.81 | 240.81 | 350.0 |
| 2025-09-18 05:10:00 | AAPL | Stock | 240.77 | 240.77 | 240.77 | 240.77 | 410.0 |
| 2025-09-18 05:11:00 | AAPL | Stock | 240.77 | 240.79 | 240.77 | 240.79 | 510.0 |
| 2025-09-18 05:12:00 | AAPL | Stock | 240.73 | 240.73 | 240.73 | 240.73 | 100.0 |
| 2025-09-18 05:13:00 | AAPL | Stock | 240.71 | 240.71 | 240.71 | 240.71 | 111.0 |
| 2025-09-18 05:14:00 | AAPL | Stock | 240.51 | 240.51 | 240.39 | 240.39 | 346.0 |
| 2025-09-18 05:15:00 | AAPL | Stock | 240.38 | 240.38 | 240.38 | 240.38 | 147.0 |
> showing 50 of 1,457,872 rows — these rows as CSV