PREVIEW / stock_30min / 2025-10-22
file: by_date/stock_30min/2025/2025-10-22.parquet size: 2.3 MB rows: 110,470 symbols: 225
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-10-22 04:00:00 | AAPL | Stock | 262.68 | 262.68 | 262.12 | 262.12 | 1972.0 |
| 2025-10-22 04:30:00 | AAPL | Stock | 262.23 | 262.35 | 262.13 | 262.17 | 3671.0 |
| 2025-10-22 05:00:00 | AAPL | Stock | 262.1 | 262.15 | 261.65 | 261.71 | 17102.0 |
| 2025-10-22 05:30:00 | AAPL | Stock | 261.65 | 261.65 | 259.8 | 261.19 | 39864.0 |
| 2025-10-22 06:00:00 | AAPL | Stock | 261.19 | 261.19 | 260.6 | 260.75 | 11857.0 |
| 2025-10-22 06:30:00 | AAPL | Stock | 260.79 | 261.49 | 260.75 | 261.3 | 18503.0 |
| 2025-10-22 07:00:00 | AAPL | Stock | 261.25 | 261.76 | 260.99 | 261.4 | 26456.0 |
| 2025-10-22 07:30:00 | AAPL | Stock | 261.31 | 261.31 | 260.7 | 260.9 | 27204.0 |
| 2025-10-22 08:00:00 | AAPL | Stock | 262.45 | 263.4 | 259.95 | 261.62 | 124605.0 |
| 2025-10-22 08:30:00 | AAPL | Stock | 261.5 | 261.6 | 261.0 | 261.3296 | 30165.0 |
| 2025-10-22 09:00:00 | AAPL | Stock | 261.28 | 262.74 | 261.1 | 262.69 | 102584.0 |
| 2025-10-22 09:30:00 | AAPL | Stock | 262.61 | 262.85 | 259.93 | 260.4 | 3981339.0 |
| 2025-10-22 10:00:00 | AAPL | Stock | 260.4125 | 261.37 | 259.72 | 260.0499 | 2460830.0 |
| 2025-10-22 10:30:00 | AAPL | Stock | 260.0 | 261.14 | 259.745 | 260.74 | 1760500.0 |
| 2025-10-22 11:00:00 | AAPL | Stock | 260.75 | 260.76 | 257.6401 | 258.44 | 2721750.0 |
| 2025-10-22 11:30:00 | AAPL | Stock | 258.45 | 259.49 | 258.08 | 259.305 | 1699568.0 |
| 2025-10-22 12:00:00 | AAPL | Stock | 259.305 | 259.41 | 258.05 | 258.55 | 1083735.0 |
| 2025-10-22 12:30:00 | AAPL | Stock | 258.55 | 258.79 | 256.375 | 257.67 | 2145024.0 |
| 2025-10-22 13:00:00 | AAPL | Stock | 257.68 | 257.8204 | 256.3 | 256.6914 | 1256191.0 |
| 2025-10-22 13:30:00 | AAPL | Stock | 256.67 | 256.7871 | 255.43 | 256.33 | 2042534.0 |
| 2025-10-22 14:00:00 | AAPL | Stock | 256.31 | 257.0798 | 256.2201 | 256.551 | 1060692.0 |
| 2025-10-22 14:30:00 | AAPL | Stock | 256.55 | 257.019 | 256.14 | 256.97 | 925018.0 |
| 2025-10-22 15:00:00 | AAPL | Stock | 256.96 | 257.68 | 256.5 | 257.51 | 1214327.0 |
| 2025-10-22 15:30:00 | AAPL | Stock | 257.52 | 258.81 | 257.43 | 258.43 | 3092598.0 |
| 2025-10-22 16:00:00 | AAPL | Stock | 258.4 | 258.96 | 258.0 | 258.3066 | 6771421.0 |
| 2025-10-22 16:30:00 | AAPL | Stock | 258.39 | 258.65 | 258.39 | 258.6436 | 23577.0 |
| 2025-10-22 17:00:00 | AAPL | Stock | 258.55 | 258.63 | 258.45 | 258.56 | 62206.0 |
| 2025-10-22 17:30:00 | AAPL | Stock | 258.64 | 258.64 | 258.46 | 258.62 | 7295.0 |
| 2025-10-22 18:00:00 | AAPL | Stock | 258.6 | 259.55 | 258.6 | 259.45 | 26628.0 |
| 2025-10-22 18:30:00 | AAPL | Stock | 259.32 | 259.44 | 259.0 | 259.07 | 10311.0 |
| 2025-10-22 19:00:00 | AAPL | Stock | 259.31 | 259.5592 | 259.07 | 259.07 | 10329.0 |
| 2025-10-22 19:30:00 | AAPL | Stock | 259.19 | 259.25 | 258.8237 | 258.89 | 10487.0 |
| 2025-10-22 04:30:00 | MSFT | Stock | 517.66 | 517.66 | 517.39 | 517.39 | 239.0 |
| 2025-10-22 05:00:00 | MSFT | Stock | 517.39 | 517.39 | 517.39 | 517.39 | 100.0 |
| 2025-10-22 06:00:00 | MSFT | Stock | 517.77 | 519.67 | 517.77 | 519.23 | 6613.0 |
| 2025-10-22 06:30:00 | MSFT | Stock | 519.03 | 519.03 | 518.65 | 518.75 | 2792.0 |
| 2025-10-22 07:00:00 | MSFT | Stock | 518.65 | 518.75 | 518.3 | 518.75 | 3218.0 |
| 2025-10-22 07:30:00 | MSFT | Stock | 519.0 | 519.0 | 518.32 | 518.99 | 5410.0 |
| 2025-10-22 08:00:00 | MSFT | Stock | 519.0 | 519.65 | 517.08 | 519.45 | 21009.0 |
| 2025-10-22 08:30:00 | MSFT | Stock | 519.222 | 520.05 | 519.222 | 519.75 | 12969.0 |
| 2025-10-22 09:00:00 | MSFT | Stock | 519.65 | 521.65 | 519.3 | 519.65 | 33330.0 |
| 2025-10-22 09:30:00 | MSFT | Stock | 521.15 | 523.54 | 519.07 | 522.44 | 1468675.0 |
| 2025-10-22 10:00:00 | MSFT | Stock | 522.4 | 524.21 | 521.8 | 523.465 | 914577.0 |
| 2025-10-22 10:30:00 | MSFT | Stock | 523.51 | 524.91 | 521.2 | 524.91 | 963114.0 |
| 2025-10-22 11:00:00 | MSFT | Stock | 524.91 | 525.23 | 522.02 | 522.75 | 802008.0 |
| 2025-10-22 11:30:00 | MSFT | Stock | 522.692 | 523.87 | 522.49 | 523.65 | 498357.0 |
| 2025-10-22 12:00:00 | MSFT | Stock | 523.6145 | 524.17 | 522.08 | 523.005 | 474029.0 |
| 2025-10-22 12:30:00 | MSFT | Stock | 523.06 | 523.47 | 520.9866 | 522.91 | 806121.0 |
| 2025-10-22 13:00:00 | MSFT | Stock | 522.89 | 523.1 | 520.1 | 520.5546 | 320140.0 |
| 2025-10-22 13:30:00 | MSFT | Stock | 520.45 | 520.46 | 517.71 | 518.805 | 383406.0 |
> showing 50 of 110,470 rows — these rows as CSV