PREVIEW / stock_5min / 2022-10-27
file: by_date/stock_5min/2022/2022-10-27.parquet size: 6.8 MB rows: 418,408 symbols: 2,122
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-10-27 04:00:00 | AAPL | Stock | 148.94 | 149.05 | 148.71 | 149.0 | 3212.0 |
| 2022-10-27 04:05:00 | AAPL | Stock | 148.9 | 148.94 | 148.65 | 148.78 | 4512.0 |
| 2022-10-27 04:10:00 | AAPL | Stock | 148.85 | 148.99 | 148.79 | 148.99 | 11293.0 |
| 2022-10-27 04:15:00 | AAPL | Stock | 148.99 | 149.1 | 148.84 | 149.1 | 7848.0 |
| 2022-10-27 04:20:00 | AAPL | Stock | 149.01 | 149.02 | 148.85 | 148.86 | 1499.0 |
| 2022-10-27 04:25:00 | AAPL | Stock | 148.88 | 149.06 | 148.88 | 149.0 | 1099.0 |
| 2022-10-27 04:30:00 | AAPL | Stock | 148.94 | 148.94 | 148.94 | 148.94 | 216.0 |
| 2022-10-27 04:35:00 | AAPL | Stock | 149.05 | 149.06 | 149.05 | 149.05 | 1224.0 |
| 2022-10-27 04:40:00 | AAPL | Stock | 148.95 | 148.95 | 148.74 | 148.82 | 1914.0 |
| 2022-10-27 04:45:00 | AAPL | Stock | 148.82 | 148.82 | 148.82 | 148.82 | 350.0 |
| 2022-10-27 04:50:00 | AAPL | Stock | 148.87 | 148.92 | 148.76 | 148.76 | 790.0 |
| 2022-10-27 04:55:00 | AAPL | Stock | 148.78 | 148.8 | 148.75 | 148.8 | 941.0 |
| 2022-10-27 05:00:00 | AAPL | Stock | 148.75 | 148.76 | 148.51 | 148.51 | 2725.0 |
| 2022-10-27 05:05:00 | AAPL | Stock | 148.54 | 148.6 | 148.39 | 148.5 | 3293.0 |
| 2022-10-27 05:10:00 | AAPL | Stock | 148.5 | 148.65 | 148.44 | 148.45 | 5028.0 |
| 2022-10-27 05:15:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 200.0 |
| 2022-10-27 05:20:00 | AAPL | Stock | 148.55 | 148.57 | 148.55 | 148.57 | 590.0 |
| 2022-10-27 05:25:00 | AAPL | Stock | 148.51 | 148.55 | 148.43 | 148.44 | 1841.0 |
| 2022-10-27 05:30:00 | AAPL | Stock | 148.6 | 148.6 | 148.41 | 148.41 | 545.0 |
| 2022-10-27 05:35:00 | AAPL | Stock | 148.55 | 148.57 | 148.42 | 148.42 | 3913.0 |
| 2022-10-27 05:40:00 | AAPL | Stock | 148.48 | 148.48 | 148.48 | 148.48 | 200.0 |
| 2022-10-27 05:45:00 | AAPL | Stock | 148.49 | 148.53 | 148.45 | 148.53 | 1498.0 |
| 2022-10-27 05:50:00 | AAPL | Stock | 148.52 | 148.61 | 148.52 | 148.59 | 2648.0 |
| 2022-10-27 05:55:00 | AAPL | Stock | 148.54 | 148.57 | 148.32 | 148.32 | 5630.0 |
| 2022-10-27 06:00:00 | AAPL | Stock | 148.32 | 148.4 | 148.31 | 148.4 | 2370.0 |
| 2022-10-27 06:05:00 | AAPL | Stock | 148.47 | 148.47 | 148.33 | 148.33 | 498.0 |
| 2022-10-27 06:10:00 | AAPL | Stock | 148.43 | 148.43 | 148.43 | 148.43 | 400.0 |
| 2022-10-27 06:15:00 | AAPL | Stock | 148.42 | 148.46 | 148.4 | 148.42 | 1990.0 |
| 2022-10-27 06:20:00 | AAPL | Stock | 148.4 | 148.4 | 148.3 | 148.3 | 1587.0 |
| 2022-10-27 06:25:00 | AAPL | Stock | 148.32 | 148.32 | 148.25 | 148.25 | 1442.0 |
| 2022-10-27 06:30:00 | AAPL | Stock | 148.34 | 148.46 | 148.31 | 148.46 | 2571.0 |
| 2022-10-27 06:35:00 | AAPL | Stock | 148.4 | 148.43 | 148.02 | 148.12 | 9651.0 |
| 2022-10-27 06:40:00 | AAPL | Stock | 148.12 | 148.15 | 148.0 | 148.0 | 8182.0 |
| 2022-10-27 06:45:00 | AAPL | Stock | 148.0 | 148.14 | 148.0 | 148.14 | 2188.0 |
| 2022-10-27 06:50:00 | AAPL | Stock | 148.15 | 148.2 | 148.01 | 148.2 | 9545.0 |
| 2022-10-27 06:55:00 | AAPL | Stock | 148.21 | 148.22 | 148.17 | 148.17 | 12150.0 |
| 2022-10-27 07:00:00 | AAPL | Stock | 148.15 | 148.37 | 148.07 | 148.18 | 19569.0 |
| 2022-10-27 07:05:00 | AAPL | Stock | 148.14 | 148.15 | 147.92 | 148.1 | 16776.0 |
| 2022-10-27 07:10:00 | AAPL | Stock | 148.17 | 148.17 | 148.06 | 148.1 | 3202.0 |
| 2022-10-27 07:15:00 | AAPL | Stock | 148.07 | 148.35 | 148.01 | 148.35 | 7132.0 |
| 2022-10-27 07:20:00 | AAPL | Stock | 148.25 | 148.35 | 148.25 | 148.35 | 2007.0 |
| 2022-10-27 07:25:00 | AAPL | Stock | 148.35 | 148.39 | 148.3 | 148.33 | 9609.0 |
| 2022-10-27 07:30:00 | AAPL | Stock | 148.35 | 148.36 | 148.25 | 148.3 | 11885.0 |
| 2022-10-27 07:35:00 | AAPL | Stock | 148.31 | 148.31 | 148.18 | 148.24 | 3578.0 |
| 2022-10-27 07:40:00 | AAPL | Stock | 148.24 | 148.29 | 148.1 | 148.1 | 2979.0 |
| 2022-10-27 07:45:00 | AAPL | Stock | 148.06 | 148.11 | 148.0 | 148.07 | 7679.0 |
| 2022-10-27 07:50:00 | AAPL | Stock | 148.09 | 148.13 | 148.05 | 148.09 | 3083.0 |
| 2022-10-27 07:55:00 | AAPL | Stock | 148.08 | 148.08 | 147.97 | 147.97 | 11672.0 |
| 2022-10-27 08:00:00 | AAPL | Stock | 148.0535 | 149.5 | 147.7 | 147.79 | 89556.0 |
| 2022-10-27 08:05:00 | AAPL | Stock | 147.83 | 147.97 | 147.77 | 147.78 | 14241.0 |
> showing 50 of 418,408 rows — these rows as CSV