PREVIEW / stock_30min / 2024-10-28
file: by_date/stock_30min/2024/2024-10-28.parquet size: 2.1 MB rows: 102,823 symbols: 741
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-10-28 04:00:00 | AAPL | Stock | 232.91 | 232.91 | 232.35 | 232.78 | 15826.0 |
| 2024-10-28 04:30:00 | AAPL | Stock | 232.82 | 233.1 | 232.82 | 233.04 | 6579.0 |
| 2024-10-28 05:00:00 | AAPL | Stock | 233.04 | 233.11 | 232.82 | 233.09 | 11864.0 |
| 2024-10-28 05:30:00 | AAPL | Stock | 232.98 | 233.0 | 232.9 | 232.92 | 3434.0 |
| 2024-10-28 06:00:00 | AAPL | Stock | 233.0 | 233.0 | 232.68 | 232.75 | 28419.0 |
| 2024-10-28 06:30:00 | AAPL | Stock | 232.8 | 232.82 | 232.2 | 232.2 | 12343.0 |
| 2024-10-28 07:00:00 | AAPL | Stock | 232.21 | 232.29 | 231.72 | 232.1 | 26610.0 |
| 2024-10-28 07:30:00 | AAPL | Stock | 231.99 | 232.37 | 231.99 | 232.37 | 21088.0 |
| 2024-10-28 08:00:00 | AAPL | Stock | 232.14 | 232.99 | 230.832 | 232.21 | 71029.0 |
| 2024-10-28 08:30:00 | AAPL | Stock | 232.19 | 232.68 | 232.19 | 232.634 | 28909.0 |
| 2024-10-28 09:00:00 | AAPL | Stock | 232.69 | 233.32 | 232.37 | 233.3 | 104439.0 |
| 2024-10-28 09:30:00 | AAPL | Stock | 233.34 | 234.55 | 232.55 | 233.18 | 3252492.0 |
| 2024-10-28 10:00:00 | AAPL | Stock | 233.18 | 233.64 | 232.9 | 233.6346 | 1396540.0 |
| 2024-10-28 10:30:00 | AAPL | Stock | 233.6273 | 234.33 | 233.43 | 233.93 | 1409439.0 |
| 2024-10-28 11:00:00 | AAPL | Stock | 233.935 | 234.18 | 233.22 | 233.55 | 1275639.0 |
| 2024-10-28 11:30:00 | AAPL | Stock | 233.55 | 233.83 | 233.25 | 233.57 | 951697.0 |
| 2024-10-28 12:00:00 | AAPL | Stock | 233.545 | 234.315 | 233.15 | 234.3101 | 1130322.0 |
| 2024-10-28 12:30:00 | AAPL | Stock | 234.31 | 234.73 | 233.93 | 234.31 | 1337114.0 |
| 2024-10-28 13:00:00 | AAPL | Stock | 234.3053 | 234.68 | 234.065 | 234.425 | 838629.0 |
| 2024-10-28 13:30:00 | AAPL | Stock | 234.425 | 234.645 | 234.205 | 234.395 | 622142.0 |
| 2024-10-28 14:00:00 | AAPL | Stock | 234.395 | 234.4 | 233.91 | 233.915 | 685535.0 |
| 2024-10-28 14:30:00 | AAPL | Stock | 233.91 | 234.11 | 233.57 | 233.76 | 683363.0 |
| 2024-10-28 15:00:00 | AAPL | Stock | 233.76 | 234.01 | 233.62 | 233.97 | 675623.0 |
| 2024-10-28 15:30:00 | AAPL | Stock | 233.96 | 233.9813 | 232.92 | 233.49 | 3055834.0 |
| 2024-10-28 16:00:00 | AAPL | Stock | 233.14 | 233.57 | 233.11 | 233.23 | 6803055.0 |
| 2024-10-28 16:30:00 | AAPL | Stock | 233.287 | 233.4 | 232.9 | 232.9 | 43245.0 |
| 2024-10-28 17:00:00 | AAPL | Stock | 232.89 | 233.4 | 232.73 | 232.73 | 41658.0 |
| 2024-10-28 17:30:00 | AAPL | Stock | 232.7002 | 232.95 | 232.6527 | 232.9398 | 13330.0 |
| 2024-10-28 18:00:00 | AAPL | Stock | 232.95 | 232.95 | 232.59 | 232.611 | 11735.0 |
| 2024-10-28 18:30:00 | AAPL | Stock | 232.61 | 232.76 | 232.55 | 232.65 | 13790.0 |
| 2024-10-28 19:00:00 | AAPL | Stock | 232.6778 | 232.75 | 232.66 | 232.7 | 5397.0 |
| 2024-10-28 19:30:00 | AAPL | Stock | 232.69 | 232.7 | 232.43 | 232.5 | 16564.0 |
| 2024-10-28 04:00:00 | MSFT | Stock | 430.7 | 431.99 | 430.2 | 431.99 | 12385.0 |
| 2024-10-28 04:30:00 | MSFT | Stock | 431.69 | 432.3 | 431.65 | 432.28 | 6002.0 |
| 2024-10-28 05:00:00 | MSFT | Stock | 432.3 | 432.5 | 432.11 | 432.27 | 2582.0 |
| 2024-10-28 05:30:00 | MSFT | Stock | 432.17 | 432.4 | 432.11 | 432.11 | 7295.0 |
| 2024-10-28 06:00:00 | MSFT | Stock | 432.02 | 432.45 | 431.97 | 432.45 | 6295.0 |
| 2024-10-28 06:30:00 | MSFT | Stock | 432.49 | 432.79 | 431.99 | 431.99 | 2623.0 |
| 2024-10-28 07:00:00 | MSFT | Stock | 432.0 | 432.0 | 431.0 | 431.0 | 7956.0 |
| 2024-10-28 07:30:00 | MSFT | Stock | 431.0 | 431.4 | 430.92 | 431.11 | 5875.0 |
| 2024-10-28 08:00:00 | MSFT | Stock | 431.94 | 432.0 | 427.08 | 431.3677 | 32257.0 |
| 2024-10-28 08:30:00 | MSFT | Stock | 431.0644 | 432.1 | 431.0644 | 431.65 | 21268.0 |
| 2024-10-28 09:00:00 | MSFT | Stock | 431.71 | 432.0 | 431.0 | 431.3 | 10466.0 |
| 2024-10-28 09:30:00 | MSFT | Stock | 431.49 | 431.94 | 428.13 | 428.94 | 1147835.0 |
| 2024-10-28 10:00:00 | MSFT | Stock | 428.98 | 429.99 | 428.935 | 429.8301 | 425870.0 |
| 2024-10-28 10:30:00 | MSFT | Stock | 429.855 | 430.84 | 429.18 | 429.36 | 416889.0 |
| 2024-10-28 11:00:00 | MSFT | Stock | 429.31 | 429.6 | 428.02 | 429.04 | 439235.0 |
| 2024-10-28 11:30:00 | MSFT | Stock | 429.025 | 429.22 | 428.41 | 428.7 | 322880.0 |
| 2024-10-28 12:00:00 | MSFT | Stock | 428.67 | 428.7 | 428.09 | 428.495 | 389658.0 |
| 2024-10-28 12:30:00 | MSFT | Stock | 428.48 | 428.73 | 428.0 | 428.1 | 358933.0 |
> showing 50 of 102,823 rows — these rows as CSV