PREVIEW / stock_30min / 2025-06-23
file: by_date/stock_30min/2025/2025-06-23.parquet size: 2.3 MB rows: 109,528 symbols: 396
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-06-23 04:00:00 | AAPL | Stock | 200.3 | 202.0 | 200.06 | 201.8 | 49926.0 |
| 2025-06-23 04:30:00 | AAPL | Stock | 201.77 | 201.8 | 201.55 | 201.76 | 11081.0 |
| 2025-06-23 05:00:00 | AAPL | Stock | 201.71 | 201.76 | 200.99 | 201.0 | 20736.0 |
| 2025-06-23 05:30:00 | AAPL | Stock | 201.07 | 201.26 | 200.97 | 200.97 | 5201.0 |
| 2025-06-23 06:00:00 | AAPL | Stock | 200.91 | 201.39 | 200.82 | 200.95 | 9869.0 |
| 2025-06-23 06:30:00 | AAPL | Stock | 200.77 | 201.1 | 200.64 | 200.88 | 25506.0 |
| 2025-06-23 07:00:00 | AAPL | Stock | 200.89 | 201.0 | 200.35 | 200.62 | 19777.0 |
| 2025-06-23 07:30:00 | AAPL | Stock | 200.62 | 201.17 | 200.5 | 201.08 | 29387.0 |
| 2025-06-23 08:00:00 | AAPL | Stock | 200.95 | 201.782 | 199.57 | 201.1515 | 155081.0 |
| 2025-06-23 08:30:00 | AAPL | Stock | 201.2 | 201.73 | 201.1345 | 201.56 | 70210.0 |
| 2025-06-23 09:00:00 | AAPL | Stock | 201.53 | 202.05 | 201.0 | 201.58 | 282302.0 |
| 2025-06-23 09:30:00 | AAPL | Stock | 201.59 | 201.91 | 199.94 | 201.73 | 5387369.0 |
| 2025-06-23 10:00:00 | AAPL | Stock | 201.72 | 202.3 | 201.17 | 201.3718 | 3022440.0 |
| 2025-06-23 10:30:00 | AAPL | Stock | 201.38 | 201.59 | 200.38 | 200.46 | 2050834.0 |
| 2025-06-23 11:00:00 | AAPL | Stock | 200.465 | 200.875 | 200.2 | 200.53 | 1907992.0 |
| 2025-06-23 11:30:00 | AAPL | Stock | 200.51 | 200.54 | 199.51 | 199.88 | 1959399.0 |
| 2025-06-23 12:00:00 | AAPL | Stock | 199.88 | 200.52 | 199.61 | 200.1396 | 1496776.0 |
| 2025-06-23 12:30:00 | AAPL | Stock | 200.14 | 200.54 | 198.96 | 199.71 | 1767311.0 |
| 2025-06-23 13:00:00 | AAPL | Stock | 199.72 | 201.52 | 199.58 | 201.439 | 1801475.0 |
| 2025-06-23 13:30:00 | AAPL | Stock | 201.46 | 201.82 | 201.08 | 201.23 | 1470355.0 |
| 2025-06-23 14:00:00 | AAPL | Stock | 201.25 | 202.24 | 201.235 | 201.68 | 1814416.0 |
| 2025-06-23 14:30:00 | AAPL | Stock | 201.67 | 201.9 | 201.35 | 201.43 | 999087.0 |
| 2025-06-23 15:00:00 | AAPL | Stock | 201.42 | 201.765 | 201.0507 | 201.3602 | 1349162.0 |
| 2025-06-23 15:30:00 | AAPL | Stock | 201.35 | 201.84 | 201.135 | 201.55 | 2856463.0 |
| 2025-06-23 16:00:00 | AAPL | Stock | 201.55 | 201.64 | 201.3063 | 201.41 | 10701696.0 |
| 2025-06-23 16:30:00 | AAPL | Stock | 201.45 | 201.5 | 201.3 | 201.4 | 28084.0 |
| 2025-06-23 17:00:00 | AAPL | Stock | 201.3608 | 201.37 | 201.26 | 201.26 | 12544.0 |
| 2025-06-23 17:30:00 | AAPL | Stock | 201.29 | 201.32 | 201.15 | 201.311 | 8884.0 |
| 2025-06-23 18:00:00 | AAPL | Stock | 201.2701 | 202.49 | 201.27 | 202.3501 | 120683.0 |
| 2025-06-23 18:30:00 | AAPL | Stock | 202.35 | 202.49 | 202.15 | 202.38 | 40347.0 |
| 2025-06-23 19:00:00 | AAPL | Stock | 202.26 | 202.5968 | 202.17 | 202.5 | 43601.0 |
| 2025-06-23 19:30:00 | AAPL | Stock | 202.55 | 202.55 | 202.3 | 202.38 | 25235.0 |
| 2025-06-23 04:00:00 | MSFT | Stock | 475.0 | 477.92 | 475.0 | 477.77 | 1526.0 |
| 2025-06-23 04:30:00 | MSFT | Stock | 477.97 | 478.33 | 477.82 | 477.82 | 1366.0 |
| 2025-06-23 05:00:00 | MSFT | Stock | 477.77 | 477.81 | 477.65 | 477.74 | 1324.0 |
| 2025-06-23 05:30:00 | MSFT | Stock | 477.73 | 477.73 | 477.5 | 477.5 | 819.0 |
| 2025-06-23 06:00:00 | MSFT | Stock | 477.19 | 477.78 | 477.15 | 477.15 | 911.0 |
| 2025-06-23 06:30:00 | MSFT | Stock | 476.94 | 477.11 | 476.6 | 476.96 | 1841.0 |
| 2025-06-23 07:00:00 | MSFT | Stock | 476.74 | 476.74 | 476.21 | 476.4 | 1473.0 |
| 2025-06-23 07:30:00 | MSFT | Stock | 476.35 | 476.96 | 476.03 | 476.96 | 3186.0 |
| 2025-06-23 08:00:00 | MSFT | Stock | 476.27 | 477.81 | 475.06 | 476.48 | 15624.0 |
| 2025-06-23 08:30:00 | MSFT | Stock | 476.43 | 477.14 | 476.27 | 477.14 | 6549.0 |
| 2025-06-23 09:00:00 | MSFT | Stock | 477.01 | 478.0 | 476.51 | 478.0 | 27781.0 |
| 2025-06-23 09:30:00 | MSFT | Stock | 478.21 | 478.21 | 472.51 | 475.39 | 1733345.0 |
| 2025-06-23 10:00:00 | MSFT | Stock | 475.415 | 476.81 | 475.415 | 475.65 | 836741.0 |
| 2025-06-23 10:30:00 | MSFT | Stock | 475.65 | 477.13 | 475.27 | 476.91 | 874357.0 |
| 2025-06-23 11:00:00 | MSFT | Stock | 476.92 | 479.542 | 476.86 | 478.8367 | 853884.0 |
| 2025-06-23 11:30:00 | MSFT | Stock | 478.88 | 481.3 | 478.74 | 480.09 | 802690.0 |
| 2025-06-23 12:00:00 | MSFT | Stock | 480.065 | 481.64 | 479.82 | 480.63 | 739440.0 |
| 2025-06-23 12:30:00 | MSFT | Stock | 480.6 | 481.8599 | 478.7 | 481.02 | 666274.0 |
> showing 50 of 109,528 rows — these rows as CSV