PREVIEW / stock_30min / 2025-10-28
file: by_date/stock_30min/2025/2025-10-28.parquet size: 2.3 MB rows: 109,390 symbols: 222
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-28 04:00:00 | AAPL | Stock | 268.51 | 268.76 | 268.42 | 268.6 | 8038.0 |
| 2025-10-28 04:30:00 | AAPL | Stock | 268.58 | 268.58 | 268.36 | 268.36 | 807.0 |
| 2025-10-28 05:00:00 | AAPL | Stock | 268.51 | 268.68 | 268.33 | 268.54 | 5654.0 |
| 2025-10-28 05:30:00 | AAPL | Stock | 268.56 | 268.56 | 268.39 | 268.41 | 2206.0 |
| 2025-10-28 06:00:00 | AAPL | Stock | 268.26 | 268.42 | 268.2 | 268.34 | 3243.0 |
| 2025-10-28 06:30:00 | AAPL | Stock | 268.32 | 268.37 | 268.13 | 268.3 | 5160.0 |
| 2025-10-28 07:00:00 | AAPL | Stock | 268.28 | 268.66 | 268.24 | 268.49 | 12215.0 |
| 2025-10-28 07:30:00 | AAPL | Stock | 268.47 | 268.73 | 268.3 | 268.57 | 15458.0 |
| 2025-10-28 08:00:00 | AAPL | Stock | 268.69 | 268.85 | 268.05 | 268.51 | 76652.0 |
| 2025-10-28 08:30:00 | AAPL | Stock | 268.64 | 268.64 | 268.2 | 268.4201 | 36649.0 |
| 2025-10-28 09:00:00 | AAPL | Stock | 268.43 | 269.12 | 267.82 | 268.95 | 188324.0 |
| 2025-10-28 09:30:00 | AAPL | Stock | 269.01 | 269.87 | 268.26 | 268.99 | 6003505.0 |
| 2025-10-28 10:00:00 | AAPL | Stock | 268.98 | 269.06 | 268.25 | 268.65 | 2255062.0 |
| 2025-10-28 10:30:00 | AAPL | Stock | 268.6423 | 269.14 | 268.15 | 268.82 | 1574659.0 |
| 2025-10-28 11:00:00 | AAPL | Stock | 268.87 | 269.07 | 268.31 | 268.6972 | 1162782.0 |
| 2025-10-28 11:30:00 | AAPL | Stock | 268.695 | 269.0758 | 268.35 | 268.91 | 1205668.0 |
| 2025-10-28 12:00:00 | AAPL | Stock | 268.9119 | 269.06 | 268.66 | 268.995 | 865830.0 |
| 2025-10-28 12:30:00 | AAPL | Stock | 268.98 | 269.89 | 268.81 | 269.59 | 1498369.0 |
| 2025-10-28 13:00:00 | AAPL | Stock | 269.6 | 269.74 | 268.94 | 269.495 | 1179430.0 |
| 2025-10-28 13:30:00 | AAPL | Stock | 269.495 | 269.495 | 268.8 | 268.92 | 1103105.0 |
| 2025-10-28 14:00:00 | AAPL | Stock | 268.9034 | 269.3 | 268.865 | 269.1 | 1154302.0 |
| 2025-10-28 14:30:00 | AAPL | Stock | 269.105 | 269.235 | 268.78 | 269.115 | 1236371.0 |
| 2025-10-28 15:00:00 | AAPL | Stock | 269.115 | 269.44 | 268.92 | 269.2 | 1809067.0 |
| 2025-10-28 15:30:00 | AAPL | Stock | 269.2 | 269.355 | 268.6 | 269.03 | 4234463.0 |
| 2025-10-28 16:00:00 | AAPL | Stock | 269.04 | 269.04 | 268.8 | 268.8 | 5054789.0 |
| 2025-10-28 16:30:00 | AAPL | Stock | 268.8 | 269.39 | 268.6 | 268.6143 | 34945.0 |
| 2025-10-28 17:00:00 | AAPL | Stock | 268.77 | 269.0 | 268.61 | 268.61 | 19814.0 |
| 2025-10-28 17:30:00 | AAPL | Stock | 268.65 | 268.7 | 268.61 | 268.6844 | 11778.0 |
| 2025-10-28 18:00:00 | AAPL | Stock | 268.61 | 268.6856 | 268.4 | 268.43 | 11231.0 |
| 2025-10-28 18:30:00 | AAPL | Stock | 268.44 | 268.5125 | 268.36 | 268.4 | 12909.0 |
| 2025-10-28 19:00:00 | AAPL | Stock | 268.4 | 269.0 | 268.36 | 268.36 | 23420.0 |
| 2025-10-28 19:30:00 | AAPL | Stock | 268.3717 | 268.61 | 268.35 | 268.35 | 11712.0 |
| 2025-10-28 04:00:00 | MSFT | Stock | 533.23 | 533.36 | 532.06 | 532.06 | 2130.0 |
| 2025-10-28 04:30:00 | MSFT | Stock | 532.42 | 532.48 | 532.31 | 532.48 | 1304.0 |
| 2025-10-28 05:00:00 | MSFT | Stock | 532.02 | 532.3 | 531.85 | 532.3 | 926.0 |
| 2025-10-28 05:30:00 | MSFT | Stock | 532.42 | 532.88 | 532.29 | 532.88 | 1102.0 |
| 2025-10-28 06:00:00 | MSFT | Stock | 532.76 | 533.06 | 532.67 | 533.0 | 1217.0 |
| 2025-10-28 06:30:00 | MSFT | Stock | 532.64 | 532.64 | 532.64 | 532.64 | 100.0 |
| 2025-10-28 07:00:00 | MSFT | Stock | 532.91 | 533.0 | 532.65 | 532.68 | 5763.0 |
| 2025-10-28 07:30:00 | MSFT | Stock | 532.62 | 532.96 | 532.55 | 532.6 | 4045.0 |
| 2025-10-28 08:00:00 | MSFT | Stock | 533.0 | 533.5 | 532.0 | 533.13 | 40018.0 |
| 2025-10-28 08:30:00 | MSFT | Stock | 533.0 | 533.9 | 532.88 | 533.75 | 9793.0 |
| 2025-10-28 09:00:00 | MSFT | Stock | 533.78 | 557.5 | 533.78 | 550.6 | 1249756.0 |
| 2025-10-28 09:30:00 | MSFT | Stock | 550.0 | 553.72 | 542.46 | 546.32 | 4392646.0 |
| 2025-10-28 10:00:00 | MSFT | Stock | 546.335 | 547.5899 | 544.29 | 545.61 | 1275507.0 |
| 2025-10-28 10:30:00 | MSFT | Stock | 545.6017 | 545.99 | 542.18 | 542.47 | 1128614.0 |
| 2025-10-28 11:00:00 | MSFT | Stock | 542.45 | 544.85 | 542.39 | 543.391 | 711675.0 |
| 2025-10-28 11:30:00 | MSFT | Stock | 543.37 | 544.54 | 540.77 | 541.3051 | 917580.0 |
| 2025-10-28 12:00:00 | MSFT | Stock | 541.3151 | 542.8 | 541.08 | 542.54 | 794982.0 |
| 2025-10-28 12:30:00 | MSFT | Stock | 542.7 | 543.514 | 541.8 | 542.5312 | 643924.0 |
> showing 50 of 109,390 rows — these rows as CSV