PREVIEW / stock_30min / 2025-01-06
file: by_date/stock_30min/2025/2025-01-06.parquet size: 2.3 MB rows: 113,645 symbols: 592
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-06 04:00:00 | AAPL | Stock | 243.89 | 245.33 | 243.89 | 244.93 | 29791.0 |
| 2025-01-06 04:30:00 | AAPL | Stock | 244.99 | 245.05 | 244.92 | 245.0 | 20533.0 |
| 2025-01-06 05:00:00 | AAPL | Stock | 245.0 | 245.09 | 244.915 | 245.02 | 5418.0 |
| 2025-01-06 05:30:00 | AAPL | Stock | 245.01 | 245.09 | 244.92 | 245.01 | 2461.0 |
| 2025-01-06 06:00:00 | AAPL | Stock | 245.0 | 245.3 | 244.85 | 245.18 | 12136.0 |
| 2025-01-06 06:30:00 | AAPL | Stock | 245.19 | 245.26 | 244.99 | 245.06 | 15626.0 |
| 2025-01-06 07:00:00 | AAPL | Stock | 245.05 | 245.06 | 244.35 | 244.41 | 37426.0 |
| 2025-01-06 07:30:00 | AAPL | Stock | 244.43 | 244.6 | 244.11 | 244.11 | 37968.0 |
| 2025-01-06 08:00:00 | AAPL | Stock | 244.965 | 245.04 | 243.74 | 244.25 | 100287.0 |
| 2025-01-06 08:30:00 | AAPL | Stock | 244.22 | 245.13 | 244.22 | 245.05 | 112571.0 |
| 2025-01-06 09:00:00 | AAPL | Stock | 245.03 | 245.04 | 243.39 | 244.36 | 157573.0 |
| 2025-01-06 09:30:00 | AAPL | Stock | 244.36 | 246.1827 | 243.2 | 244.4256 | 4594811.0 |
| 2025-01-06 10:00:00 | AAPL | Stock | 244.45 | 245.77 | 244.44 | 245.55 | 2375597.0 |
| 2025-01-06 10:30:00 | AAPL | Stock | 245.54 | 246.46 | 245.33 | 246.34 | 1768733.0 |
| 2025-01-06 11:00:00 | AAPL | Stock | 246.35 | 247.33 | 246.215 | 246.75 | 2224951.0 |
| 2025-01-06 11:30:00 | AAPL | Stock | 246.75 | 246.761 | 245.89 | 246.25 | 1109198.0 |
| 2025-01-06 12:00:00 | AAPL | Stock | 246.25 | 246.49 | 245.7013 | 245.77 | 836969.0 |
| 2025-01-06 12:30:00 | AAPL | Stock | 245.76 | 245.87 | 244.73 | 244.95 | 1377936.0 |
| 2025-01-06 13:00:00 | AAPL | Stock | 244.98 | 245.05 | 244.47 | 245.03 | 1018916.0 |
| 2025-01-06 13:30:00 | AAPL | Stock | 245.03 | 245.13 | 244.6 | 244.87 | 825972.0 |
| 2025-01-06 14:00:00 | AAPL | Stock | 244.87 | 245.18 | 244.71 | 244.9899 | 734194.0 |
| 2025-01-06 14:30:00 | AAPL | Stock | 244.98 | 245.13 | 244.5 | 244.59 | 811623.0 |
| 2025-01-06 15:00:00 | AAPL | Stock | 244.585 | 244.98 | 244.425 | 244.895 | 877777.0 |
| 2025-01-06 15:30:00 | AAPL | Stock | 244.91 | 245.34 | 244.41 | 245.0 | 2824122.0 |
| 2025-01-06 16:00:00 | AAPL | Stock | 245.0 | 245.02 | 244.68 | 244.72 | 9142815.0 |
| 2025-01-06 16:30:00 | AAPL | Stock | 244.7 | 245.0 | 244.65 | 244.69 | 59605.0 |
| 2025-01-06 17:00:00 | AAPL | Stock | 244.67 | 244.7 | 244.6 | 244.6 | 4693.0 |
| 2025-01-06 17:30:00 | AAPL | Stock | 244.65 | 244.7 | 244.5 | 244.554 | 8240.0 |
| 2025-01-06 18:00:00 | AAPL | Stock | 244.6 | 244.68 | 244.6 | 244.67 | 4377.0 |
| 2025-01-06 18:30:00 | AAPL | Stock | 244.6 | 244.78 | 244.6 | 244.7006 | 5115.0 |
| 2025-01-06 19:00:00 | AAPL | Stock | 244.72 | 244.75 | 244.6 | 244.6 | 4944.0 |
| 2025-01-06 19:30:00 | AAPL | Stock | 244.6004 | 245.0 | 244.6004 | 244.99 | 13720.0 |
| 2025-01-06 04:00:00 | MSFT | Stock | 427.15 | 427.15 | 426.18 | 426.38 | 3227.0 |
| 2025-01-06 04:30:00 | MSFT | Stock | 426.52 | 428.14 | 426.49 | 428.14 | 5951.0 |
| 2025-01-06 05:00:00 | MSFT | Stock | 428.1 | 429.2 | 428.1 | 428.67 | 6240.0 |
| 2025-01-06 05:30:00 | MSFT | Stock | 428.54 | 428.67 | 427.82 | 427.82 | 2715.0 |
| 2025-01-06 06:00:00 | MSFT | Stock | 427.88 | 427.94 | 427.05 | 427.52 | 10645.0 |
| 2025-01-06 06:30:00 | MSFT | Stock | 427.75 | 427.8 | 427.58 | 427.75 | 8539.0 |
| 2025-01-06 07:00:00 | MSFT | Stock | 427.7 | 427.75 | 426.83 | 427.0 | 14656.0 |
| 2025-01-06 07:30:00 | MSFT | Stock | 427.0 | 427.85 | 426.94 | 427.5 | 7205.0 |
| 2025-01-06 08:00:00 | MSFT | Stock | 427.59 | 428.41 | 425.6 | 427.8 | 51653.0 |
| 2025-01-06 08:30:00 | MSFT | Stock | 427.82 | 428.15 | 427.4 | 427.87 | 22887.0 |
| 2025-01-06 09:00:00 | MSFT | Stock | 427.99 | 428.4 | 426.1 | 428.0 | 43117.0 |
| 2025-01-06 09:30:00 | MSFT | Stock | 428.05 | 431.98 | 426.77 | 430.96 | 2228822.0 |
| 2025-01-06 10:00:00 | MSFT | Stock | 430.98 | 434.32 | 430.465 | 432.6485 | 1227276.0 |
| 2025-01-06 10:30:00 | MSFT | Stock | 432.6475 | 432.82 | 430.93 | 432.1925 | 702640.0 |
| 2025-01-06 11:00:00 | MSFT | Stock | 432.22 | 432.34 | 430.95 | 431.875 | 568745.0 |
| 2025-01-06 11:30:00 | MSFT | Stock | 431.875 | 432.19 | 431.18 | 431.255 | 393266.0 |
| 2025-01-06 12:00:00 | MSFT | Stock | 431.23 | 432.01 | 430.14 | 430.37 | 420082.0 |
| 2025-01-06 12:30:00 | MSFT | Stock | 430.34 | 430.62 | 428.56 | 428.76 | 453992.0 |
> showing 50 of 113,645 rows — these rows as CSV