PREVIEW / stock_1min / 2022-09-27
file: by_date/stock_1min/2022/2022-09-27.parquet size: 20.9 MB rows: 1,364,725 symbols: 2,049
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-09-27 04:00:00 | AAPL | Stock | 152.52 | 153.33 | 152.52 | 153.23 | 6360.0 |
| 2022-09-27 04:01:00 | AAPL | Stock | 153.22 | 153.3 | 153.05 | 153.28 | 1905.0 |
| 2022-09-27 04:02:00 | AAPL | Stock | 153.11 | 153.11 | 153.05 | 153.08 | 1133.0 |
| 2022-09-27 04:03:00 | AAPL | Stock | 153.1 | 153.19 | 152.93 | 153.0 | 2220.0 |
| 2022-09-27 04:04:00 | AAPL | Stock | 152.96 | 152.97 | 152.96 | 152.97 | 200.0 |
| 2022-09-27 04:05:00 | AAPL | Stock | 153.06 | 153.18 | 153.06 | 153.18 | 1087.0 |
| 2022-09-27 04:07:00 | AAPL | Stock | 152.96 | 152.96 | 152.96 | 152.96 | 100.0 |
| 2022-09-27 04:08:00 | AAPL | Stock | 152.95 | 152.99 | 152.95 | 152.99 | 1634.0 |
| 2022-09-27 04:09:00 | AAPL | Stock | 152.96 | 152.96 | 152.95 | 152.95 | 666.0 |
| 2022-09-27 04:12:00 | AAPL | Stock | 152.92 | 152.92 | 152.81 | 152.9 | 803.0 |
| 2022-09-27 04:13:00 | AAPL | Stock | 152.94 | 152.95 | 152.94 | 152.95 | 262.0 |
| 2022-09-27 04:15:00 | AAPL | Stock | 152.93 | 152.93 | 152.93 | 152.93 | 365.0 |
| 2022-09-27 04:16:00 | AAPL | Stock | 152.92 | 152.92 | 152.89 | 152.89 | 386.0 |
| 2022-09-27 04:17:00 | AAPL | Stock | 152.97 | 152.97 | 152.94 | 152.94 | 381.0 |
| 2022-09-27 04:18:00 | AAPL | Stock | 152.9 | 152.9 | 152.9 | 152.9 | 1638.0 |
| 2022-09-27 04:19:00 | AAPL | Stock | 152.95 | 152.95 | 152.95 | 152.95 | 270.0 |
| 2022-09-27 04:20:00 | AAPL | Stock | 152.91 | 152.91 | 152.91 | 152.91 | 330.0 |
| 2022-09-27 04:21:00 | AAPL | Stock | 152.96 | 153.0 | 152.96 | 153.0 | 841.0 |
| 2022-09-27 04:26:00 | AAPL | Stock | 152.95 | 152.95 | 152.95 | 152.95 | 400.0 |
| 2022-09-27 04:27:00 | AAPL | Stock | 152.95 | 152.95 | 152.92 | 152.92 | 1285.0 |
| 2022-09-27 04:28:00 | AAPL | Stock | 152.99 | 153.0 | 152.99 | 153.0 | 1080.0 |
| 2022-09-27 04:29:00 | AAPL | Stock | 152.99 | 152.99 | 152.99 | 152.99 | 100.0 |
| 2022-09-27 04:33:00 | AAPL | Stock | 152.95 | 152.96 | 152.9 | 152.9 | 317.0 |
| 2022-09-27 04:35:00 | AAPL | Stock | 152.88 | 152.88 | 152.88 | 152.88 | 269.0 |
| 2022-09-27 04:37:00 | AAPL | Stock | 152.81 | 152.81 | 152.8 | 152.8 | 583.0 |
| 2022-09-27 04:38:00 | AAPL | Stock | 152.8 | 152.8 | 152.74 | 152.75 | 2871.0 |
| 2022-09-27 04:39:00 | AAPL | Stock | 152.75 | 152.75 | 152.7 | 152.72 | 1019.0 |
| 2022-09-27 04:40:00 | AAPL | Stock | 152.74 | 152.81 | 152.74 | 152.81 | 733.0 |
| 2022-09-27 04:44:00 | AAPL | Stock | 152.78 | 152.79 | 152.78 | 152.79 | 558.0 |
| 2022-09-27 04:46:00 | AAPL | Stock | 152.7 | 152.7 | 152.7 | 152.7 | 140.0 |
| 2022-09-27 04:47:00 | AAPL | Stock | 152.65 | 152.65 | 152.65 | 152.65 | 100.0 |
| 2022-09-27 04:50:00 | AAPL | Stock | 152.8 | 152.8 | 152.8 | 152.8 | 210.0 |
| 2022-09-27 04:57:00 | AAPL | Stock | 152.75 | 152.75 | 152.75 | 152.75 | 400.0 |
| 2022-09-27 04:58:00 | AAPL | Stock | 152.68 | 152.68 | 152.67 | 152.67 | 608.0 |
| 2022-09-27 05:01:00 | AAPL | Stock | 152.68 | 152.68 | 152.68 | 152.68 | 100.0 |
| 2022-09-27 05:03:00 | AAPL | Stock | 152.67 | 152.67 | 152.67 | 152.67 | 185.0 |
| 2022-09-27 05:04:00 | AAPL | Stock | 152.65 | 152.65 | 152.38 | 152.38 | 848.0 |
| 2022-09-27 05:09:00 | AAPL | Stock | 152.32 | 152.32 | 152.29 | 152.29 | 200.0 |
| 2022-09-27 05:10:00 | AAPL | Stock | 152.25 | 152.25 | 152.25 | 152.25 | 100.0 |
| 2022-09-27 05:11:00 | AAPL | Stock | 152.3 | 152.33 | 152.29 | 152.29 | 573.0 |
| 2022-09-27 05:12:00 | AAPL | Stock | 152.26 | 152.26 | 152.17 | 152.17 | 4287.0 |
| 2022-09-27 05:13:00 | AAPL | Stock | 152.15 | 152.15 | 152.13 | 152.13 | 200.0 |
| 2022-09-27 05:15:00 | AAPL | Stock | 152.39 | 152.39 | 152.39 | 152.39 | 235.0 |
| 2022-09-27 05:16:00 | AAPL | Stock | 152.39 | 152.39 | 152.37 | 152.37 | 300.0 |
| 2022-09-27 05:17:00 | AAPL | Stock | 152.4 | 152.49 | 152.4 | 152.49 | 589.0 |
| 2022-09-27 05:24:00 | AAPL | Stock | 152.36 | 152.36 | 152.12 | 152.12 | 1004.0 |
| 2022-09-27 05:28:00 | AAPL | Stock | 152.17 | 152.17 | 152.17 | 152.17 | 284.0 |
| 2022-09-27 05:31:00 | AAPL | Stock | 152.2 | 152.2 | 152.2 | 152.2 | 150.0 |
| 2022-09-27 05:34:00 | AAPL | Stock | 152.22 | 152.22 | 152.22 | 152.22 | 100.0 |
| 2022-09-27 05:36:00 | AAPL | Stock | 152.25 | 152.25 | 152.25 | 152.25 | 578.0 |
> showing 50 of 1,364,725 rows — these rows as CSV