PREVIEW / stock_1min / 2023-12-20
file: by_date/stock_1min/2023/2023-12-20.parquet size: 22.5 MB rows: 1,347,601 symbols: 1,220
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-12-20 04:00:00 | AAPL | Stock | 196.0 | 196.2 | 195.97 | 195.97 | 1598.0 |
| 2023-12-20 04:01:00 | AAPL | Stock | 196.01 | 196.05 | 195.92 | 195.92 | 1952.0 |
| 2023-12-20 04:02:00 | AAPL | Stock | 195.88 | 195.99 | 195.81 | 195.81 | 800.0 |
| 2023-12-20 04:03:00 | AAPL | Stock | 195.82 | 195.9 | 195.8 | 195.81 | 667.0 |
| 2023-12-20 04:05:00 | AAPL | Stock | 195.77 | 195.77 | 195.74 | 195.74 | 400.0 |
| 2023-12-20 04:06:00 | AAPL | Stock | 195.75 | 195.75 | 195.71 | 195.71 | 200.0 |
| 2023-12-20 04:07:00 | AAPL | Stock | 195.71 | 195.8 | 195.71 | 195.8 | 500.0 |
| 2023-12-20 04:11:00 | AAPL | Stock | 195.91 | 195.95 | 195.86 | 195.95 | 500.0 |
| 2023-12-20 04:15:00 | AAPL | Stock | 196.05 | 196.05 | 196.05 | 196.05 | 423.0 |
| 2023-12-20 04:21:00 | AAPL | Stock | 196.06 | 196.06 | 196.06 | 196.06 | 100.0 |
| 2023-12-20 04:23:00 | AAPL | Stock | 196.17 | 196.17 | 196.16 | 196.16 | 500.0 |
| 2023-12-20 04:24:00 | AAPL | Stock | 196.15 | 196.15 | 196.15 | 196.15 | 100.0 |
| 2023-12-20 04:27:00 | AAPL | Stock | 196.09 | 196.09 | 196.09 | 196.09 | 200.0 |
| 2023-12-20 04:28:00 | AAPL | Stock | 196.06 | 196.06 | 196.04 | 196.04 | 531.0 |
| 2023-12-20 04:32:00 | AAPL | Stock | 195.96 | 195.96 | 195.96 | 195.96 | 104.0 |
| 2023-12-20 04:33:00 | AAPL | Stock | 195.9 | 195.9 | 195.9 | 195.9 | 100.0 |
| 2023-12-20 04:38:00 | AAPL | Stock | 195.78 | 195.78 | 195.69 | 195.69 | 1551.0 |
| 2023-12-20 04:45:00 | AAPL | Stock | 195.68 | 195.68 | 195.68 | 195.68 | 150.0 |
| 2023-12-20 04:46:00 | AAPL | Stock | 195.69 | 195.7 | 195.69 | 195.7 | 431.0 |
| 2023-12-20 04:48:00 | AAPL | Stock | 195.78 | 195.78 | 195.78 | 195.78 | 313.0 |
| 2023-12-20 04:49:00 | AAPL | Stock | 195.78 | 195.78 | 195.78 | 195.78 | 100.0 |
| 2023-12-20 04:50:00 | AAPL | Stock | 195.78 | 195.78 | 195.78 | 195.78 | 225.0 |
| 2023-12-20 04:52:00 | AAPL | Stock | 195.87 | 195.93 | 195.86 | 195.93 | 1163.0 |
| 2023-12-20 04:58:00 | AAPL | Stock | 195.95 | 195.95 | 195.95 | 195.95 | 140.0 |
| 2023-12-20 05:03:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 106.0 |
| 2023-12-20 05:04:00 | AAPL | Stock | 195.95 | 195.95 | 195.95 | 195.95 | 100.0 |
| 2023-12-20 05:12:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 255.0 |
| 2023-12-20 05:14:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 100.0 |
| 2023-12-20 05:16:00 | AAPL | Stock | 195.95 | 195.95 | 195.95 | 195.95 | 276.0 |
| 2023-12-20 05:17:00 | AAPL | Stock | 195.87 | 195.88 | 195.87 | 195.87 | 489.0 |
| 2023-12-20 05:18:00 | AAPL | Stock | 195.85 | 195.85 | 195.85 | 195.85 | 255.0 |
| 2023-12-20 05:21:00 | AAPL | Stock | 195.84 | 195.85 | 195.84 | 195.85 | 1290.0 |
| 2023-12-20 05:22:00 | AAPL | Stock | 195.84 | 195.84 | 195.83 | 195.83 | 357.0 |
| 2023-12-20 05:23:00 | AAPL | Stock | 195.87 | 195.87 | 195.87 | 195.87 | 300.0 |
| 2023-12-20 05:24:00 | AAPL | Stock | 195.85 | 195.85 | 195.85 | 195.85 | 100.0 |
| 2023-12-20 05:25:00 | AAPL | Stock | 195.86 | 195.86 | 195.86 | 195.86 | 100.0 |
| 2023-12-20 05:28:00 | AAPL | Stock | 195.86 | 195.86 | 195.86 | 195.86 | 180.0 |
| 2023-12-20 05:29:00 | AAPL | Stock | 195.87 | 195.87 | 195.85 | 195.85 | 2111.0 |
| 2023-12-20 05:35:00 | AAPL | Stock | 195.81 | 195.81 | 195.81 | 195.81 | 200.0 |
| 2023-12-20 05:40:00 | AAPL | Stock | 195.87 | 195.87 | 195.87 | 195.87 | 100.0 |
| 2023-12-20 05:42:00 | AAPL | Stock | 195.88 | 195.88 | 195.88 | 195.88 | 999.0 |
| 2023-12-20 05:43:00 | AAPL | Stock | 195.95 | 195.95 | 195.95 | 195.95 | 257.0 |
| 2023-12-20 05:45:00 | AAPL | Stock | 195.96 | 195.96 | 195.96 | 195.96 | 200.0 |
| 2023-12-20 05:47:00 | AAPL | Stock | 195.97 | 195.97 | 195.97 | 195.97 | 200.0 |
| 2023-12-20 05:49:00 | AAPL | Stock | 195.96 | 195.96 | 195.96 | 195.96 | 449.0 |
| 2023-12-20 05:53:00 | AAPL | Stock | 195.96 | 195.96 | 195.96 | 195.96 | 255.0 |
| 2023-12-20 05:55:00 | AAPL | Stock | 195.99 | 195.99 | 195.99 | 195.99 | 255.0 |
| 2023-12-20 06:00:00 | AAPL | Stock | 195.99 | 196.04 | 195.99 | 196.02 | 537.0 |
| 2023-12-20 06:03:00 | AAPL | Stock | 195.99 | 195.99 | 195.99 | 195.99 | 255.0 |
| 2023-12-20 06:06:00 | AAPL | Stock | 196.05 | 196.05 | 196.05 | 196.05 | 166.0 |
> showing 50 of 1,347,601 rows — these rows as CSV