PREVIEW / stock_30min / 2025-08-20
file: by_date/stock_30min/2025/2025-08-20.parquet size: 2.2 MB rows: 103,677 symbols: 329
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-08-20 04:00:00 | AAPL | Stock | 229.0 | 229.8 | 228.98 | 228.98 | 13323.0 |
| 2025-08-20 04:30:00 | AAPL | Stock | 229.28 | 229.51 | 229.28 | 229.34 | 4107.0 |
| 2025-08-20 05:00:00 | AAPL | Stock | 229.28 | 229.49 | 229.25 | 229.37 | 2386.0 |
| 2025-08-20 05:30:00 | AAPL | Stock | 229.41 | 229.41 | 229.3 | 229.31 | 2113.0 |
| 2025-08-20 06:00:00 | AAPL | Stock | 229.2 | 229.55 | 229.2 | 229.54 | 2595.0 |
| 2025-08-20 06:30:00 | AAPL | Stock | 229.45 | 229.45 | 229.13 | 229.3 | 3588.0 |
| 2025-08-20 07:00:00 | AAPL | Stock | 229.35 | 229.81 | 229.14 | 229.2 | 12688.0 |
| 2025-08-20 07:30:00 | AAPL | Stock | 229.18 | 229.58 | 229.12 | 229.55 | 4732.0 |
| 2025-08-20 08:00:00 | AAPL | Stock | 229.74 | 229.99 | 228.85 | 229.38 | 63258.0 |
| 2025-08-20 08:30:00 | AAPL | Stock | 229.36 | 229.59 | 228.51 | 229.33 | 84827.0 |
| 2025-08-20 09:00:00 | AAPL | Stock | 229.39 | 230.1 | 229.08 | 230.1 | 57101.0 |
| 2025-08-20 09:30:00 | AAPL | Stock | 229.97 | 230.47 | 226.5 | 227.31 | 5036036.0 |
| 2025-08-20 10:00:00 | AAPL | Stock | 227.285 | 227.78 | 226.695 | 226.7201 | 2619355.0 |
| 2025-08-20 10:30:00 | AAPL | Stock | 226.74 | 227.0432 | 226.22 | 226.57 | 1904107.0 |
| 2025-08-20 11:00:00 | AAPL | Stock | 226.54 | 227.55 | 226.11 | 227.335 | 1651482.0 |
| 2025-08-20 11:30:00 | AAPL | Stock | 227.33 | 227.38 | 226.41 | 226.5598 | 1287479.0 |
| 2025-08-20 12:00:00 | AAPL | Stock | 226.55 | 227.145 | 226.5249 | 227.1346 | 1147065.0 |
| 2025-08-20 12:30:00 | AAPL | Stock | 227.13 | 227.16 | 225.89 | 226.27 | 1304198.0 |
| 2025-08-20 13:00:00 | AAPL | Stock | 226.2601 | 226.85 | 226.14 | 226.295 | 1090426.0 |
| 2025-08-20 13:30:00 | AAPL | Stock | 226.3 | 226.83 | 226.23 | 226.38 | 901682.0 |
| 2025-08-20 14:00:00 | AAPL | Stock | 226.38 | 226.54 | 225.77 | 225.9901 | 1080162.0 |
| 2025-08-20 14:30:00 | AAPL | Stock | 225.99 | 226.3787 | 225.87 | 226.08 | 799666.0 |
| 2025-08-20 15:00:00 | AAPL | Stock | 226.1 | 226.73 | 225.99 | 226.44 | 1136065.0 |
| 2025-08-20 15:30:00 | AAPL | Stock | 226.44 | 227.13 | 225.92 | 225.96 | 3450903.0 |
| 2025-08-20 16:00:00 | AAPL | Stock | 225.97 | 226.01 | 225.45 | 225.6215 | 4926736.0 |
| 2025-08-20 16:30:00 | AAPL | Stock | 225.6 | 226.01 | 225.6 | 225.9 | 46634.0 |
| 2025-08-20 17:00:00 | AAPL | Stock | 225.8994 | 225.8994 | 225.64 | 225.7 | 9657.0 |
| 2025-08-20 17:30:00 | AAPL | Stock | 225.69 | 225.74 | 225.65 | 225.65 | 11314.0 |
| 2025-08-20 18:00:00 | AAPL | Stock | 225.75 | 225.78 | 225.58 | 225.71 | 16386.0 |
| 2025-08-20 18:30:00 | AAPL | Stock | 225.73 | 225.75 | 225.61 | 225.61 | 6555.0 |
| 2025-08-20 19:00:00 | AAPL | Stock | 225.58 | 225.69 | 225.5 | 225.503 | 20099.0 |
| 2025-08-20 19:30:00 | AAPL | Stock | 225.55 | 225.65 | 225.51 | 225.5999 | 19854.0 |
| 2025-08-20 04:00:00 | MSFT | Stock | 509.77 | 510.21 | 509.64 | 509.94 | 2365.0 |
| 2025-08-20 04:30:00 | MSFT | Stock | 509.98 | 510.48 | 509.98 | 510.37 | 1240.0 |
| 2025-08-20 05:00:00 | MSFT | Stock | 510.42 | 510.5 | 510.42 | 510.5 | 1554.0 |
| 2025-08-20 05:30:00 | MSFT | Stock | 510.7 | 510.9 | 510.6 | 510.9 | 450.0 |
| 2025-08-20 06:00:00 | MSFT | Stock | 510.47 | 510.47 | 510.47 | 510.47 | 350.0 |
| 2025-08-20 06:30:00 | MSFT | Stock | 510.2 | 510.45 | 510.0 | 510.45 | 1025.0 |
| 2025-08-20 07:00:00 | MSFT | Stock | 510.32 | 510.56 | 509.95 | 509.95 | 2328.0 |
| 2025-08-20 07:30:00 | MSFT | Stock | 509.99 | 509.99 | 509.25 | 509.8 | 1296.0 |
| 2025-08-20 08:00:00 | MSFT | Stock | 510.62 | 510.96 | 508.06 | 510.65 | 19516.0 |
| 2025-08-20 08:30:00 | MSFT | Stock | 510.7 | 510.9559 | 510.38 | 510.6 | 8107.0 |
| 2025-08-20 09:00:00 | MSFT | Stock | 510.72 | 510.76 | 509.0 | 509.98 | 17665.0 |
| 2025-08-20 09:30:00 | MSFT | Stock | 509.74 | 511.0 | 506.24 | 506.5 | 2065863.0 |
| 2025-08-20 10:00:00 | MSFT | Stock | 506.5 | 508.25 | 506.16 | 507.3716 | 861044.0 |
| 2025-08-20 10:30:00 | MSFT | Stock | 507.38 | 508.19 | 506.73 | 506.78 | 691885.0 |
| 2025-08-20 11:00:00 | MSFT | Stock | 506.75 | 506.92 | 505.5 | 505.88 | 1260795.0 |
| 2025-08-20 11:30:00 | MSFT | Stock | 505.885 | 507.0 | 504.44 | 504.815 | 1035658.0 |
| 2025-08-20 12:00:00 | MSFT | Stock | 504.82 | 506.27 | 504.74 | 506.085 | 829782.0 |
| 2025-08-20 12:30:00 | MSFT | Stock | 506.08 | 506.46 | 504.74 | 505.09 | 556551.0 |
> showing 50 of 103,677 rows — these rows as CSV