PREVIEW / stock_1min / 2023-07-27
file: by_date/stock_1min/2023/2023-07-27.parquet size: 21.8 MB rows: 1,303,209 symbols: 1,471
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-07-27 04:00:00 | AAPL | Stock | 195.42 | 196.22 | 195.42 | 196.22 | 1635.0 |
| 2023-07-27 04:01:00 | AAPL | Stock | 196.22 | 196.24 | 196.0 | 196.17 | 2412.0 |
| 2023-07-27 04:02:00 | AAPL | Stock | 196.17 | 196.33 | 196.17 | 196.28 | 876.0 |
| 2023-07-27 04:03:00 | AAPL | Stock | 196.31 | 196.34 | 196.26 | 196.34 | 1240.0 |
| 2023-07-27 04:04:00 | AAPL | Stock | 196.25 | 196.32 | 196.22 | 196.22 | 1588.0 |
| 2023-07-27 04:05:00 | AAPL | Stock | 196.19 | 196.19 | 196.19 | 196.19 | 400.0 |
| 2023-07-27 04:06:00 | AAPL | Stock | 196.2 | 196.2 | 196.17 | 196.17 | 369.0 |
| 2023-07-27 04:08:00 | AAPL | Stock | 196.05 | 196.11 | 196.05 | 196.11 | 848.0 |
| 2023-07-27 04:09:00 | AAPL | Stock | 196.1 | 196.1 | 196.1 | 196.1 | 810.0 |
| 2023-07-27 04:13:00 | AAPL | Stock | 196.1 | 196.13 | 196.06 | 196.13 | 1083.0 |
| 2023-07-27 04:14:00 | AAPL | Stock | 196.2 | 196.2 | 196.2 | 196.2 | 200.0 |
| 2023-07-27 04:16:00 | AAPL | Stock | 196.19 | 196.19 | 196.19 | 196.19 | 213.0 |
| 2023-07-27 04:17:00 | AAPL | Stock | 196.2 | 196.2 | 196.2 | 196.2 | 423.0 |
| 2023-07-27 04:18:00 | AAPL | Stock | 196.19 | 196.2 | 196.19 | 196.2 | 1227.0 |
| 2023-07-27 04:20:00 | AAPL | Stock | 196.2 | 196.2 | 196.18 | 196.19 | 2268.0 |
| 2023-07-27 04:22:00 | AAPL | Stock | 196.18 | 196.18 | 196.16 | 196.16 | 639.0 |
| 2023-07-27 04:23:00 | AAPL | Stock | 196.14 | 196.26 | 196.14 | 196.26 | 200.0 |
| 2023-07-27 04:24:00 | AAPL | Stock | 196.15 | 196.15 | 196.15 | 196.15 | 200.0 |
| 2023-07-27 04:27:00 | AAPL | Stock | 196.15 | 196.15 | 196.15 | 196.15 | 726.0 |
| 2023-07-27 04:29:00 | AAPL | Stock | 196.15 | 196.23 | 196.15 | 196.23 | 814.0 |
| 2023-07-27 04:30:00 | AAPL | Stock | 196.25 | 196.25 | 196.25 | 196.25 | 224.0 |
| 2023-07-27 04:34:00 | AAPL | Stock | 196.2 | 196.21 | 196.2 | 196.21 | 554.0 |
| 2023-07-27 04:35:00 | AAPL | Stock | 196.16 | 196.16 | 196.16 | 196.16 | 400.0 |
| 2023-07-27 04:36:00 | AAPL | Stock | 196.14 | 196.14 | 196.14 | 196.14 | 200.0 |
| 2023-07-27 04:38:00 | AAPL | Stock | 196.07 | 196.07 | 196.07 | 196.07 | 200.0 |
| 2023-07-27 04:39:00 | AAPL | Stock | 196.04 | 196.04 | 196.04 | 196.04 | 1677.0 |
| 2023-07-27 04:40:00 | AAPL | Stock | 196.04 | 196.04 | 196.04 | 196.04 | 194.0 |
| 2023-07-27 04:41:00 | AAPL | Stock | 196.08 | 196.09 | 196.08 | 196.09 | 200.0 |
| 2023-07-27 04:42:00 | AAPL | Stock | 196.1 | 196.1 | 196.04 | 196.04 | 1719.0 |
| 2023-07-27 04:45:00 | AAPL | Stock | 196.04 | 196.04 | 196.04 | 196.04 | 194.0 |
| 2023-07-27 04:48:00 | AAPL | Stock | 196.09 | 196.09 | 196.09 | 196.09 | 169.0 |
| 2023-07-27 04:50:00 | AAPL | Stock | 196.05 | 196.05 | 195.98 | 195.98 | 2915.0 |
| 2023-07-27 04:51:00 | AAPL | Stock | 196.0 | 196.0 | 196.0 | 196.0 | 100.0 |
| 2023-07-27 04:52:00 | AAPL | Stock | 196.03 | 196.03 | 196.03 | 196.03 | 1477.0 |
| 2023-07-27 04:53:00 | AAPL | Stock | 196.03 | 196.03 | 196.03 | 196.03 | 1000.0 |
| 2023-07-27 04:55:00 | AAPL | Stock | 196.03 | 196.11 | 196.03 | 196.11 | 285.0 |
| 2023-07-27 04:56:00 | AAPL | Stock | 196.15 | 196.2 | 196.15 | 196.2 | 3560.0 |
| 2023-07-27 04:58:00 | AAPL | Stock | 196.13 | 196.13 | 196.12 | 196.12 | 896.0 |
| 2023-07-27 05:01:00 | AAPL | Stock | 196.19 | 196.2 | 196.19 | 196.19 | 2099.0 |
| 2023-07-27 05:02:00 | AAPL | Stock | 196.18 | 196.18 | 196.03 | 196.03 | 2392.0 |
| 2023-07-27 05:05:00 | AAPL | Stock | 196.12 | 196.12 | 196.12 | 196.12 | 550.0 |
| 2023-07-27 05:06:00 | AAPL | Stock | 196.12 | 196.12 | 196.12 | 196.12 | 100.0 |
| 2023-07-27 05:10:00 | AAPL | Stock | 196.05 | 196.05 | 196.04 | 196.04 | 1587.0 |
| 2023-07-27 05:12:00 | AAPL | Stock | 196.07 | 196.07 | 196.07 | 196.07 | 100.0 |
| 2023-07-27 05:13:00 | AAPL | Stock | 196.1 | 196.1 | 196.1 | 196.1 | 200.0 |
| 2023-07-27 05:14:00 | AAPL | Stock | 196.18 | 196.18 | 196.18 | 196.18 | 125.0 |
| 2023-07-27 05:18:00 | AAPL | Stock | 196.08 | 196.08 | 196.08 | 196.08 | 387.0 |
| 2023-07-27 05:19:00 | AAPL | Stock | 196.16 | 196.16 | 196.16 | 196.16 | 200.0 |
| 2023-07-27 05:22:00 | AAPL | Stock | 196.05 | 196.07 | 196.05 | 196.07 | 250.0 |
| 2023-07-27 05:24:00 | AAPL | Stock | 196.03 | 196.03 | 196.01 | 196.01 | 6287.0 |
> showing 50 of 1,303,209 rows — these rows as CSV