PREVIEW / stock_30min / 2023-11-29
file: by_date/stock_30min/2023/2023-11-29.parquet size: 2.1 MB rows: 100,431 symbols: 1,292
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-29 04:00:00 | AAPL | Stock | 189.9 | 190.18 | 189.8 | 190.18 | 13528.0 |
| 2023-11-29 04:30:00 | AAPL | Stock | 190.15 | 190.3 | 190.14 | 190.3 | 9179.0 |
| 2023-11-29 05:00:00 | AAPL | Stock | 190.3 | 190.38 | 190.3 | 190.36 | 1012.0 |
| 2023-11-29 05:30:00 | AAPL | Stock | 190.28 | 190.28 | 190.26 | 190.26 | 765.0 |
| 2023-11-29 06:00:00 | AAPL | Stock | 190.22 | 190.24 | 190.17 | 190.17 | 2258.0 |
| 2023-11-29 06:30:00 | AAPL | Stock | 190.2 | 190.46 | 190.17 | 190.46 | 5379.0 |
| 2023-11-29 07:00:00 | AAPL | Stock | 190.4 | 190.68 | 190.28 | 190.57 | 25360.0 |
| 2023-11-29 07:30:00 | AAPL | Stock | 190.6 | 190.65 | 190.32 | 190.47 | 38206.0 |
| 2023-11-29 08:00:00 | AAPL | Stock | 190.36 | 191.03 | 189.72 | 190.87 | 104007.0 |
| 2023-11-29 08:30:00 | AAPL | Stock | 190.86 | 190.96 | 190.6416 | 190.7 | 32232.0 |
| 2023-11-29 09:00:00 | AAPL | Stock | 190.76 | 190.98 | 190.4434 | 190.91 | 108258.0 |
| 2023-11-29 09:30:00 | AAPL | Stock | 190.91 | 192.09 | 190.9 | 191.74 | 4385571.0 |
| 2023-11-29 10:00:00 | AAPL | Stock | 191.74 | 191.82 | 190.6 | 190.88 | 3020881.0 |
| 2023-11-29 10:30:00 | AAPL | Stock | 190.89 | 191.075 | 190.61 | 190.925 | 1684479.0 |
| 2023-11-29 11:00:00 | AAPL | Stock | 190.935 | 190.955 | 190.05 | 190.0974 | 2233648.0 |
| 2023-11-29 11:30:00 | AAPL | Stock | 190.1 | 190.275 | 189.9103 | 189.92 | 2013980.0 |
| 2023-11-29 12:00:00 | AAPL | Stock | 189.9201 | 189.925 | 189.52 | 189.9 | 1587801.0 |
| 2023-11-29 12:30:00 | AAPL | Stock | 189.89 | 189.93 | 189.665 | 189.7022 | 1068162.0 |
| 2023-11-29 13:00:00 | AAPL | Stock | 189.71 | 189.755 | 189.28 | 189.5003 | 1352405.0 |
| 2023-11-29 13:30:00 | AAPL | Stock | 189.505 | 189.51 | 189.18 | 189.465 | 1048219.0 |
| 2023-11-29 14:00:00 | AAPL | Stock | 189.47 | 189.5 | 189.18 | 189.2635 | 1273552.0 |
| 2023-11-29 14:30:00 | AAPL | Stock | 189.265 | 189.355 | 189.05 | 189.33 | 1245279.0 |
| 2023-11-29 15:00:00 | AAPL | Stock | 189.33 | 189.405 | 189.01 | 189.015 | 1471646.0 |
| 2023-11-29 15:30:00 | AAPL | Stock | 189.01 | 189.445 | 188.97 | 189.35 | 3659836.0 |
| 2023-11-29 16:00:00 | AAPL | Stock | 189.37 | 189.56 | 189.31 | 189.46 | 4583253.0 |
| 2023-11-29 16:30:00 | AAPL | Stock | 189.46 | 189.47 | 189.37 | 189.37 | 35292.0 |
| 2023-11-29 17:00:00 | AAPL | Stock | 189.39 | 189.46 | 189.39 | 189.46 | 4021.0 |
| 2023-11-29 17:30:00 | AAPL | Stock | 189.46 | 189.489 | 189.46 | 189.48 | 11699.0 |
| 2023-11-29 18:00:00 | AAPL | Stock | 189.45 | 189.49 | 189.41 | 189.49 | 5407.0 |
| 2023-11-29 18:30:00 | AAPL | Stock | 189.49 | 189.55 | 189.42 | 189.5 | 8536.0 |
| 2023-11-29 19:00:00 | AAPL | Stock | 189.45 | 189.58 | 189.43 | 189.5 | 4086.0 |
| 2023-11-29 19:30:00 | AAPL | Stock | 189.5 | 189.63 | 189.5 | 189.61 | 21664.0 |
| 2023-11-29 04:00:00 | MSFT | Stock | 382.97 | 383.5 | 382.97 | 383.5 | 3412.0 |
| 2023-11-29 04:30:00 | MSFT | Stock | 383.9 | 384.21 | 383.35 | 383.54 | 2606.0 |
| 2023-11-29 05:00:00 | MSFT | Stock | 384.1 | 384.6 | 384.0 | 384.27 | 3521.0 |
| 2023-11-29 05:30:00 | MSFT | Stock | 383.97 | 384.28 | 383.86 | 384.02 | 1895.0 |
| 2023-11-29 06:00:00 | MSFT | Stock | 384.15 | 384.15 | 384.03 | 384.03 | 574.0 |
| 2023-11-29 06:30:00 | MSFT | Stock | 383.89 | 384.03 | 383.89 | 384.03 | 1610.0 |
| 2023-11-29 07:00:00 | MSFT | Stock | 384.18 | 385.35 | 384.18 | 385.35 | 13947.0 |
| 2023-11-29 07:30:00 | MSFT | Stock | 385.28 | 385.4 | 384.65 | 384.7 | 12702.0 |
| 2023-11-29 08:00:00 | MSFT | Stock | 384.5 | 385.5 | 382.74 | 384.99 | 27720.0 |
| 2023-11-29 08:30:00 | MSFT | Stock | 384.98 | 385.4 | 384.45 | 384.75 | 25931.0 |
| 2023-11-29 09:00:00 | MSFT | Stock | 384.66 | 384.76 | 383.39 | 383.61 | 53240.0 |
| 2023-11-29 09:30:00 | MSFT | Stock | 383.75 | 384.3 | 381.215 | 381.6 | 2805312.0 |
| 2023-11-29 10:00:00 | MSFT | Stock | 381.625 | 381.95 | 378.69 | 379.2799 | 2320501.0 |
| 2023-11-29 10:30:00 | MSFT | Stock | 379.29 | 380.16 | 378.87 | 379.69 | 1176525.0 |
| 2023-11-29 11:00:00 | MSFT | Stock | 379.68 | 379.7025 | 378.01 | 378.31 | 1396967.0 |
| 2023-11-29 11:30:00 | MSFT | Stock | 378.31 | 378.645 | 377.44 | 378.41 | 1060884.0 |
| 2023-11-29 12:00:00 | MSFT | Stock | 378.41 | 378.527 | 377.75 | 378.48 | 633324.0 |
| 2023-11-29 12:30:00 | MSFT | Stock | 378.495 | 379.11 | 378.14 | 379.09 | 550486.0 |
> showing 50 of 100,431 rows — these rows as CSV