PREVIEW / stock_1min / 2023-10-05
file: by_date/stock_1min/2023/2023-10-05.parquet size: 18.9 MB rows: 1,203,499 symbols: 1,354
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-05 04:01:00 | AAPL | Stock | 173.23 | 173.24 | 173.23 | 173.24 | 317.0 |
| 2023-10-05 04:04:00 | AAPL | Stock | 173.3 | 173.31 | 173.26 | 173.26 | 951.0 |
| 2023-10-05 04:09:00 | AAPL | Stock | 173.2 | 173.25 | 173.2 | 173.25 | 300.0 |
| 2023-10-05 04:17:00 | AAPL | Stock | 173.2 | 173.2 | 173.2 | 173.2 | 200.0 |
| 2023-10-05 04:21:00 | AAPL | Stock | 173.22 | 173.22 | 173.22 | 173.22 | 137.0 |
| 2023-10-05 04:22:00 | AAPL | Stock | 173.24 | 173.24 | 173.24 | 173.24 | 100.0 |
| 2023-10-05 04:23:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 200.0 |
| 2023-10-05 04:29:00 | AAPL | Stock | 173.34 | 173.34 | 173.34 | 173.34 | 166.0 |
| 2023-10-05 04:33:00 | AAPL | Stock | 173.39 | 173.4 | 173.39 | 173.4 | 353.0 |
| 2023-10-05 04:40:00 | AAPL | Stock | 173.36 | 173.36 | 173.36 | 173.36 | 350.0 |
| 2023-10-05 04:52:00 | AAPL | Stock | 173.1 | 173.1 | 173.1 | 173.1 | 268.0 |
| 2023-10-05 04:54:00 | AAPL | Stock | 173.09 | 173.09 | 173.09 | 173.09 | 100.0 |
| 2023-10-05 04:55:00 | AAPL | Stock | 173.08 | 173.08 | 173.08 | 173.08 | 100.0 |
| 2023-10-05 04:57:00 | AAPL | Stock | 173.02 | 173.02 | 173.0 | 173.0 | 1388.0 |
| 2023-10-05 04:59:00 | AAPL | Stock | 172.92 | 172.92 | 172.92 | 172.92 | 100.0 |
| 2023-10-05 05:04:00 | AAPL | Stock | 172.9 | 172.9 | 172.9 | 172.9 | 100.0 |
| 2023-10-05 05:08:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 110.0 |
| 2023-10-05 05:10:00 | AAPL | Stock | 173.0 | 173.0 | 172.98 | 172.98 | 1221.0 |
| 2023-10-05 05:11:00 | AAPL | Stock | 172.98 | 172.98 | 172.98 | 172.98 | 175.0 |
| 2023-10-05 05:12:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 100.0 |
| 2023-10-05 05:15:00 | AAPL | Stock | 172.92 | 172.92 | 172.9 | 172.9 | 1148.0 |
| 2023-10-05 05:16:00 | AAPL | Stock | 172.83 | 172.83 | 172.8 | 172.8 | 469.0 |
| 2023-10-05 05:18:00 | AAPL | Stock | 172.87 | 173.0 | 172.84 | 172.98 | 3257.0 |
| 2023-10-05 05:19:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 600.0 |
| 2023-10-05 05:20:00 | AAPL | Stock | 173.01 | 173.01 | 173.0 | 173.0 | 4645.0 |
| 2023-10-05 05:24:00 | AAPL | Stock | 173.09 | 173.09 | 173.09 | 173.09 | 100.0 |
| 2023-10-05 05:25:00 | AAPL | Stock | 173.0 | 173.01 | 173.0 | 173.0 | 13251.0 |
| 2023-10-05 05:29:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 1748.0 |
| 2023-10-05 05:40:00 | AAPL | Stock | 172.9 | 172.92 | 172.9 | 172.92 | 335.0 |
| 2023-10-05 05:45:00 | AAPL | Stock | 172.94 | 172.94 | 172.94 | 172.94 | 160.0 |
| 2023-10-05 05:49:00 | AAPL | Stock | 172.95 | 172.95 | 172.95 | 172.95 | 100.0 |
| 2023-10-05 05:51:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 100.0 |
| 2023-10-05 05:59:00 | AAPL | Stock | 173.05 | 173.05 | 173.05 | 173.05 | 100.0 |
| 2023-10-05 06:08:00 | AAPL | Stock | 173.08 | 173.08 | 173.08 | 173.08 | 173.0 |
| 2023-10-05 06:09:00 | AAPL | Stock | 173.1 | 173.15 | 173.1 | 173.15 | 787.0 |
| 2023-10-05 06:11:00 | AAPL | Stock | 173.22 | 173.22 | 173.22 | 173.22 | 100.0 |
| 2023-10-05 06:14:00 | AAPL | Stock | 173.26 | 173.35 | 173.26 | 173.35 | 1436.0 |
| 2023-10-05 06:18:00 | AAPL | Stock | 173.26 | 173.26 | 173.26 | 173.26 | 100.0 |
| 2023-10-05 06:25:00 | AAPL | Stock | 173.26 | 173.3 | 173.26 | 173.3 | 297.0 |
| 2023-10-05 06:30:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 200.0 |
| 2023-10-05 06:31:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 438.0 |
| 2023-10-05 06:32:00 | AAPL | Stock | 173.32 | 173.32 | 173.32 | 173.32 | 100.0 |
| 2023-10-05 06:33:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 100.0 |
| 2023-10-05 06:35:00 | AAPL | Stock | 173.37 | 173.37 | 173.37 | 173.37 | 198.0 |
| 2023-10-05 06:36:00 | AAPL | Stock | 173.49 | 173.49 | 173.49 | 173.49 | 200.0 |
| 2023-10-05 06:37:00 | AAPL | Stock | 173.51 | 173.51 | 173.5 | 173.5 | 1195.0 |
| 2023-10-05 06:48:00 | AAPL | Stock | 173.38 | 173.38 | 173.38 | 173.38 | 400.0 |
| 2023-10-05 06:57:00 | AAPL | Stock | 173.41 | 173.41 | 173.41 | 173.41 | 100.0 |
| 2023-10-05 06:59:00 | AAPL | Stock | 173.48 | 173.48 | 173.48 | 173.48 | 108.0 |
| 2023-10-05 07:00:00 | AAPL | Stock | 173.41 | 173.6 | 173.41 | 173.6 | 1184.0 |
> showing 50 of 1,203,499 rows — these rows as CSV