PREVIEW / stock_1min / 2024-09-10
file: by_date/stock_1min/2024/2024-09-10.parquet size: 18.9 MB rows: 1,199,959 symbols: 860
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-09-10 04:00:00 | AAPL | Stock | 219.69 | 219.8 | 219.4 | 219.4 | 2075.0 |
| 2024-09-10 04:01:00 | AAPL | Stock | 219.4 | 219.4 | 219.3 | 219.35 | 822.0 |
| 2024-09-10 04:02:00 | AAPL | Stock | 219.17 | 219.17 | 218.68 | 218.68 | 2518.0 |
| 2024-09-10 04:03:00 | AAPL | Stock | 218.63 | 219.09 | 218.63 | 219.09 | 2086.0 |
| 2024-09-10 04:04:00 | AAPL | Stock | 218.91 | 218.91 | 218.9 | 218.9 | 210.0 |
| 2024-09-10 04:05:00 | AAPL | Stock | 218.8 | 218.8 | 218.55 | 218.55 | 1213.0 |
| 2024-09-10 04:06:00 | AAPL | Stock | 218.55 | 218.64 | 218.55 | 218.64 | 262.0 |
| 2024-09-10 04:07:00 | AAPL | Stock | 218.7 | 218.7 | 218.7 | 218.7 | 100.0 |
| 2024-09-10 04:08:00 | AAPL | Stock | 218.79 | 218.8 | 218.79 | 218.8 | 287.0 |
| 2024-09-10 04:09:00 | AAPL | Stock | 218.79 | 218.79 | 218.69 | 218.69 | 450.0 |
| 2024-09-10 04:10:00 | AAPL | Stock | 218.6 | 218.6 | 218.0 | 218.02 | 1637.0 |
| 2024-09-10 04:11:00 | AAPL | Stock | 218.02 | 218.06 | 218.0 | 218.06 | 1019.0 |
| 2024-09-10 04:12:00 | AAPL | Stock | 217.81 | 217.81 | 217.71 | 217.71 | 656.0 |
| 2024-09-10 04:13:00 | AAPL | Stock | 217.79 | 217.82 | 217.7 | 217.7 | 1856.0 |
| 2024-09-10 04:14:00 | AAPL | Stock | 217.72 | 217.79 | 217.63 | 217.79 | 3336.0 |
| 2024-09-10 04:15:00 | AAPL | Stock | 217.8 | 217.8 | 217.7 | 217.7 | 335.0 |
| 2024-09-10 04:16:00 | AAPL | Stock | 218.0 | 218.0 | 217.99 | 218.0 | 2711.0 |
| 2024-09-10 04:17:00 | AAPL | Stock | 218.1 | 218.21 | 218.1 | 218.21 | 2290.0 |
| 2024-09-10 04:18:00 | AAPL | Stock | 218.49 | 218.53 | 218.49 | 218.5 | 4228.0 |
| 2024-09-10 04:19:00 | AAPL | Stock | 218.59 | 218.59 | 218.47 | 218.47 | 887.0 |
| 2024-09-10 04:20:00 | AAPL | Stock | 218.32 | 218.32 | 218.3 | 218.3 | 497.0 |
| 2024-09-10 04:21:00 | AAPL | Stock | 218.45 | 218.49 | 218.45 | 218.49 | 200.0 |
| 2024-09-10 04:22:00 | AAPL | Stock | 218.38 | 218.38 | 218.3 | 218.3 | 592.0 |
| 2024-09-10 04:23:00 | AAPL | Stock | 218.3 | 218.3 | 218.3 | 218.3 | 871.0 |
| 2024-09-10 04:24:00 | AAPL | Stock | 218.35 | 218.35 | 218.2 | 218.2 | 2623.0 |
| 2024-09-10 04:25:00 | AAPL | Stock | 218.23 | 218.33 | 218.23 | 218.33 | 2161.0 |
| 2024-09-10 04:26:00 | AAPL | Stock | 218.35 | 218.7 | 218.34 | 218.7 | 3286.0 |
| 2024-09-10 04:27:00 | AAPL | Stock | 218.71 | 218.75 | 218.7 | 218.75 | 3654.0 |
| 2024-09-10 04:28:00 | AAPL | Stock | 218.75 | 218.91 | 218.75 | 218.91 | 1710.0 |
| 2024-09-10 04:29:00 | AAPL | Stock | 218.9 | 218.98 | 218.87 | 218.9 | 1847.0 |
| 2024-09-10 04:30:00 | AAPL | Stock | 218.78 | 218.99 | 218.78 | 218.99 | 2520.0 |
| 2024-09-10 04:31:00 | AAPL | Stock | 219.0 | 219.09 | 219.0 | 219.05 | 905.0 |
| 2024-09-10 04:32:00 | AAPL | Stock | 218.95 | 218.95 | 218.6 | 218.6 | 1900.0 |
| 2024-09-10 04:34:00 | AAPL | Stock | 218.61 | 218.61 | 218.42 | 218.42 | 999.0 |
| 2024-09-10 04:35:00 | AAPL | Stock | 218.41 | 218.41 | 218.26 | 218.26 | 1128.0 |
| 2024-09-10 04:37:00 | AAPL | Stock | 218.25 | 218.25 | 218.25 | 218.25 | 100.0 |
| 2024-09-10 04:39:00 | AAPL | Stock | 218.32 | 218.32 | 218.32 | 218.32 | 100.0 |
| 2024-09-10 04:41:00 | AAPL | Stock | 218.36 | 218.41 | 218.32 | 218.41 | 685.0 |
| 2024-09-10 04:42:00 | AAPL | Stock | 218.32 | 218.32 | 218.3 | 218.31 | 1100.0 |
| 2024-09-10 04:43:00 | AAPL | Stock | 218.32 | 218.32 | 218.31 | 218.31 | 299.0 |
| 2024-09-10 04:45:00 | AAPL | Stock | 218.35 | 218.5 | 218.35 | 218.5 | 821.0 |
| 2024-09-10 04:46:00 | AAPL | Stock | 218.36 | 218.36 | 218.36 | 218.36 | 187.0 |
| 2024-09-10 04:49:00 | AAPL | Stock | 218.47 | 218.47 | 218.47 | 218.47 | 200.0 |
| 2024-09-10 04:50:00 | AAPL | Stock | 218.5 | 218.5 | 218.5 | 218.5 | 100.0 |
| 2024-09-10 04:54:00 | AAPL | Stock | 218.51 | 218.51 | 218.5 | 218.5 | 356.0 |
| 2024-09-10 04:55:00 | AAPL | Stock | 218.5 | 218.5 | 218.5 | 218.5 | 795.0 |
| 2024-09-10 04:57:00 | AAPL | Stock | 218.43 | 218.43 | 218.43 | 218.43 | 407.0 |
| 2024-09-10 05:00:00 | AAPL | Stock | 218.22 | 218.22 | 218.15 | 218.15 | 913.0 |
| 2024-09-10 05:01:00 | AAPL | Stock | 218.15 | 218.15 | 218.03 | 218.03 | 1423.0 |
| 2024-09-10 05:02:00 | AAPL | Stock | 218.1 | 218.12 | 218.1 | 218.1 | 2300.0 |
> showing 50 of 1,199,959 rows — these rows as CSV