PREVIEW / stock_30min / 2024-09-30
file: by_date/stock_30min/2024/2024-09-30.parquet size: 2.1 MB rows: 103,411 symbols: 788
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-30 04:00:00 | AAPL | Stock | 227.33 | 229.37 | 227.33 | 229.33 | 46937.0 |
| 2024-09-30 04:30:00 | AAPL | Stock | 229.29 | 229.33 | 228.89 | 229.0 | 8975.0 |
| 2024-09-30 05:00:00 | AAPL | Stock | 229.0 | 230.02 | 229.0 | 229.8 | 23989.0 |
| 2024-09-30 05:30:00 | AAPL | Stock | 229.82 | 230.22 | 229.82 | 230.2 | 24976.0 |
| 2024-09-30 06:00:00 | AAPL | Stock | 230.12 | 230.55 | 230.02 | 230.19 | 17180.0 |
| 2024-09-30 06:30:00 | AAPL | Stock | 230.18 | 230.2 | 229.83 | 229.9 | 7782.0 |
| 2024-09-30 07:00:00 | AAPL | Stock | 229.85 | 229.92 | 229.18 | 229.5 | 61273.0 |
| 2024-09-30 07:30:00 | AAPL | Stock | 229.5 | 229.73 | 229.0 | 229.42 | 52221.0 |
| 2024-09-30 08:00:00 | AAPL | Stock | 229.4 | 230.1 | 226.84 | 230.02 | 210463.0 |
| 2024-09-30 08:30:00 | AAPL | Stock | 230.01 | 230.39 | 229.98 | 230.35 | 142345.0 |
| 2024-09-30 09:00:00 | AAPL | Stock | 230.35 | 230.36 | 229.21 | 230.06 | 165952.0 |
| 2024-09-30 09:30:00 | AAPL | Stock | 230.04 | 232.35 | 229.65 | 230.925 | 5471877.0 |
| 2024-09-30 10:00:00 | AAPL | Stock | 230.925 | 231.33 | 230.31 | 230.98 | 2206772.0 |
| 2024-09-30 10:30:00 | AAPL | Stock | 230.97 | 231.76 | 230.74 | 231.61 | 1673628.0 |
| 2024-09-30 11:00:00 | AAPL | Stock | 231.6 | 232.105 | 231.38 | 231.9401 | 1587058.0 |
| 2024-09-30 11:30:00 | AAPL | Stock | 231.95 | 232.43 | 231.83 | 232.25 | 1552939.0 |
| 2024-09-30 12:00:00 | AAPL | Stock | 232.25 | 232.5383 | 232.08 | 232.1205 | 1220206.0 |
| 2024-09-30 12:30:00 | AAPL | Stock | 232.12 | 232.2 | 231.74 | 231.7878 | 874070.0 |
| 2024-09-30 13:00:00 | AAPL | Stock | 231.78 | 232.0399 | 231.31 | 231.645 | 923179.0 |
| 2024-09-30 13:30:00 | AAPL | Stock | 231.65 | 232.0 | 231.3203 | 231.84 | 928122.0 |
| 2024-09-30 14:00:00 | AAPL | Stock | 231.825 | 231.8899 | 230.55 | 231.01 | 1332662.0 |
| 2024-09-30 14:30:00 | AAPL | Stock | 231.0 | 231.91 | 230.7764 | 231.7516 | 1198932.0 |
| 2024-09-30 15:00:00 | AAPL | Stock | 231.735 | 231.83 | 231.04 | 231.22 | 1315098.0 |
| 2024-09-30 15:30:00 | AAPL | Stock | 231.21 | 233.0 | 231.11 | 233.0 | 6940135.0 |
| 2024-09-30 16:00:00 | AAPL | Stock | 233.0 | 233.25 | 232.7 | 232.95 | 12795951.0 |
| 2024-09-30 16:30:00 | AAPL | Stock | 233.0 | 233.0 | 232.8 | 232.88 | 522003.0 |
| 2024-09-30 17:00:00 | AAPL | Stock | 232.88 | 233.0 | 232.8 | 232.95 | 111989.0 |
| 2024-09-30 17:30:00 | AAPL | Stock | 232.97 | 232.97 | 232.8 | 232.88 | 7686.0 |
| 2024-09-30 18:00:00 | AAPL | Stock | 232.9 | 232.98 | 232.7755 | 232.94 | 22262.0 |
| 2024-09-30 18:30:00 | AAPL | Stock | 232.89 | 232.93 | 232.782 | 232.782 | 10547.0 |
| 2024-09-30 19:00:00 | AAPL | Stock | 232.782 | 232.82 | 232.7701 | 232.8 | 10595.0 |
| 2024-09-30 19:30:00 | AAPL | Stock | 232.8 | 233.195 | 232.78 | 233.15 | 21793.0 |
| 2024-09-30 04:00:00 | MSFT | Stock | 428.0 | 428.0 | 426.78 | 427.23 | 2039.0 |
| 2024-09-30 04:30:00 | MSFT | Stock | 427.23 | 427.23 | 426.6 | 426.6 | 1256.0 |
| 2024-09-30 05:00:00 | MSFT | Stock | 426.96 | 427.19 | 426.85 | 427.19 | 1837.0 |
| 2024-09-30 05:30:00 | MSFT | Stock | 427.3 | 427.32 | 427.0 | 427.32 | 424.0 |
| 2024-09-30 06:00:00 | MSFT | Stock | 427.3 | 427.5 | 427.3 | 427.5 | 566.0 |
| 2024-09-30 06:30:00 | MSFT | Stock | 427.3 | 427.5 | 427.17 | 427.5 | 1006.0 |
| 2024-09-30 07:00:00 | MSFT | Stock | 427.38 | 427.5 | 427.02 | 427.25 | 2109.0 |
| 2024-09-30 07:30:00 | MSFT | Stock | 427.26 | 427.26 | 426.64 | 426.64 | 2805.0 |
| 2024-09-30 08:00:00 | MSFT | Stock | 427.37 | 427.5 | 426.601 | 427.35 | 18529.0 |
| 2024-09-30 08:30:00 | MSFT | Stock | 427.35 | 427.79 | 427.2091 | 427.78 | 5963.0 |
| 2024-09-30 09:00:00 | MSFT | Stock | 427.72 | 428.13 | 426.75 | 427.94 | 20461.0 |
| 2024-09-30 09:30:00 | MSFT | Stock | 428.21 | 429.5705 | 426.23 | 426.37 | 883443.0 |
| 2024-09-30 10:00:00 | MSFT | Stock | 426.41 | 426.9 | 425.57 | 426.62 | 465170.0 |
| 2024-09-30 10:30:00 | MSFT | Stock | 426.67 | 427.19 | 425.81 | 426.262 | 362801.0 |
| 2024-09-30 11:00:00 | MSFT | Stock | 426.23 | 427.94 | 426.16 | 427.88 | 365532.0 |
| 2024-09-30 11:30:00 | MSFT | Stock | 427.87 | 428.21 | 426.92 | 428.07 | 290699.0 |
| 2024-09-30 12:00:00 | MSFT | Stock | 428.05 | 428.91 | 428.025 | 428.6499 | 201274.0 |
| 2024-09-30 12:30:00 | MSFT | Stock | 428.63 | 428.7499 | 428.04 | 428.24 | 155592.0 |
> showing 50 of 103,411 rows — these rows as CSV