PREVIEW / stock_1min / 2023-10-16
file: by_date/stock_1min/2023/2023-10-16.parquet size: 20.1 MB rows: 1,234,116 symbols: 1,305
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-16 04:00:00 | AAPL | Stock | 178.54 | 178.54 | 178.54 | 178.54 | 354.0 |
| 2023-10-16 04:02:00 | AAPL | Stock | 178.55 | 178.55 | 178.55 | 178.55 | 400.0 |
| 2023-10-16 04:07:00 | AAPL | Stock | 178.4 | 178.4 | 178.4 | 178.4 | 100.0 |
| 2023-10-16 04:09:00 | AAPL | Stock | 178.29 | 178.29 | 178.29 | 178.29 | 100.0 |
| 2023-10-16 04:10:00 | AAPL | Stock | 178.28 | 178.36 | 178.28 | 178.36 | 519.0 |
| 2023-10-16 04:13:00 | AAPL | Stock | 178.3 | 178.3 | 178.3 | 178.3 | 250.0 |
| 2023-10-16 04:14:00 | AAPL | Stock | 178.27 | 178.41 | 178.27 | 178.3 | 1387.0 |
| 2023-10-16 04:15:00 | AAPL | Stock | 178.21 | 178.21 | 178.2 | 178.2 | 406.0 |
| 2023-10-16 04:17:00 | AAPL | Stock | 178.23 | 178.23 | 178.23 | 178.23 | 400.0 |
| 2023-10-16 04:20:00 | AAPL | Stock | 178.35 | 178.5 | 178.35 | 178.5 | 1135.0 |
| 2023-10-16 04:22:00 | AAPL | Stock | 178.48 | 178.58 | 178.48 | 178.54 | 642.0 |
| 2023-10-16 04:24:00 | AAPL | Stock | 178.59 | 178.59 | 178.57 | 178.57 | 286.0 |
| 2023-10-16 04:25:00 | AAPL | Stock | 178.52 | 178.6 | 178.5 | 178.6 | 1832.0 |
| 2023-10-16 04:26:00 | AAPL | Stock | 178.6 | 178.65 | 178.6 | 178.65 | 421.0 |
| 2023-10-16 04:28:00 | AAPL | Stock | 178.75 | 178.76 | 178.75 | 178.76 | 402.0 |
| 2023-10-16 04:29:00 | AAPL | Stock | 178.69 | 178.69 | 178.69 | 178.69 | 100.0 |
| 2023-10-16 04:30:00 | AAPL | Stock | 178.66 | 178.66 | 178.66 | 178.66 | 215.0 |
| 2023-10-16 04:32:00 | AAPL | Stock | 178.73 | 178.73 | 178.73 | 178.73 | 215.0 |
| 2023-10-16 04:33:00 | AAPL | Stock | 178.66 | 178.66 | 178.66 | 178.66 | 198.0 |
| 2023-10-16 04:35:00 | AAPL | Stock | 178.68 | 178.68 | 178.68 | 178.68 | 207.0 |
| 2023-10-16 04:36:00 | AAPL | Stock | 178.68 | 178.74 | 178.68 | 178.74 | 885.0 |
| 2023-10-16 04:37:00 | AAPL | Stock | 178.74 | 178.78 | 178.74 | 178.78 | 415.0 |
| 2023-10-16 04:39:00 | AAPL | Stock | 178.65 | 178.65 | 178.65 | 178.65 | 100.0 |
| 2023-10-16 04:43:00 | AAPL | Stock | 178.69 | 178.69 | 178.69 | 178.69 | 300.0 |
| 2023-10-16 04:44:00 | AAPL | Stock | 178.69 | 178.69 | 178.69 | 178.69 | 177.0 |
| 2023-10-16 04:45:00 | AAPL | Stock | 178.71 | 178.72 | 178.71 | 178.72 | 566.0 |
| 2023-10-16 04:47:00 | AAPL | Stock | 178.62 | 178.72 | 178.62 | 178.72 | 391.0 |
| 2023-10-16 04:48:00 | AAPL | Stock | 178.72 | 178.75 | 178.72 | 178.75 | 2207.0 |
| 2023-10-16 04:49:00 | AAPL | Stock | 178.75 | 178.75 | 178.75 | 178.75 | 2004.0 |
| 2023-10-16 04:50:00 | AAPL | Stock | 178.8 | 178.84 | 178.8 | 178.84 | 265.0 |
| 2023-10-16 04:52:00 | AAPL | Stock | 178.77 | 178.8 | 178.77 | 178.8 | 326.0 |
| 2023-10-16 04:54:00 | AAPL | Stock | 178.7 | 178.74 | 178.7 | 178.74 | 2131.0 |
| 2023-10-16 04:55:00 | AAPL | Stock | 178.78 | 178.78 | 178.78 | 178.78 | 326.0 |
| 2023-10-16 05:00:00 | AAPL | Stock | 178.65 | 178.65 | 178.65 | 178.65 | 157.0 |
| 2023-10-16 05:03:00 | AAPL | Stock | 178.61 | 178.61 | 178.61 | 178.61 | 197.0 |
| 2023-10-16 05:06:00 | AAPL | Stock | 178.66 | 178.67 | 178.63 | 178.63 | 1053.0 |
| 2023-10-16 05:07:00 | AAPL | Stock | 178.67 | 178.67 | 178.67 | 178.67 | 1586.0 |
| 2023-10-16 05:12:00 | AAPL | Stock | 178.56 | 178.56 | 178.56 | 178.56 | 178.0 |
| 2023-10-16 05:16:00 | AAPL | Stock | 178.65 | 178.65 | 178.65 | 178.65 | 452.0 |
| 2023-10-16 05:22:00 | AAPL | Stock | 178.58 | 178.58 | 178.58 | 178.58 | 855.0 |
| 2023-10-16 05:24:00 | AAPL | Stock | 178.52 | 178.52 | 178.52 | 178.52 | 500.0 |
| 2023-10-16 05:30:00 | AAPL | Stock | 178.44 | 178.44 | 178.44 | 178.44 | 100.0 |
| 2023-10-16 05:31:00 | AAPL | Stock | 178.45 | 178.46 | 178.44 | 178.46 | 950.0 |
| 2023-10-16 05:33:00 | AAPL | Stock | 178.44 | 178.47 | 178.44 | 178.47 | 1100.0 |
| 2023-10-16 05:34:00 | AAPL | Stock | 178.48 | 178.48 | 178.46 | 178.48 | 475.0 |
| 2023-10-16 05:35:00 | AAPL | Stock | 178.49 | 178.51 | 178.49 | 178.51 | 900.0 |
| 2023-10-16 05:36:00 | AAPL | Stock | 178.51 | 178.59 | 178.51 | 178.59 | 900.0 |
| 2023-10-16 05:37:00 | AAPL | Stock | 178.59 | 178.59 | 178.59 | 178.59 | 238.0 |
| 2023-10-16 05:39:00 | AAPL | Stock | 178.58 | 178.6 | 178.58 | 178.6 | 400.0 |
| 2023-10-16 05:40:00 | AAPL | Stock | 178.6 | 178.6 | 178.6 | 178.6 | 100.0 |
> showing 50 of 1,234,116 rows — these rows as CSV