PREVIEW / stock_30min / 2025-08-13
file: by_date/stock_30min/2025/2025-08-13.parquet size: 2.3 MB rows: 109,456 symbols: 343
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-08-13 04:00:00 | AAPL | Stock | 229.6 | 229.95 | 229.5 | 229.92 | 6456.0 |
| 2025-08-13 04:30:00 | AAPL | Stock | 229.95 | 230.09 | 229.91 | 229.92 | 5851.0 |
| 2025-08-13 05:00:00 | AAPL | Stock | 229.81 | 229.97 | 229.76 | 229.87 | 1423.0 |
| 2025-08-13 05:30:00 | AAPL | Stock | 229.94 | 229.94 | 229.84 | 229.94 | 1990.0 |
| 2025-08-13 06:00:00 | AAPL | Stock | 229.87 | 229.99 | 229.87 | 229.99 | 4184.0 |
| 2025-08-13 06:30:00 | AAPL | Stock | 229.99 | 230.06 | 229.85 | 230.06 | 5803.0 |
| 2025-08-13 07:00:00 | AAPL | Stock | 230.03 | 230.03 | 229.82 | 230.0 | 12946.0 |
| 2025-08-13 07:30:00 | AAPL | Stock | 229.99 | 230.1 | 229.95 | 230.0 | 9596.0 |
| 2025-08-13 08:00:00 | AAPL | Stock | 229.94 | 230.5 | 228.0 | 230.49 | 107120.0 |
| 2025-08-13 08:30:00 | AAPL | Stock | 230.3 | 230.9 | 230.29 | 230.8306 | 51714.0 |
| 2025-08-13 09:00:00 | AAPL | Stock | 230.83 | 231.23 | 230.5298 | 231.05 | 73614.0 |
| 2025-08-13 09:30:00 | AAPL | Stock | 231.07 | 232.19 | 230.43 | 231.7775 | 6134340.0 |
| 2025-08-13 10:00:00 | AAPL | Stock | 231.75 | 232.72 | 231.16 | 231.82 | 4649061.0 |
| 2025-08-13 10:30:00 | AAPL | Stock | 231.81 | 234.55 | 231.77 | 233.6 | 5406860.0 |
| 2025-08-13 11:00:00 | AAPL | Stock | 233.53 | 233.915 | 231.68 | 232.29 | 3761720.0 |
| 2025-08-13 11:30:00 | AAPL | Stock | 232.28 | 233.3186 | 232.0302 | 232.665 | 2042312.0 |
| 2025-08-13 12:00:00 | AAPL | Stock | 232.68 | 233.4 | 232.345 | 233.09 | 1750985.0 |
| 2025-08-13 12:30:00 | AAPL | Stock | 233.07 | 233.37 | 232.07 | 232.1068 | 1628816.0 |
| 2025-08-13 13:00:00 | AAPL | Stock | 232.12 | 232.47 | 231.56 | 232.4587 | 1756729.0 |
| 2025-08-13 13:30:00 | AAPL | Stock | 232.45 | 233.19 | 232.02 | 233.11 | 1292465.0 |
| 2025-08-13 14:00:00 | AAPL | Stock | 233.1001 | 235.0 | 232.48 | 232.925 | 4922762.0 |
| 2025-08-13 14:30:00 | AAPL | Stock | 232.94 | 233.3885 | 230.8 | 233.12 | 3837857.0 |
| 2025-08-13 15:00:00 | AAPL | Stock | 233.12 | 233.91 | 233.06 | 233.585 | 2413508.0 |
| 2025-08-13 15:30:00 | AAPL | Stock | 233.585 | 234.33 | 233.11 | 233.32 | 4440966.0 |
| 2025-08-13 16:00:00 | AAPL | Stock | 233.33 | 233.85 | 233.28 | 233.4301 | 6542707.0 |
| 2025-08-13 16:30:00 | AAPL | Stock | 233.45 | 233.554 | 233.18 | 233.44 | 34259.0 |
| 2025-08-13 17:00:00 | AAPL | Stock | 233.43 | 233.56 | 233.3306 | 233.507 | 17247.0 |
| 2025-08-13 17:30:00 | AAPL | Stock | 233.45 | 233.57 | 233.33 | 233.34 | 7365.0 |
| 2025-08-13 18:00:00 | AAPL | Stock | 233.35 | 233.35 | 233.11 | 233.17 | 11262.0 |
| 2025-08-13 18:30:00 | AAPL | Stock | 233.16 | 233.3 | 233.1 | 233.18 | 7429.0 |
| 2025-08-13 19:00:00 | AAPL | Stock | 233.21 | 233.21 | 233.1 | 233.15 | 8831.0 |
| 2025-08-13 19:30:00 | AAPL | Stock | 233.1679 | 233.25 | 233.1 | 233.1 | 7735.0 |
| 2025-08-13 04:00:00 | MSFT | Stock | 531.72 | 531.72 | 529.77 | 530.12 | 3752.0 |
| 2025-08-13 04:30:00 | MSFT | Stock | 530.53 | 530.53 | 529.7 | 529.7 | 2357.0 |
| 2025-08-13 05:00:00 | MSFT | Stock | 529.61 | 529.72 | 529.61 | 529.72 | 300.0 |
| 2025-08-13 05:30:00 | MSFT | Stock | 529.88 | 530.5 | 529.0 | 530.5 | 1684.0 |
| 2025-08-13 06:00:00 | MSFT | Stock | 530.66 | 530.73 | 530.4 | 530.45 | 2634.0 |
| 2025-08-13 06:30:00 | MSFT | Stock | 530.19 | 530.19 | 530.19 | 530.19 | 459.0 |
| 2025-08-13 07:00:00 | MSFT | Stock | 530.0 | 530.0 | 529.48 | 529.79 | 4893.0 |
| 2025-08-13 07:30:00 | MSFT | Stock | 529.71 | 529.71 | 529.48 | 529.68 | 2427.0 |
| 2025-08-13 08:00:00 | MSFT | Stock | 530.0 | 531.0 | 528.83 | 529.69 | 20266.0 |
| 2025-08-13 08:30:00 | MSFT | Stock | 529.75 | 530.99 | 529.75 | 530.6 | 17746.0 |
| 2025-08-13 09:00:00 | MSFT | Stock | 530.5001 | 532.83 | 530.5 | 532.15 | 22978.0 |
| 2025-08-13 09:30:00 | MSFT | Stock | 532.11 | 532.7 | 528.88 | 530.24 | 1278410.0 |
| 2025-08-13 10:00:00 | MSFT | Stock | 530.215 | 531.84 | 529.605 | 529.75 | 629358.0 |
| 2025-08-13 10:30:00 | MSFT | Stock | 529.77 | 530.705 | 529.51 | 530.36 | 563575.0 |
| 2025-08-13 11:00:00 | MSFT | Stock | 530.335 | 530.3392 | 526.86 | 527.27 | 735085.0 |
| 2025-08-13 11:30:00 | MSFT | Stock | 527.29 | 528.3 | 527.1 | 527.94 | 333051.0 |
| 2025-08-13 12:00:00 | MSFT | Stock | 527.93 | 528.6 | 526.28 | 526.355 | 397011.0 |
| 2025-08-13 12:30:00 | MSFT | Stock | 526.382 | 526.382 | 524.96 | 525.195 | 471941.0 |
> showing 50 of 109,456 rows — these rows as CSV