PREVIEW / stock_30min / 2025-11-20
file: by_date/stock_30min/2025/2025-11-20.parquet size: 2.2 MB rows: 105,350 symbols: 210
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-11-20 04:00:00 | AAPL | Stock | 269.55 | 269.8 | 269.1 | 269.15 | 5204.0 |
| 2025-11-20 04:30:00 | AAPL | Stock | 269.31 | 269.31 | 268.8 | 269.26 | 2620.0 |
| 2025-11-20 05:00:00 | AAPL | Stock | 269.18 | 269.79 | 268.97 | 269.39 | 3756.0 |
| 2025-11-20 05:30:00 | AAPL | Stock | 269.43 | 269.8 | 269.43 | 269.71 | 2155.0 |
| 2025-11-20 06:00:00 | AAPL | Stock | 269.5 | 269.59 | 269.38 | 269.54 | 1386.0 |
| 2025-11-20 06:30:00 | AAPL | Stock | 269.65 | 269.98 | 269.3 | 269.35 | 6860.0 |
| 2025-11-20 07:00:00 | AAPL | Stock | 269.4 | 269.84 | 269.4 | 269.71 | 5358.0 |
| 2025-11-20 07:30:00 | AAPL | Stock | 269.8 | 270.0 | 269.75 | 270.0 | 6400.0 |
| 2025-11-20 08:00:00 | AAPL | Stock | 269.5 | 270.3 | 269.1006 | 269.58 | 61354.0 |
| 2025-11-20 08:30:00 | AAPL | Stock | 269.8 | 270.9 | 269.8 | 270.4 | 57671.0 |
| 2025-11-20 09:00:00 | AAPL | Stock | 270.2487 | 270.92 | 269.8 | 270.92 | 56789.0 |
| 2025-11-20 09:30:00 | AAPL | Stock | 270.92 | 275.43 | 270.81 | 275.0 | 6504698.0 |
| 2025-11-20 10:00:00 | AAPL | Stock | 274.955 | 275.1 | 273.095 | 273.905 | 1686778.0 |
| 2025-11-20 10:30:00 | AAPL | Stock | 273.91 | 274.73 | 273.19 | 273.54 | 1438055.0 |
| 2025-11-20 11:00:00 | AAPL | Stock | 273.6 | 273.6 | 271.6 | 271.78 | 1319215.0 |
| 2025-11-20 11:30:00 | AAPL | Stock | 271.77 | 271.78 | 268.98 | 269.349 | 1543450.0 |
| 2025-11-20 12:00:00 | AAPL | Stock | 269.32 | 270.0 | 268.04 | 268.89 | 2145637.0 |
| 2025-11-20 12:30:00 | AAPL | Stock | 268.87 | 269.25 | 267.0201 | 267.48 | 1453532.0 |
| 2025-11-20 13:00:00 | AAPL | Stock | 267.51 | 269.21 | 267.31 | 268.81 | 1273554.0 |
| 2025-11-20 13:30:00 | AAPL | Stock | 268.79 | 268.93 | 266.52 | 266.94 | 1123509.0 |
| 2025-11-20 14:00:00 | AAPL | Stock | 266.96 | 268.07 | 266.36 | 267.795 | 1025820.0 |
| 2025-11-20 14:30:00 | AAPL | Stock | 267.78 | 267.91 | 267.01 | 267.805 | 769112.0 |
| 2025-11-20 15:00:00 | AAPL | Stock | 267.81 | 267.88 | 266.985 | 267.32 | 1137489.0 |
| 2025-11-20 15:30:00 | AAPL | Stock | 267.31 | 267.58 | 265.92 | 266.38 | 3375628.0 |
| 2025-11-20 16:00:00 | AAPL | Stock | 266.25 | 266.25 | 265.31 | 265.69 | 6168478.0 |
| 2025-11-20 16:30:00 | AAPL | Stock | 265.67 | 266.25 | 265.25 | 265.25 | 48190.0 |
| 2025-11-20 17:00:00 | AAPL | Stock | 265.21 | 265.8608 | 265.0 | 265.73 | 20705.0 |
| 2025-11-20 17:30:00 | AAPL | Stock | 265.8 | 266.2 | 265.7 | 266.2 | 25952.0 |
| 2025-11-20 18:00:00 | AAPL | Stock | 266.2 | 266.99 | 265.5 | 266.3 | 17099.0 |
| 2025-11-20 18:30:00 | AAPL | Stock | 266.31 | 267.27 | 265.76 | 266.25 | 31090.0 |
| 2025-11-20 19:00:00 | AAPL | Stock | 266.45 | 267.28 | 266.45 | 266.88 | 3910.0 |
| 2025-11-20 19:30:00 | AAPL | Stock | 266.53 | 267.28 | 266.53 | 266.9 | 6949.0 |
| 2025-11-20 04:00:00 | MSFT | Stock | 492.99 | 493.48 | 489.94 | 490.0 | 15880.0 |
| 2025-11-20 04:30:00 | MSFT | Stock | 490.0 | 491.15 | 489.52 | 490.06 | 6070.0 |
| 2025-11-20 05:00:00 | MSFT | Stock | 490.31 | 490.99 | 490.12 | 490.64 | 9252.0 |
| 2025-11-20 05:30:00 | MSFT | Stock | 490.75 | 491.28 | 490.66 | 491.25 | 2861.0 |
| 2025-11-20 06:00:00 | MSFT | Stock | 491.19 | 491.4 | 490.1 | 490.56 | 6979.0 |
| 2025-11-20 06:30:00 | MSFT | Stock | 490.61 | 491.61 | 490.61 | 491.5 | 6736.0 |
| 2025-11-20 07:00:00 | MSFT | Stock | 491.56 | 493.0 | 491.0 | 492.45 | 7486.0 |
| 2025-11-20 07:30:00 | MSFT | Stock | 492.37 | 493.81 | 492.37 | 493.4 | 10408.0 |
| 2025-11-20 08:00:00 | MSFT | Stock | 492.0 | 494.4111 | 490.03 | 492.18 | 82697.0 |
| 2025-11-20 08:30:00 | MSFT | Stock | 492.79 | 493.9817 | 492.0 | 493.01 | 70158.0 |
| 2025-11-20 09:00:00 | MSFT | Stock | 492.97 | 493.48 | 491.8 | 492.68 | 64778.0 |
| 2025-11-20 09:30:00 | MSFT | Stock | 492.81 | 493.28 | 489.8 | 492.93 | 2494825.0 |
| 2025-11-20 10:00:00 | MSFT | Stock | 492.93 | 493.57 | 491.44 | 492.81 | 1055126.0 |
| 2025-11-20 10:30:00 | MSFT | Stock | 492.82 | 493.11 | 490.52 | 490.72 | 834693.0 |
| 2025-11-20 11:00:00 | MSFT | Stock | 490.73 | 490.78 | 485.96 | 486.67 | 1215224.0 |
| 2025-11-20 11:30:00 | MSFT | Stock | 486.6 | 487.2 | 482.22 | 482.415 | 859505.0 |
| 2025-11-20 12:00:00 | MSFT | Stock | 482.36 | 483.3029 | 480.31 | 481.77 | 1507082.0 |
| 2025-11-20 12:30:00 | MSFT | Stock | 481.79 | 482.6134 | 479.19 | 480.445 | 1131385.0 |
> showing 50 of 105,350 rows — these rows as CSV