PREVIEW / stock_1min / 2023-06-23
file: by_date/stock_1min/2023/2023-06-23.parquet size: 20.8 MB rows: 1,336,637 symbols: 1,513
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-06-23 04:00:00 | AAPL | Stock | 186.48 | 186.48 | 186.07 | 186.07 | 500.0 |
| 2023-06-23 04:01:00 | AAPL | Stock | 186.24 | 186.24 | 186.24 | 186.24 | 550.0 |
| 2023-06-23 04:02:00 | AAPL | Stock | 186.23 | 186.23 | 186.16 | 186.2 | 424.0 |
| 2023-06-23 04:03:00 | AAPL | Stock | 186.15 | 186.15 | 186.15 | 186.15 | 1580.0 |
| 2023-06-23 04:05:00 | AAPL | Stock | 186.19 | 186.35 | 186.19 | 186.35 | 514.0 |
| 2023-06-23 04:07:00 | AAPL | Stock | 186.25 | 186.25 | 186.23 | 186.23 | 425.0 |
| 2023-06-23 04:08:00 | AAPL | Stock | 186.33 | 186.39 | 186.33 | 186.39 | 436.0 |
| 2023-06-23 04:14:00 | AAPL | Stock | 186.32 | 186.32 | 186.25 | 186.25 | 713.0 |
| 2023-06-23 04:17:00 | AAPL | Stock | 186.31 | 186.31 | 186.23 | 186.23 | 413.0 |
| 2023-06-23 04:19:00 | AAPL | Stock | 186.25 | 186.25 | 186.22 | 186.22 | 1872.0 |
| 2023-06-23 04:21:00 | AAPL | Stock | 186.22 | 186.22 | 186.22 | 186.22 | 100.0 |
| 2023-06-23 04:22:00 | AAPL | Stock | 186.22 | 186.22 | 186.2 | 186.2 | 1789.0 |
| 2023-06-23 04:23:00 | AAPL | Stock | 186.18 | 186.18 | 186.18 | 186.18 | 750.0 |
| 2023-06-23 04:25:00 | AAPL | Stock | 186.15 | 186.15 | 186.14 | 186.14 | 1163.0 |
| 2023-06-23 04:26:00 | AAPL | Stock | 186.16 | 186.16 | 186.16 | 186.16 | 100.0 |
| 2023-06-23 04:27:00 | AAPL | Stock | 186.16 | 186.17 | 186.16 | 186.17 | 1209.0 |
| 2023-06-23 04:29:00 | AAPL | Stock | 186.11 | 186.11 | 186.1 | 186.1 | 400.0 |
| 2023-06-23 04:31:00 | AAPL | Stock | 186.2 | 186.21 | 186.2 | 186.21 | 774.0 |
| 2023-06-23 04:36:00 | AAPL | Stock | 186.18 | 186.2 | 186.18 | 186.2 | 2319.0 |
| 2023-06-23 04:38:00 | AAPL | Stock | 186.19 | 186.2 | 186.19 | 186.2 | 445.0 |
| 2023-06-23 04:49:00 | AAPL | Stock | 186.09 | 186.09 | 186.09 | 186.09 | 100.0 |
| 2023-06-23 04:50:00 | AAPL | Stock | 186.02 | 186.02 | 186.02 | 186.02 | 100.0 |
| 2023-06-23 04:51:00 | AAPL | Stock | 186.01 | 186.01 | 186.0 | 186.0 | 2925.0 |
| 2023-06-23 04:52:00 | AAPL | Stock | 185.95 | 186.01 | 185.83 | 185.83 | 939.0 |
| 2023-06-23 04:53:00 | AAPL | Stock | 185.8 | 185.8 | 185.8 | 185.8 | 503.0 |
| 2023-06-23 04:54:00 | AAPL | Stock | 185.95 | 185.95 | 185.95 | 185.95 | 200.0 |
| 2023-06-23 04:57:00 | AAPL | Stock | 185.87 | 185.88 | 185.87 | 185.88 | 415.0 |
| 2023-06-23 04:58:00 | AAPL | Stock | 185.95 | 185.95 | 185.95 | 185.95 | 660.0 |
| 2023-06-23 04:59:00 | AAPL | Stock | 185.95 | 185.95 | 185.95 | 185.95 | 197.0 |
| 2023-06-23 05:00:00 | AAPL | Stock | 185.91 | 185.91 | 185.91 | 185.91 | 300.0 |
| 2023-06-23 05:03:00 | AAPL | Stock | 185.9 | 185.93 | 185.9 | 185.93 | 497.0 |
| 2023-06-23 05:04:00 | AAPL | Stock | 185.94 | 185.94 | 185.94 | 185.94 | 100.0 |
| 2023-06-23 05:05:00 | AAPL | Stock | 185.97 | 185.97 | 185.97 | 185.97 | 500.0 |
| 2023-06-23 05:06:00 | AAPL | Stock | 185.97 | 186.02 | 185.97 | 186.02 | 405.0 |
| 2023-06-23 05:07:00 | AAPL | Stock | 186.07 | 186.07 | 186.07 | 186.07 | 2216.0 |
| 2023-06-23 05:08:00 | AAPL | Stock | 185.97 | 185.97 | 185.93 | 185.97 | 529.0 |
| 2023-06-23 05:10:00 | AAPL | Stock | 186.0 | 186.0 | 186.0 | 186.0 | 250.0 |
| 2023-06-23 05:11:00 | AAPL | Stock | 186.1 | 186.1 | 186.1 | 186.1 | 112.0 |
| 2023-06-23 05:12:00 | AAPL | Stock | 186.15 | 186.15 | 186.15 | 186.15 | 500.0 |
| 2023-06-23 05:14:00 | AAPL | Stock | 186.18 | 186.21 | 186.18 | 186.21 | 1005.0 |
| 2023-06-23 05:24:00 | AAPL | Stock | 186.09 | 186.09 | 186.02 | 186.02 | 234.0 |
| 2023-06-23 05:26:00 | AAPL | Stock | 186.01 | 186.02 | 186.01 | 186.02 | 660.0 |
| 2023-06-23 05:27:00 | AAPL | Stock | 186.0 | 186.0 | 186.0 | 186.0 | 740.0 |
| 2023-06-23 05:36:00 | AAPL | Stock | 186.15 | 186.21 | 186.15 | 186.21 | 2052.0 |
| 2023-06-23 05:37:00 | AAPL | Stock | 186.2 | 186.21 | 186.2 | 186.2 | 532.0 |
| 2023-06-23 05:45:00 | AAPL | Stock | 186.05 | 186.05 | 186.0 | 186.0 | 476.0 |
| 2023-06-23 05:48:00 | AAPL | Stock | 186.0 | 186.11 | 186.0 | 186.11 | 600.0 |
| 2023-06-23 05:51:00 | AAPL | Stock | 186.13 | 186.13 | 186.13 | 186.13 | 455.0 |
| 2023-06-23 05:59:00 | AAPL | Stock | 186.07 | 186.07 | 186.05 | 186.05 | 1319.0 |
| 2023-06-23 06:01:00 | AAPL | Stock | 186.11 | 186.11 | 186.11 | 186.11 | 119.0 |
> showing 50 of 1,336,637 rows — these rows as CSV