PREVIEW / stock_30min / 2025-07-18
file: by_date/stock_30min/2025/2025-07-18.parquet size: 2.2 MB rows: 106,729 symbols: 370
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-07-18 04:00:00 | AAPL | Stock | 210.56 | 210.7 | 210.46 | 210.6 | 5925.0 |
| 2025-07-18 04:30:00 | AAPL | Stock | 210.57 | 210.6 | 210.55 | 210.55 | 3093.0 |
| 2025-07-18 05:00:00 | AAPL | Stock | 210.58 | 210.8 | 210.58 | 210.76 | 6433.0 |
| 2025-07-18 05:30:00 | AAPL | Stock | 210.76 | 210.76 | 210.66 | 210.7 | 6107.0 |
| 2025-07-18 06:00:00 | AAPL | Stock | 210.67 | 210.67 | 210.49 | 210.59 | 11875.0 |
| 2025-07-18 06:30:00 | AAPL | Stock | 210.5 | 210.5 | 210.35 | 210.4 | 8480.0 |
| 2025-07-18 07:00:00 | AAPL | Stock | 210.45 | 210.45 | 210.02 | 210.37 | 18046.0 |
| 2025-07-18 07:30:00 | AAPL | Stock | 210.41 | 210.44 | 210.3 | 210.35 | 2731.0 |
| 2025-07-18 08:00:00 | AAPL | Stock | 210.15 | 210.76 | 209.495 | 210.61 | 75448.0 |
| 2025-07-18 08:30:00 | AAPL | Stock | 210.56 | 210.66 | 210.46 | 210.5295 | 26090.0 |
| 2025-07-18 09:00:00 | AAPL | Stock | 210.5505 | 211.93 | 210.2 | 210.66 | 480459.0 |
| 2025-07-18 09:30:00 | AAPL | Stock | 210.66 | 211.01 | 209.89 | 210.32 | 7779556.0 |
| 2025-07-18 10:00:00 | AAPL | Stock | 210.38 | 210.62 | 209.7045 | 209.95 | 2184365.0 |
| 2025-07-18 10:30:00 | AAPL | Stock | 209.96 | 211.01 | 209.77 | 210.4701 | 2221115.0 |
| 2025-07-18 11:00:00 | AAPL | Stock | 210.511 | 211.0 | 210.42 | 210.85 | 1527725.0 |
| 2025-07-18 11:30:00 | AAPL | Stock | 210.855 | 211.1 | 210.69 | 211.075 | 1415387.0 |
| 2025-07-18 12:00:00 | AAPL | Stock | 211.0701 | 211.13 | 210.67 | 211.01 | 1268661.0 |
| 2025-07-18 12:30:00 | AAPL | Stock | 211.01 | 211.79 | 210.88 | 211.32 | 1832150.0 |
| 2025-07-18 13:00:00 | AAPL | Stock | 211.32 | 211.425 | 211.04 | 211.19 | 1069299.0 |
| 2025-07-18 13:30:00 | AAPL | Stock | 211.18 | 211.54 | 210.97 | 211.09 | 1205680.0 |
| 2025-07-18 14:00:00 | AAPL | Stock | 211.1 | 211.26 | 210.76 | 210.935 | 1075799.0 |
| 2025-07-18 14:30:00 | AAPL | Stock | 210.93 | 211.06 | 210.79 | 210.965 | 831173.0 |
| 2025-07-18 15:00:00 | AAPL | Stock | 210.96 | 211.195 | 210.87 | 210.95 | 1100552.0 |
| 2025-07-18 15:30:00 | AAPL | Stock | 210.94 | 211.35 | 209.94 | 211.22 | 3199884.0 |
| 2025-07-18 16:00:00 | AAPL | Stock | 211.23 | 211.23 | 210.76 | 211.03 | 6770570.0 |
| 2025-07-18 16:30:00 | AAPL | Stock | 211.011 | 211.18 | 211.01 | 211.0978 | 24272.0 |
| 2025-07-18 17:00:00 | AAPL | Stock | 211.01 | 211.26 | 211.01 | 211.11 | 49567.0 |
| 2025-07-18 17:30:00 | AAPL | Stock | 211.23 | 211.28 | 211.1201 | 211.1999 | 8678.0 |
| 2025-07-18 18:00:00 | AAPL | Stock | 211.2 | 211.2001 | 211.08 | 211.1 | 5197.0 |
| 2025-07-18 18:30:00 | AAPL | Stock | 211.13 | 211.13 | 211.05 | 211.07 | 5271.0 |
| 2025-07-18 19:00:00 | AAPL | Stock | 211.08 | 211.18 | 211.0519 | 211.18 | 7556.0 |
| 2025-07-18 19:30:00 | AAPL | Stock | 211.18 | 211.3 | 211.15 | 211.2 | 8274.0 |
| 2025-07-18 04:00:00 | MSFT | Stock | 512.86 | 512.86 | 512.0 | 512.47 | 1429.0 |
| 2025-07-18 04:30:00 | MSFT | Stock | 512.75 | 513.2 | 512.75 | 513.2 | 564.0 |
| 2025-07-18 05:00:00 | MSFT | Stock | 513.5 | 513.5 | 513.4 | 513.4 | 280.0 |
| 2025-07-18 05:30:00 | MSFT | Stock | 513.25 | 513.32 | 513.21 | 513.32 | 300.0 |
| 2025-07-18 06:00:00 | MSFT | Stock | 513.32 | 513.32 | 512.84 | 512.86 | 1896.0 |
| 2025-07-18 06:30:00 | MSFT | Stock | 513.32 | 513.32 | 513.19 | 513.19 | 843.0 |
| 2025-07-18 07:00:00 | MSFT | Stock | 513.11 | 513.36 | 512.78 | 512.8 | 2690.0 |
| 2025-07-18 07:30:00 | MSFT | Stock | 512.89 | 513.0 | 512.7 | 512.7 | 1335.0 |
| 2025-07-18 08:00:00 | MSFT | Stock | 513.0 | 513.5 | 510.421 | 512.5 | 10201.0 |
| 2025-07-18 08:30:00 | MSFT | Stock | 512.44 | 512.69 | 512.44 | 512.56 | 2121.0 |
| 2025-07-18 09:00:00 | MSFT | Stock | 512.58 | 518.07 | 511.8978 | 514.15 | 213291.0 |
| 2025-07-18 09:30:00 | MSFT | Stock | 514.28 | 514.64 | 510.74 | 511.4 | 2761436.0 |
| 2025-07-18 10:00:00 | MSFT | Stock | 511.49 | 512.29 | 510.33 | 510.535 | 744321.0 |
| 2025-07-18 10:30:00 | MSFT | Stock | 510.53 | 511.45 | 510.3 | 510.5068 | 899199.0 |
| 2025-07-18 11:00:00 | MSFT | Stock | 510.43 | 510.5199 | 509.527 | 510.35 | 432391.0 |
| 2025-07-18 11:30:00 | MSFT | Stock | 510.38 | 510.79 | 509.51 | 509.66 | 471319.0 |
| 2025-07-18 12:00:00 | MSFT | Stock | 509.66 | 509.67 | 508.33 | 508.765 | 544850.0 |
| 2025-07-18 12:30:00 | MSFT | Stock | 508.73 | 509.89 | 508.38 | 509.8312 | 371606.0 |
> showing 50 of 106,729 rows — these rows as CSV