PREVIEW / stock_30min / 2025-08-04
file: by_date/stock_30min/2025/2025-08-04.parquet size: 2.2 MB rows: 107,741 symbols: 354
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-08-04 04:00:00 | AAPL | Stock | 203.02 | 203.91 | 203.02 | 203.91 | 36745.0 |
| 2025-08-04 04:30:00 | AAPL | Stock | 203.91 | 204.12 | 203.75 | 204.12 | 17130.0 |
| 2025-08-04 05:00:00 | AAPL | Stock | 204.12 | 204.36 | 204.12 | 204.15 | 7957.0 |
| 2025-08-04 05:30:00 | AAPL | Stock | 204.18 | 204.3 | 203.9 | 203.95 | 11703.0 |
| 2025-08-04 06:00:00 | AAPL | Stock | 203.88 | 204.13 | 203.88 | 203.97 | 22578.0 |
| 2025-08-04 06:30:00 | AAPL | Stock | 203.92 | 204.11 | 203.82 | 203.88 | 7405.0 |
| 2025-08-04 07:00:00 | AAPL | Stock | 203.83 | 203.97 | 203.4 | 203.69 | 25210.0 |
| 2025-08-04 07:30:00 | AAPL | Stock | 203.72 | 203.98 | 203.72 | 203.89 | 14678.0 |
| 2025-08-04 08:00:00 | AAPL | Stock | 203.7 | 204.43 | 202.92 | 203.82 | 142410.0 |
| 2025-08-04 08:30:00 | AAPL | Stock | 203.92 | 204.1405 | 203.82 | 203.8244 | 66669.0 |
| 2025-08-04 09:00:00 | AAPL | Stock | 203.92 | 204.75 | 203.57 | 204.5 | 155785.0 |
| 2025-08-04 09:30:00 | AAPL | Stock | 204.46 | 206.31 | 204.195 | 206.17 | 6624732.0 |
| 2025-08-04 10:00:00 | AAPL | Stock | 206.195 | 206.84 | 205.93 | 206.76 | 3094200.0 |
| 2025-08-04 10:30:00 | AAPL | Stock | 206.76 | 207.88 | 206.06 | 207.195 | 4539266.0 |
| 2025-08-04 11:00:00 | AAPL | Stock | 207.195 | 207.4145 | 205.74 | 205.77 | 2335891.0 |
| 2025-08-04 11:30:00 | AAPL | Stock | 205.76 | 205.88 | 205.265 | 205.29 | 1946408.0 |
| 2025-08-04 12:00:00 | AAPL | Stock | 205.3 | 205.5099 | 203.93 | 203.9309 | 2604110.0 |
| 2025-08-04 12:30:00 | AAPL | Stock | 203.94 | 204.39 | 203.865 | 204.13 | 2334552.0 |
| 2025-08-04 13:00:00 | AAPL | Stock | 204.1434 | 204.48 | 203.94 | 204.15 | 1686585.0 |
| 2025-08-04 13:30:00 | AAPL | Stock | 204.14 | 204.2027 | 203.57 | 203.7114 | 1650824.0 |
| 2025-08-04 14:00:00 | AAPL | Stock | 203.72 | 204.22 | 203.41 | 203.43 | 2019075.0 |
| 2025-08-04 14:30:00 | AAPL | Stock | 203.44 | 203.5354 | 202.07 | 202.59 | 2979118.0 |
| 2025-08-04 15:00:00 | AAPL | Stock | 202.59 | 203.085 | 202.27 | 202.325 | 3419400.0 |
| 2025-08-04 15:30:00 | AAPL | Stock | 202.33 | 203.45 | 201.675 | 203.34 | 6441109.0 |
| 2025-08-04 16:00:00 | AAPL | Stock | 203.35 | 204.0842 | 202.88 | 203.389 | 6031283.0 |
| 2025-08-04 16:30:00 | AAPL | Stock | 203.39 | 203.49 | 203.29 | 203.49 | 52575.0 |
| 2025-08-04 17:00:00 | AAPL | Stock | 203.43 | 203.49 | 203.35 | 203.45 | 23662.0 |
| 2025-08-04 17:30:00 | AAPL | Stock | 203.49 | 203.49 | 203.36 | 203.36 | 26363.0 |
| 2025-08-04 18:00:00 | AAPL | Stock | 203.42 | 203.45 | 203.27 | 203.3 | 15705.0 |
| 2025-08-04 18:30:00 | AAPL | Stock | 203.4 | 203.4 | 203.2601 | 203.35 | 8177.0 |
| 2025-08-04 19:00:00 | AAPL | Stock | 203.36 | 203.45 | 203.24 | 203.28 | 23947.0 |
| 2025-08-04 19:30:00 | AAPL | Stock | 203.38 | 203.38 | 203.14 | 203.25 | 22739.0 |
| 2025-08-04 04:00:00 | MSFT | Stock | 528.52 | 528.61 | 527.99 | 528.18 | 10263.0 |
| 2025-08-04 04:30:00 | MSFT | Stock | 528.0 | 528.5 | 528.0 | 528.4 | 5821.0 |
| 2025-08-04 05:00:00 | MSFT | Stock | 528.39 | 528.5 | 528.25 | 528.3 | 5558.0 |
| 2025-08-04 05:30:00 | MSFT | Stock | 528.5 | 528.5 | 528.1 | 528.1 | 2632.0 |
| 2025-08-04 06:00:00 | MSFT | Stock | 528.15 | 528.31 | 527.67 | 528.1 | 4153.0 |
| 2025-08-04 06:30:00 | MSFT | Stock | 528.1 | 528.3 | 527.9 | 528.0 | 4192.0 |
| 2025-08-04 07:00:00 | MSFT | Stock | 528.04 | 528.05 | 527.5 | 527.6 | 11288.0 |
| 2025-08-04 07:30:00 | MSFT | Stock | 527.87 | 528.0 | 527.5 | 527.87 | 3918.0 |
| 2025-08-04 08:00:00 | MSFT | Stock | 528.0 | 529.5 | 522.8 | 527.79 | 22960.0 |
| 2025-08-04 08:30:00 | MSFT | Stock | 527.9 | 528.1 | 527.76 | 528.0999 | 9437.0 |
| 2025-08-04 09:00:00 | MSFT | Stock | 528.1 | 528.3 | 526.54 | 528.0 | 129605.0 |
| 2025-08-04 09:30:00 | MSFT | Stock | 528.27 | 536.4 | 528.13 | 536.2525 | 2531025.0 |
| 2025-08-04 10:00:00 | MSFT | Stock | 536.2 | 536.46 | 534.3176 | 535.0468 | 972191.0 |
| 2025-08-04 10:30:00 | MSFT | Stock | 535.015 | 536.9 | 533.97 | 534.6065 | 977827.0 |
| 2025-08-04 11:00:00 | MSFT | Stock | 534.61 | 534.85 | 533.19 | 533.63 | 656323.0 |
| 2025-08-04 11:30:00 | MSFT | Stock | 533.62 | 535.56 | 533.3 | 535.39 | 686363.0 |
| 2025-08-04 12:00:00 | MSFT | Stock | 535.395 | 537.31 | 535.26 | 536.73 | 720281.0 |
| 2025-08-04 12:30:00 | MSFT | Stock | 536.79 | 537.39 | 536.56 | 537.09 | 470249.0 |
> showing 50 of 107,741 rows — these rows as CSV