PREVIEW / stock_5min / 2025-01-28
file: by_date/stock_5min/2025/2025-01-28.parquet size: 7.1 MB rows: 422,024 symbols: 569
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-28 04:00:00 | AAPL | Stock | 230.23 | 230.74 | 230.07 | 230.35 | 11441.0 |
| 2025-01-28 04:05:00 | AAPL | Stock | 230.33 | 230.33 | 229.82 | 229.82 | 5156.0 |
| 2025-01-28 04:10:00 | AAPL | Stock | 229.79 | 229.79 | 229.15 | 229.25 | 1899.0 |
| 2025-01-28 04:15:00 | AAPL | Stock | 229.38 | 229.38 | 229.08 | 229.14 | 1010.0 |
| 2025-01-28 04:20:00 | AAPL | Stock | 229.08 | 229.62 | 229.08 | 229.62 | 1791.0 |
| 2025-01-28 04:25:00 | AAPL | Stock | 229.62 | 229.62 | 229.22 | 229.22 | 894.0 |
| 2025-01-28 04:30:00 | AAPL | Stock | 229.23 | 229.3 | 229.14 | 229.14 | 5239.0 |
| 2025-01-28 04:35:00 | AAPL | Stock | 229.23 | 229.23 | 228.96 | 229.0 | 9480.0 |
| 2025-01-28 04:40:00 | AAPL | Stock | 228.88 | 228.92 | 228.52 | 228.92 | 4671.0 |
| 2025-01-28 04:45:00 | AAPL | Stock | 228.98 | 228.98 | 228.98 | 228.98 | 100.0 |
| 2025-01-28 04:50:00 | AAPL | Stock | 229.0 | 229.14 | 228.99 | 229.12 | 1251.0 |
| 2025-01-28 04:55:00 | AAPL | Stock | 229.11 | 229.27 | 229.1 | 229.27 | 1143.0 |
| 2025-01-28 05:00:00 | AAPL | Stock | 229.31 | 229.34 | 229.0 | 229.16 | 5461.0 |
| 2025-01-28 05:05:00 | AAPL | Stock | 229.27 | 229.38 | 229.09 | 229.09 | 2647.0 |
| 2025-01-28 05:10:00 | AAPL | Stock | 229.36 | 229.54 | 229.36 | 229.37 | 820.0 |
| 2025-01-28 05:15:00 | AAPL | Stock | 229.45 | 229.55 | 229.45 | 229.51 | 500.0 |
| 2025-01-28 05:20:00 | AAPL | Stock | 229.57 | 229.62 | 229.57 | 229.62 | 1000.0 |
| 2025-01-28 05:25:00 | AAPL | Stock | 229.6 | 230.56 | 229.6 | 230.45 | 18085.0 |
| 2025-01-28 05:30:00 | AAPL | Stock | 230.44 | 230.69 | 230.14 | 230.64 | 25677.0 |
| 2025-01-28 05:35:00 | AAPL | Stock | 230.67 | 230.87 | 230.43 | 230.5 | 15899.0 |
| 2025-01-28 05:40:00 | AAPL | Stock | 230.56 | 231.39 | 230.52 | 231.34 | 27785.0 |
| 2025-01-28 05:45:00 | AAPL | Stock | 231.34 | 231.59 | 231.34 | 231.5 | 15133.0 |
| 2025-01-28 05:50:00 | AAPL | Stock | 231.5 | 231.72 | 231.5 | 231.72 | 9659.0 |
| 2025-01-28 05:55:00 | AAPL | Stock | 231.5 | 231.78 | 231.5 | 231.67 | 8224.0 |
| 2025-01-28 06:00:00 | AAPL | Stock | 231.69 | 231.8 | 231.49 | 231.51 | 6560.0 |
| 2025-01-28 06:05:00 | AAPL | Stock | 231.5 | 231.7 | 231.15 | 231.56 | 5229.0 |
| 2025-01-28 06:10:00 | AAPL | Stock | 231.69 | 231.82 | 231.66 | 231.76 | 8976.0 |
| 2025-01-28 06:15:00 | AAPL | Stock | 231.74 | 231.84 | 231.4 | 231.4 | 5764.0 |
| 2025-01-28 06:20:00 | AAPL | Stock | 231.3 | 231.4 | 231.3 | 231.4 | 1350.0 |
| 2025-01-28 06:25:00 | AAPL | Stock | 231.33 | 231.33 | 231.18 | 231.18 | 639.0 |
| 2025-01-28 06:30:00 | AAPL | Stock | 231.26 | 231.38 | 230.8 | 230.85 | 4587.0 |
| 2025-01-28 06:35:00 | AAPL | Stock | 230.85 | 230.85 | 230.54 | 230.79 | 2874.0 |
| 2025-01-28 06:40:00 | AAPL | Stock | 230.85 | 231.13 | 230.85 | 230.98 | 776.0 |
| 2025-01-28 06:45:00 | AAPL | Stock | 231.03 | 231.05 | 230.83 | 230.83 | 875.0 |
| 2025-01-28 06:50:00 | AAPL | Stock | 230.84 | 230.86 | 230.7 | 230.75 | 2405.0 |
| 2025-01-28 06:55:00 | AAPL | Stock | 230.92 | 231.02 | 230.89 | 230.93 | 5992.0 |
| 2025-01-28 07:00:00 | AAPL | Stock | 231.05 | 231.05 | 230.25 | 230.92 | 17599.0 |
| 2025-01-28 07:05:00 | AAPL | Stock | 230.8 | 230.82 | 230.14 | 230.25 | 15633.0 |
| 2025-01-28 07:10:00 | AAPL | Stock | 230.24 | 230.25 | 229.96 | 229.96 | 14313.0 |
| 2025-01-28 07:15:00 | AAPL | Stock | 229.98 | 229.99 | 229.7 | 229.75 | 5542.0 |
| 2025-01-28 07:20:00 | AAPL | Stock | 229.75 | 230.27 | 229.53 | 230.27 | 7196.0 |
| 2025-01-28 07:25:00 | AAPL | Stock | 230.11 | 230.11 | 229.8 | 229.99 | 5561.0 |
| 2025-01-28 07:30:00 | AAPL | Stock | 230.04 | 230.04 | 229.82 | 230.0 | 4040.0 |
| 2025-01-28 07:35:00 | AAPL | Stock | 230.02 | 230.48 | 230.0 | 230.44 | 15669.0 |
| 2025-01-28 07:40:00 | AAPL | Stock | 230.4 | 230.43 | 230.16 | 230.43 | 10525.0 |
| 2025-01-28 07:45:00 | AAPL | Stock | 230.44 | 230.67 | 230.44 | 230.63 | 3676.0 |
| 2025-01-28 07:50:00 | AAPL | Stock | 230.61 | 230.79 | 230.61 | 230.78 | 3467.0 |
| 2025-01-28 07:55:00 | AAPL | Stock | 230.75 | 230.77 | 230.66 | 230.66 | 3280.0 |
| 2025-01-28 08:00:00 | AAPL | Stock | 230.25 | 231.0 | 229.0768 | 230.81 | 101565.0 |
| 2025-01-28 08:05:00 | AAPL | Stock | 230.81 | 230.87 | 230.555 | 230.6 | 11849.0 |
> showing 50 of 422,024 rows — these rows as CSV