PREVIEW / stock_30min / 2025-06-04
file: by_date/stock_30min/2025/2025-06-04.parquet size: 2.2 MB rows: 103,637 symbols: 405
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-04 04:00:00 | AAPL | Stock | 203.07 | 203.55 | 203.07 | 203.4 | 8527.0 |
| 2025-06-04 04:30:00 | AAPL | Stock | 203.39 | 203.45 | 203.17 | 203.22 | 3337.0 |
| 2025-06-04 05:00:00 | AAPL | Stock | 203.33 | 203.37 | 203.29 | 203.34 | 2294.0 |
| 2025-06-04 05:30:00 | AAPL | Stock | 203.25 | 203.46 | 203.25 | 203.38 | 5336.0 |
| 2025-06-04 06:00:00 | AAPL | Stock | 203.49 | 203.8 | 201.0 | 201.95 | 106730.0 |
| 2025-06-04 06:30:00 | AAPL | Stock | 201.94 | 202.14 | 201.62 | 202.08 | 43700.0 |
| 2025-06-04 07:00:00 | AAPL | Stock | 202.15 | 202.37 | 202.02 | 202.26 | 31780.0 |
| 2025-06-04 07:30:00 | AAPL | Stock | 202.18 | 202.85 | 202.17 | 202.5 | 28856.0 |
| 2025-06-04 08:00:00 | AAPL | Stock | 202.25 | 203.76 | 201.61 | 202.2 | 149486.0 |
| 2025-06-04 08:30:00 | AAPL | Stock | 202.18 | 202.6 | 202.0 | 202.48 | 69891.0 |
| 2025-06-04 09:00:00 | AAPL | Stock | 202.53 | 203.0 | 202.3 | 203.0 | 94803.0 |
| 2025-06-04 09:30:00 | AAPL | Stock | 202.97 | 205.36 | 202.6508 | 205.06 | 5031447.0 |
| 2025-06-04 10:00:00 | AAPL | Stock | 205.06 | 206.24 | 204.6 | 205.14 | 3863081.0 |
| 2025-06-04 10:30:00 | AAPL | Stock | 205.13 | 205.18 | 203.9901 | 204.28 | 1705788.0 |
| 2025-06-04 11:00:00 | AAPL | Stock | 204.289 | 204.71 | 204.09 | 204.09 | 1573208.0 |
| 2025-06-04 11:30:00 | AAPL | Stock | 204.09 | 204.6 | 202.1 | 203.36 | 4140926.0 |
| 2025-06-04 12:00:00 | AAPL | Stock | 203.35 | 203.39 | 202.82 | 202.83 | 1422532.0 |
| 2025-06-04 12:30:00 | AAPL | Stock | 202.82 | 203.27 | 202.61 | 203.2 | 944286.0 |
| 2025-06-04 13:00:00 | AAPL | Stock | 203.22 | 203.59 | 203.2 | 203.415 | 1031228.0 |
| 2025-06-04 13:30:00 | AAPL | Stock | 203.415 | 203.47 | 202.85 | 203.29 | 1057879.0 |
| 2025-06-04 14:00:00 | AAPL | Stock | 203.29 | 203.45 | 203.08 | 203.12 | 851014.0 |
| 2025-06-04 14:30:00 | AAPL | Stock | 203.11 | 203.13 | 202.76 | 202.935 | 973279.0 |
| 2025-06-04 15:00:00 | AAPL | Stock | 202.93 | 203.25 | 202.87 | 203.19 | 1191958.0 |
| 2025-06-04 15:30:00 | AAPL | Stock | 203.19 | 203.4477 | 202.75 | 202.887 | 2742601.0 |
| 2025-06-04 16:00:00 | AAPL | Stock | 202.82 | 203.11 | 202.71 | 202.86 | 4126815.0 |
| 2025-06-04 16:30:00 | AAPL | Stock | 202.9 | 202.94 | 202.4 | 202.51 | 51979.0 |
| 2025-06-04 17:00:00 | AAPL | Stock | 202.5 | 202.5 | 202.02 | 202.02 | 37973.0 |
| 2025-06-04 17:30:00 | AAPL | Stock | 202.02 | 202.02 | 200.55 | 200.9 | 160648.0 |
| 2025-06-04 18:00:00 | AAPL | Stock | 200.97 | 201.6 | 200.9016 | 201.55 | 47606.0 |
| 2025-06-04 18:30:00 | AAPL | Stock | 201.54 | 201.7 | 201.4 | 201.52 | 22543.0 |
| 2025-06-04 19:00:00 | AAPL | Stock | 201.5101 | 201.7 | 201.46 | 201.67 | 8390.0 |
| 2025-06-04 19:30:00 | AAPL | Stock | 201.63 | 201.9 | 201.6 | 201.8601 | 21569.0 |
| 2025-06-04 04:00:00 | MSFT | Stock | 462.11 | 462.6 | 461.92 | 462.45 | 2224.0 |
| 2025-06-04 04:30:00 | MSFT | Stock | 462.41 | 462.6 | 462.2 | 462.2 | 1810.0 |
| 2025-06-04 05:00:00 | MSFT | Stock | 462.3 | 462.76 | 462.3 | 462.76 | 1583.0 |
| 2025-06-04 05:30:00 | MSFT | Stock | 462.62 | 462.67 | 462.4 | 462.4 | 1176.0 |
| 2025-06-04 06:00:00 | MSFT | Stock | 462.6 | 463.3 | 462.6 | 463.25 | 6783.0 |
| 2025-06-04 06:30:00 | MSFT | Stock | 463.15 | 463.45 | 462.97 | 462.97 | 2603.0 |
| 2025-06-04 07:00:00 | MSFT | Stock | 463.19 | 463.19 | 462.9 | 463.05 | 2988.0 |
| 2025-06-04 07:30:00 | MSFT | Stock | 462.9 | 463.25 | 462.9 | 463.06 | 1118.0 |
| 2025-06-04 08:00:00 | MSFT | Stock | 463.05 | 463.45 | 461.813 | 462.2 | 34897.0 |
| 2025-06-04 08:30:00 | MSFT | Stock | 462.2 | 462.64 | 462.1387 | 462.4001 | 2077.0 |
| 2025-06-04 09:00:00 | MSFT | Stock | 462.84 | 464.3 | 462.84 | 464.0 | 16361.0 |
| 2025-06-04 09:30:00 | MSFT | Stock | 463.8 | 465.65 | 463.0201 | 465.59 | 1300382.0 |
| 2025-06-04 10:00:00 | MSFT | Stock | 465.5 | 465.69 | 464.1 | 464.9201 | 663030.0 |
| 2025-06-04 10:30:00 | MSFT | Stock | 464.92 | 465.0399 | 463.77 | 464.8 | 514924.0 |
| 2025-06-04 11:00:00 | MSFT | Stock | 464.87 | 465.15 | 464.61 | 464.6319 | 379927.0 |
| 2025-06-04 11:30:00 | MSFT | Stock | 464.66 | 465.11 | 464.39 | 464.765 | 253695.0 |
| 2025-06-04 12:00:00 | MSFT | Stock | 464.73 | 464.9 | 463.74 | 463.76 | 329314.0 |
| 2025-06-04 12:30:00 | MSFT | Stock | 463.74 | 464.42 | 463.655 | 464.19 | 280377.0 |
> showing 50 of 103,637 rows — these rows as CSV