PREVIEW / stock_1min / 2022-08-01
file: by_date/stock_1min/2022/2022-08-01.parquet size: 22.1 MB rows: 1,364,639 symbols: 2,083
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-08-01 04:00:00 | AAPL | Stock | 161.98 | 162.2 | 161.98 | 162.2 | 2473.0 |
| 2022-08-01 04:01:00 | AAPL | Stock | 162.13 | 162.13 | 162.13 | 162.13 | 400.0 |
| 2022-08-01 04:02:00 | AAPL | Stock | 162.1 | 162.2 | 162.1 | 162.15 | 635.0 |
| 2022-08-01 04:04:00 | AAPL | Stock | 162.14 | 162.21 | 162.14 | 162.21 | 405.0 |
| 2022-08-01 04:05:00 | AAPL | Stock | 162.18 | 162.18 | 162.18 | 162.18 | 100.0 |
| 2022-08-01 04:06:00 | AAPL | Stock | 162.18 | 162.2 | 162.18 | 162.2 | 380.0 |
| 2022-08-01 04:07:00 | AAPL | Stock | 162.22 | 162.24 | 162.22 | 162.24 | 784.0 |
| 2022-08-01 04:09:00 | AAPL | Stock | 162.24 | 162.24 | 162.24 | 162.24 | 619.0 |
| 2022-08-01 04:10:00 | AAPL | Stock | 162.25 | 162.25 | 162.2 | 162.2 | 517.0 |
| 2022-08-01 04:11:00 | AAPL | Stock | 162.2 | 162.2 | 162.2 | 162.2 | 100.0 |
| 2022-08-01 04:12:00 | AAPL | Stock | 162.15 | 162.15 | 162.15 | 162.15 | 130.0 |
| 2022-08-01 04:13:00 | AAPL | Stock | 162.15 | 162.15 | 162.13 | 162.13 | 630.0 |
| 2022-08-01 04:14:00 | AAPL | Stock | 162.13 | 162.13 | 162.13 | 162.13 | 506.0 |
| 2022-08-01 04:15:00 | AAPL | Stock | 162.13 | 162.13 | 162.13 | 162.13 | 298.0 |
| 2022-08-01 04:16:00 | AAPL | Stock | 162.07 | 162.11 | 162.07 | 162.11 | 274.0 |
| 2022-08-01 04:17:00 | AAPL | Stock | 162.11 | 162.11 | 162.11 | 162.11 | 328.0 |
| 2022-08-01 04:18:00 | AAPL | Stock | 162.13 | 162.16 | 162.13 | 162.13 | 1234.0 |
| 2022-08-01 04:20:00 | AAPL | Stock | 162.09 | 162.09 | 162.09 | 162.09 | 179.0 |
| 2022-08-01 04:21:00 | AAPL | Stock | 162.09 | 162.09 | 162.09 | 162.09 | 281.0 |
| 2022-08-01 04:22:00 | AAPL | Stock | 162.1 | 162.1 | 162.1 | 162.1 | 100.0 |
| 2022-08-01 04:23:00 | AAPL | Stock | 162.07 | 162.07 | 162.07 | 162.07 | 468.0 |
| 2022-08-01 04:24:00 | AAPL | Stock | 162.04 | 162.04 | 162.04 | 162.04 | 200.0 |
| 2022-08-01 04:25:00 | AAPL | Stock | 162.01 | 162.01 | 162.01 | 162.01 | 104.0 |
| 2022-08-01 04:26:00 | AAPL | Stock | 162.04 | 162.04 | 162.02 | 162.02 | 209.0 |
| 2022-08-01 04:27:00 | AAPL | Stock | 162.03 | 162.03 | 162.03 | 162.03 | 120.0 |
| 2022-08-01 04:29:00 | AAPL | Stock | 162.07 | 162.07 | 162.07 | 162.07 | 142.0 |
| 2022-08-01 04:30:00 | AAPL | Stock | 162.08 | 162.14 | 162.08 | 162.14 | 254.0 |
| 2022-08-01 04:33:00 | AAPL | Stock | 162.13 | 162.15 | 162.13 | 162.15 | 300.0 |
| 2022-08-01 04:34:00 | AAPL | Stock | 162.15 | 162.15 | 162.15 | 162.15 | 863.0 |
| 2022-08-01 04:36:00 | AAPL | Stock | 162.14 | 162.14 | 162.1 | 162.1 | 350.0 |
| 2022-08-01 04:38:00 | AAPL | Stock | 162.07 | 162.1 | 162.07 | 162.1 | 817.0 |
| 2022-08-01 04:39:00 | AAPL | Stock | 162.1 | 162.1 | 162.1 | 162.1 | 500.0 |
| 2022-08-01 04:42:00 | AAPL | Stock | 162.1 | 162.1 | 162.1 | 162.1 | 121.0 |
| 2022-08-01 04:43:00 | AAPL | Stock | 162.09 | 162.09 | 162.09 | 162.09 | 200.0 |
| 2022-08-01 04:45:00 | AAPL | Stock | 162.1 | 162.1 | 162.1 | 162.1 | 825.0 |
| 2022-08-01 04:46:00 | AAPL | Stock | 162.01 | 162.01 | 162.0 | 162.0 | 1824.0 |
| 2022-08-01 04:49:00 | AAPL | Stock | 161.84 | 161.84 | 161.82 | 161.82 | 548.0 |
| 2022-08-01 04:50:00 | AAPL | Stock | 161.85 | 161.85 | 161.85 | 161.85 | 124.0 |
| 2022-08-01 04:52:00 | AAPL | Stock | 161.82 | 161.83 | 161.79 | 161.82 | 1841.0 |
| 2022-08-01 04:54:00 | AAPL | Stock | 161.83 | 161.86 | 161.83 | 161.86 | 534.0 |
| 2022-08-01 04:55:00 | AAPL | Stock | 161.88 | 161.9 | 161.88 | 161.9 | 200.0 |
| 2022-08-01 04:56:00 | AAPL | Stock | 162.0 | 162.01 | 162.0 | 162.01 | 280.0 |
| 2022-08-01 05:11:00 | AAPL | Stock | 161.92 | 161.92 | 161.92 | 161.92 | 190.0 |
| 2022-08-01 05:12:00 | AAPL | Stock | 162.0 | 162.0 | 162.0 | 162.0 | 100.0 |
| 2022-08-01 05:13:00 | AAPL | Stock | 161.99 | 161.99 | 161.99 | 161.99 | 300.0 |
| 2022-08-01 05:15:00 | AAPL | Stock | 162.0 | 162.0 | 162.0 | 162.0 | 150.0 |
| 2022-08-01 05:19:00 | AAPL | Stock | 162.08 | 162.08 | 162.08 | 162.08 | 200.0 |
| 2022-08-01 05:20:00 | AAPL | Stock | 162.09 | 162.13 | 162.09 | 162.13 | 1013.0 |
| 2022-08-01 05:25:00 | AAPL | Stock | 162.09 | 162.09 | 162.09 | 162.09 | 116.0 |
| 2022-08-01 05:27:00 | AAPL | Stock | 162.09 | 162.09 | 162.08 | 162.08 | 1100.0 |
> showing 50 of 1,364,639 rows — these rows as CSV