PREVIEW / stock_30min / 2025-09-09
file: by_date/stock_30min/2025/2025-09-09.parquet size: 2.3 MB rows: 110,035 symbols: 312
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-09-09 04:00:00 | AAPL | Stock | 237.87 | 238.08 | 237.53 | 237.65 | 7355.0 |
| 2025-09-09 04:30:00 | AAPL | Stock | 237.52 | 237.52 | 237.1 | 237.14 | 3851.0 |
| 2025-09-09 05:00:00 | AAPL | Stock | 237.15 | 237.3 | 237.09 | 237.09 | 2495.0 |
| 2025-09-09 05:30:00 | AAPL | Stock | 237.17 | 237.23 | 236.65 | 236.96 | 37366.0 |
| 2025-09-09 06:00:00 | AAPL | Stock | 236.95 | 237.07 | 236.94 | 237.0 | 7862.0 |
| 2025-09-09 06:30:00 | AAPL | Stock | 237.0 | 237.05 | 236.95 | 237.05 | 2727.0 |
| 2025-09-09 07:00:00 | AAPL | Stock | 237.15 | 237.15 | 236.89 | 236.95 | 8920.0 |
| 2025-09-09 07:30:00 | AAPL | Stock | 236.91 | 237.3 | 236.89 | 237.3 | 6612.0 |
| 2025-09-09 08:00:00 | AAPL | Stock | 237.02 | 238.35 | 236.69 | 237.7994 | 90979.0 |
| 2025-09-09 08:30:00 | AAPL | Stock | 237.74 | 237.7999 | 237.41 | 237.73 | 26442.0 |
| 2025-09-09 09:00:00 | AAPL | Stock | 237.64 | 237.71 | 236.63 | 237.06 | 72561.0 |
| 2025-09-09 09:30:00 | AAPL | Stock | 237.0 | 238.0 | 236.22 | 236.8 | 3734389.0 |
| 2025-09-09 10:00:00 | AAPL | Stock | 236.83 | 236.91 | 236.075 | 236.3101 | 2080359.0 |
| 2025-09-09 10:30:00 | AAPL | Stock | 236.31 | 236.6785 | 235.78 | 236.545 | 1747497.0 |
| 2025-09-09 11:00:00 | AAPL | Stock | 236.545 | 236.69 | 235.935 | 236.235 | 1224055.0 |
| 2025-09-09 11:30:00 | AAPL | Stock | 236.23 | 236.26 | 235.55 | 235.68 | 1356245.0 |
| 2025-09-09 12:00:00 | AAPL | Stock | 235.68 | 236.24 | 235.56 | 236.0 | 1595840.0 |
| 2025-09-09 12:30:00 | AAPL | Stock | 236.0 | 236.67 | 235.825 | 236.6196 | 1352444.0 |
| 2025-09-09 13:00:00 | AAPL | Stock | 236.62 | 238.7805 | 236.615 | 237.75 | 6607393.0 |
| 2025-09-09 13:30:00 | AAPL | Stock | 237.76 | 238.1 | 236.32 | 236.53 | 4978115.0 |
| 2025-09-09 14:00:00 | AAPL | Stock | 236.54 | 236.7899 | 233.66 | 234.5286 | 7899660.0 |
| 2025-09-09 14:30:00 | AAPL | Stock | 234.535 | 234.7 | 233.36 | 233.7399 | 4540171.0 |
| 2025-09-09 15:00:00 | AAPL | Stock | 233.74 | 234.49 | 233.56 | 234.31 | 3293375.0 |
| 2025-09-09 15:30:00 | AAPL | Stock | 234.31 | 234.635 | 233.515 | 234.35 | 4882719.0 |
| 2025-09-09 16:00:00 | AAPL | Stock | 234.34 | 234.4 | 233.76 | 233.83 | 5024679.0 |
| 2025-09-09 16:30:00 | AAPL | Stock | 233.83 | 234.35 | 233.0 | 233.18 | 119384.0 |
| 2025-09-09 17:00:00 | AAPL | Stock | 233.2016 | 233.3 | 233.01 | 233.04 | 55064.0 |
| 2025-09-09 17:30:00 | AAPL | Stock | 233.03 | 233.23 | 233.01 | 233.16 | 79329.0 |
| 2025-09-09 18:00:00 | AAPL | Stock | 233.15 | 233.6317 | 233.04 | 233.5275 | 50788.0 |
| 2025-09-09 18:30:00 | AAPL | Stock | 233.55 | 233.86 | 233.55 | 233.6 | 31575.0 |
| 2025-09-09 19:00:00 | AAPL | Stock | 233.57 | 233.75 | 233.335 | 233.6 | 30541.0 |
| 2025-09-09 19:30:00 | AAPL | Stock | 233.55 | 233.5992 | 233.5 | 233.54 | 39866.0 |
| 2025-09-09 04:00:00 | MSFT | Stock | 500.4 | 500.6 | 500.4 | 500.6 | 2152.0 |
| 2025-09-09 04:30:00 | MSFT | Stock | 500.79 | 500.79 | 500.0 | 500.0 | 1455.0 |
| 2025-09-09 05:00:00 | MSFT | Stock | 500.11 | 500.12 | 499.36 | 499.36 | 5064.0 |
| 2025-09-09 05:30:00 | MSFT | Stock | 499.5 | 499.5 | 499.5 | 499.5 | 592.0 |
| 2025-09-09 06:30:00 | MSFT | Stock | 500.4 | 500.4 | 500.0 | 500.0 | 653.0 |
| 2025-09-09 07:00:00 | MSFT | Stock | 500.0 | 500.05 | 499.77 | 499.87 | 3214.0 |
| 2025-09-09 07:30:00 | MSFT | Stock | 500.0 | 500.37 | 500.0 | 500.25 | 1680.0 |
| 2025-09-09 08:00:00 | MSFT | Stock | 500.37 | 501.15 | 499.4 | 500.5026 | 14151.0 |
| 2025-09-09 08:30:00 | MSFT | Stock | 500.68 | 500.8595 | 500.315 | 500.66 | 5450.0 |
| 2025-09-09 09:00:00 | MSFT | Stock | 500.47 | 501.81 | 500.0727 | 501.57 | 25153.0 |
| 2025-09-09 09:30:00 | MSFT | Stock | 501.73 | 502.095 | 500.1 | 501.01 | 1148502.0 |
| 2025-09-09 10:00:00 | MSFT | Stock | 501.01 | 502.25 | 499.4 | 500.905 | 693100.0 |
| 2025-09-09 10:30:00 | MSFT | Stock | 500.895 | 501.1 | 498.8 | 499.75 | 404975.0 |
| 2025-09-09 11:00:00 | MSFT | Stock | 499.73 | 500.25 | 499.0334 | 499.515 | 286212.0 |
| 2025-09-09 11:30:00 | MSFT | Stock | 499.475 | 500.1 | 498.7127 | 499.46 | 232645.0 |
| 2025-09-09 12:00:00 | MSFT | Stock | 499.4 | 499.66 | 498.36 | 498.63 | 581467.0 |
| 2025-09-09 12:30:00 | MSFT | Stock | 498.66 | 499.35 | 498.25 | 498.84 | 324892.0 |
| 2025-09-09 13:00:00 | MSFT | Stock | 498.82 | 499.61 | 498.69 | 499.14 | 388984.0 |
> showing 50 of 110,035 rows — these rows as CSV