PREVIEW / stock_1min / 2025-07-18
file: by_date/stock_1min/2025/2025-07-18.parquet size: 23.7 MB rows: 1,357,484 symbols: 370
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-07-18 04:00:00 | AAPL | Stock | 210.56 | 210.7 | 210.5 | 210.52 | 826.0 |
| 2025-07-18 04:01:00 | AAPL | Stock | 210.46 | 210.46 | 210.46 | 210.46 | 100.0 |
| 2025-07-18 04:03:00 | AAPL | Stock | 210.46 | 210.47 | 210.46 | 210.46 | 596.0 |
| 2025-07-18 04:04:00 | AAPL | Stock | 210.5 | 210.5 | 210.5 | 210.5 | 100.0 |
| 2025-07-18 04:05:00 | AAPL | Stock | 210.51 | 210.53 | 210.51 | 210.53 | 204.0 |
| 2025-07-18 04:08:00 | AAPL | Stock | 210.54 | 210.54 | 210.49 | 210.49 | 399.0 |
| 2025-07-18 04:11:00 | AAPL | Stock | 210.53 | 210.53 | 210.53 | 210.53 | 145.0 |
| 2025-07-18 04:15:00 | AAPL | Stock | 210.5 | 210.5 | 210.5 | 210.5 | 100.0 |
| 2025-07-18 04:18:00 | AAPL | Stock | 210.53 | 210.53 | 210.53 | 210.53 | 113.0 |
| 2025-07-18 04:19:00 | AAPL | Stock | 210.56 | 210.56 | 210.56 | 210.56 | 100.0 |
| 2025-07-18 04:20:00 | AAPL | Stock | 210.56 | 210.56 | 210.56 | 210.56 | 2742.0 |
| 2025-07-18 04:23:00 | AAPL | Stock | 210.58 | 210.58 | 210.58 | 210.58 | 400.0 |
| 2025-07-18 04:28:00 | AAPL | Stock | 210.6 | 210.6 | 210.6 | 210.6 | 100.0 |
| 2025-07-18 04:33:00 | AAPL | Stock | 210.57 | 210.57 | 210.57 | 210.57 | 100.0 |
| 2025-07-18 04:37:00 | AAPL | Stock | 210.55 | 210.55 | 210.55 | 210.55 | 100.0 |
| 2025-07-18 04:45:00 | AAPL | Stock | 210.6 | 210.6 | 210.6 | 210.6 | 1623.0 |
| 2025-07-18 04:46:00 | AAPL | Stock | 210.55 | 210.57 | 210.55 | 210.57 | 970.0 |
| 2025-07-18 04:53:00 | AAPL | Stock | 210.6 | 210.6 | 210.6 | 210.6 | 200.0 |
| 2025-07-18 04:56:00 | AAPL | Stock | 210.55 | 210.55 | 210.55 | 210.55 | 100.0 |
| 2025-07-18 05:06:00 | AAPL | Stock | 210.58 | 210.58 | 210.58 | 210.58 | 100.0 |
| 2025-07-18 05:09:00 | AAPL | Stock | 210.58 | 210.58 | 210.58 | 210.58 | 240.0 |
| 2025-07-18 05:13:00 | AAPL | Stock | 210.66 | 210.8 | 210.66 | 210.8 | 5310.0 |
| 2025-07-18 05:18:00 | AAPL | Stock | 210.79 | 210.79 | 210.79 | 210.79 | 100.0 |
| 2025-07-18 05:25:00 | AAPL | Stock | 210.76 | 210.77 | 210.76 | 210.77 | 296.0 |
| 2025-07-18 05:26:00 | AAPL | Stock | 210.76 | 210.76 | 210.76 | 210.76 | 100.0 |
| 2025-07-18 05:29:00 | AAPL | Stock | 210.76 | 210.76 | 210.76 | 210.76 | 287.0 |
| 2025-07-18 05:30:00 | AAPL | Stock | 210.76 | 210.76 | 210.76 | 210.76 | 129.0 |
| 2025-07-18 05:31:00 | AAPL | Stock | 210.73 | 210.73 | 210.71 | 210.71 | 400.0 |
| 2025-07-18 05:42:00 | AAPL | Stock | 210.68 | 210.68 | 210.68 | 210.68 | 100.0 |
| 2025-07-18 05:47:00 | AAPL | Stock | 210.7 | 210.7 | 210.7 | 210.7 | 692.0 |
| 2025-07-18 05:51:00 | AAPL | Stock | 210.72 | 210.72 | 210.72 | 210.72 | 100.0 |
| 2025-07-18 05:56:00 | AAPL | Stock | 210.66 | 210.66 | 210.66 | 210.66 | 125.0 |
| 2025-07-18 05:58:00 | AAPL | Stock | 210.7 | 210.7 | 210.69 | 210.7 | 4561.0 |
| 2025-07-18 06:09:00 | AAPL | Stock | 210.67 | 210.67 | 210.67 | 210.67 | 100.0 |
| 2025-07-18 06:13:00 | AAPL | Stock | 210.67 | 210.67 | 210.67 | 210.67 | 108.0 |
| 2025-07-18 06:17:00 | AAPL | Stock | 210.65 | 210.65 | 210.65 | 210.65 | 659.0 |
| 2025-07-18 06:18:00 | AAPL | Stock | 210.65 | 210.65 | 210.65 | 210.65 | 2115.0 |
| 2025-07-18 06:19:00 | AAPL | Stock | 210.64 | 210.66 | 210.64 | 210.64 | 7304.0 |
| 2025-07-18 06:20:00 | AAPL | Stock | 210.63 | 210.63 | 210.58 | 210.58 | 877.0 |
| 2025-07-18 06:22:00 | AAPL | Stock | 210.58 | 210.58 | 210.49 | 210.49 | 512.0 |
| 2025-07-18 06:24:00 | AAPL | Stock | 210.55 | 210.55 | 210.55 | 210.55 | 100.0 |
| 2025-07-18 06:27:00 | AAPL | Stock | 210.59 | 210.59 | 210.59 | 210.59 | 100.0 |
| 2025-07-18 06:40:00 | AAPL | Stock | 210.5 | 210.5 | 210.48 | 210.48 | 200.0 |
| 2025-07-18 06:41:00 | AAPL | Stock | 210.5 | 210.5 | 210.5 | 210.5 | 222.0 |
| 2025-07-18 06:43:00 | AAPL | Stock | 210.49 | 210.49 | 210.49 | 210.49 | 249.0 |
| 2025-07-18 06:49:00 | AAPL | Stock | 210.48 | 210.48 | 210.35 | 210.35 | 6039.0 |
| 2025-07-18 06:52:00 | AAPL | Stock | 210.48 | 210.48 | 210.48 | 210.48 | 105.0 |
| 2025-07-18 06:53:00 | AAPL | Stock | 210.48 | 210.48 | 210.48 | 210.48 | 100.0 |
| 2025-07-18 06:56:00 | AAPL | Stock | 210.4 | 210.4 | 210.4 | 210.4 | 319.0 |
| 2025-07-18 06:57:00 | AAPL | Stock | 210.38 | 210.44 | 210.37 | 210.44 | 1091.0 |
> showing 50 of 1,357,484 rows — these rows as CSV