PREVIEW / stock_30min / 2025-08-26
file: by_date/stock_30min/2025/2025-08-26.parquet size: 2.2 MB rows: 104,383 symbols: 327
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-08-26 04:00:00 | AAPL | Stock | 226.8 | 227.04 | 226.8 | 226.94 | 2587.0 |
| 2025-08-26 04:30:00 | AAPL | Stock | 226.87 | 226.87 | 226.87 | 226.87 | 100.0 |
| 2025-08-26 05:00:00 | AAPL | Stock | 227.0 | 227.0 | 226.99 | 226.99 | 785.0 |
| 2025-08-26 05:30:00 | AAPL | Stock | 227.05 | 227.05 | 226.98 | 227.04 | 906.0 |
| 2025-08-26 06:00:00 | AAPL | Stock | 227.04 | 227.04 | 226.98 | 226.99 | 1506.0 |
| 2025-08-26 06:30:00 | AAPL | Stock | 227.08 | 227.1 | 227.0 | 227.0 | 2352.0 |
| 2025-08-26 07:00:00 | AAPL | Stock | 227.04 | 227.04 | 226.8 | 226.8 | 5746.0 |
| 2025-08-26 07:30:00 | AAPL | Stock | 226.6 | 226.76 | 226.59 | 226.7 | 1790.0 |
| 2025-08-26 08:00:00 | AAPL | Stock | 227.05 | 227.25 | 226.53 | 226.86 | 28768.0 |
| 2025-08-26 08:30:00 | AAPL | Stock | 226.9699 | 226.9699 | 226.75 | 226.75 | 12109.0 |
| 2025-08-26 09:00:00 | AAPL | Stock | 226.8099 | 227.07 | 226.52 | 227.0 | 34802.0 |
| 2025-08-26 09:30:00 | AAPL | Stock | 226.86 | 227.05 | 224.69 | 225.26 | 3462975.0 |
| 2025-08-26 10:00:00 | AAPL | Stock | 225.27 | 226.5034 | 224.8866 | 226.5 | 2388067.0 |
| 2025-08-26 10:30:00 | AAPL | Stock | 226.51 | 227.08 | 226.28 | 226.615 | 1498212.0 |
| 2025-08-26 11:00:00 | AAPL | Stock | 226.63 | 227.2999 | 226.6 | 226.9616 | 1070471.0 |
| 2025-08-26 11:30:00 | AAPL | Stock | 226.96 | 227.2899 | 226.55 | 226.695 | 908867.0 |
| 2025-08-26 12:00:00 | AAPL | Stock | 226.71 | 227.7 | 226.71 | 227.5705 | 1469379.0 |
| 2025-08-26 12:30:00 | AAPL | Stock | 227.57 | 227.97 | 227.42 | 227.7 | 931418.0 |
| 2025-08-26 13:00:00 | AAPL | Stock | 227.71 | 228.17 | 227.64 | 228.1116 | 821521.0 |
| 2025-08-26 13:30:00 | AAPL | Stock | 228.11 | 228.13 | 227.735 | 227.9957 | 803978.0 |
| 2025-08-26 14:00:00 | AAPL | Stock | 227.99 | 228.51 | 227.92 | 228.3592 | 1053255.0 |
| 2025-08-26 14:30:00 | AAPL | Stock | 228.36 | 228.529 | 227.9 | 227.97 | 830544.0 |
| 2025-08-26 15:00:00 | AAPL | Stock | 227.98 | 228.62 | 227.77 | 228.5682 | 1095487.0 |
| 2025-08-26 15:30:00 | AAPL | Stock | 228.57 | 229.49 | 227.5 | 229.3 | 3622706.0 |
| 2025-08-26 16:00:00 | AAPL | Stock | 229.31 | 229.6 | 229.0731 | 229.2801 | 20443150.0 |
| 2025-08-26 16:30:00 | AAPL | Stock | 229.4 | 229.61 | 229.3003 | 229.55 | 39697.0 |
| 2025-08-26 17:00:00 | AAPL | Stock | 229.55 | 229.7 | 229.45 | 229.66 | 10485.0 |
| 2025-08-26 17:30:00 | AAPL | Stock | 229.63 | 229.87 | 229.56 | 229.75 | 14394.0 |
| 2025-08-26 18:00:00 | AAPL | Stock | 229.72 | 229.9 | 229.6488 | 229.86 | 7232.0 |
| 2025-08-26 18:30:00 | AAPL | Stock | 229.86 | 229.87 | 229.6 | 229.7501 | 9594.0 |
| 2025-08-26 19:00:00 | AAPL | Stock | 229.75 | 229.9 | 229.75 | 229.8789 | 5244.0 |
| 2025-08-26 19:30:00 | AAPL | Stock | 229.85 | 229.99 | 229.8032 | 229.99 | 13572.0 |
| 2025-08-26 04:00:00 | MSFT | Stock | 504.0 | 504.74 | 504.0 | 504.7 | 1458.0 |
| 2025-08-26 04:30:00 | MSFT | Stock | 504.73 | 504.73 | 504.73 | 504.73 | 138.0 |
| 2025-08-26 05:00:00 | MSFT | Stock | 504.71 | 504.71 | 504.71 | 504.71 | 629.0 |
| 2025-08-26 05:30:00 | MSFT | Stock | 504.6 | 504.6 | 504.54 | 504.54 | 538.0 |
| 2025-08-26 06:00:00 | MSFT | Stock | 504.67 | 504.72 | 504.34 | 504.72 | 1083.0 |
| 2025-08-26 06:30:00 | MSFT | Stock | 504.53 | 504.64 | 504.45 | 504.45 | 425.0 |
| 2025-08-26 07:00:00 | MSFT | Stock | 504.5 | 504.5 | 503.41 | 503.5 | 2010.0 |
| 2025-08-26 07:30:00 | MSFT | Stock | 503.5 | 504.16 | 503.47 | 504.07 | 4286.0 |
| 2025-08-26 08:00:00 | MSFT | Stock | 504.3 | 504.9 | 503.41 | 504.3 | 12630.0 |
| 2025-08-26 08:30:00 | MSFT | Stock | 504.27 | 504.3563 | 503.98 | 503.98 | 1890.0 |
| 2025-08-26 09:00:00 | MSFT | Stock | 504.06 | 504.84 | 503.66 | 504.57 | 5985.0 |
| 2025-08-26 09:30:00 | MSFT | Stock | 504.355 | 504.9778 | 502.11 | 502.93 | 1030079.0 |
| 2025-08-26 10:00:00 | MSFT | Stock | 502.94 | 504.71 | 502.84 | 504.45 | 488038.0 |
| 2025-08-26 10:30:00 | MSFT | Stock | 504.42 | 504.445 | 502.72 | 502.76 | 393109.0 |
| 2025-08-26 11:00:00 | MSFT | Stock | 502.79 | 503.35 | 502.53 | 502.7 | 303525.0 |
| 2025-08-26 11:30:00 | MSFT | Stock | 502.66 | 502.71 | 502.1196 | 502.34 | 308255.0 |
| 2025-08-26 12:00:00 | MSFT | Stock | 502.34 | 502.8 | 502.09 | 502.29 | 361984.0 |
| 2025-08-26 12:30:00 | MSFT | Stock | 502.27 | 502.27 | 500.35 | 500.8475 | 689175.0 |
> showing 50 of 104,383 rows — these rows as CSV