PREVIEW / stock_30min / 2025-05-29
file: by_date/stock_30min/2025/2025-05-29.parquet size: 2.2 MB rows: 103,456 symbols: 406
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-05-29 04:00:00 | AAPL | Stock | 207.3 | 207.9 | 206.65 | 207.0 | 108232.0 |
| 2025-05-29 04:30:00 | AAPL | Stock | 206.85 | 207.1 | 206.72 | 206.97 | 43904.0 |
| 2025-05-29 05:00:00 | AAPL | Stock | 206.93 | 207.34 | 206.9 | 207.08 | 11902.0 |
| 2025-05-29 05:30:00 | AAPL | Stock | 207.06 | 207.13 | 206.59 | 206.59 | 25990.0 |
| 2025-05-29 06:00:00 | AAPL | Stock | 206.5 | 206.58 | 205.4 | 205.82 | 53018.0 |
| 2025-05-29 06:30:00 | AAPL | Stock | 205.92 | 206.1 | 205.5 | 205.69 | 29327.0 |
| 2025-05-29 07:00:00 | AAPL | Stock | 205.78 | 206.0 | 204.5 | 204.69 | 88190.0 |
| 2025-05-29 07:30:00 | AAPL | Stock | 204.7 | 205.29 | 204.57 | 205.05 | 70603.0 |
| 2025-05-29 08:00:00 | AAPL | Stock | 205.5 | 207.42 | 203.79 | 204.7 | 424916.0 |
| 2025-05-29 08:30:00 | AAPL | Stock | 204.86 | 205.18 | 203.6 | 203.84 | 135984.0 |
| 2025-05-29 09:00:00 | AAPL | Stock | 203.8399 | 204.4899 | 203.39 | 203.49 | 301206.0 |
| 2025-05-29 09:30:00 | AAPL | Stock | 203.62 | 203.81 | 201.0 | 201.345 | 5741715.0 |
| 2025-05-29 10:00:00 | AAPL | Stock | 201.33 | 201.67 | 200.76 | 201.14 | 2732807.0 |
| 2025-05-29 10:30:00 | AAPL | Stock | 201.13 | 201.65 | 200.87 | 201.46 | 1939327.0 |
| 2025-05-29 11:00:00 | AAPL | Stock | 201.45 | 201.4899 | 200.55 | 200.74 | 1934384.0 |
| 2025-05-29 11:30:00 | AAPL | Stock | 200.74 | 200.8 | 198.7 | 198.865 | 2742613.0 |
| 2025-05-29 12:00:00 | AAPL | Stock | 198.86 | 199.75 | 198.51 | 199.42 | 1914880.0 |
| 2025-05-29 12:30:00 | AAPL | Stock | 199.41 | 200.205 | 199.4 | 200.1 | 1451994.0 |
| 2025-05-29 13:00:00 | AAPL | Stock | 200.09 | 200.45 | 199.92 | 199.975 | 1618464.0 |
| 2025-05-29 13:30:00 | AAPL | Stock | 199.96 | 200.17 | 199.06 | 199.21 | 1523253.0 |
| 2025-05-29 14:00:00 | AAPL | Stock | 199.205 | 199.77 | 199.04 | 199.04 | 1438189.0 |
| 2025-05-29 14:30:00 | AAPL | Stock | 199.04 | 199.57 | 198.76 | 198.92 | 1616480.0 |
| 2025-05-29 15:00:00 | AAPL | Stock | 198.915 | 199.45 | 198.57 | 199.1393 | 2126800.0 |
| 2025-05-29 15:30:00 | AAPL | Stock | 199.125 | 200.31 | 199.08 | 199.94 | 3768001.0 |
| 2025-05-29 16:00:00 | AAPL | Stock | 199.93 | 200.0 | 199.63 | 199.81 | 6433975.0 |
| 2025-05-29 16:30:00 | AAPL | Stock | 199.85 | 199.99 | 199.78 | 199.88 | 23544.0 |
| 2025-05-29 17:00:00 | AAPL | Stock | 199.8798 | 199.88 | 199.3 | 199.35 | 33926.0 |
| 2025-05-29 17:30:00 | AAPL | Stock | 199.38 | 199.4956 | 199.3 | 199.3898 | 14961.0 |
| 2025-05-29 18:00:00 | AAPL | Stock | 199.37 | 199.61 | 199.25 | 199.4372 | 27727.0 |
| 2025-05-29 18:30:00 | AAPL | Stock | 199.35 | 199.42 | 199.2401 | 199.25 | 12385.0 |
| 2025-05-29 19:00:00 | AAPL | Stock | 199.24 | 199.44 | 199.24 | 199.44 | 10743.0 |
| 2025-05-29 19:30:00 | AAPL | Stock | 199.44 | 199.44 | 199.0 | 199.0 | 27132.0 |
| 2025-05-29 04:00:00 | MSFT | Stock | 461.89 | 462.53 | 461.66 | 461.78 | 4203.0 |
| 2025-05-29 04:30:00 | MSFT | Stock | 461.87 | 462.15 | 461.5 | 461.98 | 1576.0 |
| 2025-05-29 05:00:00 | MSFT | Stock | 461.98 | 461.98 | 461.0 | 461.08 | 3005.0 |
| 2025-05-29 05:30:00 | MSFT | Stock | 460.7 | 461.3 | 460.68 | 460.9 | 2185.0 |
| 2025-05-29 06:00:00 | MSFT | Stock | 460.15 | 460.56 | 459.9 | 460.56 | 2091.0 |
| 2025-05-29 06:30:00 | MSFT | Stock | 459.92 | 460.3 | 459.92 | 460.3 | 541.0 |
| 2025-05-29 07:00:00 | MSFT | Stock | 460.68 | 461.45 | 460.68 | 460.71 | 4929.0 |
| 2025-05-29 07:30:00 | MSFT | Stock | 460.4 | 460.9 | 460.0 | 460.54 | 4943.0 |
| 2025-05-29 08:00:00 | MSFT | Stock | 460.9 | 462.39 | 460.01 | 460.88 | 29785.0 |
| 2025-05-29 08:30:00 | MSFT | Stock | 461.0 | 461.15 | 460.1 | 460.97 | 12720.0 |
| 2025-05-29 09:00:00 | MSFT | Stock | 460.8 | 461.89 | 460.71 | 461.65 | 12010.0 |
| 2025-05-29 09:30:00 | MSFT | Stock | 461.55 | 461.72 | 458.4353 | 458.745 | 975644.0 |
| 2025-05-29 10:00:00 | MSFT | Stock | 458.69 | 458.9 | 456.76 | 458.77 | 418293.0 |
| 2025-05-29 10:30:00 | MSFT | Stock | 458.77 | 459.84 | 458.43 | 459.725 | 333722.0 |
| 2025-05-29 11:00:00 | MSFT | Stock | 459.725 | 459.96 | 458.2603 | 459.27 | 338486.0 |
| 2025-05-29 11:30:00 | MSFT | Stock | 459.27 | 459.45 | 455.69 | 456.05 | 304706.0 |
| 2025-05-29 12:00:00 | MSFT | Stock | 455.91 | 458.85 | 455.3105 | 458.55 | 312640.0 |
| 2025-05-29 12:30:00 | MSFT | Stock | 458.5445 | 459.56 | 458.395 | 459.1085 | 291622.0 |
> showing 50 of 103,456 rows — these rows as CSV