PREVIEW / stock_1min / 2023-09-29
file: by_date/stock_1min/2023/2023-09-29.parquet size: 19.5 MB rows: 1,237,770 symbols: 1,343
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-09-29 04:00:00 | AAPL | Stock | 171.28 | 172.03 | 171.28 | 172.03 | 441.0 |
| 2023-09-29 04:01:00 | AAPL | Stock | 171.97 | 172.0 | 171.97 | 171.97 | 878.0 |
| 2023-09-29 04:02:00 | AAPL | Stock | 171.9 | 171.9 | 171.9 | 171.9 | 1695.0 |
| 2023-09-29 04:03:00 | AAPL | Stock | 171.86 | 171.86 | 171.8 | 171.84 | 2631.0 |
| 2023-09-29 04:05:00 | AAPL | Stock | 171.83 | 171.83 | 171.83 | 171.83 | 100.0 |
| 2023-09-29 04:06:00 | AAPL | Stock | 171.88 | 171.88 | 171.88 | 171.88 | 100.0 |
| 2023-09-29 04:07:00 | AAPL | Stock | 171.88 | 172.01 | 171.88 | 172.01 | 1258.0 |
| 2023-09-29 04:09:00 | AAPL | Stock | 172.0 | 172.0 | 172.0 | 172.0 | 400.0 |
| 2023-09-29 04:10:00 | AAPL | Stock | 172.0 | 172.0 | 172.0 | 172.0 | 290.0 |
| 2023-09-29 04:11:00 | AAPL | Stock | 172.0 | 172.0 | 172.0 | 172.0 | 100.0 |
| 2023-09-29 04:14:00 | AAPL | Stock | 172.04 | 172.04 | 172.04 | 172.04 | 119.0 |
| 2023-09-29 04:15:00 | AAPL | Stock | 172.04 | 172.04 | 172.04 | 172.04 | 119.0 |
| 2023-09-29 04:16:00 | AAPL | Stock | 171.98 | 171.98 | 171.98 | 171.98 | 100.0 |
| 2023-09-29 04:19:00 | AAPL | Stock | 172.04 | 172.04 | 172.04 | 172.04 | 119.0 |
| 2023-09-29 04:20:00 | AAPL | Stock | 172.05 | 172.05 | 172.05 | 172.05 | 100.0 |
| 2023-09-29 04:21:00 | AAPL | Stock | 172.0 | 172.0 | 172.0 | 172.0 | 374.0 |
| 2023-09-29 04:22:00 | AAPL | Stock | 172.05 | 172.05 | 172.05 | 172.05 | 100.0 |
| 2023-09-29 04:24:00 | AAPL | Stock | 172.09 | 172.09 | 172.09 | 172.09 | 415.0 |
| 2023-09-29 04:28:00 | AAPL | Stock | 172.05 | 172.1 | 172.05 | 172.1 | 308.0 |
| 2023-09-29 04:29:00 | AAPL | Stock | 172.05 | 172.05 | 172.05 | 172.05 | 100.0 |
| 2023-09-29 04:30:00 | AAPL | Stock | 172.13 | 172.15 | 172.13 | 172.15 | 650.0 |
| 2023-09-29 04:32:00 | AAPL | Stock | 172.15 | 172.15 | 172.15 | 172.15 | 1239.0 |
| 2023-09-29 04:33:00 | AAPL | Stock | 172.07 | 172.07 | 172.07 | 172.07 | 400.0 |
| 2023-09-29 04:35:00 | AAPL | Stock | 172.07 | 172.07 | 172.07 | 172.07 | 107.0 |
| 2023-09-29 04:39:00 | AAPL | Stock | 172.18 | 172.18 | 172.18 | 172.18 | 662.0 |
| 2023-09-29 04:42:00 | AAPL | Stock | 172.15 | 172.15 | 172.15 | 172.15 | 100.0 |
| 2023-09-29 04:43:00 | AAPL | Stock | 172.18 | 172.18 | 172.18 | 172.18 | 100.0 |
| 2023-09-29 04:44:00 | AAPL | Stock | 172.2 | 172.26 | 172.2 | 172.26 | 208.0 |
| 2023-09-29 04:45:00 | AAPL | Stock | 172.29 | 172.3 | 172.29 | 172.3 | 1633.0 |
| 2023-09-29 04:47:00 | AAPL | Stock | 172.3 | 172.3 | 172.3 | 172.3 | 125.0 |
| 2023-09-29 04:48:00 | AAPL | Stock | 172.34 | 172.34 | 172.34 | 172.34 | 100.0 |
| 2023-09-29 04:49:00 | AAPL | Stock | 172.3 | 172.3 | 172.3 | 172.3 | 100.0 |
| 2023-09-29 04:50:00 | AAPL | Stock | 172.21 | 172.21 | 172.12 | 172.12 | 1467.0 |
| 2023-09-29 04:51:00 | AAPL | Stock | 172.14 | 172.21 | 172.12 | 172.21 | 485.0 |
| 2023-09-29 04:52:00 | AAPL | Stock | 172.28 | 172.31 | 172.28 | 172.31 | 1456.0 |
| 2023-09-29 04:55:00 | AAPL | Stock | 172.27 | 172.27 | 172.25 | 172.25 | 406.0 |
| 2023-09-29 04:56:00 | AAPL | Stock | 172.12 | 172.12 | 172.12 | 172.12 | 100.0 |
| 2023-09-29 04:57:00 | AAPL | Stock | 172.12 | 172.12 | 172.12 | 172.12 | 1264.0 |
| 2023-09-29 04:58:00 | AAPL | Stock | 172.05 | 172.05 | 172.0 | 172.0 | 1822.0 |
| 2023-09-29 04:59:00 | AAPL | Stock | 172.0 | 172.0 | 172.0 | 172.0 | 2508.0 |
| 2023-09-29 05:11:00 | AAPL | Stock | 172.25 | 172.25 | 172.25 | 172.25 | 225.0 |
| 2023-09-29 05:13:00 | AAPL | Stock | 172.26 | 172.3 | 172.26 | 172.3 | 530.0 |
| 2023-09-29 05:18:00 | AAPL | Stock | 172.26 | 172.26 | 172.26 | 172.26 | 431.0 |
| 2023-09-29 05:22:00 | AAPL | Stock | 172.16 | 172.16 | 172.16 | 172.16 | 114.0 |
| 2023-09-29 05:28:00 | AAPL | Stock | 172.2 | 172.2 | 172.2 | 172.2 | 100.0 |
| 2023-09-29 05:32:00 | AAPL | Stock | 172.06 | 172.06 | 172.06 | 172.06 | 416.0 |
| 2023-09-29 05:33:00 | AAPL | Stock | 172.05 | 172.05 | 172.01 | 172.01 | 602.0 |
| 2023-09-29 05:46:00 | AAPL | Stock | 172.05 | 172.05 | 172.05 | 172.05 | 422.0 |
| 2023-09-29 05:48:00 | AAPL | Stock | 172.15 | 172.19 | 172.15 | 172.19 | 650.0 |
| 2023-09-29 05:51:00 | AAPL | Stock | 172.19 | 172.19 | 172.19 | 172.19 | 100.0 |
> showing 50 of 1,237,770 rows — these rows as CSV