PREVIEW / stock_30min / 2025-03-24
file: by_date/stock_30min/2025/2025-03-24.parquet size: 2.2 MB rows: 105,307 symbols: 484
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-03-24 04:00:00 | AAPL | Stock | 219.8 | 220.6 | 219.3 | 220.17 | 32599.0 |
| 2025-03-24 04:30:00 | AAPL | Stock | 220.25 | 220.47 | 220.1 | 220.39 | 13510.0 |
| 2025-03-24 05:00:00 | AAPL | Stock | 220.43 | 220.84 | 220.35 | 220.58 | 29725.0 |
| 2025-03-24 05:30:00 | AAPL | Stock | 220.6 | 220.76 | 220.45 | 220.53 | 23058.0 |
| 2025-03-24 06:00:00 | AAPL | Stock | 220.6 | 220.61 | 220.33 | 220.36 | 27065.0 |
| 2025-03-24 06:30:00 | AAPL | Stock | 220.38 | 220.48 | 219.87 | 220.15 | 19471.0 |
| 2025-03-24 07:00:00 | AAPL | Stock | 220.15 | 220.3 | 219.77 | 220.09 | 34790.0 |
| 2025-03-24 07:30:00 | AAPL | Stock | 220.1 | 220.32 | 220.03 | 220.19 | 25389.0 |
| 2025-03-24 08:00:00 | AAPL | Stock | 219.9 | 220.33 | 219.68 | 220.33 | 64047.0 |
| 2025-03-24 08:30:00 | AAPL | Stock | 220.33 | 220.59 | 220.25 | 220.5 | 33408.0 |
| 2025-03-24 09:00:00 | AAPL | Stock | 220.5 | 221.22 | 219.87 | 221.0687 | 117534.0 |
| 2025-03-24 09:30:00 | AAPL | Stock | 221.0 | 221.03 | 218.58 | 220.2101 | 4724245.0 |
| 2025-03-24 10:00:00 | AAPL | Stock | 220.2065 | 220.37 | 219.22 | 219.77 | 2013096.0 |
| 2025-03-24 10:30:00 | AAPL | Stock | 219.81 | 220.24 | 219.25 | 219.73 | 1543038.0 |
| 2025-03-24 11:00:00 | AAPL | Stock | 219.73 | 220.69 | 219.0292 | 219.1575 | 2001684.0 |
| 2025-03-24 11:30:00 | AAPL | Stock | 219.155 | 219.83 | 218.96 | 219.79 | 1216482.0 |
| 2025-03-24 12:00:00 | AAPL | Stock | 219.79 | 220.05 | 218.98 | 219.0 | 1129716.0 |
| 2025-03-24 12:30:00 | AAPL | Stock | 219.015 | 219.33 | 218.82 | 219.29 | 1016872.0 |
| 2025-03-24 13:00:00 | AAPL | Stock | 219.29 | 219.5 | 218.89 | 219.29 | 950405.0 |
| 2025-03-24 13:30:00 | AAPL | Stock | 219.32 | 219.59 | 219.09 | 219.57 | 961072.0 |
| 2025-03-24 14:00:00 | AAPL | Stock | 219.59 | 219.85 | 219.17 | 219.76 | 958627.0 |
| 2025-03-24 14:30:00 | AAPL | Stock | 219.775 | 220.38 | 219.4658 | 220.125 | 1443100.0 |
| 2025-03-24 15:00:00 | AAPL | Stock | 220.1332 | 220.47 | 219.5837 | 219.77 | 1643310.0 |
| 2025-03-24 15:30:00 | AAPL | Stock | 219.79 | 221.48 | 219.66 | 220.43 | 4598028.0 |
| 2025-03-24 16:00:00 | AAPL | Stock | 220.38 | 220.85 | 220.38 | 220.7 | 8976892.0 |
| 2025-03-24 16:30:00 | AAPL | Stock | 220.7 | 220.8 | 220.7 | 220.72 | 42245.0 |
| 2025-03-24 17:00:00 | AAPL | Stock | 220.73 | 220.74 | 220.7 | 220.71 | 9149.0 |
| 2025-03-24 17:30:00 | AAPL | Stock | 220.7 | 220.82 | 220.7 | 220.76 | 8257.0 |
| 2025-03-24 18:00:00 | AAPL | Stock | 220.76 | 220.8 | 220.7 | 220.72 | 16496.0 |
| 2025-03-24 18:30:00 | AAPL | Stock | 220.72 | 220.8 | 220.7011 | 220.71 | 7344.0 |
| 2025-03-24 19:00:00 | AAPL | Stock | 220.79 | 220.8599 | 220.73 | 220.75 | 3142.0 |
| 2025-03-24 19:30:00 | AAPL | Stock | 220.876 | 220.876 | 220.7135 | 220.74 | 9316.0 |
| 2025-03-24 04:00:00 | MSFT | Stock | 394.46 | 395.57 | 393.25 | 395.27 | 7375.0 |
| 2025-03-24 04:30:00 | MSFT | Stock | 395.18 | 395.4 | 395.04 | 395.36 | 3751.0 |
| 2025-03-24 05:00:00 | MSFT | Stock | 395.16 | 395.2 | 394.9 | 394.9 | 2425.0 |
| 2025-03-24 05:30:00 | MSFT | Stock | 394.86 | 395.0 | 394.66 | 394.82 | 2603.0 |
| 2025-03-24 06:00:00 | MSFT | Stock | 394.62 | 394.7 | 394.31 | 394.62 | 4264.0 |
| 2025-03-24 06:30:00 | MSFT | Stock | 395.1 | 395.35 | 394.66 | 394.94 | 6381.0 |
| 2025-03-24 07:00:00 | MSFT | Stock | 394.97 | 395.3 | 394.4 | 395.19 | 11096.0 |
| 2025-03-24 07:30:00 | MSFT | Stock | 395.0 | 396.3 | 394.9 | 396.0 | 12253.0 |
| 2025-03-24 08:00:00 | MSFT | Stock | 395.24 | 396.3 | 394.15 | 396.1 | 23199.0 |
| 2025-03-24 08:30:00 | MSFT | Stock | 396.34 | 396.71 | 395.6006 | 396.13 | 19676.0 |
| 2025-03-24 09:00:00 | MSFT | Stock | 396.21 | 396.53 | 394.77 | 395.21 | 35300.0 |
| 2025-03-24 09:30:00 | MSFT | Stock | 395.17 | 395.4 | 391.47 | 391.7 | 2141976.0 |
| 2025-03-24 10:00:00 | MSFT | Stock | 391.8 | 392.58 | 389.81 | 391.742 | 1273802.0 |
| 2025-03-24 10:30:00 | MSFT | Stock | 391.75 | 392.52 | 391.1917 | 391.96 | 596586.0 |
| 2025-03-24 11:00:00 | MSFT | Stock | 391.97 | 393.34 | 391.81 | 393.02 | 503275.0 |
| 2025-03-24 11:30:00 | MSFT | Stock | 393.02 | 393.4631 | 392.39 | 392.975 | 647225.0 |
| 2025-03-24 12:00:00 | MSFT | Stock | 393.0 | 393.4191 | 392.45 | 392.5766 | 541578.0 |
| 2025-03-24 12:30:00 | MSFT | Stock | 392.48 | 393.0 | 392.17 | 392.3325 | 424497.0 |
> showing 50 of 105,307 rows — these rows as CSV