PREVIEW / stock_1min / 2022-01-27
file: by_date/stock_1min/2022/2022-01-27.parquet size: 24.1 MB rows: 1,465,790 symbols: 2,340
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-01-27 04:00:00 | AAPL | Stock | 160.33 | 160.35 | 159.28 | 159.69 | 13217.0 |
| 2022-01-27 04:01:00 | AAPL | Stock | 159.7 | 159.86 | 159.62 | 159.86 | 5864.0 |
| 2022-01-27 04:02:00 | AAPL | Stock | 159.95 | 159.99 | 159.95 | 159.99 | 438.0 |
| 2022-01-27 04:03:00 | AAPL | Stock | 160.29 | 160.33 | 160.29 | 160.33 | 979.0 |
| 2022-01-27 04:04:00 | AAPL | Stock | 160.33 | 160.36 | 160.1 | 160.1 | 3204.0 |
| 2022-01-27 04:05:00 | AAPL | Stock | 160.1 | 160.1 | 160.07 | 160.07 | 510.0 |
| 2022-01-27 04:06:00 | AAPL | Stock | 160.08 | 160.08 | 160.08 | 160.08 | 300.0 |
| 2022-01-27 04:07:00 | AAPL | Stock | 160.15 | 160.15 | 160.14 | 160.15 | 1850.0 |
| 2022-01-27 04:08:00 | AAPL | Stock | 160.13 | 160.13 | 159.99 | 159.99 | 1103.0 |
| 2022-01-27 04:09:00 | AAPL | Stock | 159.99 | 159.99 | 159.99 | 159.99 | 144.0 |
| 2022-01-27 04:10:00 | AAPL | Stock | 159.88 | 159.88 | 159.67 | 159.68 | 1436.0 |
| 2022-01-27 04:11:00 | AAPL | Stock | 159.73 | 159.73 | 159.68 | 159.73 | 644.0 |
| 2022-01-27 04:12:00 | AAPL | Stock | 159.74 | 159.99 | 159.74 | 159.98 | 2023.0 |
| 2022-01-27 04:13:00 | AAPL | Stock | 160.0 | 160.07 | 160.0 | 160.0 | 1496.0 |
| 2022-01-27 04:14:00 | AAPL | Stock | 160.05 | 160.07 | 160.05 | 160.07 | 878.0 |
| 2022-01-27 04:15:00 | AAPL | Stock | 160.19 | 160.19 | 160.19 | 160.19 | 200.0 |
| 2022-01-27 04:16:00 | AAPL | Stock | 160.12 | 160.12 | 160.0 | 160.05 | 1474.0 |
| 2022-01-27 04:19:00 | AAPL | Stock | 160.1 | 160.22 | 160.1 | 160.22 | 1311.0 |
| 2022-01-27 04:20:00 | AAPL | Stock | 160.2 | 160.21 | 160.13 | 160.13 | 656.0 |
| 2022-01-27 04:21:00 | AAPL | Stock | 160.06 | 160.06 | 160.04 | 160.04 | 204.0 |
| 2022-01-27 04:22:00 | AAPL | Stock | 160.11 | 160.11 | 160.09 | 160.09 | 239.0 |
| 2022-01-27 04:23:00 | AAPL | Stock | 160.19 | 160.22 | 160.19 | 160.22 | 204.0 |
| 2022-01-27 04:24:00 | AAPL | Stock | 160.22 | 160.38 | 160.22 | 160.38 | 2150.0 |
| 2022-01-27 04:26:00 | AAPL | Stock | 160.38 | 160.4 | 160.38 | 160.4 | 204.0 |
| 2022-01-27 04:27:00 | AAPL | Stock | 160.43 | 160.45 | 160.43 | 160.44 | 676.0 |
| 2022-01-27 04:28:00 | AAPL | Stock | 160.48 | 160.5 | 160.48 | 160.5 | 401.0 |
| 2022-01-27 04:29:00 | AAPL | Stock | 160.48 | 160.48 | 160.48 | 160.48 | 100.0 |
| 2022-01-27 04:31:00 | AAPL | Stock | 160.31 | 160.31 | 160.12 | 160.12 | 612.0 |
| 2022-01-27 04:32:00 | AAPL | Stock | 160.27 | 160.27 | 160.27 | 160.27 | 200.0 |
| 2022-01-27 04:33:00 | AAPL | Stock | 160.3 | 160.3 | 160.3 | 160.3 | 190.0 |
| 2022-01-27 04:34:00 | AAPL | Stock | 160.12 | 160.34 | 160.12 | 160.34 | 1360.0 |
| 2022-01-27 04:36:00 | AAPL | Stock | 160.32 | 160.49 | 160.21 | 160.21 | 781.0 |
| 2022-01-27 04:37:00 | AAPL | Stock | 160.38 | 160.38 | 160.38 | 160.38 | 100.0 |
| 2022-01-27 04:38:00 | AAPL | Stock | 160.34 | 160.34 | 160.34 | 160.34 | 400.0 |
| 2022-01-27 04:39:00 | AAPL | Stock | 160.37 | 160.37 | 160.37 | 160.37 | 100.0 |
| 2022-01-27 04:46:00 | AAPL | Stock | 160.68 | 160.76 | 160.68 | 160.76 | 430.0 |
| 2022-01-27 04:48:00 | AAPL | Stock | 160.65 | 160.65 | 160.65 | 160.65 | 600.0 |
| 2022-01-27 04:49:00 | AAPL | Stock | 160.63 | 160.65 | 160.63 | 160.65 | 567.0 |
| 2022-01-27 04:51:00 | AAPL | Stock | 160.66 | 160.7 | 160.66 | 160.7 | 400.0 |
| 2022-01-27 04:52:00 | AAPL | Stock | 160.78 | 160.78 | 160.78 | 160.78 | 154.0 |
| 2022-01-27 04:53:00 | AAPL | Stock | 160.81 | 160.81 | 160.81 | 160.81 | 100.0 |
| 2022-01-27 04:54:00 | AAPL | Stock | 160.9 | 160.9 | 160.81 | 160.81 | 1083.0 |
| 2022-01-27 04:55:00 | AAPL | Stock | 160.89 | 160.92 | 160.89 | 160.92 | 200.0 |
| 2022-01-27 05:00:00 | AAPL | Stock | 160.8 | 160.8 | 160.78 | 160.78 | 923.0 |
| 2022-01-27 05:05:00 | AAPL | Stock | 161.15 | 161.3 | 161.13 | 161.3 | 2900.0 |
| 2022-01-27 05:07:00 | AAPL | Stock | 161.27 | 161.27 | 161.18 | 161.18 | 353.0 |
| 2022-01-27 05:08:00 | AAPL | Stock | 161.16 | 161.16 | 161.1 | 161.1 | 1000.0 |
| 2022-01-27 05:09:00 | AAPL | Stock | 161.1 | 161.1 | 161.1 | 161.1 | 100.0 |
| 2022-01-27 05:10:00 | AAPL | Stock | 161.09 | 161.12 | 161.09 | 161.1 | 684.0 |
| 2022-01-27 05:11:00 | AAPL | Stock | 161.19 | 161.19 | 161.0 | 161.0 | 659.0 |
> showing 50 of 1,465,790 rows — these rows as CSV