PREVIEW / stock_1min / 2022-11-17
file: by_date/stock_1min/2022/2022-11-17.parquet size: 20.8 MB rows: 1,288,879 symbols: 1,883
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-17 04:00:00 | AAPL | Stock | 148.98 | 149.26 | 148.98 | 149.15 | 1856.0 |
| 2022-11-17 04:01:00 | AAPL | Stock | 149.26 | 149.26 | 149.26 | 149.26 | 138.0 |
| 2022-11-17 04:05:00 | AAPL | Stock | 149.08 | 149.09 | 149.02 | 149.02 | 804.0 |
| 2022-11-17 04:06:00 | AAPL | Stock | 149.05 | 149.05 | 149.0 | 149.0 | 1300.0 |
| 2022-11-17 04:07:00 | AAPL | Stock | 148.91 | 148.98 | 148.9 | 148.98 | 564.0 |
| 2022-11-17 04:08:00 | AAPL | Stock | 149.0 | 149.0 | 149.0 | 149.0 | 100.0 |
| 2022-11-17 04:11:00 | AAPL | Stock | 149.0 | 149.0 | 149.0 | 149.0 | 392.0 |
| 2022-11-17 04:12:00 | AAPL | Stock | 148.95 | 148.95 | 148.95 | 148.95 | 200.0 |
| 2022-11-17 04:13:00 | AAPL | Stock | 148.93 | 148.93 | 148.93 | 148.93 | 100.0 |
| 2022-11-17 04:14:00 | AAPL | Stock | 148.91 | 148.91 | 148.91 | 148.91 | 113.0 |
| 2022-11-17 04:16:00 | AAPL | Stock | 148.91 | 148.95 | 148.91 | 148.95 | 484.0 |
| 2022-11-17 04:18:00 | AAPL | Stock | 149.0 | 149.0 | 148.99 | 149.0 | 890.0 |
| 2022-11-17 04:19:00 | AAPL | Stock | 149.0 | 149.0 | 149.0 | 149.0 | 1488.0 |
| 2022-11-17 04:21:00 | AAPL | Stock | 149.05 | 149.05 | 149.05 | 149.05 | 100.0 |
| 2022-11-17 04:24:00 | AAPL | Stock | 148.98 | 148.98 | 148.98 | 148.98 | 200.0 |
| 2022-11-17 04:30:00 | AAPL | Stock | 148.98 | 148.98 | 148.98 | 148.98 | 332.0 |
| 2022-11-17 04:31:00 | AAPL | Stock | 148.91 | 148.91 | 148.9 | 148.9 | 992.0 |
| 2022-11-17 04:32:00 | AAPL | Stock | 148.9 | 148.9 | 148.66 | 148.66 | 2664.0 |
| 2022-11-17 04:33:00 | AAPL | Stock | 148.65 | 148.67 | 148.65 | 148.65 | 1161.0 |
| 2022-11-17 04:35:00 | AAPL | Stock | 148.52 | 148.52 | 148.41 | 148.41 | 4029.0 |
| 2022-11-17 04:37:00 | AAPL | Stock | 148.7 | 148.7 | 148.7 | 148.7 | 100.0 |
| 2022-11-17 04:39:00 | AAPL | Stock | 148.53 | 148.53 | 148.53 | 148.53 | 200.0 |
| 2022-11-17 04:41:00 | AAPL | Stock | 148.66 | 148.69 | 148.66 | 148.69 | 200.0 |
| 2022-11-17 04:42:00 | AAPL | Stock | 148.69 | 148.69 | 148.69 | 148.69 | 300.0 |
| 2022-11-17 04:43:00 | AAPL | Stock | 148.61 | 148.61 | 148.61 | 148.61 | 100.0 |
| 2022-11-17 04:47:00 | AAPL | Stock | 148.66 | 148.66 | 148.66 | 148.66 | 100.0 |
| 2022-11-17 04:50:00 | AAPL | Stock | 148.62 | 148.62 | 148.52 | 148.52 | 1081.0 |
| 2022-11-17 04:51:00 | AAPL | Stock | 148.52 | 148.52 | 148.21 | 148.21 | 1259.0 |
| 2022-11-17 04:52:00 | AAPL | Stock | 148.25 | 148.25 | 148.25 | 148.25 | 137.0 |
| 2022-11-17 04:54:00 | AAPL | Stock | 148.33 | 148.33 | 148.33 | 148.33 | 100.0 |
| 2022-11-17 04:55:00 | AAPL | Stock | 148.32 | 148.32 | 148.32 | 148.32 | 250.0 |
| 2022-11-17 04:56:00 | AAPL | Stock | 148.34 | 148.34 | 148.34 | 148.34 | 100.0 |
| 2022-11-17 05:00:00 | AAPL | Stock | 148.49 | 148.49 | 148.49 | 148.49 | 415.0 |
| 2022-11-17 05:06:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 200.0 |
| 2022-11-17 05:10:00 | AAPL | Stock | 148.41 | 148.41 | 148.41 | 148.41 | 109.0 |
| 2022-11-17 05:14:00 | AAPL | Stock | 148.49 | 148.5 | 148.49 | 148.5 | 1322.0 |
| 2022-11-17 05:15:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 400.0 |
| 2022-11-17 05:20:00 | AAPL | Stock | 148.58 | 148.58 | 148.58 | 148.58 | 100.0 |
| 2022-11-17 05:23:00 | AAPL | Stock | 148.61 | 148.64 | 148.51 | 148.51 | 802.0 |
| 2022-11-17 05:27:00 | AAPL | Stock | 148.68 | 148.68 | 148.68 | 148.68 | 100.0 |
| 2022-11-17 05:31:00 | AAPL | Stock | 148.51 | 148.51 | 148.5 | 148.5 | 231.0 |
| 2022-11-17 05:33:00 | AAPL | Stock | 148.44 | 148.44 | 148.44 | 148.44 | 179.0 |
| 2022-11-17 05:39:00 | AAPL | Stock | 148.4 | 148.4 | 148.4 | 148.4 | 200.0 |
| 2022-11-17 05:45:00 | AAPL | Stock | 148.4 | 148.4 | 148.38 | 148.38 | 1400.0 |
| 2022-11-17 05:46:00 | AAPL | Stock | 148.28 | 148.28 | 148.28 | 148.28 | 100.0 |
| 2022-11-17 05:48:00 | AAPL | Stock | 148.28 | 148.28 | 148.21 | 148.21 | 1178.0 |
| 2022-11-17 05:50:00 | AAPL | Stock | 148.19 | 148.19 | 148.0 | 148.09 | 5302.0 |
| 2022-11-17 05:51:00 | AAPL | Stock | 148.12 | 148.12 | 147.93 | 147.99 | 3886.0 |
| 2022-11-17 05:52:00 | AAPL | Stock | 147.99 | 147.99 | 147.76 | 147.76 | 1416.0 |
| 2022-11-17 05:54:00 | AAPL | Stock | 147.94 | 147.94 | 147.94 | 147.94 | 143.0 |
> showing 50 of 1,288,879 rows — these rows as CSV