PREVIEW / stock_30min / 2025-07-01
file: by_date/stock_30min/2025/2025-07-01.parquet size: 2.2 MB rows: 106,434 symbols: 387
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-07-01 04:00:00 | AAPL | Stock | 205.5 | 205.55 | 204.61 | 204.93 | 39093.0 |
| 2025-07-01 04:30:00 | AAPL | Stock | 204.99 | 205.59 | 204.99 | 205.42 | 21137.0 |
| 2025-07-01 05:00:00 | AAPL | Stock | 205.45 | 205.51 | 205.28 | 205.3 | 4372.0 |
| 2025-07-01 05:30:00 | AAPL | Stock | 205.28 | 205.41 | 205.16 | 205.41 | 7477.0 |
| 2025-07-01 06:00:00 | AAPL | Stock | 205.42 | 205.66 | 205.42 | 205.53 | 7383.0 |
| 2025-07-01 06:30:00 | AAPL | Stock | 205.56 | 205.76 | 205.56 | 205.76 | 15134.0 |
| 2025-07-01 07:00:00 | AAPL | Stock | 205.72 | 206.23 | 205.7 | 206.19 | 59783.0 |
| 2025-07-01 07:30:00 | AAPL | Stock | 206.17 | 206.57 | 206.07 | 206.27 | 46569.0 |
| 2025-07-01 08:00:00 | AAPL | Stock | 205.8 | 206.6 | 204.44 | 206.4903 | 394325.0 |
| 2025-07-01 08:30:00 | AAPL | Stock | 206.5 | 207.47 | 206.4901 | 207.2 | 372795.0 |
| 2025-07-01 09:00:00 | AAPL | Stock | 207.21 | 207.21 | 205.17 | 206.5 | 200283.0 |
| 2025-07-01 09:30:00 | AAPL | Stock | 206.72 | 209.11 | 206.1401 | 209.0848 | 13370063.0 |
| 2025-07-01 10:00:00 | AAPL | Stock | 209.06 | 209.83 | 208.42 | 209.5401 | 6665988.0 |
| 2025-07-01 10:30:00 | AAPL | Stock | 209.5501 | 209.9 | 207.47 | 208.96 | 5412776.0 |
| 2025-07-01 11:00:00 | AAPL | Stock | 208.96 | 210.1865 | 207.776 | 207.95 | 5965032.0 |
| 2025-07-01 11:30:00 | AAPL | Stock | 207.96 | 208.13 | 206.79 | 207.3029 | 3046137.0 |
| 2025-07-01 12:00:00 | AAPL | Stock | 207.3 | 208.185 | 207.17 | 207.87 | 2350301.0 |
| 2025-07-01 12:30:00 | AAPL | Stock | 207.87 | 208.53 | 207.14 | 207.1754 | 2660030.0 |
| 2025-07-01 13:00:00 | AAPL | Stock | 207.18 | 208.14 | 207.09 | 208.09 | 1829227.0 |
| 2025-07-01 13:30:00 | AAPL | Stock | 208.0889 | 208.37 | 207.61 | 208.15 | 1837163.0 |
| 2025-07-01 14:00:00 | AAPL | Stock | 208.15 | 208.42 | 207.88 | 208.22 | 1598143.0 |
| 2025-07-01 14:30:00 | AAPL | Stock | 208.21 | 208.43 | 207.8501 | 208.01 | 1376881.0 |
| 2025-07-01 15:00:00 | AAPL | Stock | 208.02 | 208.35 | 207.375 | 208.19 | 2252603.0 |
| 2025-07-01 15:30:00 | AAPL | Stock | 208.185 | 208.23 | 207.515 | 207.86 | 3852605.0 |
| 2025-07-01 16:00:00 | AAPL | Stock | 207.86 | 209.8 | 207.7696 | 209.2 | 6056443.0 |
| 2025-07-01 16:30:00 | AAPL | Stock | 209.2449 | 209.56 | 209.03 | 209.23 | 71900.0 |
| 2025-07-01 17:00:00 | AAPL | Stock | 209.17 | 209.5 | 207.82 | 209.01 | 68897.0 |
| 2025-07-01 17:30:00 | AAPL | Stock | 209.04 | 209.45 | 208.87 | 209.2 | 73879.0 |
| 2025-07-01 18:00:00 | AAPL | Stock | 209.2 | 209.3 | 209.11 | 209.15 | 15246.0 |
| 2025-07-01 18:30:00 | AAPL | Stock | 209.15 | 209.26 | 209.0 | 209.18 | 23043.0 |
| 2025-07-01 19:00:00 | AAPL | Stock | 209.07 | 209.29 | 208.95 | 208.95 | 23954.0 |
| 2025-07-01 19:30:00 | AAPL | Stock | 208.9107 | 209.0 | 208.8 | 208.92 | 33259.0 |
| 2025-07-01 04:00:00 | MSFT | Stock | 497.89 | 498.77 | 497.89 | 498.77 | 7082.0 |
| 2025-07-01 04:30:00 | MSFT | Stock | 498.35 | 498.57 | 498.31 | 498.33 | 3028.0 |
| 2025-07-01 05:00:00 | MSFT | Stock | 498.22 | 498.22 | 498.2 | 498.2 | 377.0 |
| 2025-07-01 05:30:00 | MSFT | Stock | 497.64 | 497.64 | 497.64 | 497.64 | 100.0 |
| 2025-07-01 06:00:00 | MSFT | Stock | 498.08 | 498.25 | 498.07 | 498.25 | 585.0 |
| 2025-07-01 06:30:00 | MSFT | Stock | 497.8 | 497.8 | 497.8 | 497.8 | 100.0 |
| 2025-07-01 07:00:00 | MSFT | Stock | 497.87 | 497.97 | 497.75 | 497.75 | 1785.0 |
| 2025-07-01 07:30:00 | MSFT | Stock | 497.84 | 497.88 | 497.43 | 497.43 | 1240.0 |
| 2025-07-01 08:00:00 | MSFT | Stock | 498.23 | 498.41 | 496.167 | 497.08 | 18798.0 |
| 2025-07-01 08:30:00 | MSFT | Stock | 497.43 | 497.818 | 497.12 | 497.818 | 8793.0 |
| 2025-07-01 09:00:00 | MSFT | Stock | 497.57 | 498.0 | 495.39 | 495.95 | 21398.0 |
| 2025-07-01 09:30:00 | MSFT | Stock | 496.49 | 498.05 | 495.64 | 497.465 | 1244306.0 |
| 2025-07-01 10:00:00 | MSFT | Stock | 497.38 | 498.02 | 496.42 | 497.155 | 667717.0 |
| 2025-07-01 10:30:00 | MSFT | Stock | 497.13 | 497.14 | 495.27 | 495.3925 | 770646.0 |
| 2025-07-01 11:00:00 | MSFT | Stock | 495.372 | 495.59 | 491.82 | 493.805 | 1169873.0 |
| 2025-07-01 11:30:00 | MSFT | Stock | 493.81 | 493.95 | 491.81 | 491.845 | 434272.0 |
| 2025-07-01 12:00:00 | MSFT | Stock | 491.845 | 492.645 | 490.98 | 491.88 | 627229.0 |
| 2025-07-01 12:30:00 | MSFT | Stock | 491.85 | 494.05 | 491.59 | 493.49 | 485201.0 |
> showing 50 of 106,434 rows — these rows as CSV