PREVIEW / stock_1min / 2024-10-17
file: by_date/stock_1min/2024/2024-10-17.parquet size: 21.0 MB rows: 1,200,543 symbols: 749
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-10-17 04:00:00 | AAPL | Stock | 232.0 | 233.4 | 232.0 | 233.3 | 2901.0 |
| 2024-10-17 04:01:00 | AAPL | Stock | 233.33 | 233.33 | 233.33 | 233.33 | 203.0 |
| 2024-10-17 04:02:00 | AAPL | Stock | 233.41 | 233.42 | 233.32 | 233.35 | 1667.0 |
| 2024-10-17 04:03:00 | AAPL | Stock | 233.43 | 233.43 | 233.25 | 233.29 | 1945.0 |
| 2024-10-17 04:04:00 | AAPL | Stock | 233.18 | 233.18 | 233.12 | 233.12 | 842.0 |
| 2024-10-17 04:05:00 | AAPL | Stock | 233.0 | 233.0 | 232.98 | 232.98 | 200.0 |
| 2024-10-17 04:06:00 | AAPL | Stock | 232.85 | 232.85 | 232.85 | 232.85 | 130.0 |
| 2024-10-17 04:07:00 | AAPL | Stock | 232.79 | 232.79 | 232.77 | 232.77 | 500.0 |
| 2024-10-17 04:10:00 | AAPL | Stock | 232.9 | 232.9 | 232.9 | 232.9 | 200.0 |
| 2024-10-17 04:11:00 | AAPL | Stock | 233.12 | 233.12 | 233.12 | 233.12 | 542.0 |
| 2024-10-17 04:12:00 | AAPL | Stock | 233.3 | 233.3 | 233.3 | 233.3 | 100.0 |
| 2024-10-17 04:13:00 | AAPL | Stock | 233.24 | 233.24 | 233.24 | 233.24 | 300.0 |
| 2024-10-17 04:14:00 | AAPL | Stock | 233.28 | 233.28 | 233.28 | 233.28 | 100.0 |
| 2024-10-17 04:15:00 | AAPL | Stock | 233.27 | 233.29 | 233.26 | 233.27 | 2718.0 |
| 2024-10-17 04:16:00 | AAPL | Stock | 233.27 | 233.28 | 233.27 | 233.28 | 331.0 |
| 2024-10-17 04:17:00 | AAPL | Stock | 233.3 | 233.3 | 233.3 | 233.3 | 311.0 |
| 2024-10-17 04:18:00 | AAPL | Stock | 233.29 | 233.29 | 233.29 | 233.29 | 100.0 |
| 2024-10-17 04:19:00 | AAPL | Stock | 233.28 | 233.28 | 233.28 | 233.28 | 581.0 |
| 2024-10-17 04:23:00 | AAPL | Stock | 233.25 | 233.25 | 233.2 | 233.2 | 537.0 |
| 2024-10-17 04:25:00 | AAPL | Stock | 233.18 | 233.18 | 233.18 | 233.18 | 350.0 |
| 2024-10-17 04:26:00 | AAPL | Stock | 233.19 | 233.19 | 233.19 | 233.19 | 123.0 |
| 2024-10-17 04:27:00 | AAPL | Stock | 233.18 | 233.18 | 233.18 | 233.18 | 762.0 |
| 2024-10-17 04:28:00 | AAPL | Stock | 233.18 | 233.18 | 233.1 | 233.16 | 1130.0 |
| 2024-10-17 04:29:00 | AAPL | Stock | 233.17 | 233.17 | 233.0 | 233.1 | 4322.0 |
| 2024-10-17 04:30:00 | AAPL | Stock | 233.06 | 233.28 | 233.0 | 233.28 | 1603.0 |
| 2024-10-17 04:31:00 | AAPL | Stock | 233.19 | 233.19 | 233.19 | 233.19 | 600.0 |
| 2024-10-17 04:32:00 | AAPL | Stock | 233.07 | 233.24 | 233.07 | 233.24 | 749.0 |
| 2024-10-17 04:33:00 | AAPL | Stock | 233.24 | 233.24 | 233.13 | 233.13 | 250.0 |
| 2024-10-17 04:35:00 | AAPL | Stock | 232.82 | 232.99 | 232.82 | 232.88 | 300.0 |
| 2024-10-17 04:36:00 | AAPL | Stock | 232.87 | 232.87 | 232.83 | 232.83 | 275.0 |
| 2024-10-17 04:37:00 | AAPL | Stock | 232.81 | 232.97 | 232.81 | 232.97 | 223.0 |
| 2024-10-17 04:39:00 | AAPL | Stock | 232.88 | 232.88 | 232.81 | 232.81 | 700.0 |
| 2024-10-17 04:40:00 | AAPL | Stock | 232.8 | 232.8 | 232.8 | 232.8 | 100.0 |
| 2024-10-17 04:41:00 | AAPL | Stock | 232.89 | 232.89 | 232.89 | 232.89 | 100.0 |
| 2024-10-17 04:43:00 | AAPL | Stock | 232.9 | 232.9 | 232.9 | 232.9 | 149.0 |
| 2024-10-17 04:44:00 | AAPL | Stock | 232.82 | 233.04 | 232.82 | 233.04 | 820.0 |
| 2024-10-17 04:45:00 | AAPL | Stock | 233.04 | 233.09 | 232.99 | 233.04 | 2213.0 |
| 2024-10-17 04:46:00 | AAPL | Stock | 233.0 | 233.09 | 232.99 | 232.99 | 1301.0 |
| 2024-10-17 04:47:00 | AAPL | Stock | 232.99 | 233.23 | 232.99 | 233.22 | 3285.0 |
| 2024-10-17 04:48:00 | AAPL | Stock | 233.23 | 233.25 | 233.23 | 233.25 | 299.0 |
| 2024-10-17 04:50:00 | AAPL | Stock | 233.21 | 233.22 | 233.21 | 233.22 | 701.0 |
| 2024-10-17 04:51:00 | AAPL | Stock | 233.25 | 233.29 | 233.25 | 233.29 | 499.0 |
| 2024-10-17 04:52:00 | AAPL | Stock | 233.29 | 233.31 | 233.29 | 233.31 | 639.0 |
| 2024-10-17 04:53:00 | AAPL | Stock | 233.51 | 233.51 | 233.51 | 233.51 | 100.0 |
| 2024-10-17 04:54:00 | AAPL | Stock | 233.48 | 233.64 | 233.47 | 233.6 | 4694.0 |
| 2024-10-17 04:55:00 | AAPL | Stock | 233.9 | 233.9 | 233.79 | 233.79 | 1408.0 |
| 2024-10-17 04:56:00 | AAPL | Stock | 233.63 | 233.63 | 233.47 | 233.47 | 549.0 |
| 2024-10-17 04:57:00 | AAPL | Stock | 233.02 | 233.05 | 233.0 | 233.0 | 1100.0 |
| 2024-10-17 04:58:00 | AAPL | Stock | 232.99 | 232.99 | 232.9 | 232.9 | 1514.0 |
| 2024-10-17 05:00:00 | AAPL | Stock | 232.86 | 232.86 | 232.81 | 232.81 | 371.0 |
> showing 50 of 1,200,543 rows — these rows as CSV