PREVIEW / stock_30min / 2024-01-11
file: by_date/stock_30min/2024/2024-01-11.parquet size: 2.1 MB rows: 99,045 symbols: 1,178
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-01-11 04:00:00 | AAPL | Stock | 187.0 | 187.16 | 186.81 | 186.93 | 18864.0 |
| 2024-01-11 04:30:00 | AAPL | Stock | 186.86 | 186.93 | 186.85 | 186.91 | 4584.0 |
| 2024-01-11 05:00:00 | AAPL | Stock | 187.0 | 187.1 | 187.0 | 187.09 | 7420.0 |
| 2024-01-11 05:30:00 | AAPL | Stock | 187.13 | 187.13 | 187.02 | 187.04 | 944.0 |
| 2024-01-11 06:00:00 | AAPL | Stock | 187.15 | 187.42 | 187.15 | 187.35 | 4955.0 |
| 2024-01-11 06:30:00 | AAPL | Stock | 187.25 | 187.29 | 187.13 | 187.2 | 3600.0 |
| 2024-01-11 07:00:00 | AAPL | Stock | 187.18 | 187.27 | 187.07 | 187.12 | 29013.0 |
| 2024-01-11 07:30:00 | AAPL | Stock | 187.15 | 187.15 | 186.95 | 186.95 | 9387.0 |
| 2024-01-11 08:00:00 | AAPL | Stock | 187.24 | 187.25 | 186.76 | 186.95 | 85067.0 |
| 2024-01-11 08:30:00 | AAPL | Stock | 186.95 | 187.14 | 185.58 | 185.64 | 218781.0 |
| 2024-01-11 09:00:00 | AAPL | Stock | 185.65 | 186.62 | 185.6074 | 186.51 | 158614.0 |
| 2024-01-11 09:30:00 | AAPL | Stock | 186.54 | 187.05 | 184.6 | 184.72 | 6079987.0 |
| 2024-01-11 10:00:00 | AAPL | Stock | 184.735 | 184.7698 | 183.62 | 184.37 | 4399854.0 |
| 2024-01-11 10:30:00 | AAPL | Stock | 184.365 | 184.88 | 184.09 | 184.6798 | 2461982.0 |
| 2024-01-11 11:00:00 | AAPL | Stock | 184.67 | 184.87 | 183.835 | 184.19 | 2173824.0 |
| 2024-01-11 11:30:00 | AAPL | Stock | 184.185 | 184.45 | 183.835 | 183.94 | 1986185.0 |
| 2024-01-11 12:00:00 | AAPL | Stock | 183.95 | 184.39 | 183.91 | 184.05 | 1220906.0 |
| 2024-01-11 12:30:00 | AAPL | Stock | 184.075 | 184.585 | 184.075 | 184.32 | 1204380.0 |
| 2024-01-11 13:00:00 | AAPL | Stock | 184.32 | 184.7772 | 184.255 | 184.655 | 1316149.0 |
| 2024-01-11 13:30:00 | AAPL | Stock | 184.67 | 185.17 | 184.56 | 185.1516 | 1525990.0 |
| 2024-01-11 14:00:00 | AAPL | Stock | 185.16 | 185.54 | 184.99 | 185.515 | 1682462.0 |
| 2024-01-11 14:30:00 | AAPL | Stock | 185.52 | 185.7 | 185.36 | 185.54 | 1488348.0 |
| 2024-01-11 15:00:00 | AAPL | Stock | 185.54 | 185.595 | 184.755 | 185.37 | 2081942.0 |
| 2024-01-11 15:30:00 | AAPL | Stock | 185.37 | 185.77 | 185.32 | 185.58 | 3870163.0 |
| 2024-01-11 16:00:00 | AAPL | Stock | 185.59 | 185.92 | 185.59 | 185.59 | 6295533.0 |
| 2024-01-11 16:30:00 | AAPL | Stock | 185.88 | 185.88 | 185.59 | 185.66 | 30649.0 |
| 2024-01-11 17:00:00 | AAPL | Stock | 185.66 | 185.75 | 185.59 | 185.61 | 36623.0 |
| 2024-01-11 17:30:00 | AAPL | Stock | 185.61 | 185.72 | 185.59 | 185.72 | 14256.0 |
| 2024-01-11 18:00:00 | AAPL | Stock | 185.635 | 185.67 | 185.58 | 185.67 | 6580.0 |
| 2024-01-11 18:30:00 | AAPL | Stock | 185.68 | 185.68 | 185.3 | 185.59 | 18778.0 |
| 2024-01-11 19:00:00 | AAPL | Stock | 185.4 | 185.69 | 185.4 | 185.55 | 11114.0 |
| 2024-01-11 19:30:00 | AAPL | Stock | 185.55 | 185.56 | 185.35 | 185.4 | 10279.0 |
| 2024-01-11 04:00:00 | MSFT | Stock | 385.7 | 385.7 | 385.0 | 385.3 | 4828.0 |
| 2024-01-11 04:30:00 | MSFT | Stock | 385.15 | 385.4 | 385.06 | 385.4 | 2546.0 |
| 2024-01-11 05:00:00 | MSFT | Stock | 385.3 | 385.38 | 385.17 | 385.27 | 1062.0 |
| 2024-01-11 05:30:00 | MSFT | Stock | 385.29 | 385.29 | 385.09 | 385.15 | 1300.0 |
| 2024-01-11 06:00:00 | MSFT | Stock | 385.15 | 385.33 | 385.14 | 385.24 | 2763.0 |
| 2024-01-11 06:30:00 | MSFT | Stock | 385.21 | 385.21 | 384.9 | 384.9 | 2774.0 |
| 2024-01-11 07:00:00 | MSFT | Stock | 385.01 | 385.16 | 384.08 | 384.5 | 9469.0 |
| 2024-01-11 07:30:00 | MSFT | Stock | 384.66 | 385.11 | 384.5 | 384.94 | 6829.0 |
| 2024-01-11 08:00:00 | MSFT | Stock | 385.01 | 385.64 | 384.23 | 384.99 | 65983.0 |
| 2024-01-11 08:30:00 | MSFT | Stock | 385.5 | 385.5 | 382.88 | 383.6 | 110532.0 |
| 2024-01-11 09:00:00 | MSFT | Stock | 383.6 | 385.97 | 383.6 | 385.97 | 58262.0 |
| 2024-01-11 09:30:00 | MSFT | Stock | 385.9 | 390.68 | 385.17 | 387.025 | 4275560.0 |
| 2024-01-11 10:00:00 | MSFT | Stock | 387.08 | 387.24 | 382.9 | 385.67 | 1931201.0 |
| 2024-01-11 10:30:00 | MSFT | Stock | 385.64 | 386.4179 | 382.71 | 382.9193 | 1241120.0 |
| 2024-01-11 11:00:00 | MSFT | Stock | 382.91 | 383.09 | 380.45 | 380.84 | 1334039.0 |
| 2024-01-11 11:30:00 | MSFT | Stock | 380.85 | 382.27 | 380.38 | 380.92 | 1042611.0 |
| 2024-01-11 12:00:00 | MSFT | Stock | 380.94 | 381.755 | 380.7 | 380.74 | 497394.0 |
| 2024-01-11 12:30:00 | MSFT | Stock | 380.78 | 382.85 | 380.76 | 382.17 | 676500.0 |
> showing 50 of 99,045 rows — these rows as CSV