PREVIEW / stock_30min / 2025-07-11
file: by_date/stock_30min/2025/2025-07-11.parquet size: 2.2 MB rows: 105,933 symbols: 375
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-07-11 04:00:00 | AAPL | Stock | 211.52 | 211.52 | 210.32 | 210.89 | 27386.0 |
| 2025-07-11 04:30:00 | AAPL | Stock | 210.92 | 210.99 | 210.84 | 210.93 | 5485.0 |
| 2025-07-11 05:00:00 | AAPL | Stock | 210.92 | 211.11 | 210.8 | 210.87 | 7398.0 |
| 2025-07-11 05:30:00 | AAPL | Stock | 210.87 | 211.01 | 210.35 | 210.41 | 11175.0 |
| 2025-07-11 06:00:00 | AAPL | Stock | 210.39 | 210.76 | 210.3 | 210.58 | 10788.0 |
| 2025-07-11 06:30:00 | AAPL | Stock | 210.53 | 210.67 | 210.39 | 210.56 | 6406.0 |
| 2025-07-11 07:00:00 | AAPL | Stock | 210.55 | 211.05 | 210.52 | 211.05 | 17041.0 |
| 2025-07-11 07:30:00 | AAPL | Stock | 211.03 | 211.24 | 211.03 | 211.1 | 12892.0 |
| 2025-07-11 08:00:00 | AAPL | Stock | 210.91 | 211.879 | 210.35 | 210.87 | 88910.0 |
| 2025-07-11 08:30:00 | AAPL | Stock | 210.94 | 211.0 | 210.78 | 210.88 | 14394.0 |
| 2025-07-11 09:00:00 | AAPL | Stock | 210.95 | 211.2867 | 210.4 | 210.43 | 86809.0 |
| 2025-07-11 09:30:00 | AAPL | Stock | 210.43 | 211.1274 | 209.86 | 210.99 | 4348702.0 |
| 2025-07-11 10:00:00 | AAPL | Stock | 210.985 | 212.13 | 210.88 | 211.79 | 2277684.0 |
| 2025-07-11 10:30:00 | AAPL | Stock | 211.79 | 211.79 | 210.8 | 210.96 | 1612140.0 |
| 2025-07-11 11:00:00 | AAPL | Stock | 210.95 | 211.15 | 210.48 | 210.825 | 1579088.0 |
| 2025-07-11 11:30:00 | AAPL | Stock | 210.83 | 211.21 | 210.4283 | 210.67 | 1645135.0 |
| 2025-07-11 12:00:00 | AAPL | Stock | 210.6799 | 211.059 | 210.59 | 210.625 | 1022516.0 |
| 2025-07-11 12:30:00 | AAPL | Stock | 210.62 | 211.078 | 210.45 | 211.0205 | 1181675.0 |
| 2025-07-11 13:00:00 | AAPL | Stock | 211.011 | 211.29 | 210.9 | 211.165 | 1028952.0 |
| 2025-07-11 13:30:00 | AAPL | Stock | 211.16 | 211.24 | 210.952 | 211.21 | 674644.0 |
| 2025-07-11 14:00:00 | AAPL | Stock | 211.2 | 211.66 | 211.185 | 211.405 | 1171249.0 |
| 2025-07-11 14:30:00 | AAPL | Stock | 211.41 | 211.517 | 211.03 | 211.135 | 692390.0 |
| 2025-07-11 15:00:00 | AAPL | Stock | 211.13 | 211.3 | 210.62 | 211.16 | 1077818.0 |
| 2025-07-11 15:30:00 | AAPL | Stock | 211.16 | 211.41 | 211.01 | 211.075 | 3257687.0 |
| 2025-07-11 16:00:00 | AAPL | Stock | 211.16 | 211.16 | 210.57 | 210.6 | 7447329.0 |
| 2025-07-11 16:30:00 | AAPL | Stock | 210.57 | 211.16 | 210.4 | 210.42 | 290017.0 |
| 2025-07-11 17:00:00 | AAPL | Stock | 210.49 | 210.58 | 210.4303 | 210.5301 | 16340.0 |
| 2025-07-11 17:30:00 | AAPL | Stock | 210.54 | 210.58 | 210.5 | 210.5 | 7508.0 |
| 2025-07-11 18:00:00 | AAPL | Stock | 210.51 | 210.55 | 210.45 | 210.52 | 6576.0 |
| 2025-07-11 18:30:00 | AAPL | Stock | 210.5861 | 210.6991 | 210.5 | 210.61 | 9773.0 |
| 2025-07-11 19:00:00 | AAPL | Stock | 210.6 | 210.63 | 210.52 | 210.55 | 8571.0 |
| 2025-07-11 19:30:00 | AAPL | Stock | 210.5601 | 210.59 | 210.5201 | 210.5201 | 11131.0 |
| 2025-07-11 04:00:00 | MSFT | Stock | 500.46 | 500.46 | 499.49 | 499.76 | 3092.0 |
| 2025-07-11 04:30:00 | MSFT | Stock | 499.66 | 500.2 | 499.66 | 500.17 | 1072.0 |
| 2025-07-11 05:00:00 | MSFT | Stock | 500.12 | 500.12 | 499.81 | 499.81 | 772.0 |
| 2025-07-11 05:30:00 | MSFT | Stock | 499.66 | 499.66 | 499.43 | 499.43 | 2167.0 |
| 2025-07-11 06:00:00 | MSFT | Stock | 499.5 | 499.62 | 499.27 | 499.6 | 885.0 |
| 2025-07-11 07:00:00 | MSFT | Stock | 499.0 | 499.689 | 498.92 | 499.65 | 1542.0 |
| 2025-07-11 07:30:00 | MSFT | Stock | 499.78 | 499.9 | 499.51 | 499.9 | 651.0 |
| 2025-07-11 08:00:00 | MSFT | Stock | 499.27 | 500.66 | 498.8857 | 499.1241 | 12083.0 |
| 2025-07-11 08:30:00 | MSFT | Stock | 499.37 | 499.8 | 499.1438 | 499.56 | 3631.0 |
| 2025-07-11 09:00:00 | MSFT | Stock | 499.51 | 499.66 | 498.0 | 498.0 | 16205.0 |
| 2025-07-11 09:30:00 | MSFT | Stock | 498.0 | 501.14 | 497.78 | 501.02 | 1153136.0 |
| 2025-07-11 10:00:00 | MSFT | Stock | 501.02 | 502.39 | 500.7822 | 501.5 | 588832.0 |
| 2025-07-11 10:30:00 | MSFT | Stock | 501.47 | 502.3 | 501.05 | 502.0 | 360750.0 |
| 2025-07-11 11:00:00 | MSFT | Stock | 502.0 | 502.94 | 501.65 | 502.79 | 523694.0 |
| 2025-07-11 11:30:00 | MSFT | Stock | 502.76 | 504.03 | 502.74 | 503.9 | 460028.0 |
| 2025-07-11 12:00:00 | MSFT | Stock | 503.9 | 505.03 | 503.735 | 504.66 | 483798.0 |
| 2025-07-11 12:30:00 | MSFT | Stock | 504.67 | 504.75 | 503.955 | 504.65 | 316782.0 |
| 2025-07-11 13:00:00 | MSFT | Stock | 504.65 | 504.93 | 504.35 | 504.56 | 270332.0 |
> showing 50 of 105,933 rows — these rows as CSV