PREVIEW / stock_30min / 2025-07-09
file: by_date/stock_30min/2025/2025-07-09.parquet size: 2.2 MB rows: 105,511 symbols: 379
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-09 04:00:00 | AAPL | Stock | 210.05 | 210.15 | 209.9 | 209.9 | 1948.0 |
| 2025-07-09 04:30:00 | AAPL | Stock | 210.05 | 210.05 | 210.01 | 210.01 | 200.0 |
| 2025-07-09 05:00:00 | AAPL | Stock | 210.17 | 210.46 | 210.17 | 210.36 | 3116.0 |
| 2025-07-09 05:30:00 | AAPL | Stock | 210.49 | 210.68 | 210.24 | 210.24 | 2922.0 |
| 2025-07-09 06:00:00 | AAPL | Stock | 210.25 | 210.3 | 210.2 | 210.24 | 1421.0 |
| 2025-07-09 06:30:00 | AAPL | Stock | 210.3 | 210.3 | 209.87 | 209.91 | 9867.0 |
| 2025-07-09 07:00:00 | AAPL | Stock | 209.91 | 210.01 | 209.87 | 209.93 | 7085.0 |
| 2025-07-09 07:30:00 | AAPL | Stock | 210.0 | 210.2 | 209.82 | 209.9 | 19688.0 |
| 2025-07-09 08:00:00 | AAPL | Stock | 209.94 | 210.61 | 209.8027 | 210.04 | 58959.0 |
| 2025-07-09 08:30:00 | AAPL | Stock | 209.95 | 210.24 | 208.95 | 209.3 | 119114.0 |
| 2025-07-09 09:00:00 | AAPL | Stock | 209.31 | 209.96 | 209.0 | 209.55 | 136548.0 |
| 2025-07-09 09:30:00 | AAPL | Stock | 209.53 | 210.9 | 209.35 | 209.86 | 4348592.0 |
| 2025-07-09 10:00:00 | AAPL | Stock | 209.88 | 210.495 | 209.585 | 209.91 | 2355501.0 |
| 2025-07-09 10:30:00 | AAPL | Stock | 209.91 | 209.91 | 207.45 | 207.6481 | 3412206.0 |
| 2025-07-09 11:00:00 | AAPL | Stock | 207.64 | 207.95 | 207.22 | 207.81 | 3096938.0 |
| 2025-07-09 11:30:00 | AAPL | Stock | 207.81 | 207.9707 | 207.2659 | 207.73 | 1908655.0 |
| 2025-07-09 12:00:00 | AAPL | Stock | 207.739 | 208.22 | 207.539 | 207.81 | 1718574.0 |
| 2025-07-09 12:30:00 | AAPL | Stock | 207.8104 | 208.4401 | 207.5714 | 208.21 | 1327564.0 |
| 2025-07-09 13:00:00 | AAPL | Stock | 208.21 | 209.045 | 207.97 | 208.9156 | 1640939.0 |
| 2025-07-09 13:30:00 | AAPL | Stock | 208.915 | 209.3796 | 208.72 | 209.24 | 1412742.0 |
| 2025-07-09 14:00:00 | AAPL | Stock | 209.21 | 209.98 | 209.15 | 209.7325 | 1672668.0 |
| 2025-07-09 14:30:00 | AAPL | Stock | 209.74 | 210.06 | 209.62 | 209.9361 | 1306223.0 |
| 2025-07-09 15:00:00 | AAPL | Stock | 209.94 | 210.19 | 209.6401 | 209.89 | 1525984.0 |
| 2025-07-09 15:30:00 | AAPL | Stock | 209.88 | 211.33 | 209.73 | 211.1 | 4914496.0 |
| 2025-07-09 16:00:00 | AAPL | Stock | 211.09 | 211.21 | 209.6317 | 210.71 | 8059570.0 |
| 2025-07-09 16:30:00 | AAPL | Stock | 210.72 | 210.81 | 210.5588 | 210.7552 | 16517.0 |
| 2025-07-09 17:00:00 | AAPL | Stock | 210.78 | 210.8 | 210.61 | 210.6685 | 17875.0 |
| 2025-07-09 17:30:00 | AAPL | Stock | 210.66 | 210.89 | 210.6001 | 210.8 | 11386.0 |
| 2025-07-09 18:00:00 | AAPL | Stock | 210.71 | 210.88 | 210.7 | 210.88 | 20611.0 |
| 2025-07-09 18:30:00 | AAPL | Stock | 210.88 | 210.89 | 210.71 | 210.8 | 12963.0 |
| 2025-07-09 19:00:00 | AAPL | Stock | 210.75 | 210.87 | 210.726 | 210.8283 | 10635.0 |
| 2025-07-09 19:30:00 | AAPL | Stock | 210.7814 | 210.87 | 210.71 | 210.72 | 14295.0 |
| 2025-07-09 04:00:00 | MSFT | Stock | 496.21 | 496.27 | 496.0 | 496.02 | 900.0 |
| 2025-07-09 04:30:00 | MSFT | Stock | 496.23 | 496.23 | 496.23 | 496.23 | 137.0 |
| 2025-07-09 05:00:00 | MSFT | Stock | 496.8 | 496.8 | 496.8 | 496.8 | 119.0 |
| 2025-07-09 05:30:00 | MSFT | Stock | 497.4 | 497.55 | 497.4 | 497.55 | 600.0 |
| 2025-07-09 06:30:00 | MSFT | Stock | 497.43 | 503.0 | 497.43 | 501.49 | 38899.0 |
| 2025-07-09 07:00:00 | MSFT | Stock | 501.31 | 501.31 | 500.51 | 500.73 | 13258.0 |
| 2025-07-09 07:30:00 | MSFT | Stock | 500.75 | 500.92 | 500.34 | 500.92 | 3066.0 |
| 2025-07-09 08:00:00 | MSFT | Stock | 500.85 | 501.4875 | 495.17 | 500.1 | 18584.0 |
| 2025-07-09 08:30:00 | MSFT | Stock | 500.2 | 500.8 | 499.35 | 499.9512 | 17909.0 |
| 2025-07-09 09:00:00 | MSFT | Stock | 499.6 | 500.75 | 498.75 | 500.42 | 51665.0 |
| 2025-07-09 09:30:00 | MSFT | Stock | 500.42 | 505.745 | 500.08 | 505.54 | 2447038.0 |
| 2025-07-09 10:00:00 | MSFT | Stock | 505.53 | 506.78 | 503.57 | 504.56 | 1460514.0 |
| 2025-07-09 10:30:00 | MSFT | Stock | 504.56 | 504.61 | 501.5625 | 502.03 | 709408.0 |
| 2025-07-09 11:00:00 | MSFT | Stock | 502.01 | 502.245 | 500.45 | 501.53 | 601597.0 |
| 2025-07-09 11:30:00 | MSFT | Stock | 501.49 | 501.62 | 500.0 | 500.03 | 482895.0 |
| 2025-07-09 12:00:00 | MSFT | Stock | 500.01 | 501.12 | 499.74 | 501.09 | 528640.0 |
| 2025-07-09 12:30:00 | MSFT | Stock | 501.08 | 501.28 | 500.445 | 500.5 | 287030.0 |
| 2025-07-09 13:00:00 | MSFT | Stock | 500.51 | 501.6699 | 500.0 | 501.47 | 466590.0 |
> showing 50 of 105,511 rows — these rows as CSV