PREVIEW / stock_30min / 2025-02-04
file: by_date/stock_30min/2025/2025-02-04.parquet size: 2.2 MB rows: 105,164 symbols: 551
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-02-04 04:00:00 | AAPL | Stock | 226.65 | 226.91 | 226.47 | 226.73 | 11200.0 |
| 2025-02-04 04:30:00 | AAPL | Stock | 226.63 | 227.0 | 226.62 | 226.71 | 8675.0 |
| 2025-02-04 05:00:00 | AAPL | Stock | 226.57 | 227.39 | 226.55 | 227.39 | 5669.0 |
| 2025-02-04 05:30:00 | AAPL | Stock | 227.4 | 227.4 | 227.17 | 227.17 | 2150.0 |
| 2025-02-04 06:00:00 | AAPL | Stock | 227.29 | 227.65 | 227.13 | 227.31 | 20372.0 |
| 2025-02-04 06:30:00 | AAPL | Stock | 227.32 | 227.32 | 226.79 | 226.98 | 8099.0 |
| 2025-02-04 07:00:00 | AAPL | Stock | 226.94 | 227.14 | 226.41 | 226.91 | 15432.0 |
| 2025-02-04 07:30:00 | AAPL | Stock | 226.95 | 227.46 | 226.84 | 227.07 | 17802.0 |
| 2025-02-04 08:00:00 | AAPL | Stock | 226.85 | 228.0 | 226.18 | 227.01 | 132756.0 |
| 2025-02-04 08:30:00 | AAPL | Stock | 227.0019 | 227.46 | 226.8537 | 227.39 | 59631.0 |
| 2025-02-04 09:00:00 | AAPL | Stock | 227.3 | 227.9179 | 226.99 | 227.24 | 94548.0 |
| 2025-02-04 09:30:00 | AAPL | Stock | 227.25 | 229.21 | 226.65 | 228.922 | 4575507.0 |
| 2025-02-04 10:00:00 | AAPL | Stock | 228.94 | 230.4118 | 228.64 | 230.37 | 2874785.0 |
| 2025-02-04 10:30:00 | AAPL | Stock | 230.38 | 231.5488 | 230.22 | 230.52 | 2564965.0 |
| 2025-02-04 11:00:00 | AAPL | Stock | 230.52 | 231.07 | 230.12 | 231.05 | 1762729.0 |
| 2025-02-04 11:30:00 | AAPL | Stock | 231.06 | 232.465 | 231.05 | 232.19 | 2087201.0 |
| 2025-02-04 12:00:00 | AAPL | Stock | 232.19 | 232.79 | 231.67 | 231.78 | 1988311.0 |
| 2025-02-04 12:30:00 | AAPL | Stock | 231.79 | 232.255 | 231.39 | 232.245 | 1344343.0 |
| 2025-02-04 13:00:00 | AAPL | Stock | 232.24 | 232.38 | 231.64 | 232.22 | 1041512.0 |
| 2025-02-04 13:30:00 | AAPL | Stock | 232.2257 | 232.36 | 231.49 | 231.49 | 760917.0 |
| 2025-02-04 14:00:00 | AAPL | Stock | 231.49 | 232.37 | 231.37 | 232.14 | 948021.0 |
| 2025-02-04 14:30:00 | AAPL | Stock | 232.135 | 232.77 | 232.13 | 232.547 | 1124310.0 |
| 2025-02-04 15:00:00 | AAPL | Stock | 232.5564 | 232.95 | 232.22 | 232.309 | 1345065.0 |
| 2025-02-04 15:30:00 | AAPL | Stock | 232.29 | 233.13 | 232.01 | 232.79 | 2643503.0 |
| 2025-02-04 16:00:00 | AAPL | Stock | 232.75 | 233.1 | 232.224 | 232.3425 | 6241020.0 |
| 2025-02-04 16:30:00 | AAPL | Stock | 232.8 | 232.8 | 232.0 | 232.34 | 148864.0 |
| 2025-02-04 17:00:00 | AAPL | Stock | 232.39 | 232.59 | 232.0203 | 232.035 | 12404.0 |
| 2025-02-04 17:30:00 | AAPL | Stock | 232.05 | 232.2 | 231.61 | 231.79 | 26213.0 |
| 2025-02-04 18:00:00 | AAPL | Stock | 231.88 | 232.79 | 231.75 | 232.65 | 32922.0 |
| 2025-02-04 18:30:00 | AAPL | Stock | 232.73 | 232.73 | 232.0587 | 232.25 | 7437.0 |
| 2025-02-04 19:00:00 | AAPL | Stock | 232.13 | 232.59 | 232.055 | 232.53 | 14212.0 |
| 2025-02-04 19:30:00 | AAPL | Stock | 232.59 | 233.0 | 232.3495 | 232.75 | 26928.0 |
| 2025-02-04 04:00:00 | MSFT | Stock | 410.77 | 411.95 | 409.51 | 409.8 | 11060.0 |
| 2025-02-04 04:30:00 | MSFT | Stock | 409.63 | 409.89 | 409.34 | 409.71 | 2577.0 |
| 2025-02-04 05:00:00 | MSFT | Stock | 409.96 | 410.44 | 409.73 | 410.2 | 6231.0 |
| 2025-02-04 05:30:00 | MSFT | Stock | 410.2 | 410.2 | 410.02 | 410.05 | 1009.0 |
| 2025-02-04 06:00:00 | MSFT | Stock | 410.04 | 410.5 | 410.04 | 410.46 | 8586.0 |
| 2025-02-04 06:30:00 | MSFT | Stock | 410.45 | 410.45 | 410.0 | 410.25 | 4383.0 |
| 2025-02-04 07:00:00 | MSFT | Stock | 410.3 | 411.3 | 410.2 | 411.3 | 11844.0 |
| 2025-02-04 07:30:00 | MSFT | Stock | 411.35 | 412.72 | 411.35 | 411.74 | 10216.0 |
| 2025-02-04 08:00:00 | MSFT | Stock | 410.49 | 412.5 | 409.0 | 411.84 | 44690.0 |
| 2025-02-04 08:30:00 | MSFT | Stock | 411.7999 | 412.01 | 411.4855 | 411.77 | 19777.0 |
| 2025-02-04 09:00:00 | MSFT | Stock | 411.8 | 413.35 | 411.77 | 412.85 | 26535.0 |
| 2025-02-04 09:30:00 | MSFT | Stock | 412.58 | 412.88 | 409.74 | 411.27 | 2543541.0 |
| 2025-02-04 10:00:00 | MSFT | Stock | 411.33 | 413.44 | 411.275 | 413.17 | 855168.0 |
| 2025-02-04 10:30:00 | MSFT | Stock | 413.2305 | 413.9199 | 412.6601 | 413.1708 | 854501.0 |
| 2025-02-04 11:00:00 | MSFT | Stock | 413.245 | 413.65 | 412.24 | 413.12 | 592145.0 |
| 2025-02-04 11:30:00 | MSFT | Stock | 413.14 | 413.625 | 412.18 | 412.55 | 415433.0 |
| 2025-02-04 12:00:00 | MSFT | Stock | 412.55 | 413.0 | 411.0 | 411.06 | 582364.0 |
| 2025-02-04 12:30:00 | MSFT | Stock | 411.09 | 411.75 | 410.66 | 411.73 | 584583.0 |
> showing 50 of 105,164 rows — these rows as CSV