PREVIEW / stock_30min / 2025-07-14
file: by_date/stock_30min/2025/2025-07-14.parquet size: 2.3 MB rows: 108,596 symbols: 380
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-14 04:00:00 | AAPL | Stock | 209.8 | 210.0 | 209.33 | 209.39 | 19740.0 |
| 2025-07-14 04:30:00 | AAPL | Stock | 209.45 | 209.45 | 209.2 | 209.21 | 10755.0 |
| 2025-07-14 05:00:00 | AAPL | Stock | 209.24 | 209.41 | 209.14 | 209.33 | 7836.0 |
| 2025-07-14 05:30:00 | AAPL | Stock | 209.35 | 209.4 | 209.14 | 209.18 | 6375.0 |
| 2025-07-14 06:00:00 | AAPL | Stock | 209.21 | 209.3 | 209.1 | 209.18 | 4882.0 |
| 2025-07-14 06:30:00 | AAPL | Stock | 209.23 | 209.28 | 209.2 | 209.28 | 3422.0 |
| 2025-07-14 07:00:00 | AAPL | Stock | 209.33 | 209.46 | 209.2 | 209.24 | 18070.0 |
| 2025-07-14 07:30:00 | AAPL | Stock | 209.31 | 209.45 | 209.3 | 209.37 | 10828.0 |
| 2025-07-14 08:00:00 | AAPL | Stock | 209.2 | 209.9 | 209.11 | 209.4599 | 120113.0 |
| 2025-07-14 08:30:00 | AAPL | Stock | 209.499 | 209.5601 | 209.32 | 209.48 | 30434.0 |
| 2025-07-14 09:00:00 | AAPL | Stock | 209.4501 | 210.0 | 209.4 | 209.9899 | 66907.0 |
| 2025-07-14 09:30:00 | AAPL | Stock | 209.925 | 210.91 | 207.67 | 207.8867 | 5616920.0 |
| 2025-07-14 10:00:00 | AAPL | Stock | 207.9 | 208.78 | 207.54 | 208.02 | 2986451.0 |
| 2025-07-14 10:30:00 | AAPL | Stock | 208.02 | 208.755 | 207.825 | 208.485 | 1709404.0 |
| 2025-07-14 11:00:00 | AAPL | Stock | 208.48 | 208.8917 | 208.2001 | 208.765 | 1462992.0 |
| 2025-07-14 11:30:00 | AAPL | Stock | 208.77 | 209.15 | 208.56 | 208.84 | 1732084.0 |
| 2025-07-14 12:00:00 | AAPL | Stock | 208.83 | 209.18 | 208.68 | 208.8407 | 989992.0 |
| 2025-07-14 12:30:00 | AAPL | Stock | 208.85 | 209.245 | 208.79 | 208.9 | 857673.0 |
| 2025-07-14 13:00:00 | AAPL | Stock | 208.89 | 209.33 | 208.7602 | 209.0 | 1064395.0 |
| 2025-07-14 13:30:00 | AAPL | Stock | 209.01 | 209.3 | 209.01 | 209.155 | 887083.0 |
| 2025-07-14 14:00:00 | AAPL | Stock | 209.16 | 209.45 | 208.9608 | 209.0 | 952379.0 |
| 2025-07-14 14:30:00 | AAPL | Stock | 209.0 | 209.4073 | 208.99 | 209.3101 | 876578.0 |
| 2025-07-14 15:00:00 | AAPL | Stock | 209.315 | 209.36 | 208.8701 | 209.1999 | 1574582.0 |
| 2025-07-14 15:30:00 | AAPL | Stock | 209.17 | 209.195 | 208.52 | 208.54 | 3259027.0 |
| 2025-07-14 16:00:00 | AAPL | Stock | 208.54 | 208.68 | 208.41 | 208.5397 | 5529129.0 |
| 2025-07-14 16:30:00 | AAPL | Stock | 208.5 | 208.55 | 208.48 | 208.52 | 26173.0 |
| 2025-07-14 17:00:00 | AAPL | Stock | 208.53 | 208.62 | 208.5 | 208.52 | 7746.0 |
| 2025-07-14 17:30:00 | AAPL | Stock | 208.5001 | 208.52 | 208.48 | 208.5186 | 10477.0 |
| 2025-07-14 18:00:00 | AAPL | Stock | 208.49 | 208.52 | 207.78 | 207.89 | 50944.0 |
| 2025-07-14 18:30:00 | AAPL | Stock | 207.9198 | 208.29 | 207.91 | 208.15 | 16601.0 |
| 2025-07-14 19:00:00 | AAPL | Stock | 208.15 | 208.1899 | 208.07 | 208.15 | 15071.0 |
| 2025-07-14 19:30:00 | AAPL | Stock | 208.17 | 208.19 | 208.0 | 208.01 | 31724.0 |
| 2025-07-14 04:00:00 | MSFT | Stock | 500.5 | 501.5 | 500.5 | 500.8 | 2370.0 |
| 2025-07-14 04:30:00 | MSFT | Stock | 501.15 | 501.38 | 501.15 | 501.38 | 909.0 |
| 2025-07-14 05:00:00 | MSFT | Stock | 501.44 | 501.44 | 501.07 | 501.07 | 1952.0 |
| 2025-07-14 05:30:00 | MSFT | Stock | 501.01 | 501.01 | 501.01 | 501.01 | 500.0 |
| 2025-07-14 06:00:00 | MSFT | Stock | 501.0 | 501.0 | 500.89 | 500.89 | 2059.0 |
| 2025-07-14 06:30:00 | MSFT | Stock | 501.41 | 501.41 | 501.41 | 501.41 | 834.0 |
| 2025-07-14 07:00:00 | MSFT | Stock | 501.21 | 501.48 | 501.02 | 501.12 | 1630.0 |
| 2025-07-14 07:30:00 | MSFT | Stock | 501.2 | 501.7 | 501.05 | 501.45 | 2238.0 |
| 2025-07-14 08:00:00 | MSFT | Stock | 501.55 | 502.062 | 500.01 | 501.5884 | 8970.0 |
| 2025-07-14 08:30:00 | MSFT | Stock | 501.32 | 501.531 | 501.2001 | 501.39 | 2242.0 |
| 2025-07-14 09:00:00 | MSFT | Stock | 501.39 | 501.74 | 500.9 | 501.28 | 6326.0 |
| 2025-07-14 09:30:00 | MSFT | Stock | 501.515 | 502.89 | 501.03 | 502.58 | 850455.0 |
| 2025-07-14 10:00:00 | MSFT | Stock | 502.55 | 502.68 | 501.21 | 501.55 | 500087.0 |
| 2025-07-14 10:30:00 | MSFT | Stock | 501.59 | 502.92 | 501.1 | 502.86 | 352609.0 |
| 2025-07-14 11:00:00 | MSFT | Stock | 502.86 | 503.97 | 502.74 | 503.01 | 422582.0 |
| 2025-07-14 11:30:00 | MSFT | Stock | 503.03 | 503.0599 | 502.3572 | 502.93 | 251749.0 |
| 2025-07-14 12:00:00 | MSFT | Stock | 502.9486 | 503.4 | 502.3327 | 502.45 | 251523.0 |
| 2025-07-14 12:30:00 | MSFT | Stock | 502.46 | 502.9958 | 502.3006 | 502.33 | 157819.0 |
> showing 50 of 108,596 rows — these rows as CSV