PREVIEW / stock_30min / 2025-03-06
file: by_date/stock_30min/2025/2025-03-06.parquet size: 2.2 MB rows: 104,324 symbols: 507
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-03-06 04:00:00 | AAPL | Stock | 234.88 | 235.4 | 234.08 | 234.5 | 10052.0 |
| 2025-03-06 04:30:00 | AAPL | Stock | 234.61 | 234.75 | 234.42 | 234.51 | 3093.0 |
| 2025-03-06 05:00:00 | AAPL | Stock | 234.44 | 234.7 | 234.24 | 234.7 | 5338.0 |
| 2025-03-06 05:30:00 | AAPL | Stock | 234.52 | 234.56 | 234.25 | 234.25 | 5041.0 |
| 2025-03-06 06:00:00 | AAPL | Stock | 234.24 | 234.5 | 234.15 | 234.43 | 11907.0 |
| 2025-03-06 06:30:00 | AAPL | Stock | 234.23 | 234.41 | 234.08 | 234.37 | 2657.0 |
| 2025-03-06 07:00:00 | AAPL | Stock | 234.34 | 234.74 | 234.25 | 234.74 | 9402.0 |
| 2025-03-06 07:30:00 | AAPL | Stock | 234.74 | 234.75 | 233.94 | 234.23 | 10556.0 |
| 2025-03-06 08:00:00 | AAPL | Stock | 234.46 | 236.07 | 233.28 | 233.6899 | 56095.0 |
| 2025-03-06 08:30:00 | AAPL | Stock | 233.69 | 234.11 | 233.5303 | 233.99 | 21279.0 |
| 2025-03-06 09:00:00 | AAPL | Stock | 233.7935 | 234.5 | 233.4 | 234.5 | 59729.0 |
| 2025-03-06 09:30:00 | AAPL | Stock | 234.435 | 236.46 | 233.54 | 235.375 | 4441787.0 |
| 2025-03-06 10:00:00 | AAPL | Stock | 235.31 | 237.17 | 234.9359 | 236.47 | 2347652.0 |
| 2025-03-06 10:30:00 | AAPL | Stock | 236.47 | 237.86 | 236.23 | 236.95 | 1733393.0 |
| 2025-03-06 11:00:00 | AAPL | Stock | 236.98 | 237.72 | 236.24 | 236.76 | 1505557.0 |
| 2025-03-06 11:30:00 | AAPL | Stock | 236.75 | 237.34 | 234.8201 | 234.935 | 1495359.0 |
| 2025-03-06 12:00:00 | AAPL | Stock | 234.95 | 235.28 | 234.04 | 234.4 | 1831416.0 |
| 2025-03-06 12:30:00 | AAPL | Stock | 234.4 | 235.31 | 234.06 | 235.04 | 1469735.0 |
| 2025-03-06 13:00:00 | AAPL | Stock | 235.03 | 235.43 | 234.21 | 234.295 | 1411159.0 |
| 2025-03-06 13:30:00 | AAPL | Stock | 234.305 | 235.17 | 233.96 | 234.28 | 1568469.0 |
| 2025-03-06 14:00:00 | AAPL | Stock | 234.29 | 234.45 | 233.4 | 233.65 | 1721662.0 |
| 2025-03-06 14:30:00 | AAPL | Stock | 233.64 | 236.01 | 233.33 | 234.41 | 2066679.0 |
| 2025-03-06 15:00:00 | AAPL | Stock | 234.43 | 235.52 | 234.19 | 235.18 | 1516005.0 |
| 2025-03-06 15:30:00 | AAPL | Stock | 235.17 | 235.76 | 234.45 | 235.32 | 3300569.0 |
| 2025-03-06 16:00:00 | AAPL | Stock | 235.33 | 235.78 | 234.81 | 235.45 | 7849761.0 |
| 2025-03-06 16:30:00 | AAPL | Stock | 235.45 | 235.45 | 235.1501 | 235.333 | 55817.0 |
| 2025-03-06 17:00:00 | AAPL | Stock | 235.33 | 235.45 | 234.3826 | 234.63 | 45769.0 |
| 2025-03-06 17:30:00 | AAPL | Stock | 234.79 | 234.79 | 234.5 | 234.75 | 5306.0 |
| 2025-03-06 18:00:00 | AAPL | Stock | 234.68 | 234.87 | 234.68 | 234.7532 | 5588.0 |
| 2025-03-06 18:30:00 | AAPL | Stock | 234.88 | 234.88 | 234.75 | 234.77 | 8673.0 |
| 2025-03-06 19:00:00 | AAPL | Stock | 234.78 | 235.33 | 234.62 | 234.62 | 8619.0 |
| 2025-03-06 19:30:00 | AAPL | Stock | 234.86 | 234.98 | 234.7 | 234.98 | 9599.0 |
| 2025-03-06 04:00:00 | MSFT | Stock | 397.18 | 398.65 | 396.65 | 396.65 | 7701.0 |
| 2025-03-06 04:30:00 | MSFT | Stock | 396.5 | 398.0 | 396.05 | 397.51 | 3740.0 |
| 2025-03-06 05:00:00 | MSFT | Stock | 397.26 | 398.5 | 397.0 | 398.3 | 3937.0 |
| 2025-03-06 05:30:00 | MSFT | Stock | 398.09 | 398.09 | 395.84 | 395.99 | 7322.0 |
| 2025-03-06 06:00:00 | MSFT | Stock | 395.5 | 395.88 | 394.64 | 395.2 | 15297.0 |
| 2025-03-06 06:30:00 | MSFT | Stock | 395.02 | 395.78 | 394.5 | 395.63 | 8027.0 |
| 2025-03-06 07:00:00 | MSFT | Stock | 395.7 | 396.29 | 395.69 | 395.89 | 6298.0 |
| 2025-03-06 07:30:00 | MSFT | Stock | 395.99 | 396.54 | 395.8 | 396.16 | 6405.0 |
| 2025-03-06 08:00:00 | MSFT | Stock | 396.0 | 400.26 | 394.41 | 394.9999 | 28638.0 |
| 2025-03-06 08:30:00 | MSFT | Stock | 394.99 | 396.0475 | 394.99 | 395.2 | 16076.0 |
| 2025-03-06 09:00:00 | MSFT | Stock | 395.0 | 396.4 | 393.18 | 393.89 | 38670.0 |
| 2025-03-06 09:30:00 | MSFT | Stock | 394.04 | 398.115 | 393.29 | 397.265 | 1937176.0 |
| 2025-03-06 10:00:00 | MSFT | Stock | 397.235 | 402.15 | 396.86 | 401.23 | 1207856.0 |
| 2025-03-06 10:30:00 | MSFT | Stock | 401.22 | 402.04 | 399.46 | 400.3 | 718674.0 |
| 2025-03-06 11:00:00 | MSFT | Stock | 400.3365 | 401.91 | 398.78 | 399.87 | 719587.0 |
| 2025-03-06 11:30:00 | MSFT | Stock | 399.885 | 400.8999 | 396.61 | 396.68 | 590087.0 |
| 2025-03-06 12:00:00 | MSFT | Stock | 396.665 | 397.12 | 395.11 | 395.6428 | 605092.0 |
| 2025-03-06 12:30:00 | MSFT | Stock | 395.69 | 397.86 | 395.3 | 397.465 | 482087.0 |
> showing 50 of 104,324 rows — these rows as CSV