PREVIEW / stock_30min / 2025-01-28
file: by_date/stock_30min/2025/2025-01-28.parquet size: 2.2 MB rows: 105,910 symbols: 569
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-01-28 04:00:00 | AAPL | Stock | 230.23 | 230.74 | 229.08 | 229.22 | 22191.0 |
| 2025-01-28 04:30:00 | AAPL | Stock | 229.23 | 229.3 | 228.52 | 229.27 | 21884.0 |
| 2025-01-28 05:00:00 | AAPL | Stock | 229.31 | 230.56 | 229.0 | 230.45 | 28513.0 |
| 2025-01-28 05:30:00 | AAPL | Stock | 230.44 | 231.78 | 230.14 | 231.67 | 102377.0 |
| 2025-01-28 06:00:00 | AAPL | Stock | 231.69 | 231.84 | 231.15 | 231.18 | 28518.0 |
| 2025-01-28 06:30:00 | AAPL | Stock | 231.26 | 231.38 | 230.54 | 230.93 | 17509.0 |
| 2025-01-28 07:00:00 | AAPL | Stock | 231.05 | 231.05 | 229.53 | 229.99 | 65844.0 |
| 2025-01-28 07:30:00 | AAPL | Stock | 230.04 | 230.79 | 229.82 | 230.66 | 40657.0 |
| 2025-01-28 08:00:00 | AAPL | Stock | 230.25 | 231.0 | 229.0768 | 230.39 | 165413.0 |
| 2025-01-28 08:30:00 | AAPL | Stock | 230.37 | 230.8 | 229.8 | 230.3 | 58280.0 |
| 2025-01-28 09:00:00 | AAPL | Stock | 230.32 | 230.95 | 230.12 | 230.91 | 92078.0 |
| 2025-01-28 09:30:00 | AAPL | Stock | 230.84 | 235.59 | 230.81 | 234.69 | 9980573.0 |
| 2025-01-28 10:00:00 | AAPL | Stock | 234.67 | 237.79 | 234.38 | 237.62 | 5598040.0 |
| 2025-01-28 10:30:00 | AAPL | Stock | 237.65 | 239.25 | 237.63 | 238.84 | 5803054.0 |
| 2025-01-28 11:00:00 | AAPL | Stock | 238.84 | 239.45 | 238.17 | 239.08 | 3929678.0 |
| 2025-01-28 11:30:00 | AAPL | Stock | 239.06 | 240.19 | 239.04 | 239.72 | 3884659.0 |
| 2025-01-28 12:00:00 | AAPL | Stock | 239.705 | 240.17 | 238.16 | 238.55 | 2684724.0 |
| 2025-01-28 12:30:00 | AAPL | Stock | 238.55 | 238.93 | 238.235 | 238.73 | 1514982.0 |
| 2025-01-28 13:00:00 | AAPL | Stock | 238.71 | 239.25 | 238.47 | 238.7442 | 1361699.0 |
| 2025-01-28 13:30:00 | AAPL | Stock | 238.76 | 239.06 | 238.6 | 238.81 | 1058564.0 |
| 2025-01-28 14:00:00 | AAPL | Stock | 238.81 | 239.1 | 238.59 | 238.82 | 1306004.0 |
| 2025-01-28 14:30:00 | AAPL | Stock | 238.8222 | 239.48 | 238.79 | 239.165 | 1476622.0 |
| 2025-01-28 15:00:00 | AAPL | Stock | 239.155 | 239.25 | 238.31 | 238.84 | 2151594.0 |
| 2025-01-28 15:30:00 | AAPL | Stock | 238.88 | 238.98 | 237.76 | 238.24 | 3789960.0 |
| 2025-01-28 16:00:00 | AAPL | Stock | 238.24 | 238.97 | 238.11 | 238.29 | 11433375.0 |
| 2025-01-28 16:30:00 | AAPL | Stock | 238.27 | 238.28 | 238.11 | 238.15 | 47568.0 |
| 2025-01-28 17:00:00 | AAPL | Stock | 238.16 | 238.16 | 237.5 | 237.5 | 60389.0 |
| 2025-01-28 17:30:00 | AAPL | Stock | 237.6 | 237.77 | 237.25 | 237.5 | 54650.0 |
| 2025-01-28 18:00:00 | AAPL | Stock | 237.41 | 237.77 | 237.366 | 237.77 | 7697.0 |
| 2025-01-28 18:30:00 | AAPL | Stock | 237.65 | 237.77 | 237.55 | 237.6 | 6149.0 |
| 2025-01-28 19:00:00 | AAPL | Stock | 237.69 | 237.9498 | 237.63 | 237.8605 | 13653.0 |
| 2025-01-28 19:30:00 | AAPL | Stock | 237.86 | 238.35 | 237.83 | 238.35 | 30106.0 |
| 2025-01-28 04:00:00 | MSFT | Stock | 437.31 | 437.7 | 436.43 | 436.7 | 11583.0 |
| 2025-01-28 04:30:00 | MSFT | Stock | 436.58 | 437.87 | 436.47 | 437.87 | 3704.0 |
| 2025-01-28 05:00:00 | MSFT | Stock | 437.85 | 438.2 | 437.85 | 438.17 | 4969.0 |
| 2025-01-28 05:30:00 | MSFT | Stock | 438.05 | 438.12 | 437.5 | 437.5 | 4577.0 |
| 2025-01-28 06:00:00 | MSFT | Stock | 437.38 | 437.56 | 436.5 | 436.5 | 3397.0 |
| 2025-01-28 06:30:00 | MSFT | Stock | 436.2 | 436.2 | 435.2 | 436.0 | 5967.0 |
| 2025-01-28 07:00:00 | MSFT | Stock | 436.0 | 437.0 | 434.47 | 435.27 | 12612.0 |
| 2025-01-28 07:30:00 | MSFT | Stock | 435.2 | 435.4 | 434.8 | 435.3 | 3450.0 |
| 2025-01-28 08:00:00 | MSFT | Stock | 436.26 | 441.5 | 433.87 | 436.41 | 44915.0 |
| 2025-01-28 08:30:00 | MSFT | Stock | 436.2 | 436.2 | 434.56 | 435.8001 | 19971.0 |
| 2025-01-28 09:00:00 | MSFT | Stock | 435.8 | 435.996 | 433.01 | 433.28 | 19837.0 |
| 2025-01-28 09:30:00 | MSFT | Stock | 434.6 | 436.3381 | 431.38 | 435.27 | 1968803.0 |
| 2025-01-28 10:00:00 | MSFT | Stock | 435.165 | 443.01 | 434.53 | 442.265 | 1333324.0 |
| 2025-01-28 10:30:00 | MSFT | Stock | 442.33 | 442.72 | 439.88 | 441.56 | 940033.0 |
| 2025-01-28 11:00:00 | MSFT | Stock | 441.545 | 443.18 | 440.41 | 442.0 | 662168.0 |
| 2025-01-28 11:30:00 | MSFT | Stock | 442.0 | 443.39 | 441.5 | 443.05 | 503302.0 |
| 2025-01-28 12:00:00 | MSFT | Stock | 443.2 | 444.7 | 442.48 | 444.59 | 491518.0 |
| 2025-01-28 12:30:00 | MSFT | Stock | 444.55 | 445.3 | 444.175 | 445.0458 | 571414.0 |
> showing 50 of 105,910 rows — these rows as CSV