PREVIEW / stock_30min / 2025-02-14
file: by_date/stock_30min/2025/2025-02-14.parquet size: 2.2 MB rows: 107,330 symbols: 535
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-14 04:00:00 | AAPL | Stock | 241.98 | 241.98 | 241.02 | 241.42 | 20515.0 |
| 2025-02-14 04:30:00 | AAPL | Stock | 241.36 | 241.5 | 241.05 | 241.06 | 9870.0 |
| 2025-02-14 05:00:00 | AAPL | Stock | 241.11 | 241.11 | 240.7 | 240.99 | 6262.0 |
| 2025-02-14 05:30:00 | AAPL | Stock | 240.94 | 241.52 | 240.68 | 241.52 | 20090.0 |
| 2025-02-14 06:00:00 | AAPL | Stock | 241.5 | 241.63 | 241.0 | 241.0 | 11616.0 |
| 2025-02-14 06:30:00 | AAPL | Stock | 241.04 | 241.05 | 240.47 | 240.68 | 31400.0 |
| 2025-02-14 07:00:00 | AAPL | Stock | 240.75 | 240.88 | 240.65 | 240.76 | 11227.0 |
| 2025-02-14 07:30:00 | AAPL | Stock | 240.8 | 241.0 | 240.8 | 240.96 | 10451.0 |
| 2025-02-14 08:00:00 | AAPL | Stock | 240.72 | 242.46 | 240.65 | 240.78 | 52705.0 |
| 2025-02-14 08:30:00 | AAPL | Stock | 240.78 | 240.97 | 240.72 | 240.79 | 20089.0 |
| 2025-02-14 09:00:00 | AAPL | Stock | 240.88 | 241.45 | 240.6514 | 241.34 | 50010.0 |
| 2025-02-14 09:30:00 | AAPL | Stock | 241.21 | 244.42 | 240.99 | 244.32 | 5156468.0 |
| 2025-02-14 10:00:00 | AAPL | Stock | 244.31 | 245.05 | 243.85 | 244.38 | 3516445.0 |
| 2025-02-14 10:30:00 | AAPL | Stock | 244.38 | 244.38 | 243.18 | 244.28 | 2435317.0 |
| 2025-02-14 11:00:00 | AAPL | Stock | 244.28 | 244.315 | 243.16 | 243.945 | 1442136.0 |
| 2025-02-14 11:30:00 | AAPL | Stock | 243.94 | 244.45 | 243.71 | 244.38 | 1291386.0 |
| 2025-02-14 12:00:00 | AAPL | Stock | 244.37 | 244.53 | 243.69 | 243.81 | 1098567.0 |
| 2025-02-14 12:30:00 | AAPL | Stock | 243.815 | 244.01 | 243.34 | 243.91 | 1146592.0 |
| 2025-02-14 13:00:00 | AAPL | Stock | 243.915 | 244.32 | 243.8 | 243.9999 | 715552.0 |
| 2025-02-14 13:30:00 | AAPL | Stock | 243.98 | 244.54 | 243.98 | 244.16 | 720220.0 |
| 2025-02-14 14:00:00 | AAPL | Stock | 244.1602 | 244.3 | 243.94 | 244.14 | 739728.0 |
| 2025-02-14 14:30:00 | AAPL | Stock | 244.14 | 244.37 | 244.0 | 244.2683 | 694979.0 |
| 2025-02-14 15:00:00 | AAPL | Stock | 244.265 | 244.265 | 243.9101 | 244.09 | 1041161.0 |
| 2025-02-14 15:30:00 | AAPL | Stock | 244.09 | 245.55 | 243.91 | 244.57 | 3889545.0 |
| 2025-02-14 16:00:00 | AAPL | Stock | 244.6 | 245.0 | 244.52 | 244.72 | 5883980.0 |
| 2025-02-14 16:30:00 | AAPL | Stock | 244.72 | 244.87 | 244.6 | 244.67 | 79450.0 |
| 2025-02-14 17:00:00 | AAPL | Stock | 244.6637 | 244.68 | 244.1 | 244.36 | 56977.0 |
| 2025-02-14 17:30:00 | AAPL | Stock | 244.3717 | 244.6 | 244.3632 | 244.48 | 6086.0 |
| 2025-02-14 18:00:00 | AAPL | Stock | 244.4703 | 244.5672 | 244.43 | 244.45 | 5348.0 |
| 2025-02-14 18:30:00 | AAPL | Stock | 244.46 | 244.7925 | 244.356 | 244.7925 | 2935.0 |
| 2025-02-14 19:00:00 | AAPL | Stock | 244.75 | 244.78 | 244.5025 | 244.65 | 1550.0 |
| 2025-02-14 19:30:00 | AAPL | Stock | 244.6 | 244.7784 | 244.5999 | 244.65 | 2633.0 |
| 2025-02-14 04:00:00 | MSFT | Stock | 410.54 | 411.0 | 410.54 | 410.92 | 7390.0 |
| 2025-02-14 04:30:00 | MSFT | Stock | 410.96 | 410.97 | 410.47 | 410.47 | 2412.0 |
| 2025-02-14 05:00:00 | MSFT | Stock | 410.28 | 410.35 | 410.08 | 410.24 | 813.0 |
| 2025-02-14 05:30:00 | MSFT | Stock | 410.1 | 410.22 | 410.0 | 410.16 | 1815.0 |
| 2025-02-14 06:00:00 | MSFT | Stock | 410.16 | 410.22 | 409.7 | 409.7 | 1961.0 |
| 2025-02-14 06:30:00 | MSFT | Stock | 409.68 | 410.0 | 409.18 | 409.79 | 7664.0 |
| 2025-02-14 07:00:00 | MSFT | Stock | 409.85 | 409.94 | 409.64 | 409.7 | 2530.0 |
| 2025-02-14 07:30:00 | MSFT | Stock | 409.7 | 409.7 | 409.59 | 409.7 | 998.0 |
| 2025-02-14 08:00:00 | MSFT | Stock | 409.69 | 411.18 | 409.52 | 409.71 | 14670.0 |
| 2025-02-14 08:30:00 | MSFT | Stock | 409.8 | 410.2 | 409.1 | 409.25 | 33486.0 |
| 2025-02-14 09:00:00 | MSFT | Stock | 409.2599 | 409.45 | 407.37 | 407.59 | 89706.0 |
| 2025-02-14 09:30:00 | MSFT | Stock | 407.6 | 408.71 | 406.17 | 406.54 | 3092012.0 |
| 2025-02-14 10:00:00 | MSFT | Stock | 406.5 | 407.6 | 406.2 | 406.24 | 1109121.0 |
| 2025-02-14 10:30:00 | MSFT | Stock | 406.24 | 407.99 | 405.88 | 407.76 | 1099653.0 |
| 2025-02-14 11:00:00 | MSFT | Stock | 407.8 | 407.85 | 406.595 | 407.8207 | 604549.0 |
| 2025-02-14 11:30:00 | MSFT | Stock | 407.8212 | 408.3249 | 407.4101 | 407.92 | 540220.0 |
| 2025-02-14 12:00:00 | MSFT | Stock | 407.93 | 408.2 | 407.5 | 407.53 | 395358.0 |
| 2025-02-14 12:30:00 | MSFT | Stock | 407.55 | 408.05 | 407.395 | 407.73 | 395382.0 |
> showing 50 of 107,330 rows — these rows as CSV