PREVIEW / stock_30min / 2025-01-29
file: by_date/stock_30min/2025/2025-01-29.parquet size: 2.2 MB rows: 104,728 symbols: 563
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-29 04:00:00 | AAPL | Stock | 238.56 | 238.56 | 237.22 | 237.34 | 32671.0 |
| 2025-01-29 04:30:00 | AAPL | Stock | 237.37 | 237.51 | 237.05 | 237.2 | 15741.0 |
| 2025-01-29 05:00:00 | AAPL | Stock | 237.21 | 237.47 | 237.19 | 237.23 | 5395.0 |
| 2025-01-29 05:30:00 | AAPL | Stock | 237.25 | 237.3 | 237.02 | 237.15 | 16261.0 |
| 2025-01-29 06:00:00 | AAPL | Stock | 237.12 | 237.56 | 237.07 | 237.24 | 9249.0 |
| 2025-01-29 06:30:00 | AAPL | Stock | 237.18 | 237.47 | 237.16 | 237.47 | 5582.0 |
| 2025-01-29 07:00:00 | AAPL | Stock | 237.43 | 237.81 | 234.75 | 235.51 | 227261.0 |
| 2025-01-29 07:30:00 | AAPL | Stock | 235.51 | 235.84 | 235.13 | 235.65 | 62376.0 |
| 2025-01-29 08:00:00 | AAPL | Stock | 237.58 | 239.56 | 232.98 | 234.0 | 464033.0 |
| 2025-01-29 08:30:00 | AAPL | Stock | 234.0 | 234.6 | 233.78 | 234.58 | 131835.0 |
| 2025-01-29 09:00:00 | AAPL | Stock | 234.57 | 235.2255 | 233.91 | 234.11 | 201668.0 |
| 2025-01-29 09:30:00 | AAPL | Stock | 234.12 | 236.29 | 234.01 | 235.79 | 4869100.0 |
| 2025-01-29 10:00:00 | AAPL | Stock | 235.805 | 237.13 | 235.52 | 236.835 | 2431511.0 |
| 2025-01-29 10:30:00 | AAPL | Stock | 236.81 | 238.0 | 236.71 | 237.7894 | 2243451.0 |
| 2025-01-29 11:00:00 | AAPL | Stock | 237.78 | 237.95 | 236.43 | 236.5157 | 1610800.0 |
| 2025-01-29 11:30:00 | AAPL | Stock | 236.52 | 237.22 | 236.13 | 236.54 | 1383413.0 |
| 2025-01-29 12:00:00 | AAPL | Stock | 236.54 | 237.19 | 236.3008 | 236.869 | 1420976.0 |
| 2025-01-29 12:30:00 | AAPL | Stock | 236.87 | 236.94 | 235.945 | 236.03 | 987346.0 |
| 2025-01-29 13:00:00 | AAPL | Stock | 236.04 | 237.435 | 235.45 | 237.43 | 1512349.0 |
| 2025-01-29 13:30:00 | AAPL | Stock | 237.44 | 237.66 | 236.87 | 237.0 | 1019725.0 |
| 2025-01-29 14:00:00 | AAPL | Stock | 236.97 | 237.23 | 236.31 | 236.445 | 1112951.0 |
| 2025-01-29 14:30:00 | AAPL | Stock | 236.44 | 238.29 | 236.345 | 238.08 | 1783515.0 |
| 2025-01-29 15:00:00 | AAPL | Stock | 238.07 | 239.24 | 237.69 | 239.05 | 2080004.0 |
| 2025-01-29 15:30:00 | AAPL | Stock | 239.06 | 239.855 | 238.72 | 239.35 | 3940859.0 |
| 2025-01-29 16:00:00 | AAPL | Stock | 239.36 | 239.98 | 239.2 | 239.3487 | 6640503.0 |
| 2025-01-29 16:30:00 | AAPL | Stock | 239.3463 | 239.36 | 238.7106 | 239.25 | 79440.0 |
| 2025-01-29 17:00:00 | AAPL | Stock | 239.22 | 239.22 | 238.51 | 238.7 | 39735.0 |
| 2025-01-29 17:30:00 | AAPL | Stock | 238.9 | 238.9971 | 238.55 | 238.6209 | 12182.0 |
| 2025-01-29 18:00:00 | AAPL | Stock | 238.8 | 239.25 | 238.62 | 238.73 | 34782.0 |
| 2025-01-29 18:30:00 | AAPL | Stock | 238.8 | 239.0786 | 238.5013 | 238.8001 | 35437.0 |
| 2025-01-29 19:00:00 | AAPL | Stock | 238.85 | 239.5 | 238.85 | 239.22 | 18618.0 |
| 2025-01-29 19:30:00 | AAPL | Stock | 239.2203 | 239.3 | 239.1 | 239.2015 | 13195.0 |
| 2025-01-29 04:00:00 | MSFT | Stock | 446.59 | 446.99 | 444.93 | 446.94 | 14526.0 |
| 2025-01-29 04:30:00 | MSFT | Stock | 446.21 | 446.5 | 446.01 | 446.5 | 1771.0 |
| 2025-01-29 05:00:00 | MSFT | Stock | 446.55 | 446.55 | 446.55 | 446.55 | 430.0 |
| 2025-01-29 05:30:00 | MSFT | Stock | 446.47 | 446.83 | 446.47 | 446.83 | 1554.0 |
| 2025-01-29 06:00:00 | MSFT | Stock | 446.59 | 446.59 | 445.93 | 446.01 | 895.0 |
| 2025-01-29 06:30:00 | MSFT | Stock | 446.04 | 446.72 | 445.61 | 446.72 | 2240.0 |
| 2025-01-29 07:00:00 | MSFT | Stock | 446.3 | 447.2 | 446.08 | 446.72 | 11123.0 |
| 2025-01-29 07:30:00 | MSFT | Stock | 446.72 | 446.77 | 446.29 | 446.48 | 8157.0 |
| 2025-01-29 08:00:00 | MSFT | Stock | 446.5 | 447.95 | 440.0 | 445.5 | 59684.0 |
| 2025-01-29 08:30:00 | MSFT | Stock | 446.18 | 446.18 | 445.0013 | 446.0 | 10394.0 |
| 2025-01-29 09:00:00 | MSFT | Stock | 446.32 | 446.89 | 445.21 | 446.89 | 21490.0 |
| 2025-01-29 09:30:00 | MSFT | Stock | 446.69 | 446.88 | 440.4 | 441.39 | 1617382.0 |
| 2025-01-29 10:00:00 | MSFT | Stock | 441.425 | 442.5499 | 440.8158 | 442.03 | 656555.0 |
| 2025-01-29 10:30:00 | MSFT | Stock | 442.02 | 443.391 | 441.4576 | 442.715 | 472615.0 |
| 2025-01-29 11:00:00 | MSFT | Stock | 442.715 | 443.49 | 442.3601 | 442.4186 | 370076.0 |
| 2025-01-29 11:30:00 | MSFT | Stock | 442.412 | 444.4786 | 442.257 | 443.86 | 483190.0 |
| 2025-01-29 12:00:00 | MSFT | Stock | 443.84 | 445.09 | 443.5145 | 443.5902 | 538451.0 |
| 2025-01-29 12:30:00 | MSFT | Stock | 443.645 | 444.3 | 442.7 | 442.8892 | 300529.0 |
> showing 50 of 104,728 rows — these rows as CSV