PREVIEW / stock_5min / 2023-11-13
file: by_date/stock_5min/2023/2023-11-13.parquet size: 6.4 MB rows: 390,215 symbols: 1,305
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-13 04:00:00 | AAPL | Stock | 185.35 | 185.63 | 185.35 | 185.63 | 1794.0 |
| 2023-11-13 04:05:00 | AAPL | Stock | 185.56 | 185.58 | 185.48 | 185.58 | 3797.0 |
| 2023-11-13 04:15:00 | AAPL | Stock | 185.51 | 185.63 | 185.51 | 185.63 | 1497.0 |
| 2023-11-13 04:20:00 | AAPL | Stock | 185.66 | 185.7 | 185.66 | 185.7 | 603.0 |
| 2023-11-13 04:25:00 | AAPL | Stock | 185.66 | 185.66 | 185.5 | 185.51 | 2221.0 |
| 2023-11-13 04:50:00 | AAPL | Stock | 185.59 | 185.61 | 185.59 | 185.61 | 541.0 |
| 2023-11-13 05:00:00 | AAPL | Stock | 185.6 | 185.6 | 185.55 | 185.55 | 203.0 |
| 2023-11-13 05:20:00 | AAPL | Stock | 185.55 | 185.55 | 185.55 | 185.55 | 100.0 |
| 2023-11-13 05:25:00 | AAPL | Stock | 185.59 | 185.65 | 185.59 | 185.65 | 997.0 |
| 2023-11-13 05:30:00 | AAPL | Stock | 185.64 | 185.65 | 185.64 | 185.65 | 507.0 |
| 2023-11-13 05:35:00 | AAPL | Stock | 185.65 | 185.7 | 185.64 | 185.64 | 691.0 |
| 2023-11-13 05:40:00 | AAPL | Stock | 185.65 | 185.65 | 185.65 | 185.65 | 125.0 |
| 2023-11-13 05:50:00 | AAPL | Stock | 185.6 | 185.6 | 185.6 | 185.6 | 100.0 |
| 2023-11-13 05:55:00 | AAPL | Stock | 185.6 | 185.75 | 185.6 | 185.75 | 2713.0 |
| 2023-11-13 06:00:00 | AAPL | Stock | 185.74 | 185.75 | 185.69 | 185.7 | 1691.0 |
| 2023-11-13 06:10:00 | AAPL | Stock | 185.65 | 185.68 | 185.62 | 185.68 | 1280.0 |
| 2023-11-13 06:15:00 | AAPL | Stock | 185.61 | 185.61 | 185.58 | 185.58 | 369.0 |
| 2023-11-13 06:20:00 | AAPL | Stock | 185.56 | 185.56 | 185.56 | 185.56 | 530.0 |
| 2023-11-13 06:30:00 | AAPL | Stock | 185.54 | 185.54 | 185.47 | 185.47 | 543.0 |
| 2023-11-13 06:35:00 | AAPL | Stock | 185.54 | 185.6 | 185.52 | 185.54 | 2708.0 |
| 2023-11-13 06:40:00 | AAPL | Stock | 185.52 | 185.52 | 185.52 | 185.52 | 100.0 |
| 2023-11-13 06:45:00 | AAPL | Stock | 185.58 | 185.58 | 185.53 | 185.53 | 450.0 |
| 2023-11-13 06:50:00 | AAPL | Stock | 185.6 | 185.62 | 185.6 | 185.62 | 785.0 |
| 2023-11-13 06:55:00 | AAPL | Stock | 185.64 | 185.7 | 185.64 | 185.7 | 1183.0 |
| 2023-11-13 07:00:00 | AAPL | Stock | 185.7 | 186.0 | 185.7 | 186.0 | 24679.0 |
| 2023-11-13 07:05:00 | AAPL | Stock | 186.01 | 186.15 | 186.01 | 186.15 | 13892.0 |
| 2023-11-13 07:10:00 | AAPL | Stock | 186.17 | 186.2 | 186.07 | 186.15 | 12632.0 |
| 2023-11-13 07:15:00 | AAPL | Stock | 186.18 | 186.26 | 186.16 | 186.2 | 9448.0 |
| 2023-11-13 07:20:00 | AAPL | Stock | 186.16 | 186.21 | 186.06 | 186.06 | 1981.0 |
| 2023-11-13 07:25:00 | AAPL | Stock | 186.07 | 186.1 | 186.06 | 186.1 | 2471.0 |
| 2023-11-13 07:30:00 | AAPL | Stock | 186.13 | 186.18 | 186.1 | 186.18 | 4465.0 |
| 2023-11-13 07:35:00 | AAPL | Stock | 186.23 | 186.4 | 186.22 | 186.35 | 7056.0 |
| 2023-11-13 07:40:00 | AAPL | Stock | 186.35 | 186.39 | 186.24 | 186.27 | 3278.0 |
| 2023-11-13 07:45:00 | AAPL | Stock | 186.29 | 186.38 | 186.25 | 186.38 | 2884.0 |
| 2023-11-13 07:50:00 | AAPL | Stock | 186.25 | 186.3 | 186.1 | 186.1 | 3996.0 |
| 2023-11-13 07:55:00 | AAPL | Stock | 186.08 | 186.13 | 186.08 | 186.13 | 1212.0 |
| 2023-11-13 08:00:00 | AAPL | Stock | 185.7519 | 186.39 | 185.03 | 186.08 | 35502.0 |
| 2023-11-13 08:05:00 | AAPL | Stock | 186.06 | 186.19 | 186.05 | 186.19 | 2830.0 |
| 2023-11-13 08:10:00 | AAPL | Stock | 186.19 | 186.19 | 186.05 | 186.05 | 5970.0 |
| 2023-11-13 08:15:00 | AAPL | Stock | 186.01 | 186.06 | 185.95 | 186.06 | 7339.0 |
| 2023-11-13 08:20:00 | AAPL | Stock | 186.05 | 186.09 | 185.95 | 186.0792 | 9910.0 |
| 2023-11-13 08:25:00 | AAPL | Stock | 186.06 | 186.08 | 186.0 | 186.0 | 1451.0 |
| 2023-11-13 08:30:00 | AAPL | Stock | 186.09 | 186.16 | 186.0 | 186.0 | 10479.0 |
| 2023-11-13 08:35:00 | AAPL | Stock | 186.0 | 186.0 | 185.65 | 185.7 | 17219.0 |
| 2023-11-13 08:40:00 | AAPL | Stock | 185.72 | 185.76 | 185.63 | 185.64 | 6408.0 |
| 2023-11-13 08:45:00 | AAPL | Stock | 185.66 | 185.79 | 185.62 | 185.73 | 4713.0 |
| 2023-11-13 08:50:00 | AAPL | Stock | 185.74 | 185.77 | 185.65 | 185.65 | 8494.0 |
| 2023-11-13 08:55:00 | AAPL | Stock | 185.64 | 185.7 | 185.64 | 185.69 | 4511.0 |
| 2023-11-13 09:00:00 | AAPL | Stock | 185.7 | 185.82 | 185.7 | 185.7809 | 9697.0 |
| 2023-11-13 09:05:00 | AAPL | Stock | 185.7 | 185.7 | 185.64 | 185.65 | 4694.0 |
> showing 50 of 390,215 rows — these rows as CSV