PREVIEW / stock_1min / 2024-07-17
file: by_date/stock_1min/2024/2024-07-17.parquet size: 21.4 MB rows: 1,316,730 symbols: 899
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-07-17 04:00:00 | AAPL | Stock | 233.41 | 233.41 | 231.97 | 232.15 | 1756.0 |
| 2024-07-17 04:01:00 | AAPL | Stock | 232.15 | 232.19 | 232.15 | 232.16 | 584.0 |
| 2024-07-17 04:02:00 | AAPL | Stock | 232.29 | 232.39 | 232.29 | 232.38 | 2194.0 |
| 2024-07-17 04:03:00 | AAPL | Stock | 232.2 | 232.31 | 232.2 | 232.31 | 293.0 |
| 2024-07-17 04:04:00 | AAPL | Stock | 232.22 | 232.25 | 232.2 | 232.25 | 4547.0 |
| 2024-07-17 04:05:00 | AAPL | Stock | 232.25 | 232.25 | 232.0 | 232.03 | 3401.0 |
| 2024-07-17 04:06:00 | AAPL | Stock | 232.0 | 232.0 | 231.95 | 231.95 | 500.0 |
| 2024-07-17 04:07:00 | AAPL | Stock | 231.95 | 231.95 | 231.95 | 231.95 | 102.0 |
| 2024-07-17 04:08:00 | AAPL | Stock | 231.93 | 231.93 | 231.93 | 231.93 | 100.0 |
| 2024-07-17 04:10:00 | AAPL | Stock | 231.7 | 231.7 | 231.67 | 231.67 | 406.0 |
| 2024-07-17 04:11:00 | AAPL | Stock | 231.56 | 231.56 | 231.55 | 231.55 | 2044.0 |
| 2024-07-17 04:12:00 | AAPL | Stock | 231.35 | 231.35 | 231.17 | 231.17 | 534.0 |
| 2024-07-17 04:13:00 | AAPL | Stock | 231.16 | 231.29 | 231.16 | 231.2 | 8904.0 |
| 2024-07-17 04:14:00 | AAPL | Stock | 231.08 | 231.08 | 231.01 | 231.01 | 858.0 |
| 2024-07-17 04:15:00 | AAPL | Stock | 231.09 | 231.3 | 231.09 | 231.3 | 2440.0 |
| 2024-07-17 04:16:00 | AAPL | Stock | 231.3 | 231.3 | 231.3 | 231.3 | 140.0 |
| 2024-07-17 04:17:00 | AAPL | Stock | 231.29 | 231.29 | 231.18 | 231.28 | 1658.0 |
| 2024-07-17 04:18:00 | AAPL | Stock | 231.19 | 231.3 | 231.05 | 231.07 | 2769.0 |
| 2024-07-17 04:19:00 | AAPL | Stock | 231.07 | 231.07 | 231.0 | 231.01 | 3207.0 |
| 2024-07-17 04:20:00 | AAPL | Stock | 230.95 | 230.95 | 230.89 | 230.89 | 1651.0 |
| 2024-07-17 04:21:00 | AAPL | Stock | 230.81 | 230.82 | 230.8 | 230.8 | 1584.0 |
| 2024-07-17 04:22:00 | AAPL | Stock | 230.75 | 230.75 | 230.47 | 230.47 | 9518.0 |
| 2024-07-17 04:23:00 | AAPL | Stock | 230.4 | 230.51 | 230.35 | 230.35 | 1642.0 |
| 2024-07-17 04:24:00 | AAPL | Stock | 230.43 | 230.45 | 230.28 | 230.28 | 1463.0 |
| 2024-07-17 04:25:00 | AAPL | Stock | 230.35 | 230.36 | 230.35 | 230.36 | 300.0 |
| 2024-07-17 04:26:00 | AAPL | Stock | 230.35 | 230.35 | 230.3 | 230.34 | 850.0 |
| 2024-07-17 04:27:00 | AAPL | Stock | 230.41 | 230.45 | 230.41 | 230.45 | 616.0 |
| 2024-07-17 04:28:00 | AAPL | Stock | 230.55 | 230.55 | 230.55 | 230.55 | 150.0 |
| 2024-07-17 04:29:00 | AAPL | Stock | 230.5 | 230.5 | 230.45 | 230.45 | 3194.0 |
| 2024-07-17 04:30:00 | AAPL | Stock | 230.4 | 230.55 | 230.39 | 230.55 | 1087.0 |
| 2024-07-17 04:31:00 | AAPL | Stock | 230.6 | 230.65 | 230.6 | 230.65 | 478.0 |
| 2024-07-17 04:33:00 | AAPL | Stock | 230.56 | 230.6 | 230.55 | 230.6 | 407.0 |
| 2024-07-17 04:34:00 | AAPL | Stock | 230.65 | 230.7 | 230.62 | 230.7 | 500.0 |
| 2024-07-17 04:35:00 | AAPL | Stock | 230.8 | 230.87 | 230.77 | 230.86 | 2000.0 |
| 2024-07-17 04:36:00 | AAPL | Stock | 230.82 | 230.82 | 230.78 | 230.78 | 280.0 |
| 2024-07-17 04:37:00 | AAPL | Stock | 230.78 | 230.81 | 230.78 | 230.81 | 448.0 |
| 2024-07-17 04:38:00 | AAPL | Stock | 230.73 | 230.82 | 230.73 | 230.82 | 1567.0 |
| 2024-07-17 04:40:00 | AAPL | Stock | 230.72 | 230.72 | 230.65 | 230.65 | 791.0 |
| 2024-07-17 04:43:00 | AAPL | Stock | 230.59 | 230.59 | 230.59 | 230.59 | 200.0 |
| 2024-07-17 04:45:00 | AAPL | Stock | 230.57 | 230.57 | 230.57 | 230.57 | 217.0 |
| 2024-07-17 04:46:00 | AAPL | Stock | 230.56 | 230.56 | 230.56 | 230.56 | 118.0 |
| 2024-07-17 04:47:00 | AAPL | Stock | 230.66 | 230.66 | 230.66 | 230.66 | 200.0 |
| 2024-07-17 04:49:00 | AAPL | Stock | 230.79 | 230.88 | 230.79 | 230.86 | 738.0 |
| 2024-07-17 04:50:00 | AAPL | Stock | 230.88 | 230.89 | 230.88 | 230.89 | 308.0 |
| 2024-07-17 04:51:00 | AAPL | Stock | 230.85 | 231.0 | 230.85 | 231.0 | 1499.0 |
| 2024-07-17 04:52:00 | AAPL | Stock | 231.0 | 231.0 | 231.0 | 231.0 | 200.0 |
| 2024-07-17 04:53:00 | AAPL | Stock | 231.08 | 231.09 | 231.08 | 231.09 | 221.0 |
| 2024-07-17 04:56:00 | AAPL | Stock | 231.05 | 231.05 | 231.0 | 231.0 | 292.0 |
| 2024-07-17 04:57:00 | AAPL | Stock | 231.12 | 231.15 | 231.07 | 231.12 | 1271.0 |
| 2024-07-17 04:58:00 | AAPL | Stock | 231.12 | 231.12 | 231.12 | 231.12 | 200.0 |
> showing 50 of 1,316,730 rows — these rows as CSV