PREVIEW / stock_30min / 2025-07-08
file: by_date/stock_30min/2025/2025-07-08.parquet size: 2.2 MB rows: 105,549 symbols: 373
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-08 04:00:00 | AAPL | Stock | 210.35 | 210.49 | 209.9 | 210.29 | 12252.0 |
| 2025-07-08 04:30:00 | AAPL | Stock | 210.25 | 210.45 | 210.16 | 210.44 | 10436.0 |
| 2025-07-08 05:00:00 | AAPL | Stock | 210.44 | 210.44 | 210.15 | 210.15 | 4119.0 |
| 2025-07-08 05:30:00 | AAPL | Stock | 210.17 | 210.24 | 210.03 | 210.03 | 4744.0 |
| 2025-07-08 06:00:00 | AAPL | Stock | 210.03 | 210.03 | 209.63 | 209.72 | 5740.0 |
| 2025-07-08 06:30:00 | AAPL | Stock | 209.76 | 210.03 | 209.76 | 209.85 | 5510.0 |
| 2025-07-08 07:00:00 | AAPL | Stock | 209.95 | 210.1 | 209.8 | 210.08 | 8027.0 |
| 2025-07-08 07:30:00 | AAPL | Stock | 210.05 | 210.13 | 210.0 | 210.05 | 8705.0 |
| 2025-07-08 08:00:00 | AAPL | Stock | 210.07 | 210.6 | 209.64 | 210.35 | 124851.0 |
| 2025-07-08 08:30:00 | AAPL | Stock | 210.2799 | 210.317 | 210.0 | 210.1988 | 26263.0 |
| 2025-07-08 09:00:00 | AAPL | Stock | 210.2 | 210.4299 | 210.0 | 210.0 | 98608.0 |
| 2025-07-08 09:30:00 | AAPL | Stock | 210.1 | 210.49 | 208.48 | 208.66 | 4490060.0 |
| 2025-07-08 10:00:00 | AAPL | Stock | 208.645 | 209.68 | 208.45 | 209.28 | 2339447.0 |
| 2025-07-08 10:30:00 | AAPL | Stock | 209.285 | 210.83 | 209.26 | 210.725 | 2369582.0 |
| 2025-07-08 11:00:00 | AAPL | Stock | 210.73 | 211.43 | 209.78 | 209.8707 | 2196076.0 |
| 2025-07-08 11:30:00 | AAPL | Stock | 209.88 | 210.65 | 209.78 | 210.55 | 1659108.0 |
| 2025-07-08 12:00:00 | AAPL | Stock | 210.56 | 211.185 | 210.46 | 210.83 | 1241972.0 |
| 2025-07-08 12:30:00 | AAPL | Stock | 210.84 | 210.89 | 210.2603 | 210.38 | 1350270.0 |
| 2025-07-08 13:00:00 | AAPL | Stock | 210.37 | 210.435 | 209.5 | 209.84 | 1542694.0 |
| 2025-07-08 13:30:00 | AAPL | Stock | 209.84 | 209.935 | 209.32 | 209.85 | 1084787.0 |
| 2025-07-08 14:00:00 | AAPL | Stock | 209.81 | 210.26 | 209.72 | 209.95 | 973632.0 |
| 2025-07-08 14:30:00 | AAPL | Stock | 209.95 | 210.05 | 209.56 | 209.7 | 817089.0 |
| 2025-07-08 15:00:00 | AAPL | Stock | 209.7 | 209.73 | 209.405 | 209.605 | 1056539.0 |
| 2025-07-08 15:30:00 | AAPL | Stock | 209.6 | 210.81 | 209.3 | 210.035 | 3508341.0 |
| 2025-07-08 16:00:00 | AAPL | Stock | 210.01 | 210.2 | 209.94 | 210.14 | 5753258.0 |
| 2025-07-08 16:30:00 | AAPL | Stock | 210.09 | 210.09 | 208.8 | 210.04 | 74202.0 |
| 2025-07-08 17:00:00 | AAPL | Stock | 209.8964 | 210.06 | 209.82 | 210.05 | 15750.0 |
| 2025-07-08 17:30:00 | AAPL | Stock | 210.06 | 210.09 | 209.86 | 210.0 | 5406.0 |
| 2025-07-08 18:00:00 | AAPL | Stock | 209.9725 | 210.09 | 209.9725 | 210.07 | 5077.0 |
| 2025-07-08 18:30:00 | AAPL | Stock | 210.02 | 210.15 | 210.01 | 210.15 | 6634.0 |
| 2025-07-08 19:00:00 | AAPL | Stock | 210.14 | 210.26 | 210.02 | 210.1517 | 10213.0 |
| 2025-07-08 19:30:00 | AAPL | Stock | 210.15 | 210.2917 | 210.15 | 210.1606 | 17465.0 |
| 2025-07-08 04:00:00 | MSFT | Stock | 498.8 | 498.8 | 498.4 | 498.4 | 1266.0 |
| 2025-07-08 04:30:00 | MSFT | Stock | 498.05 | 498.05 | 498.05 | 498.05 | 149.0 |
| 2025-07-08 05:00:00 | MSFT | Stock | 497.9 | 498.02 | 497.9 | 498.02 | 714.0 |
| 2025-07-08 05:30:00 | MSFT | Stock | 497.68 | 497.68 | 497.68 | 497.68 | 200.0 |
| 2025-07-08 06:00:00 | MSFT | Stock | 497.25 | 497.25 | 497.25 | 497.25 | 500.0 |
| 2025-07-08 07:00:00 | MSFT | Stock | 497.76 | 497.88 | 497.58 | 497.88 | 885.0 |
| 2025-07-08 07:30:00 | MSFT | Stock | 497.99 | 498.15 | 497.99 | 498.15 | 747.0 |
| 2025-07-08 08:00:00 | MSFT | Stock | 497.9 | 499.0 | 496.476 | 498.0 | 5842.0 |
| 2025-07-08 08:30:00 | MSFT | Stock | 497.66 | 497.9 | 497.63 | 497.631 | 5794.0 |
| 2025-07-08 09:00:00 | MSFT | Stock | 498.12 | 498.3 | 496.84 | 497.4 | 7319.0 |
| 2025-07-08 09:30:00 | MSFT | Stock | 497.24 | 498.2 | 496.36 | 496.47 | 847174.0 |
| 2025-07-08 10:00:00 | MSFT | Stock | 496.55 | 497.03 | 495.56 | 495.95 | 403399.0 |
| 2025-07-08 10:30:00 | MSFT | Stock | 495.945 | 497.14 | 494.54 | 495.14 | 406824.0 |
| 2025-07-08 11:00:00 | MSFT | Stock | 495.16 | 496.0 | 494.11 | 494.875 | 534077.0 |
| 2025-07-08 11:30:00 | MSFT | Stock | 494.84 | 495.43 | 494.5401 | 495.29 | 244077.0 |
| 2025-07-08 12:00:00 | MSFT | Stock | 495.295 | 496.25 | 495.105 | 496.0009 | 179283.0 |
| 2025-07-08 12:30:00 | MSFT | Stock | 496.0001 | 496.07 | 494.69 | 495.6 | 225344.0 |
| 2025-07-08 13:00:00 | MSFT | Stock | 495.5701 | 495.96 | 495.18 | 495.86 | 203896.0 |
> showing 50 of 105,549 rows — these rows as CSV