PREVIEW / stock_1min / 2022-07-12
file: by_date/stock_1min/2022/2022-07-12.parquet size: 19.8 MB rows: 1,285,523 symbols: 2,033
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-07-12 04:00:00 | AAPL | Stock | 143.98 | 144.07 | 143.5 | 143.55 | 4291.0 |
| 2022-07-12 04:01:00 | AAPL | Stock | 143.42 | 143.42 | 143.42 | 143.42 | 372.0 |
| 2022-07-12 04:02:00 | AAPL | Stock | 143.46 | 143.46 | 143.46 | 143.46 | 100.0 |
| 2022-07-12 04:04:00 | AAPL | Stock | 143.6 | 143.6 | 143.6 | 143.6 | 290.0 |
| 2022-07-12 04:05:00 | AAPL | Stock | 143.6 | 143.6 | 143.6 | 143.6 | 751.0 |
| 2022-07-12 04:06:00 | AAPL | Stock | 143.6 | 143.6 | 143.6 | 143.6 | 139.0 |
| 2022-07-12 04:09:00 | AAPL | Stock | 143.56 | 143.6 | 143.48 | 143.5 | 3223.0 |
| 2022-07-12 04:10:00 | AAPL | Stock | 143.69 | 143.7 | 143.69 | 143.7 | 344.0 |
| 2022-07-12 04:11:00 | AAPL | Stock | 143.7 | 143.7 | 143.7 | 143.7 | 498.0 |
| 2022-07-12 04:12:00 | AAPL | Stock | 143.71 | 143.71 | 143.7 | 143.7 | 528.0 |
| 2022-07-12 04:22:00 | AAPL | Stock | 143.73 | 143.73 | 143.73 | 143.73 | 250.0 |
| 2022-07-12 04:23:00 | AAPL | Stock | 143.73 | 143.73 | 143.66 | 143.73 | 1465.0 |
| 2022-07-12 04:27:00 | AAPL | Stock | 143.87 | 143.87 | 143.87 | 143.87 | 250.0 |
| 2022-07-12 04:29:00 | AAPL | Stock | 143.9 | 143.9 | 143.9 | 143.9 | 100.0 |
| 2022-07-12 04:31:00 | AAPL | Stock | 143.92 | 143.93 | 143.92 | 143.93 | 664.0 |
| 2022-07-12 04:33:00 | AAPL | Stock | 144.07 | 144.07 | 144.07 | 144.07 | 200.0 |
| 2022-07-12 04:37:00 | AAPL | Stock | 144.19 | 144.19 | 144.19 | 144.19 | 169.0 |
| 2022-07-12 04:39:00 | AAPL | Stock | 144.2 | 144.2 | 144.2 | 144.2 | 500.0 |
| 2022-07-12 04:43:00 | AAPL | Stock | 144.11 | 144.11 | 144.06 | 144.06 | 1450.0 |
| 2022-07-12 04:45:00 | AAPL | Stock | 144.05 | 144.05 | 144.05 | 144.05 | 2339.0 |
| 2022-07-12 04:48:00 | AAPL | Stock | 143.89 | 143.89 | 143.89 | 143.89 | 100.0 |
| 2022-07-12 04:50:00 | AAPL | Stock | 143.9 | 143.9 | 143.9 | 143.9 | 100.0 |
| 2022-07-12 04:51:00 | AAPL | Stock | 143.95 | 143.96 | 143.95 | 143.96 | 222.0 |
| 2022-07-12 04:52:00 | AAPL | Stock | 143.95 | 143.95 | 143.95 | 143.95 | 300.0 |
| 2022-07-12 04:53:00 | AAPL | Stock | 144.05 | 144.05 | 144.05 | 144.05 | 1044.0 |
| 2022-07-12 04:54:00 | AAPL | Stock | 144.05 | 144.06 | 144.05 | 144.06 | 519.0 |
| 2022-07-12 05:01:00 | AAPL | Stock | 144.01 | 144.15 | 144.01 | 144.15 | 1017.0 |
| 2022-07-12 05:02:00 | AAPL | Stock | 144.01 | 144.01 | 143.96 | 143.96 | 200.0 |
| 2022-07-12 05:03:00 | AAPL | Stock | 144.01 | 144.01 | 144.01 | 144.01 | 200.0 |
| 2022-07-12 05:07:00 | AAPL | Stock | 144.14 | 144.14 | 144.04 | 144.04 | 1302.0 |
| 2022-07-12 05:12:00 | AAPL | Stock | 144.1 | 144.1 | 144.1 | 144.1 | 174.0 |
| 2022-07-12 05:18:00 | AAPL | Stock | 144.15 | 144.15 | 144.13 | 144.13 | 1011.0 |
| 2022-07-12 05:20:00 | AAPL | Stock | 144.13 | 144.13 | 144.13 | 144.13 | 100.0 |
| 2022-07-12 05:22:00 | AAPL | Stock | 144.13 | 144.13 | 144.08 | 144.08 | 1150.0 |
| 2022-07-12 05:23:00 | AAPL | Stock | 144.02 | 144.02 | 144.01 | 144.01 | 968.0 |
| 2022-07-12 05:26:00 | AAPL | Stock | 144.03 | 144.03 | 144.01 | 144.01 | 479.0 |
| 2022-07-12 05:27:00 | AAPL | Stock | 144.0 | 144.0 | 144.0 | 144.0 | 200.0 |
| 2022-07-12 05:31:00 | AAPL | Stock | 143.96 | 143.96 | 143.96 | 143.96 | 487.0 |
| 2022-07-12 05:41:00 | AAPL | Stock | 144.05 | 144.05 | 144.05 | 144.05 | 490.0 |
| 2022-07-12 05:42:00 | AAPL | Stock | 144.1 | 144.1 | 144.1 | 144.1 | 198.0 |
| 2022-07-12 05:49:00 | AAPL | Stock | 143.96 | 143.96 | 143.91 | 143.91 | 273.0 |
| 2022-07-12 05:53:00 | AAPL | Stock | 143.88 | 143.93 | 143.88 | 143.93 | 763.0 |
| 2022-07-12 05:56:00 | AAPL | Stock | 144.0 | 144.0 | 144.0 | 144.0 | 150.0 |
| 2022-07-12 06:00:00 | AAPL | Stock | 144.03 | 144.03 | 144.03 | 144.03 | 966.0 |
| 2022-07-12 06:01:00 | AAPL | Stock | 144.16 | 144.16 | 144.16 | 144.16 | 100.0 |
| 2022-07-12 06:02:00 | AAPL | Stock | 144.16 | 144.16 | 144.16 | 144.16 | 244.0 |
| 2022-07-12 06:04:00 | AAPL | Stock | 144.12 | 144.12 | 144.12 | 144.12 | 100.0 |
| 2022-07-12 06:05:00 | AAPL | Stock | 144.15 | 144.15 | 144.15 | 144.15 | 100.0 |
| 2022-07-12 06:07:00 | AAPL | Stock | 144.16 | 144.17 | 144.16 | 144.17 | 367.0 |
| 2022-07-12 06:08:00 | AAPL | Stock | 144.17 | 144.2 | 144.15 | 144.2 | 5580.0 |
> showing 50 of 1,285,523 rows — these rows as CSV