PREVIEW / stock_30min / 2025-10-01
file: by_date/stock_30min/2025/2025-10-01.parquet size: 2.3 MB rows: 109,609 symbols: 292
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-01 04:00:00 | AAPL | Stock | 253.38 | 253.38 | 251.51 | 251.85 | 10777.0 |
| 2025-10-01 04:30:00 | AAPL | Stock | 252.0 | 252.52 | 252.0 | 252.52 | 2862.0 |
| 2025-10-01 05:00:00 | AAPL | Stock | 252.47 | 253.03 | 252.41 | 253.03 | 12142.0 |
| 2025-10-01 05:30:00 | AAPL | Stock | 253.0 | 253.06 | 252.79 | 253.01 | 2561.0 |
| 2025-10-01 06:00:00 | AAPL | Stock | 253.13 | 253.93 | 253.13 | 253.73 | 10553.0 |
| 2025-10-01 06:30:00 | AAPL | Stock | 253.58 | 253.68 | 253.24 | 253.5 | 3569.0 |
| 2025-10-01 07:00:00 | AAPL | Stock | 253.46 | 253.82 | 253.4 | 253.8 | 11030.0 |
| 2025-10-01 07:30:00 | AAPL | Stock | 253.8 | 254.12 | 253.8 | 253.97 | 11152.0 |
| 2025-10-01 08:00:00 | AAPL | Stock | 253.53 | 254.63 | 251.11 | 254.03 | 83453.0 |
| 2025-10-01 08:30:00 | AAPL | Stock | 254.06 | 255.8999 | 253.84 | 255.19 | 117068.0 |
| 2025-10-01 09:00:00 | AAPL | Stock | 255.1 | 255.41 | 254.32 | 255.05 | 121396.0 |
| 2025-10-01 09:30:00 | AAPL | Stock | 255.04 | 258.79 | 254.93 | 256.505 | 7685997.0 |
| 2025-10-01 10:00:00 | AAPL | Stock | 256.515 | 257.33 | 255.435 | 256.1614 | 2959615.0 |
| 2025-10-01 10:30:00 | AAPL | Stock | 256.18 | 256.259 | 255.4 | 255.53 | 1785481.0 |
| 2025-10-01 11:00:00 | AAPL | Stock | 255.53 | 255.64 | 255.1 | 255.5245 | 1653299.0 |
| 2025-10-01 11:30:00 | AAPL | Stock | 255.5301 | 256.12 | 255.51 | 256.11 | 1213810.0 |
| 2025-10-01 12:00:00 | AAPL | Stock | 256.1 | 256.93 | 255.9376 | 256.16 | 1352732.0 |
| 2025-10-01 12:30:00 | AAPL | Stock | 256.1636 | 256.63 | 256.0287 | 256.4532 | 1048543.0 |
| 2025-10-01 13:00:00 | AAPL | Stock | 256.46 | 256.8298 | 255.855 | 256.1404 | 990900.0 |
| 2025-10-01 13:30:00 | AAPL | Stock | 256.165 | 256.56 | 256.06 | 256.4561 | 789695.0 |
| 2025-10-01 14:00:00 | AAPL | Stock | 256.4512 | 256.6859 | 256.4 | 256.485 | 849940.0 |
| 2025-10-01 14:30:00 | AAPL | Stock | 256.48 | 256.75 | 256.235 | 256.74 | 777317.0 |
| 2025-10-01 15:00:00 | AAPL | Stock | 256.73 | 256.94 | 255.87 | 255.94 | 1251390.0 |
| 2025-10-01 15:30:00 | AAPL | Stock | 255.94 | 256.14 | 255.28 | 255.41 | 3206202.0 |
| 2025-10-01 16:00:00 | AAPL | Stock | 255.45 | 256.1134 | 255.1312 | 255.3601 | 11498092.0 |
| 2025-10-01 16:30:00 | AAPL | Stock | 255.4 | 255.54 | 255.2604 | 255.4 | 42474.0 |
| 2025-10-01 17:00:00 | AAPL | Stock | 255.38 | 255.5 | 255.26 | 255.3225 | 10320.0 |
| 2025-10-01 17:30:00 | AAPL | Stock | 255.31 | 255.48 | 255.3019 | 255.4 | 1975.0 |
| 2025-10-01 18:00:00 | AAPL | Stock | 255.4 | 255.48 | 255.3195 | 255.4 | 6299.0 |
| 2025-10-01 18:30:00 | AAPL | Stock | 255.45 | 255.45 | 255.33 | 255.34 | 14620.0 |
| 2025-10-01 19:00:00 | AAPL | Stock | 255.35 | 255.4 | 255.3 | 255.31 | 9008.0 |
| 2025-10-01 19:30:00 | AAPL | Stock | 255.3 | 255.3 | 255.2201 | 255.28 | 10346.0 |
| 2025-10-01 04:00:00 | MSFT | Stock | 512.95 | 513.5 | 512.0 | 512.7 | 2855.0 |
| 2025-10-01 04:30:00 | MSFT | Stock | 513.26 | 513.59 | 513.26 | 513.5 | 1041.0 |
| 2025-10-01 05:00:00 | MSFT | Stock | 513.5 | 513.65 | 513.5 | 513.6 | 2047.0 |
| 2025-10-01 05:30:00 | MSFT | Stock | 513.83 | 513.88 | 513.83 | 513.88 | 218.0 |
| 2025-10-01 06:00:00 | MSFT | Stock | 513.8 | 514.06 | 513.65 | 513.65 | 4224.0 |
| 2025-10-01 06:30:00 | MSFT | Stock | 513.44 | 513.69 | 513.25 | 513.69 | 1359.0 |
| 2025-10-01 07:00:00 | MSFT | Stock | 513.5 | 514.4 | 513.38 | 514.24 | 5692.0 |
| 2025-10-01 07:30:00 | MSFT | Stock | 514.27 | 514.5 | 514.0 | 514.15 | 3937.0 |
| 2025-10-01 08:00:00 | MSFT | Stock | 513.5 | 517.95 | 512.15 | 514.22 | 43044.0 |
| 2025-10-01 08:30:00 | MSFT | Stock | 514.41 | 514.6999 | 514.0022 | 514.15 | 10962.0 |
| 2025-10-01 09:00:00 | MSFT | Stock | 514.4 | 515.73 | 514.4 | 514.8 | 10622.0 |
| 2025-10-01 09:30:00 | MSFT | Stock | 514.8 | 517.25 | 512.1001 | 512.63 | 1758674.0 |
| 2025-10-01 10:00:00 | MSFT | Stock | 512.67 | 514.17 | 511.69 | 512.59 | 728383.0 |
| 2025-10-01 10:30:00 | MSFT | Stock | 512.66 | 514.25 | 512.29 | 514.22 | 528190.0 |
| 2025-10-01 11:00:00 | MSFT | Stock | 514.25 | 515.4 | 513.36 | 514.55 | 566731.0 |
| 2025-10-01 11:30:00 | MSFT | Stock | 514.58 | 515.21 | 513.65 | 513.905 | 312991.0 |
| 2025-10-01 12:00:00 | MSFT | Stock | 513.91 | 516.12 | 513.81 | 516.11 | 521639.0 |
| 2025-10-01 12:30:00 | MSFT | Stock | 516.105 | 517.06 | 515.63 | 517.005 | 400000.0 |
> showing 50 of 109,609 rows — these rows as CSV