PREVIEW / stock_5min / 2025-01-21
file: by_date/stock_5min/2025/2025-01-21.parquet size: 7.6 MB rows: 446,970 symbols: 593
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-21 04:00:00 | AAPL | Stock | 227.33 | 228.27 | 226.5 | 227.26 | 29274.0 |
| 2025-01-21 04:05:00 | AAPL | Stock | 227.3 | 227.4 | 227.11 | 227.17 | 5587.0 |
| 2025-01-21 04:10:00 | AAPL | Stock | 227.35 | 227.66 | 227.35 | 227.57 | 3217.0 |
| 2025-01-21 04:15:00 | AAPL | Stock | 227.59 | 227.69 | 227.46 | 227.55 | 5636.0 |
| 2025-01-21 04:20:00 | AAPL | Stock | 227.54 | 227.6 | 227.11 | 227.11 | 9210.0 |
| 2025-01-21 04:25:00 | AAPL | Stock | 227.03 | 227.24 | 227.03 | 227.23 | 1614.0 |
| 2025-01-21 04:30:00 | AAPL | Stock | 227.25 | 227.34 | 227.23 | 227.33 | 1702.0 |
| 2025-01-21 04:35:00 | AAPL | Stock | 227.23 | 227.23 | 227.03 | 227.09 | 5034.0 |
| 2025-01-21 04:40:00 | AAPL | Stock | 227.01 | 227.01 | 226.65 | 226.68 | 15439.0 |
| 2025-01-21 04:45:00 | AAPL | Stock | 226.86 | 226.99 | 226.78 | 226.91 | 3770.0 |
| 2025-01-21 04:50:00 | AAPL | Stock | 226.99 | 227.1 | 226.99 | 227.1 | 864.0 |
| 2025-01-21 04:55:00 | AAPL | Stock | 227.03 | 227.03 | 227.03 | 227.03 | 100.0 |
| 2025-01-21 05:00:00 | AAPL | Stock | 227.14 | 227.32 | 227.14 | 227.32 | 1711.0 |
| 2025-01-21 05:05:00 | AAPL | Stock | 227.29 | 227.39 | 227.29 | 227.39 | 1183.0 |
| 2025-01-21 05:10:00 | AAPL | Stock | 227.36 | 227.36 | 227.3 | 227.3 | 1419.0 |
| 2025-01-21 05:15:00 | AAPL | Stock | 227.29 | 227.35 | 227.24 | 227.35 | 1588.0 |
| 2025-01-21 05:20:00 | AAPL | Stock | 227.35 | 227.51 | 227.35 | 227.49 | 800.0 |
| 2025-01-21 05:25:00 | AAPL | Stock | 227.46 | 227.51 | 227.45 | 227.51 | 800.0 |
| 2025-01-21 05:30:00 | AAPL | Stock | 227.46 | 227.51 | 227.44 | 227.5 | 1137.0 |
| 2025-01-21 05:35:00 | AAPL | Stock | 227.43 | 227.45 | 227.33 | 227.33 | 2417.0 |
| 2025-01-21 05:40:00 | AAPL | Stock | 227.38 | 227.48 | 227.32 | 227.35 | 1273.0 |
| 2025-01-21 05:45:00 | AAPL | Stock | 227.32 | 227.38 | 227.31 | 227.38 | 1639.0 |
| 2025-01-21 05:50:00 | AAPL | Stock | 227.38 | 227.45 | 227.37 | 227.37 | 1756.0 |
| 2025-01-21 05:55:00 | AAPL | Stock | 227.38 | 227.38 | 226.8 | 226.8 | 8008.0 |
| 2025-01-21 06:00:00 | AAPL | Stock | 226.96 | 226.98 | 226.76 | 226.93 | 2126.0 |
| 2025-01-21 06:05:00 | AAPL | Stock | 226.99 | 227.0 | 226.75 | 226.9 | 3520.0 |
| 2025-01-21 06:10:00 | AAPL | Stock | 226.88 | 227.14 | 226.88 | 227.09 | 2599.0 |
| 2025-01-21 06:15:00 | AAPL | Stock | 227.04 | 227.04 | 226.64 | 226.69 | 5456.0 |
| 2025-01-21 06:20:00 | AAPL | Stock | 226.7 | 226.7 | 226.61 | 226.66 | 2223.0 |
| 2025-01-21 06:25:00 | AAPL | Stock | 226.7 | 226.7 | 226.25 | 226.3 | 8995.0 |
| 2025-01-21 06:30:00 | AAPL | Stock | 226.4 | 226.5 | 226.38 | 226.46 | 2541.0 |
| 2025-01-21 06:35:00 | AAPL | Stock | 226.5 | 226.56 | 225.63 | 225.63 | 23699.0 |
| 2025-01-21 06:40:00 | AAPL | Stock | 225.62 | 226.09 | 225.62 | 226.0 | 6621.0 |
| 2025-01-21 06:45:00 | AAPL | Stock | 226.15 | 226.15 | 225.61 | 225.61 | 16790.0 |
| 2025-01-21 06:50:00 | AAPL | Stock | 225.79 | 225.79 | 225.34 | 225.79 | 25163.0 |
| 2025-01-21 06:55:00 | AAPL | Stock | 225.63 | 225.63 | 225.36 | 225.45 | 11253.0 |
| 2025-01-21 07:00:00 | AAPL | Stock | 225.49 | 225.91 | 224.85 | 224.85 | 63905.0 |
| 2025-01-21 07:05:00 | AAPL | Stock | 224.84 | 225.12 | 224.82 | 225.0 | 40440.0 |
| 2025-01-21 07:10:00 | AAPL | Stock | 225.08 | 225.25 | 224.99 | 225.0 | 17215.0 |
| 2025-01-21 07:15:00 | AAPL | Stock | 225.07 | 225.18 | 224.97 | 225.09 | 15568.0 |
| 2025-01-21 07:20:00 | AAPL | Stock | 225.08 | 225.18 | 225.07 | 225.18 | 16809.0 |
| 2025-01-21 07:25:00 | AAPL | Stock | 225.22 | 225.5 | 225.22 | 225.39 | 14136.0 |
| 2025-01-21 07:30:00 | AAPL | Stock | 225.39 | 225.8 | 225.33 | 225.68 | 16503.0 |
| 2025-01-21 07:35:00 | AAPL | Stock | 225.55 | 225.7 | 225.5 | 225.59 | 7375.0 |
| 2025-01-21 07:40:00 | AAPL | Stock | 225.57 | 225.83 | 225.57 | 225.82 | 12706.0 |
| 2025-01-21 07:45:00 | AAPL | Stock | 225.88 | 226.1 | 225.75 | 225.8 | 47313.0 |
| 2025-01-21 07:50:00 | AAPL | Stock | 225.75 | 225.84 | 225.61 | 225.75 | 9791.0 |
| 2025-01-21 07:55:00 | AAPL | Stock | 225.8 | 225.94 | 225.8 | 225.87 | 2866.0 |
| 2025-01-21 08:00:00 | AAPL | Stock | 225.25 | 227.75 | 224.83 | 225.85 | 192323.0 |
| 2025-01-21 08:05:00 | AAPL | Stock | 225.85 | 225.86 | 225.75 | 225.77 | 10130.0 |
> showing 50 of 446,970 rows — these rows as CSV