PREVIEW / stock_30min / 2024-06-21
file: by_date/stock_30min/2024/2024-06-21.parquet size: 2.0 MB rows: 97,448 symbols: 957
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-06-21 04:00:00 | AAPL | Stock | 209.47 | 209.62 | 208.67 | 208.98 | 16397.0 |
| 2024-06-21 04:30:00 | AAPL | Stock | 208.84 | 209.44 | 208.8 | 209.0 | 14476.0 |
| 2024-06-21 05:00:00 | AAPL | Stock | 209.0 | 209.33 | 208.75 | 209.2 | 9358.0 |
| 2024-06-21 05:30:00 | AAPL | Stock | 209.18 | 209.3 | 209.0 | 209.04 | 4851.0 |
| 2024-06-21 06:00:00 | AAPL | Stock | 209.09 | 209.67 | 209.09 | 209.5 | 9410.0 |
| 2024-06-21 06:30:00 | AAPL | Stock | 209.52 | 210.3 | 209.52 | 210.15 | 8368.0 |
| 2024-06-21 07:00:00 | AAPL | Stock | 210.01 | 210.77 | 210.01 | 210.7 | 42337.0 |
| 2024-06-21 07:30:00 | AAPL | Stock | 210.65 | 210.65 | 210.05 | 210.35 | 23221.0 |
| 2024-06-21 08:00:00 | AAPL | Stock | 210.3 | 210.81 | 209.0502 | 209.84 | 152583.0 |
| 2024-06-21 08:30:00 | AAPL | Stock | 209.71 | 211.4 | 209.71 | 211.2 | 189128.0 |
| 2024-06-21 09:00:00 | AAPL | Stock | 211.21 | 211.95 | 209.5 | 210.45 | 626129.0 |
| 2024-06-21 09:30:00 | AAPL | Stock | 210.45 | 211.89 | 209.85 | 210.43 | 18907661.0 |
| 2024-06-21 10:00:00 | AAPL | Stock | 210.44 | 211.48 | 209.58 | 210.8201 | 4344828.0 |
| 2024-06-21 10:30:00 | AAPL | Stock | 210.83 | 211.4348 | 210.42 | 211.06 | 2727754.0 |
| 2024-06-21 11:00:00 | AAPL | Stock | 211.055 | 211.3 | 210.63 | 210.82 | 2435590.0 |
| 2024-06-21 11:30:00 | AAPL | Stock | 210.82 | 211.63 | 210.72 | 211.2693 | 2242393.0 |
| 2024-06-21 12:00:00 | AAPL | Stock | 211.28 | 211.5 | 210.935 | 211.1 | 1610826.0 |
| 2024-06-21 12:30:00 | AAPL | Stock | 211.09 | 211.1099 | 209.85 | 210.22 | 5160331.0 |
| 2024-06-21 13:00:00 | AAPL | Stock | 210.225 | 210.47 | 209.91 | 210.06 | 1966781.0 |
| 2024-06-21 13:30:00 | AAPL | Stock | 210.06 | 210.63 | 209.95 | 210.3 | 2021205.0 |
| 2024-06-21 14:00:00 | AAPL | Stock | 210.3 | 210.98 | 210.0901 | 210.845 | 1867173.0 |
| 2024-06-21 14:30:00 | AAPL | Stock | 210.84 | 210.845 | 209.97 | 210.16 | 3500308.0 |
| 2024-06-21 15:00:00 | AAPL | Stock | 210.1699 | 210.97 | 210.13 | 210.42 | 4245351.0 |
| 2024-06-21 15:30:00 | AAPL | Stock | 210.42 | 210.85 | 207.11 | 207.11 | 17227994.0 |
| 2024-06-21 16:00:00 | AAPL | Stock | 207.11 | 208.49 | 207.1 | 207.7098 | 111194395.0 |
| 2024-06-21 16:30:00 | AAPL | Stock | 207.7199 | 207.83 | 207.49 | 207.65 | 3106014.0 |
| 2024-06-21 17:00:00 | AAPL | Stock | 207.63 | 207.7 | 207.49 | 207.64 | 197919.0 |
| 2024-06-21 17:30:00 | AAPL | Stock | 207.58 | 207.75 | 207.47 | 207.6999 | 98244.0 |
| 2024-06-21 18:00:00 | AAPL | Stock | 207.69 | 207.7 | 207.49 | 207.58 | 106979.0 |
| 2024-06-21 18:30:00 | AAPL | Stock | 207.55 | 207.5637 | 207.4 | 207.42 | 42246.0 |
| 2024-06-21 19:00:00 | AAPL | Stock | 207.43 | 207.44 | 207.3 | 207.31 | 64697.0 |
| 2024-06-21 19:30:00 | AAPL | Stock | 207.31 | 207.3499 | 207.18 | 207.22 | 61747.0 |
| 2024-06-21 04:00:00 | MSFT | Stock | 444.6 | 444.66 | 444.13 | 444.5 | 2514.0 |
| 2024-06-21 04:30:00 | MSFT | Stock | 444.43 | 444.43 | 443.95 | 444.12 | 1025.0 |
| 2024-06-21 05:00:00 | MSFT | Stock | 444.2 | 444.6 | 444.2 | 444.6 | 1706.0 |
| 2024-06-21 05:30:00 | MSFT | Stock | 444.6 | 444.9 | 444.6 | 444.9 | 356.0 |
| 2024-06-21 06:00:00 | MSFT | Stock | 444.8 | 444.8 | 444.8 | 444.8 | 350.0 |
| 2024-06-21 06:30:00 | MSFT | Stock | 444.07 | 444.63 | 444.02 | 444.56 | 743.0 |
| 2024-06-21 07:00:00 | MSFT | Stock | 444.93 | 445.81 | 444.91 | 445.8 | 4275.0 |
| 2024-06-21 07:30:00 | MSFT | Stock | 445.6 | 446.58 | 445.2 | 446.58 | 4090.0 |
| 2024-06-21 08:00:00 | MSFT | Stock | 444.84 | 447.58 | 444.2101 | 444.95 | 31729.0 |
| 2024-06-21 08:30:00 | MSFT | Stock | 444.95 | 446.6 | 444.95 | 446.6 | 10609.0 |
| 2024-06-21 09:00:00 | MSFT | Stock | 446.42 | 448.33 | 445.24 | 447.53 | 74557.0 |
| 2024-06-21 09:30:00 | MSFT | Stock | 447.38 | 450.3899 | 446.57 | 447.295 | 7340914.0 |
| 2024-06-21 10:00:00 | MSFT | Stock | 447.285 | 448.93 | 447.08 | 447.115 | 733792.0 |
| 2024-06-21 10:30:00 | MSFT | Stock | 447.18 | 447.68 | 446.51 | 447.5915 | 481670.0 |
| 2024-06-21 11:00:00 | MSFT | Stock | 447.6387 | 448.4526 | 447.45 | 447.6407 | 523549.0 |
| 2024-06-21 11:30:00 | MSFT | Stock | 447.655 | 449.3 | 447.5 | 449.1529 | 558448.0 |
| 2024-06-21 12:00:00 | MSFT | Stock | 449.185 | 449.5856 | 448.7301 | 449.5 | 401364.0 |
| 2024-06-21 12:30:00 | MSFT | Stock | 449.52 | 449.78 | 448.54 | 448.73 | 365354.0 |
> showing 50 of 97,448 rows — these rows as CSV