PREVIEW / stock_5min / 2025-09-18
file: by_date/stock_5min/2025/2025-09-18.parquet size: 7.8 MB rows: 461,291 symbols: 311
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-09-18 04:00:00 | AAPL | Stock | 240.7 | 240.71 | 240.0 | 240.71 | 1699.0 |
| 2025-09-18 04:05:00 | AAPL | Stock | 240.79 | 240.79 | 240.6 | 240.66 | 950.0 |
| 2025-09-18 04:10:00 | AAPL | Stock | 240.64 | 240.73 | 240.57 | 240.57 | 3181.0 |
| 2025-09-18 04:15:00 | AAPL | Stock | 240.51 | 240.83 | 240.51 | 240.57 | 3097.0 |
| 2025-09-18 04:20:00 | AAPL | Stock | 240.64 | 240.7 | 240.64 | 240.7 | 865.0 |
| 2025-09-18 04:25:00 | AAPL | Stock | 240.64 | 240.68 | 240.59 | 240.59 | 1080.0 |
| 2025-09-18 04:30:00 | AAPL | Stock | 240.61 | 240.61 | 240.54 | 240.58 | 1749.0 |
| 2025-09-18 04:35:00 | AAPL | Stock | 240.51 | 240.64 | 240.51 | 240.59 | 1938.0 |
| 2025-09-18 04:45:00 | AAPL | Stock | 240.68 | 240.79 | 240.68 | 240.78 | 1851.0 |
| 2025-09-18 04:50:00 | AAPL | Stock | 240.79 | 240.98 | 240.79 | 240.9 | 6320.0 |
| 2025-09-18 04:55:00 | AAPL | Stock | 240.87 | 240.9 | 240.85 | 240.9 | 6025.0 |
| 2025-09-18 05:00:00 | AAPL | Stock | 240.9 | 240.93 | 240.76 | 240.87 | 1591.0 |
| 2025-09-18 05:05:00 | AAPL | Stock | 240.81 | 240.85 | 240.8 | 240.81 | 1461.0 |
| 2025-09-18 05:10:00 | AAPL | Stock | 240.77 | 240.79 | 240.39 | 240.39 | 1477.0 |
| 2025-09-18 05:15:00 | AAPL | Stock | 240.38 | 240.56 | 240.38 | 240.56 | 1336.0 |
| 2025-09-18 05:20:00 | AAPL | Stock | 240.48 | 240.48 | 240.38 | 240.43 | 2375.0 |
| 2025-09-18 05:25:00 | AAPL | Stock | 240.47 | 240.59 | 240.47 | 240.59 | 208.0 |
| 2025-09-18 05:30:00 | AAPL | Stock | 240.57 | 240.57 | 240.5 | 240.5 | 2279.0 |
| 2025-09-18 05:40:00 | AAPL | Stock | 240.67 | 240.8 | 240.49 | 240.49 | 2367.0 |
| 2025-09-18 05:45:00 | AAPL | Stock | 240.5 | 240.5 | 240.4 | 240.43 | 1201.0 |
| 2025-09-18 05:50:00 | AAPL | Stock | 240.45 | 240.53 | 240.11 | 240.11 | 4232.0 |
| 2025-09-18 05:55:00 | AAPL | Stock | 240.32 | 240.33 | 240.32 | 240.33 | 400.0 |
| 2025-09-18 06:00:00 | AAPL | Stock | 240.33 | 240.33 | 240.2 | 240.28 | 759.0 |
| 2025-09-18 06:05:00 | AAPL | Stock | 240.27 | 240.31 | 240.27 | 240.31 | 202.0 |
| 2025-09-18 06:15:00 | AAPL | Stock | 240.26 | 240.27 | 240.04 | 240.04 | 1542.0 |
| 2025-09-18 06:20:00 | AAPL | Stock | 240.1 | 240.1 | 240.06 | 240.09 | 365.0 |
| 2025-09-18 06:25:00 | AAPL | Stock | 240.14 | 240.15 | 240.03 | 240.08 | 3088.0 |
| 2025-09-18 06:30:00 | AAPL | Stock | 240.02 | 240.05 | 239.81 | 239.9 | 2992.0 |
| 2025-09-18 06:35:00 | AAPL | Stock | 239.95 | 239.97 | 239.92 | 239.97 | 621.0 |
| 2025-09-18 06:40:00 | AAPL | Stock | 239.9 | 239.97 | 239.9 | 239.97 | 1987.0 |
| 2025-09-18 06:45:00 | AAPL | Stock | 239.99 | 240.0 | 239.99 | 240.0 | 385.0 |
| 2025-09-18 06:50:00 | AAPL | Stock | 240.08 | 240.08 | 239.98 | 239.98 | 934.0 |
| 2025-09-18 06:55:00 | AAPL | Stock | 240.02 | 240.24 | 240.02 | 240.2 | 1113.0 |
| 2025-09-18 07:00:00 | AAPL | Stock | 240.11 | 240.28 | 240.02 | 240.15 | 7051.0 |
| 2025-09-18 07:05:00 | AAPL | Stock | 240.11 | 240.21 | 240.11 | 240.2 | 686.0 |
| 2025-09-18 07:10:00 | AAPL | Stock | 240.2 | 240.2 | 240.16 | 240.16 | 213.0 |
| 2025-09-18 07:15:00 | AAPL | Stock | 240.06 | 240.07 | 240.05 | 240.06 | 890.0 |
| 2025-09-18 07:20:00 | AAPL | Stock | 240.08 | 240.15 | 240.08 | 240.12 | 1605.0 |
| 2025-09-18 07:25:00 | AAPL | Stock | 240.07 | 240.11 | 239.86 | 239.87 | 5055.0 |
| 2025-09-18 07:30:00 | AAPL | Stock | 239.87 | 239.87 | 239.5 | 239.5 | 5192.0 |
| 2025-09-18 07:35:00 | AAPL | Stock | 239.55 | 239.57 | 239.1 | 239.15 | 6473.0 |
| 2025-09-18 07:40:00 | AAPL | Stock | 239.19 | 239.3 | 239.07 | 239.11 | 2053.0 |
| 2025-09-18 07:45:00 | AAPL | Stock | 239.15 | 239.2 | 239.1 | 239.2 | 2496.0 |
| 2025-09-18 07:50:00 | AAPL | Stock | 239.22 | 239.32 | 239.22 | 239.32 | 1350.0 |
| 2025-09-18 07:55:00 | AAPL | Stock | 239.32 | 239.4 | 239.26 | 239.4 | 3760.0 |
| 2025-09-18 08:00:00 | AAPL | Stock | 240.05 | 240.97 | 239.0109 | 239.48 | 132558.0 |
| 2025-09-18 08:05:00 | AAPL | Stock | 239.38 | 239.5089 | 239.34 | 239.34 | 4821.0 |
| 2025-09-18 08:10:00 | AAPL | Stock | 239.28 | 239.38 | 239.2009 | 239.38 | 3362.0 |
| 2025-09-18 08:15:00 | AAPL | Stock | 239.37 | 239.5 | 239.2313 | 239.43 | 4445.0 |
| 2025-09-18 08:20:00 | AAPL | Stock | 239.5 | 239.6496 | 239.5 | 239.6496 | 6388.0 |
> showing 50 of 461,291 rows — these rows as CSV