PREVIEW / stock_30min / 2025-06-25
file: by_date/stock_30min/2025/2025-06-25.parquet size: 2.2 MB rows: 104,655 symbols: 390
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-25 04:00:00 | AAPL | Stock | 201.0 | 201.1 | 200.87 | 201.1 | 9178.0 |
| 2025-06-25 04:30:00 | AAPL | Stock | 200.94 | 201.25 | 200.86 | 201.25 | 3362.0 |
| 2025-06-25 05:00:00 | AAPL | Stock | 201.25 | 201.31 | 201.16 | 201.16 | 5608.0 |
| 2025-06-25 05:30:00 | AAPL | Stock | 201.09 | 201.3 | 201.09 | 201.21 | 2653.0 |
| 2025-06-25 06:00:00 | AAPL | Stock | 201.15 | 201.3 | 201.09 | 201.1 | 7965.0 |
| 2025-06-25 06:30:00 | AAPL | Stock | 201.15 | 201.71 | 201.13 | 201.18 | 19011.0 |
| 2025-06-25 07:00:00 | AAPL | Stock | 201.17 | 201.22 | 201.02 | 201.11 | 20567.0 |
| 2025-06-25 07:30:00 | AAPL | Stock | 201.11 | 201.24 | 200.92 | 201.21 | 18452.0 |
| 2025-06-25 08:00:00 | AAPL | Stock | 201.1 | 201.5 | 199.8 | 201.3 | 129450.0 |
| 2025-06-25 08:30:00 | AAPL | Stock | 201.3 | 201.4 | 201.15 | 201.39 | 45052.0 |
| 2025-06-25 09:00:00 | AAPL | Stock | 201.39 | 201.62 | 201.05 | 201.4 | 102532.0 |
| 2025-06-25 09:30:00 | AAPL | Stock | 201.45 | 203.67 | 201.2 | 201.8 | 5770204.0 |
| 2025-06-25 10:00:00 | AAPL | Stock | 201.76 | 202.45 | 201.24 | 202.44 | 2344845.0 |
| 2025-06-25 10:30:00 | AAPL | Stock | 202.44 | 203.175 | 202.26 | 202.455 | 2411434.0 |
| 2025-06-25 11:00:00 | AAPL | Stock | 202.44 | 202.56 | 201.95 | 202.1 | 1443121.0 |
| 2025-06-25 11:30:00 | AAPL | Stock | 202.12 | 202.17 | 201.8276 | 201.98 | 1091983.0 |
| 2025-06-25 12:00:00 | AAPL | Stock | 201.99 | 202.1298 | 201.4 | 201.88 | 1061165.0 |
| 2025-06-25 12:30:00 | AAPL | Stock | 201.88 | 202.1999 | 201.68 | 202.055 | 943954.0 |
| 2025-06-25 13:00:00 | AAPL | Stock | 202.06 | 202.09 | 201.09 | 201.14 | 1116360.0 |
| 2025-06-25 13:30:00 | AAPL | Stock | 201.15 | 201.28 | 200.6201 | 200.9999 | 1552303.0 |
| 2025-06-25 14:00:00 | AAPL | Stock | 201.0 | 201.11 | 200.8558 | 201.02 | 742387.0 |
| 2025-06-25 14:30:00 | AAPL | Stock | 201.02 | 201.5 | 200.95 | 201.07 | 892045.0 |
| 2025-06-25 15:00:00 | AAPL | Stock | 201.07 | 201.38 | 201.01 | 201.1598 | 1308502.0 |
| 2025-06-25 15:30:00 | AAPL | Stock | 201.14 | 201.62 | 200.885 | 201.6 | 2841403.0 |
| 2025-06-25 16:00:00 | AAPL | Stock | 201.56 | 201.74 | 201.1501 | 201.26 | 4457646.0 |
| 2025-06-25 16:30:00 | AAPL | Stock | 201.26 | 201.56 | 201.2401 | 201.4 | 196600.0 |
| 2025-06-25 17:00:00 | AAPL | Stock | 201.42 | 201.52 | 201.33 | 201.33 | 7922.0 |
| 2025-06-25 17:30:00 | AAPL | Stock | 201.36 | 201.4 | 201.29 | 201.29 | 14715.0 |
| 2025-06-25 18:00:00 | AAPL | Stock | 201.3 | 201.4991 | 201.27 | 201.44 | 9312.0 |
| 2025-06-25 18:30:00 | AAPL | Stock | 201.41 | 201.46 | 201.36 | 201.39 | 9817.0 |
| 2025-06-25 19:00:00 | AAPL | Stock | 201.4 | 201.46 | 201.33 | 201.45 | 12868.0 |
| 2025-06-25 19:30:00 | AAPL | Stock | 201.46 | 201.74 | 201.4 | 201.74 | 26827.0 |
| 2025-06-25 04:00:00 | MSFT | Stock | 490.07 | 490.07 | 489.59 | 489.77 | 1864.0 |
| 2025-06-25 04:30:00 | MSFT | Stock | 489.71 | 489.94 | 489.71 | 489.94 | 562.0 |
| 2025-06-25 05:00:00 | MSFT | Stock | 489.77 | 489.77 | 489.45 | 489.5 | 554.0 |
| 2025-06-25 05:30:00 | MSFT | Stock | 489.36 | 489.36 | 488.93 | 489.19 | 512.0 |
| 2025-06-25 06:00:00 | MSFT | Stock | 489.34 | 493.61 | 489.34 | 492.98 | 23151.0 |
| 2025-06-25 06:30:00 | MSFT | Stock | 491.81 | 492.1 | 490.86 | 491.5 | 5897.0 |
| 2025-06-25 07:00:00 | MSFT | Stock | 491.19 | 491.63 | 491.03 | 491.35 | 3950.0 |
| 2025-06-25 07:30:00 | MSFT | Stock | 491.38 | 491.7 | 491.32 | 491.32 | 2016.0 |
| 2025-06-25 08:00:00 | MSFT | Stock | 491.7 | 492.64 | 488.885 | 492.2009 | 26174.0 |
| 2025-06-25 08:30:00 | MSFT | Stock | 492.25 | 492.42 | 491.8 | 491.981 | 10283.0 |
| 2025-06-25 09:00:00 | MSFT | Stock | 491.85 | 492.4 | 491.03 | 492.04 | 17624.0 |
| 2025-06-25 09:30:00 | MSFT | Stock | 492.04 | 494.1504 | 491.61 | 493.54 | 1606918.0 |
| 2025-06-25 10:00:00 | MSFT | Stock | 493.455 | 494.5556 | 492.96 | 493.645 | 771278.0 |
| 2025-06-25 10:30:00 | MSFT | Stock | 493.62 | 493.96 | 492.75 | 492.9575 | 470308.0 |
| 2025-06-25 11:00:00 | MSFT | Stock | 492.92 | 493.1 | 492.4 | 492.59 | 446220.0 |
| 2025-06-25 11:30:00 | MSFT | Stock | 492.57 | 492.765 | 491.56 | 491.72 | 364544.0 |
| 2025-06-25 12:00:00 | MSFT | Stock | 491.71 | 491.91 | 491.15 | 491.6 | 332364.0 |
| 2025-06-25 12:30:00 | MSFT | Stock | 491.63 | 491.6599 | 490.21 | 490.73 | 400383.0 |
> showing 50 of 104,655 rows — these rows as CSV