PREVIEW / stock_1min / 2023-08-07
file: by_date/stock_1min/2023/2023-08-07.parquet size: 20.8 MB rows: 1,275,839 symbols: 1,450
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-08-07 04:00:00 | AAPL | Stock | 183.04 | 183.49 | 182.54 | 183.3 | 5927.0 |
| 2023-08-07 04:01:00 | AAPL | Stock | 183.27 | 183.37 | 183.25 | 183.25 | 1756.0 |
| 2023-08-07 04:02:00 | AAPL | Stock | 183.24 | 183.28 | 183.24 | 183.28 | 1287.0 |
| 2023-08-07 04:03:00 | AAPL | Stock | 183.32 | 183.37 | 183.25 | 183.25 | 3247.0 |
| 2023-08-07 04:04:00 | AAPL | Stock | 183.33 | 183.35 | 183.25 | 183.35 | 2723.0 |
| 2023-08-07 04:05:00 | AAPL | Stock | 183.25 | 183.35 | 183.25 | 183.28 | 1645.0 |
| 2023-08-07 04:06:00 | AAPL | Stock | 183.28 | 183.28 | 183.2 | 183.2 | 4655.0 |
| 2023-08-07 04:08:00 | AAPL | Stock | 183.24 | 183.24 | 183.15 | 183.15 | 925.0 |
| 2023-08-07 04:09:00 | AAPL | Stock | 183.12 | 183.2 | 183.0 | 183.01 | 4792.0 |
| 2023-08-07 04:10:00 | AAPL | Stock | 182.89 | 182.89 | 182.8 | 182.8 | 783.0 |
| 2023-08-07 04:11:00 | AAPL | Stock | 182.83 | 182.89 | 182.83 | 182.85 | 4895.0 |
| 2023-08-07 04:12:00 | AAPL | Stock | 182.82 | 182.82 | 182.77 | 182.82 | 1438.0 |
| 2023-08-07 04:13:00 | AAPL | Stock | 182.75 | 183.0 | 182.75 | 183.0 | 3207.0 |
| 2023-08-07 04:14:00 | AAPL | Stock | 182.95 | 182.95 | 182.93 | 182.93 | 1094.0 |
| 2023-08-07 04:15:00 | AAPL | Stock | 182.95 | 182.95 | 182.9 | 182.95 | 1294.0 |
| 2023-08-07 04:16:00 | AAPL | Stock | 182.93 | 182.93 | 182.93 | 182.93 | 100.0 |
| 2023-08-07 04:18:00 | AAPL | Stock | 182.93 | 182.93 | 182.93 | 182.93 | 100.0 |
| 2023-08-07 04:19:00 | AAPL | Stock | 182.97 | 182.97 | 182.97 | 182.97 | 667.0 |
| 2023-08-07 04:20:00 | AAPL | Stock | 183.0 | 183.0 | 183.0 | 183.0 | 762.0 |
| 2023-08-07 04:21:00 | AAPL | Stock | 183.0 | 183.0 | 183.0 | 183.0 | 873.0 |
| 2023-08-07 04:22:00 | AAPL | Stock | 183.0 | 183.0 | 183.0 | 183.0 | 480.0 |
| 2023-08-07 04:23:00 | AAPL | Stock | 182.98 | 183.0 | 182.98 | 183.0 | 722.0 |
| 2023-08-07 04:24:00 | AAPL | Stock | 183.0 | 183.0 | 183.0 | 183.0 | 183.0 |
| 2023-08-07 04:25:00 | AAPL | Stock | 182.93 | 182.93 | 182.93 | 182.93 | 100.0 |
| 2023-08-07 04:26:00 | AAPL | Stock | 182.89 | 182.89 | 182.89 | 182.89 | 100.0 |
| 2023-08-07 04:29:00 | AAPL | Stock | 182.97 | 182.97 | 182.97 | 182.97 | 100.0 |
| 2023-08-07 04:31:00 | AAPL | Stock | 183.0 | 183.0 | 182.98 | 183.0 | 1108.0 |
| 2023-08-07 04:32:00 | AAPL | Stock | 183.02 | 183.02 | 183.02 | 183.02 | 100.0 |
| 2023-08-07 04:33:00 | AAPL | Stock | 183.0 | 183.0 | 182.89 | 182.89 | 2258.0 |
| 2023-08-07 04:34:00 | AAPL | Stock | 182.87 | 182.99 | 182.81 | 182.99 | 5152.0 |
| 2023-08-07 04:35:00 | AAPL | Stock | 182.87 | 182.87 | 182.84 | 182.84 | 3583.0 |
| 2023-08-07 04:36:00 | AAPL | Stock | 182.9 | 182.9 | 182.9 | 182.9 | 310.0 |
| 2023-08-07 04:38:00 | AAPL | Stock | 182.9 | 182.9 | 182.9 | 182.9 | 100.0 |
| 2023-08-07 04:40:00 | AAPL | Stock | 182.98 | 182.98 | 182.98 | 182.98 | 276.0 |
| 2023-08-07 04:41:00 | AAPL | Stock | 182.98 | 182.98 | 182.91 | 182.91 | 854.0 |
| 2023-08-07 04:43:00 | AAPL | Stock | 182.91 | 182.91 | 182.91 | 182.91 | 100.0 |
| 2023-08-07 04:44:00 | AAPL | Stock | 182.84 | 182.99 | 182.8 | 182.99 | 3700.0 |
| 2023-08-07 04:45:00 | AAPL | Stock | 182.88 | 182.88 | 182.8 | 182.86 | 1590.0 |
| 2023-08-07 04:46:00 | AAPL | Stock | 182.81 | 182.81 | 182.76 | 182.76 | 2826.0 |
| 2023-08-07 04:48:00 | AAPL | Stock | 182.77 | 182.78 | 182.77 | 182.78 | 326.0 |
| 2023-08-07 04:49:00 | AAPL | Stock | 182.75 | 182.75 | 182.75 | 182.75 | 150.0 |
| 2023-08-07 04:52:00 | AAPL | Stock | 182.85 | 182.88 | 182.85 | 182.88 | 427.0 |
| 2023-08-07 04:53:00 | AAPL | Stock | 182.95 | 182.98 | 182.95 | 182.98 | 406.0 |
| 2023-08-07 04:54:00 | AAPL | Stock | 182.99 | 182.99 | 182.98 | 182.98 | 1049.0 |
| 2023-08-07 04:55:00 | AAPL | Stock | 182.98 | 183.04 | 182.98 | 182.99 | 975.0 |
| 2023-08-07 04:56:00 | AAPL | Stock | 183.02 | 183.02 | 183.0 | 183.02 | 1150.0 |
| 2023-08-07 04:57:00 | AAPL | Stock | 183.0 | 183.01 | 183.0 | 183.0 | 484.0 |
| 2023-08-07 04:58:00 | AAPL | Stock | 183.0 | 183.0 | 183.0 | 183.0 | 475.0 |
| 2023-08-07 04:59:00 | AAPL | Stock | 182.94 | 182.94 | 182.91 | 182.91 | 900.0 |
| 2023-08-07 05:00:00 | AAPL | Stock | 182.82 | 182.82 | 182.82 | 182.82 | 200.0 |
> showing 50 of 1,275,839 rows — these rows as CSV