PREVIEW / stock_30min / 2025-08-05
file: by_date/stock_30min/2025/2025-08-05.parquet size: 2.2 MB rows: 105,830 symbols: 356
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-05 04:00:00 | AAPL | Stock | 203.5 | 203.85 | 203.5 | 203.78 | 10758.0 |
| 2025-08-05 04:30:00 | AAPL | Stock | 203.88 | 203.99 | 203.81 | 203.85 | 4186.0 |
| 2025-08-05 05:00:00 | AAPL | Stock | 203.85 | 203.89 | 203.8 | 203.85 | 3754.0 |
| 2025-08-05 05:30:00 | AAPL | Stock | 203.9 | 203.94 | 203.82 | 203.88 | 6635.0 |
| 2025-08-05 06:00:00 | AAPL | Stock | 203.93 | 204.25 | 203.93 | 204.24 | 6726.0 |
| 2025-08-05 06:30:00 | AAPL | Stock | 204.2 | 204.26 | 204.1 | 204.26 | 7772.0 |
| 2025-08-05 07:00:00 | AAPL | Stock | 204.25 | 204.3 | 204.15 | 204.28 | 9337.0 |
| 2025-08-05 07:30:00 | AAPL | Stock | 204.2 | 204.32 | 203.98 | 204.03 | 19305.0 |
| 2025-08-05 08:00:00 | AAPL | Stock | 204.1 | 204.344 | 203.0 | 203.6 | 171514.0 |
| 2025-08-05 08:30:00 | AAPL | Stock | 203.72 | 203.86 | 203.5 | 203.7501 | 40653.0 |
| 2025-08-05 09:00:00 | AAPL | Stock | 203.7511 | 203.89 | 203.16 | 203.36 | 89465.0 |
| 2025-08-05 09:30:00 | AAPL | Stock | 203.4 | 204.26 | 202.16 | 203.37 | 4276646.0 |
| 2025-08-05 10:00:00 | AAPL | Stock | 203.35 | 204.555 | 202.89 | 204.53 | 3020363.0 |
| 2025-08-05 10:30:00 | AAPL | Stock | 204.535 | 204.7904 | 203.905 | 204.23 | 2510920.0 |
| 2025-08-05 11:00:00 | AAPL | Stock | 204.23 | 205.34 | 204.075 | 204.63 | 2631529.0 |
| 2025-08-05 11:30:00 | AAPL | Stock | 204.62 | 204.69 | 203.6779 | 203.92 | 1718009.0 |
| 2025-08-05 12:00:00 | AAPL | Stock | 203.91 | 203.9319 | 203.44 | 203.71 | 1182375.0 |
| 2025-08-05 12:30:00 | AAPL | Stock | 203.71 | 203.93 | 203.08 | 203.8316 | 1686598.0 |
| 2025-08-05 13:00:00 | AAPL | Stock | 203.83 | 204.17 | 203.76 | 204.035 | 1315198.0 |
| 2025-08-05 13:30:00 | AAPL | Stock | 204.05 | 204.12 | 203.75 | 204.03 | 973440.0 |
| 2025-08-05 14:00:00 | AAPL | Stock | 204.035 | 204.3 | 203.83 | 203.87 | 1157227.0 |
| 2025-08-05 14:30:00 | AAPL | Stock | 203.86 | 203.97 | 203.1901 | 203.58 | 1415102.0 |
| 2025-08-05 15:00:00 | AAPL | Stock | 203.6 | 203.68 | 203.26 | 203.33 | 1275041.0 |
| 2025-08-05 15:30:00 | AAPL | Stock | 203.34 | 203.41 | 202.67 | 202.93 | 2872521.0 |
| 2025-08-05 16:00:00 | AAPL | Stock | 202.92 | 203.05 | 202.8494 | 203.01 | 5591733.0 |
| 2025-08-05 16:30:00 | AAPL | Stock | 203.04 | 203.1 | 202.7 | 202.75 | 40482.0 |
| 2025-08-05 17:00:00 | AAPL | Stock | 202.82 | 202.9 | 202.5 | 202.6999 | 26214.0 |
| 2025-08-05 17:30:00 | AAPL | Stock | 202.6995 | 202.9 | 202.65 | 202.81 | 30330.0 |
| 2025-08-05 18:00:00 | AAPL | Stock | 202.9 | 202.94 | 202.61 | 202.7477 | 10829.0 |
| 2025-08-05 18:30:00 | AAPL | Stock | 202.7 | 202.79 | 202.7 | 202.79 | 8988.0 |
| 2025-08-05 19:00:00 | AAPL | Stock | 202.79 | 202.83 | 202.71 | 202.75 | 11728.0 |
| 2025-08-05 19:30:00 | AAPL | Stock | 202.8 | 202.86 | 202.7 | 202.8 | 9827.0 |
| 2025-08-05 04:00:00 | MSFT | Stock | 536.81 | 537.48 | 536.46 | 537.48 | 3230.0 |
| 2025-08-05 04:30:00 | MSFT | Stock | 537.04 | 537.04 | 537.04 | 537.04 | 110.0 |
| 2025-08-05 05:00:00 | MSFT | Stock | 537.35 | 537.35 | 537.2 | 537.2 | 276.0 |
| 2025-08-05 05:30:00 | MSFT | Stock | 537.5 | 537.52 | 537.5 | 537.5 | 300.0 |
| 2025-08-05 06:00:00 | MSFT | Stock | 537.69 | 537.95 | 537.69 | 537.95 | 2095.0 |
| 2025-08-05 06:30:00 | MSFT | Stock | 537.94 | 538.95 | 537.9 | 538.95 | 719.0 |
| 2025-08-05 07:00:00 | MSFT | Stock | 538.61 | 539.0 | 538.35 | 538.35 | 2877.0 |
| 2025-08-05 07:30:00 | MSFT | Stock | 538.35 | 538.62 | 538.14 | 538.4 | 3590.0 |
| 2025-08-05 08:00:00 | MSFT | Stock | 538.59 | 538.9 | 536.9 | 538.17 | 18915.0 |
| 2025-08-05 08:30:00 | MSFT | Stock | 538.3 | 538.51 | 537.99 | 538.0 | 9494.0 |
| 2025-08-05 09:00:00 | MSFT | Stock | 537.93 | 538.31 | 537.11 | 537.12 | 56344.0 |
| 2025-08-05 09:30:00 | MSFT | Stock | 537.24 | 537.3 | 534.73 | 535.28 | 1655715.0 |
| 2025-08-05 10:00:00 | MSFT | Stock | 535.15 | 535.215 | 533.47 | 534.08 | 1016893.0 |
| 2025-08-05 10:30:00 | MSFT | Stock | 534.08 | 534.08 | 531.8101 | 531.91 | 956099.0 |
| 2025-08-05 11:00:00 | MSFT | Stock | 531.885 | 532.96 | 531.47 | 532.3686 | 726883.0 |
| 2025-08-05 11:30:00 | MSFT | Stock | 532.31 | 532.5 | 530.7 | 532.14 | 433984.0 |
| 2025-08-05 12:00:00 | MSFT | Stock | 532.11 | 533.19 | 531.72 | 532.94 | 471460.0 |
| 2025-08-05 12:30:00 | MSFT | Stock | 532.915 | 533.2 | 531.55 | 531.93 | 387773.0 |
> showing 50 of 105,830 rows — these rows as CSV