PREVIEW / stock_30min / 2025-11-03
file: by_date/stock_30min/2025/2025-11-03.parquet size: 2.3 MB rows: 112,049 symbols: 217
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-11-03 04:00:00 | AAPL | Stock | 270.0 | 271.2 | 270.0 | 271.04 | 14000.0 |
| 2025-11-03 04:30:00 | AAPL | Stock | 271.21 | 271.21 | 270.7 | 270.78 | 1906.0 |
| 2025-11-03 05:00:00 | AAPL | Stock | 270.81 | 271.15 | 270.5 | 270.8 | 11751.0 |
| 2025-11-03 05:30:00 | AAPL | Stock | 270.98 | 271.39 | 270.86 | 270.86 | 3637.0 |
| 2025-11-03 06:00:00 | AAPL | Stock | 270.85 | 271.43 | 270.5 | 271.01 | 14293.0 |
| 2025-11-03 06:30:00 | AAPL | Stock | 270.94 | 270.94 | 270.6 | 270.75 | 3325.0 |
| 2025-11-03 07:00:00 | AAPL | Stock | 270.74 | 271.0 | 270.39 | 270.39 | 12892.0 |
| 2025-11-03 07:30:00 | AAPL | Stock | 270.37 | 270.47 | 270.05 | 270.25 | 8607.0 |
| 2025-11-03 08:00:00 | AAPL | Stock | 270.5 | 271.29 | 269.52 | 269.52 | 104393.0 |
| 2025-11-03 08:30:00 | AAPL | Stock | 269.6 | 270.1067 | 269.6 | 270.02 | 48244.0 |
| 2025-11-03 09:00:00 | AAPL | Stock | 270.0 | 270.48 | 269.05 | 270.48 | 114796.0 |
| 2025-11-03 09:30:00 | AAPL | Stock | 270.48 | 270.85 | 266.355 | 267.275 | 5273541.0 |
| 2025-11-03 10:00:00 | AAPL | Stock | 267.37 | 268.7 | 266.25 | 267.63 | 2836089.0 |
| 2025-11-03 10:30:00 | AAPL | Stock | 267.64 | 268.28 | 267.26 | 267.5499 | 1416553.0 |
| 2025-11-03 11:00:00 | AAPL | Stock | 267.55 | 267.6 | 266.5 | 266.64 | 1525090.0 |
| 2025-11-03 11:30:00 | AAPL | Stock | 266.6599 | 268.0 | 266.5223 | 267.84 | 1183660.0 |
| 2025-11-03 12:00:00 | AAPL | Stock | 267.85 | 268.15 | 267.3601 | 267.535 | 1248989.0 |
| 2025-11-03 12:30:00 | AAPL | Stock | 267.52 | 267.87 | 267.28 | 267.423 | 816884.0 |
| 2025-11-03 13:00:00 | AAPL | Stock | 267.45 | 268.0 | 267.25 | 267.678 | 1068046.0 |
| 2025-11-03 13:30:00 | AAPL | Stock | 267.7099 | 268.62 | 267.68 | 268.13 | 852089.0 |
| 2025-11-03 14:00:00 | AAPL | Stock | 268.14 | 268.31 | 267.31 | 267.32 | 1184506.0 |
| 2025-11-03 14:30:00 | AAPL | Stock | 267.32 | 267.53 | 266.91 | 267.195 | 833699.0 |
| 2025-11-03 15:00:00 | AAPL | Stock | 267.2 | 267.79 | 266.9522 | 267.62 | 1274295.0 |
| 2025-11-03 15:30:00 | AAPL | Stock | 267.63 | 269.12 | 267.46 | 269.06 | 3341096.0 |
| 2025-11-03 16:00:00 | AAPL | Stock | 269.05 | 269.22 | 268.31 | 268.6 | 8085260.0 |
| 2025-11-03 16:30:00 | AAPL | Stock | 268.61 | 269.05 | 268.42 | 268.66 | 23158.0 |
| 2025-11-03 17:00:00 | AAPL | Stock | 268.49 | 268.51 | 268.4201 | 268.4201 | 6442.0 |
| 2025-11-03 17:30:00 | AAPL | Stock | 268.42 | 269.0 | 268.36 | 268.75 | 16174.0 |
| 2025-11-03 18:00:00 | AAPL | Stock | 268.61 | 269.05 | 268.3441 | 268.4817 | 9309.0 |
| 2025-11-03 18:30:00 | AAPL | Stock | 268.3608 | 268.4199 | 268.15 | 268.15 | 6260.0 |
| 2025-11-03 19:00:00 | AAPL | Stock | 268.2 | 268.35 | 267.38 | 267.95 | 18059.0 |
| 2025-11-03 19:30:00 | AAPL | Stock | 267.61 | 268.2 | 267.55 | 268.2 | 8671.0 |
| 2025-11-03 04:00:00 | MSFT | Stock | 518.3 | 520.88 | 518.02 | 518.4 | 12051.0 |
| 2025-11-03 04:30:00 | MSFT | Stock | 518.5 | 518.63 | 518.33 | 518.55 | 7056.0 |
| 2025-11-03 05:00:00 | MSFT | Stock | 518.69 | 519.2 | 518.3 | 519.2 | 1836.0 |
| 2025-11-03 05:30:00 | MSFT | Stock | 519.0 | 519.22 | 518.76 | 518.76 | 3364.0 |
| 2025-11-03 06:00:00 | MSFT | Stock | 518.97 | 519.65 | 518.93 | 519.24 | 9485.0 |
| 2025-11-03 06:30:00 | MSFT | Stock | 519.26 | 519.26 | 518.64 | 518.68 | 4207.0 |
| 2025-11-03 07:00:00 | MSFT | Stock | 518.68 | 520.65 | 518.4 | 520.15 | 35584.0 |
| 2025-11-03 07:30:00 | MSFT | Stock | 520.15 | 523.0 | 520.14 | 521.5 | 41803.0 |
| 2025-11-03 08:00:00 | MSFT | Stock | 519.04 | 522.9 | 517.28 | 521.1 | 82647.0 |
| 2025-11-03 08:30:00 | MSFT | Stock | 521.374 | 522.0 | 520.7 | 521.04 | 27464.0 |
| 2025-11-03 09:00:00 | MSFT | Stock | 520.79 | 521.09 | 512.9 | 519.89 | 276579.0 |
| 2025-11-03 09:30:00 | MSFT | Stock | 519.92 | 524.96 | 519.69 | 522.35 | 2704211.0 |
| 2025-11-03 10:00:00 | MSFT | Stock | 522.46 | 522.88 | 519.31 | 519.46 | 1307175.0 |
| 2025-11-03 10:30:00 | MSFT | Stock | 519.41 | 520.41 | 518.7011 | 519.9709 | 725058.0 |
| 2025-11-03 11:00:00 | MSFT | Stock | 519.96 | 520.0389 | 518.39 | 518.67 | 662298.0 |
| 2025-11-03 11:30:00 | MSFT | Stock | 518.65 | 519.599 | 517.77 | 519.23 | 629169.0 |
| 2025-11-03 12:00:00 | MSFT | Stock | 519.26 | 520.44 | 518.52 | 518.64 | 602570.0 |
| 2025-11-03 12:30:00 | MSFT | Stock | 518.6401 | 519.8 | 518.3601 | 518.4 | 522696.0 |
> showing 50 of 112,049 rows — these rows as CSV