PREVIEW / stock_30min / 2025-01-07
file: by_date/stock_30min/2025/2025-01-07.parquet size: 2.3 MB rows: 109,790 symbols: 595
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-07 04:00:00 | AAPL | Stock | 244.58 | 244.75 | 244.46 | 244.61 | 8005.0 |
| 2025-01-07 04:30:00 | AAPL | Stock | 244.4 | 244.44 | 244.12 | 244.18 | 5438.0 |
| 2025-01-07 05:00:00 | AAPL | Stock | 244.31 | 244.63 | 244.19 | 244.6 | 2638.0 |
| 2025-01-07 05:30:00 | AAPL | Stock | 244.67 | 244.75 | 244.59 | 244.59 | 1433.0 |
| 2025-01-07 06:00:00 | AAPL | Stock | 244.57 | 244.8 | 244.48 | 244.78 | 9112.0 |
| 2025-01-07 06:30:00 | AAPL | Stock | 244.84 | 244.84 | 241.57 | 242.53 | 106329.0 |
| 2025-01-07 07:00:00 | AAPL | Stock | 242.7 | 242.84 | 242.15 | 242.15 | 29381.0 |
| 2025-01-07 07:30:00 | AAPL | Stock | 242.22 | 242.44 | 241.73 | 242.31 | 75813.0 |
| 2025-01-07 08:00:00 | AAPL | Stock | 242.43 | 244.78 | 241.75 | 242.25 | 131266.0 |
| 2025-01-07 08:30:00 | AAPL | Stock | 242.28 | 243.48 | 242.15 | 243.48 | 104902.0 |
| 2025-01-07 09:00:00 | AAPL | Stock | 243.48 | 243.48 | 242.69 | 242.69 | 146430.0 |
| 2025-01-07 09:30:00 | AAPL | Stock | 242.7 | 245.36 | 242.66 | 244.92 | 3669785.0 |
| 2025-01-07 10:00:00 | AAPL | Stock | 244.85 | 245.55 | 244.1951 | 245.165 | 2250132.0 |
| 2025-01-07 10:30:00 | AAPL | Stock | 245.16 | 245.38 | 244.03 | 244.67 | 1823809.0 |
| 2025-01-07 11:00:00 | AAPL | Stock | 244.67 | 244.78 | 243.71 | 243.76 | 1205139.0 |
| 2025-01-07 11:30:00 | AAPL | Stock | 243.74 | 243.88 | 243.0 | 243.08 | 1261952.0 |
| 2025-01-07 12:00:00 | AAPL | Stock | 243.06 | 243.31 | 242.1382 | 242.39 | 1224723.0 |
| 2025-01-07 12:30:00 | AAPL | Stock | 242.4 | 242.73 | 241.35 | 242.26 | 1464105.0 |
| 2025-01-07 13:00:00 | AAPL | Stock | 242.27 | 243.4084 | 242.17 | 243.1555 | 1156377.0 |
| 2025-01-07 13:30:00 | AAPL | Stock | 243.15 | 243.18 | 242.0701 | 242.33 | 1135400.0 |
| 2025-01-07 14:00:00 | AAPL | Stock | 242.3101 | 242.57 | 242.3101 | 242.458 | 777605.0 |
| 2025-01-07 14:30:00 | AAPL | Stock | 242.45 | 242.49 | 241.84 | 242.2102 | 797799.0 |
| 2025-01-07 15:00:00 | AAPL | Stock | 242.23 | 242.28 | 241.75 | 242.01 | 1234558.0 |
| 2025-01-07 15:30:00 | AAPL | Stock | 242.02 | 242.405 | 241.539 | 242.19 | 2863418.0 |
| 2025-01-07 16:00:00 | AAPL | Stock | 242.21 | 242.35 | 242.1 | 242.27 | 7629601.0 |
| 2025-01-07 16:30:00 | AAPL | Stock | 242.29 | 242.29 | 242.0314 | 242.2499 | 61646.0 |
| 2025-01-07 17:00:00 | AAPL | Stock | 242.09 | 242.21 | 242.03 | 242.09 | 11203.0 |
| 2025-01-07 17:30:00 | AAPL | Stock | 242.09 | 242.2 | 242.0304 | 242.1 | 7875.0 |
| 2025-01-07 18:00:00 | AAPL | Stock | 242.07 | 242.2 | 242.03 | 242.18 | 4639.0 |
| 2025-01-07 18:30:00 | AAPL | Stock | 242.09 | 242.17 | 242.03 | 242.15 | 3941.0 |
| 2025-01-07 19:00:00 | AAPL | Stock | 242.19 | 242.72 | 242.15 | 242.72 | 17681.0 |
| 2025-01-07 19:30:00 | AAPL | Stock | 242.7001 | 242.85 | 242.5 | 242.84 | 13825.0 |
| 2025-01-07 04:00:00 | MSFT | Stock | 428.49 | 429.71 | 428.48 | 429.71 | 3862.0 |
| 2025-01-07 04:30:00 | MSFT | Stock | 429.52 | 429.6 | 428.83 | 429.0 | 5638.0 |
| 2025-01-07 05:00:00 | MSFT | Stock | 428.54 | 429.68 | 428.54 | 429.63 | 2054.0 |
| 2025-01-07 05:30:00 | MSFT | Stock | 429.65 | 429.8 | 429.65 | 429.75 | 1563.0 |
| 2025-01-07 06:00:00 | MSFT | Stock | 429.73 | 429.81 | 429.56 | 429.81 | 1532.0 |
| 2025-01-07 06:30:00 | MSFT | Stock | 429.72 | 430.02 | 429.7 | 429.9 | 2210.0 |
| 2025-01-07 07:00:00 | MSFT | Stock | 429.9 | 429.95 | 429.04 | 429.29 | 4160.0 |
| 2025-01-07 07:30:00 | MSFT | Stock | 429.3 | 429.33 | 429.0 | 429.0 | 3169.0 |
| 2025-01-07 08:00:00 | MSFT | Stock | 429.3 | 429.84 | 427.56 | 429.25 | 11020.0 |
| 2025-01-07 08:30:00 | MSFT | Stock | 429.34 | 429.41 | 428.88 | 429.41 | 8596.0 |
| 2025-01-07 09:00:00 | MSFT | Stock | 429.2643 | 430.47 | 429.0 | 429.29 | 21935.0 |
| 2025-01-07 09:30:00 | MSFT | Stock | 429.11 | 430.65 | 427.155 | 430.37 | 1568713.0 |
| 2025-01-07 10:00:00 | MSFT | Stock | 430.3 | 430.3 | 427.89 | 428.79 | 704088.0 |
| 2025-01-07 10:30:00 | MSFT | Stock | 428.71 | 428.79 | 425.585 | 426.97 | 686257.0 |
| 2025-01-07 11:00:00 | MSFT | Stock | 427.03 | 427.18 | 425.2 | 426.0899 | 602150.0 |
| 2025-01-07 11:30:00 | MSFT | Stock | 426.0 | 426.1399 | 424.36 | 424.585 | 567304.0 |
| 2025-01-07 12:00:00 | MSFT | Stock | 424.49 | 424.9326 | 423.35 | 423.59 | 421085.0 |
| 2025-01-07 12:30:00 | MSFT | Stock | 423.57 | 423.99 | 422.76 | 423.725 | 269484.0 |
> showing 50 of 109,790 rows — these rows as CSV