PREVIEW / stock_5min / 2025-06-18
file: by_date/stock_5min/2025/2025-06-18.parquet size: 7.2 MB rows: 424,219 symbols: 393
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-06-18 04:00:00 | AAPL | Stock | 196.15 | 196.4 | 196.13 | 196.4 | 1565.0 |
| 2025-06-18 04:05:00 | AAPL | Stock | 196.45 | 196.56 | 196.45 | 196.56 | 2979.0 |
| 2025-06-18 04:10:00 | AAPL | Stock | 196.55 | 196.6 | 196.52 | 196.52 | 1357.0 |
| 2025-06-18 04:15:00 | AAPL | Stock | 196.5 | 196.5 | 196.44 | 196.45 | 2260.0 |
| 2025-06-18 04:20:00 | AAPL | Stock | 196.5 | 196.5 | 196.4 | 196.4 | 1093.0 |
| 2025-06-18 04:30:00 | AAPL | Stock | 196.43 | 196.43 | 196.38 | 196.38 | 2678.0 |
| 2025-06-18 04:35:00 | AAPL | Stock | 196.4 | 196.42 | 196.4 | 196.42 | 1331.0 |
| 2025-06-18 04:40:00 | AAPL | Stock | 196.43 | 196.43 | 196.43 | 196.43 | 100.0 |
| 2025-06-18 04:45:00 | AAPL | Stock | 196.44 | 196.5 | 196.44 | 196.5 | 1476.0 |
| 2025-06-18 04:50:00 | AAPL | Stock | 196.51 | 196.52 | 196.5 | 196.52 | 405.0 |
| 2025-06-18 04:55:00 | AAPL | Stock | 196.58 | 196.58 | 196.5 | 196.5 | 1759.0 |
| 2025-06-18 05:00:00 | AAPL | Stock | 196.55 | 196.67 | 196.55 | 196.67 | 1336.0 |
| 2025-06-18 05:05:00 | AAPL | Stock | 196.7 | 196.79 | 196.69 | 196.74 | 8892.0 |
| 2025-06-18 05:10:00 | AAPL | Stock | 196.6 | 196.71 | 196.59 | 196.71 | 1905.0 |
| 2025-06-18 05:15:00 | AAPL | Stock | 196.63 | 196.66 | 196.62 | 196.66 | 560.0 |
| 2025-06-18 05:20:00 | AAPL | Stock | 196.76 | 196.76 | 196.69 | 196.69 | 3151.0 |
| 2025-06-18 05:25:00 | AAPL | Stock | 196.66 | 196.67 | 196.65 | 196.65 | 589.0 |
| 2025-06-18 05:30:00 | AAPL | Stock | 196.61 | 196.61 | 196.61 | 196.61 | 200.0 |
| 2025-06-18 05:35:00 | AAPL | Stock | 196.64 | 196.64 | 196.52 | 196.52 | 811.0 |
| 2025-06-18 05:40:00 | AAPL | Stock | 196.55 | 196.6 | 196.51 | 196.6 | 1020.0 |
| 2025-06-18 05:45:00 | AAPL | Stock | 196.6 | 196.6 | 196.54 | 196.54 | 647.0 |
| 2025-06-18 05:50:00 | AAPL | Stock | 196.55 | 196.55 | 196.55 | 196.55 | 114.0 |
| 2025-06-18 05:55:00 | AAPL | Stock | 196.58 | 196.58 | 196.51 | 196.55 | 1397.0 |
| 2025-06-18 06:00:00 | AAPL | Stock | 196.58 | 196.6 | 196.52 | 196.56 | 1775.0 |
| 2025-06-18 06:05:00 | AAPL | Stock | 196.58 | 196.58 | 196.55 | 196.55 | 654.0 |
| 2025-06-18 06:10:00 | AAPL | Stock | 196.5 | 196.5 | 196.5 | 196.5 | 352.0 |
| 2025-06-18 06:15:00 | AAPL | Stock | 196.53 | 196.54 | 196.47 | 196.5 | 1169.0 |
| 2025-06-18 06:20:00 | AAPL | Stock | 196.48 | 196.48 | 196.31 | 196.32 | 727.0 |
| 2025-06-18 06:25:00 | AAPL | Stock | 196.35 | 196.4 | 196.35 | 196.4 | 1020.0 |
| 2025-06-18 06:30:00 | AAPL | Stock | 196.36 | 196.4 | 196.35 | 196.4 | 1135.0 |
| 2025-06-18 06:35:00 | AAPL | Stock | 196.3 | 196.32 | 196.24 | 196.32 | 1202.0 |
| 2025-06-18 06:40:00 | AAPL | Stock | 196.21 | 196.34 | 196.2 | 196.34 | 1428.0 |
| 2025-06-18 06:45:00 | AAPL | Stock | 196.39 | 196.39 | 196.35 | 196.35 | 840.0 |
| 2025-06-18 06:50:00 | AAPL | Stock | 196.2 | 196.2 | 196.04 | 196.04 | 2296.0 |
| 2025-06-18 06:55:00 | AAPL | Stock | 196.0 | 196.0 | 195.81 | 195.99 | 4865.0 |
| 2025-06-18 07:00:00 | AAPL | Stock | 196.0 | 196.05 | 195.8 | 195.84 | 7284.0 |
| 2025-06-18 07:05:00 | AAPL | Stock | 195.93 | 195.93 | 195.85 | 195.85 | 715.0 |
| 2025-06-18 07:10:00 | AAPL | Stock | 195.84 | 195.84 | 195.72 | 195.83 | 3174.0 |
| 2025-06-18 07:15:00 | AAPL | Stock | 195.9 | 195.94 | 195.82 | 195.88 | 8307.0 |
| 2025-06-18 07:20:00 | AAPL | Stock | 195.94 | 196.0 | 195.94 | 196.0 | 500.0 |
| 2025-06-18 07:25:00 | AAPL | Stock | 196.05 | 196.05 | 196.0 | 196.0 | 1631.0 |
| 2025-06-18 07:30:00 | AAPL | Stock | 196.02 | 196.05 | 196.02 | 196.05 | 564.0 |
| 2025-06-18 07:35:00 | AAPL | Stock | 196.05 | 196.05 | 195.95 | 195.95 | 3059.0 |
| 2025-06-18 07:40:00 | AAPL | Stock | 196.06 | 196.09 | 196.02 | 196.09 | 2915.0 |
| 2025-06-18 07:45:00 | AAPL | Stock | 196.2 | 196.28 | 196.2 | 196.25 | 1426.0 |
| 2025-06-18 07:50:00 | AAPL | Stock | 196.2 | 196.2 | 196.2 | 196.2 | 100.0 |
| 2025-06-18 07:55:00 | AAPL | Stock | 196.17 | 196.17 | 196.15 | 196.16 | 1077.0 |
| 2025-06-18 08:00:00 | AAPL | Stock | 195.98 | 196.66 | 195.51 | 196.19 | 44364.0 |
| 2025-06-18 08:05:00 | AAPL | Stock | 196.17 | 196.2 | 196.12 | 196.13 | 4731.0 |
| 2025-06-18 08:10:00 | AAPL | Stock | 196.16 | 196.16 | 196.16 | 196.16 | 200.0 |
> showing 50 of 424,219 rows — these rows as CSV