PREVIEW / stock_5min / 2023-01-26
file: by_date/stock_5min/2023/2023-01-26.parquet size: 6.9 MB rows: 419,293 symbols: 1,900
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-01-26 04:00:00 | AAPL | Stock | 142.9 | 142.95 | 142.74 | 142.8 | 2495.0 |
| 2023-01-26 04:05:00 | AAPL | Stock | 142.79 | 142.84 | 142.7 | 142.84 | 2953.0 |
| 2023-01-26 04:10:00 | AAPL | Stock | 142.86 | 142.86 | 142.78 | 142.78 | 676.0 |
| 2023-01-26 04:15:00 | AAPL | Stock | 142.78 | 142.78 | 142.68 | 142.69 | 899.0 |
| 2023-01-26 04:20:00 | AAPL | Stock | 142.69 | 142.75 | 142.58 | 142.6 | 1267.0 |
| 2023-01-26 04:25:00 | AAPL | Stock | 142.59 | 142.59 | 142.58 | 142.58 | 205.0 |
| 2023-01-26 04:35:00 | AAPL | Stock | 142.28 | 142.28 | 142.28 | 142.28 | 200.0 |
| 2023-01-26 04:40:00 | AAPL | Stock | 142.21 | 142.28 | 142.21 | 142.28 | 1280.0 |
| 2023-01-26 04:45:00 | AAPL | Stock | 142.3 | 142.43 | 142.3 | 142.43 | 2704.0 |
| 2023-01-26 04:50:00 | AAPL | Stock | 142.4 | 142.4 | 142.4 | 142.4 | 750.0 |
| 2023-01-26 04:55:00 | AAPL | Stock | 142.35 | 142.35 | 142.31 | 142.32 | 1243.0 |
| 2023-01-26 05:00:00 | AAPL | Stock | 142.31 | 142.31 | 142.31 | 142.31 | 100.0 |
| 2023-01-26 05:05:00 | AAPL | Stock | 142.29 | 142.29 | 142.29 | 142.29 | 100.0 |
| 2023-01-26 05:10:00 | AAPL | Stock | 142.32 | 142.39 | 142.32 | 142.39 | 200.0 |
| 2023-01-26 05:15:00 | AAPL | Stock | 142.4 | 142.4 | 142.4 | 142.4 | 124.0 |
| 2023-01-26 05:20:00 | AAPL | Stock | 142.48 | 142.55 | 142.48 | 142.55 | 712.0 |
| 2023-01-26 05:25:00 | AAPL | Stock | 142.49 | 142.49 | 142.49 | 142.49 | 144.0 |
| 2023-01-26 05:30:00 | AAPL | Stock | 142.48 | 142.48 | 142.48 | 142.48 | 115.0 |
| 2023-01-26 05:35:00 | AAPL | Stock | 142.58 | 142.61 | 142.58 | 142.61 | 520.0 |
| 2023-01-26 05:40:00 | AAPL | Stock | 142.61 | 142.61 | 142.6 | 142.6 | 405.0 |
| 2023-01-26 05:45:00 | AAPL | Stock | 142.6 | 142.6 | 142.54 | 142.54 | 300.0 |
| 2023-01-26 05:50:00 | AAPL | Stock | 142.61 | 142.62 | 142.57 | 142.57 | 382.0 |
| 2023-01-26 05:55:00 | AAPL | Stock | 142.57 | 142.65 | 142.57 | 142.61 | 515.0 |
| 2023-01-26 06:00:00 | AAPL | Stock | 142.63 | 142.63 | 142.63 | 142.63 | 590.0 |
| 2023-01-26 06:05:00 | AAPL | Stock | 142.64 | 142.74 | 142.64 | 142.74 | 1295.0 |
| 2023-01-26 06:10:00 | AAPL | Stock | 142.73 | 142.73 | 142.73 | 142.73 | 550.0 |
| 2023-01-26 06:15:00 | AAPL | Stock | 142.66 | 142.66 | 142.66 | 142.66 | 100.0 |
| 2023-01-26 06:20:00 | AAPL | Stock | 142.72 | 142.73 | 142.65 | 142.7 | 977.0 |
| 2023-01-26 06:25:00 | AAPL | Stock | 142.64 | 142.64 | 142.63 | 142.63 | 401.0 |
| 2023-01-26 06:30:00 | AAPL | Stock | 142.63 | 142.63 | 142.6 | 142.6 | 251.0 |
| 2023-01-26 06:35:00 | AAPL | Stock | 142.62 | 142.67 | 142.59 | 142.61 | 1336.0 |
| 2023-01-26 06:40:00 | AAPL | Stock | 142.51 | 142.53 | 142.49 | 142.51 | 959.0 |
| 2023-01-26 06:45:00 | AAPL | Stock | 142.58 | 142.59 | 142.58 | 142.59 | 461.0 |
| 2023-01-26 06:50:00 | AAPL | Stock | 142.59 | 142.6 | 142.5 | 142.5 | 2139.0 |
| 2023-01-26 06:55:00 | AAPL | Stock | 142.54 | 142.55 | 142.53 | 142.55 | 1339.0 |
| 2023-01-26 07:00:00 | AAPL | Stock | 142.59 | 142.63 | 142.5 | 142.6 | 4134.0 |
| 2023-01-26 07:05:00 | AAPL | Stock | 142.57 | 142.62 | 142.54 | 142.54 | 5906.0 |
| 2023-01-26 07:10:00 | AAPL | Stock | 142.58 | 142.58 | 142.55 | 142.55 | 889.0 |
| 2023-01-26 07:15:00 | AAPL | Stock | 142.54 | 142.55 | 142.5 | 142.5 | 900.0 |
| 2023-01-26 07:20:00 | AAPL | Stock | 142.5 | 142.5 | 142.5 | 142.5 | 100.0 |
| 2023-01-26 07:25:00 | AAPL | Stock | 142.49 | 142.53 | 142.44 | 142.44 | 5991.0 |
| 2023-01-26 07:30:00 | AAPL | Stock | 142.45 | 142.62 | 142.45 | 142.62 | 3468.0 |
| 2023-01-26 07:35:00 | AAPL | Stock | 142.62 | 142.65 | 142.62 | 142.65 | 1588.0 |
| 2023-01-26 07:40:00 | AAPL | Stock | 142.66 | 142.78 | 142.66 | 142.78 | 4481.0 |
| 2023-01-26 07:45:00 | AAPL | Stock | 142.75 | 142.98 | 142.72 | 142.98 | 9227.0 |
| 2023-01-26 07:50:00 | AAPL | Stock | 142.96 | 143.42 | 142.96 | 143.28 | 17975.0 |
| 2023-01-26 07:55:00 | AAPL | Stock | 143.24 | 143.31 | 143.16 | 143.31 | 2425.0 |
| 2023-01-26 08:00:00 | AAPL | Stock | 142.6 | 143.4 | 142.2915 | 143.21 | 99318.0 |
| 2023-01-26 08:05:00 | AAPL | Stock | 143.2 | 143.2 | 142.9985 | 142.9985 | 17701.0 |
| 2023-01-26 08:10:00 | AAPL | Stock | 142.96 | 143.0 | 142.83 | 142.92 | 15286.0 |
> showing 50 of 419,293 rows — these rows as CSV