PREVIEW / stock_30min / 2025-01-22
file: by_date/stock_30min/2025/2025-01-22.parquet size: 2.3 MB rows: 108,840 symbols: 580
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-22 04:00:00 | AAPL | Stock | 222.7 | 222.72 | 222.17 | 222.72 | 26720.0 |
| 2025-01-22 04:30:00 | AAPL | Stock | 222.68 | 222.68 | 221.91 | 222.2 | 34749.0 |
| 2025-01-22 05:00:00 | AAPL | Stock | 222.09 | 222.48 | 222.09 | 222.48 | 11482.0 |
| 2025-01-22 05:30:00 | AAPL | Stock | 222.48 | 222.78 | 222.44 | 222.78 | 12833.0 |
| 2025-01-22 06:00:00 | AAPL | Stock | 222.66 | 223.0 | 222.5 | 222.52 | 24583.0 |
| 2025-01-22 06:30:00 | AAPL | Stock | 222.52 | 222.76 | 222.45 | 222.46 | 12986.0 |
| 2025-01-22 07:00:00 | AAPL | Stock | 222.47 | 222.59 | 221.83 | 222.07 | 31803.0 |
| 2025-01-22 07:30:00 | AAPL | Stock | 222.06 | 222.25 | 222.0 | 222.0 | 25447.0 |
| 2025-01-22 08:00:00 | AAPL | Stock | 222.43 | 222.82 | 221.82 | 221.8797 | 148330.0 |
| 2025-01-22 08:30:00 | AAPL | Stock | 221.861 | 221.94 | 220.85 | 221.15 | 167015.0 |
| 2025-01-22 09:00:00 | AAPL | Stock | 221.21 | 221.84 | 219.05 | 219.75 | 478313.0 |
| 2025-01-22 09:30:00 | AAPL | Stock | 219.75 | 223.28 | 219.75 | 222.95 | 8770436.0 |
| 2025-01-22 10:00:00 | AAPL | Stock | 222.96 | 223.3528 | 221.52 | 221.631 | 3309343.0 |
| 2025-01-22 10:30:00 | AAPL | Stock | 221.635 | 222.97 | 221.55 | 222.935 | 2802139.0 |
| 2025-01-22 11:00:00 | AAPL | Stock | 222.94 | 223.08 | 222.47 | 222.855 | 2445675.0 |
| 2025-01-22 11:30:00 | AAPL | Stock | 222.8579 | 222.928 | 221.7 | 221.935 | 2112116.0 |
| 2025-01-22 12:00:00 | AAPL | Stock | 221.945 | 222.59 | 221.8 | 222.565 | 1976659.0 |
| 2025-01-22 12:30:00 | AAPL | Stock | 222.565 | 222.8299 | 222.35 | 222.7299 | 1443628.0 |
| 2025-01-22 13:00:00 | AAPL | Stock | 222.73 | 222.85 | 222.015 | 222.1157 | 1505120.0 |
| 2025-01-22 13:30:00 | AAPL | Stock | 222.12 | 222.7 | 221.91 | 222.43 | 1402694.0 |
| 2025-01-22 14:00:00 | AAPL | Stock | 222.4299 | 222.865 | 222.35 | 222.746 | 1200449.0 |
| 2025-01-22 14:30:00 | AAPL | Stock | 222.745 | 223.4 | 222.42 | 223.3889 | 1840630.0 |
| 2025-01-22 15:00:00 | AAPL | Stock | 223.38 | 223.6 | 222.82 | 223.35 | 2085299.0 |
| 2025-01-22 15:30:00 | AAPL | Stock | 223.365 | 224.12 | 223.06 | 223.77 | 4042277.0 |
| 2025-01-22 16:00:00 | AAPL | Stock | 223.76 | 223.99 | 223.3495 | 223.44 | 9096354.0 |
| 2025-01-22 16:30:00 | AAPL | Stock | 223.44 | 223.83 | 223.4 | 223.5002 | 81885.0 |
| 2025-01-22 17:00:00 | AAPL | Stock | 223.51 | 223.59 | 223.2 | 223.22 | 43913.0 |
| 2025-01-22 17:30:00 | AAPL | Stock | 223.27 | 223.3995 | 223.22 | 223.35 | 11616.0 |
| 2025-01-22 18:00:00 | AAPL | Stock | 223.3999 | 223.5 | 223.3437 | 223.43 | 22596.0 |
| 2025-01-22 18:30:00 | AAPL | Stock | 223.37 | 223.45 | 223.3 | 223.3607 | 23315.0 |
| 2025-01-22 19:00:00 | AAPL | Stock | 223.4 | 223.45 | 223.24 | 223.3 | 15598.0 |
| 2025-01-22 19:30:00 | AAPL | Stock | 223.32 | 223.35 | 223.1245 | 223.18 | 22285.0 |
| 2025-01-22 04:00:00 | MSFT | Stock | 435.65 | 435.7 | 434.77 | 435.1 | 12778.0 |
| 2025-01-22 04:30:00 | MSFT | Stock | 435.1 | 435.65 | 434.88 | 435.6 | 7506.0 |
| 2025-01-22 05:00:00 | MSFT | Stock | 435.55 | 435.65 | 435.2 | 435.31 | 7812.0 |
| 2025-01-22 05:30:00 | MSFT | Stock | 435.2 | 435.24 | 434.7 | 434.73 | 2091.0 |
| 2025-01-22 06:00:00 | MSFT | Stock | 434.89 | 434.98 | 433.4 | 433.9 | 11590.0 |
| 2025-01-22 06:30:00 | MSFT | Stock | 434.0 | 434.0 | 433.12 | 433.34 | 2551.0 |
| 2025-01-22 07:00:00 | MSFT | Stock | 433.23 | 434.5 | 432.78 | 434.3 | 13746.0 |
| 2025-01-22 07:30:00 | MSFT | Stock | 434.34 | 434.75 | 433.59 | 434.7 | 13348.0 |
| 2025-01-22 08:00:00 | MSFT | Stock | 433.96 | 436.29 | 432.9 | 436.05 | 62688.0 |
| 2025-01-22 08:30:00 | MSFT | Stock | 436.01 | 438.0 | 428.5 | 437.23 | 59314.0 |
| 2025-01-22 09:00:00 | MSFT | Stock | 437.3 | 438.0 | 436.49 | 437.6 | 66375.0 |
| 2025-01-22 09:30:00 | MSFT | Stock | 437.56 | 441.9 | 436.0 | 441.285 | 3248400.0 |
| 2025-01-22 10:00:00 | MSFT | Stock | 441.285 | 441.9 | 439.17 | 439.76 | 1111293.0 |
| 2025-01-22 10:30:00 | MSFT | Stock | 439.765 | 443.3 | 439.68 | 441.2 | 1191297.0 |
| 2025-01-22 11:00:00 | MSFT | Stock | 441.29 | 442.59 | 440.51 | 442.58 | 721133.0 |
| 2025-01-22 11:30:00 | MSFT | Stock | 442.58 | 444.44 | 442.32 | 444.33 | 791470.0 |
| 2025-01-22 12:00:00 | MSFT | Stock | 444.34 | 445.96 | 444.27 | 444.76 | 775440.0 |
| 2025-01-22 12:30:00 | MSFT | Stock | 444.74 | 445.79 | 444.66 | 445.3229 | 435215.0 |
> showing 50 of 108,840 rows — these rows as CSV