PREVIEW / stock_30min / 2023-11-28
file: by_date/stock_30min/2023/2023-11-28.parquet size: 2.0 MB rows: 97,974 symbols: 1,297
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-28 04:00:00 | AAPL | Stock | 189.9 | 189.9 | 189.75 | 189.85 | 2202.0 |
| 2023-11-28 04:30:00 | AAPL | Stock | 189.86 | 189.92 | 189.8 | 189.92 | 5619.0 |
| 2023-11-28 05:00:00 | AAPL | Stock | 189.87 | 189.89 | 189.86 | 189.86 | 987.0 |
| 2023-11-28 05:30:00 | AAPL | Stock | 189.86 | 189.98 | 189.86 | 189.98 | 5221.0 |
| 2023-11-28 06:00:00 | AAPL | Stock | 190.0 | 190.13 | 189.89 | 189.94 | 4783.0 |
| 2023-11-28 06:30:00 | AAPL | Stock | 189.9 | 189.93 | 189.89 | 189.89 | 2989.0 |
| 2023-11-28 07:00:00 | AAPL | Stock | 190.01 | 190.07 | 189.96 | 190.02 | 7086.0 |
| 2023-11-28 07:30:00 | AAPL | Stock | 189.98 | 190.06 | 189.63 | 189.63 | 12325.0 |
| 2023-11-28 08:00:00 | AAPL | Stock | 190.05 | 190.0999 | 189.41 | 189.7 | 46741.0 |
| 2023-11-28 08:30:00 | AAPL | Stock | 189.72 | 190.1 | 189.72 | 190.08 | 34174.0 |
| 2023-11-28 09:00:00 | AAPL | Stock | 190.06 | 190.08 | 189.6 | 189.78 | 70035.0 |
| 2023-11-28 09:30:00 | AAPL | Stock | 189.78 | 190.27 | 189.4 | 189.72 | 3376017.0 |
| 2023-11-28 10:00:00 | AAPL | Stock | 189.715 | 190.195 | 189.715 | 189.9813 | 2458430.0 |
| 2023-11-28 10:30:00 | AAPL | Stock | 189.99 | 190.61 | 189.94 | 190.145 | 2476079.0 |
| 2023-11-28 11:00:00 | AAPL | Stock | 190.145 | 190.61 | 190.08 | 190.585 | 1599474.0 |
| 2023-11-28 11:30:00 | AAPL | Stock | 190.58 | 191.08 | 190.56 | 190.71 | 2174691.0 |
| 2023-11-28 12:00:00 | AAPL | Stock | 190.715 | 190.81 | 190.49 | 190.52 | 1203370.0 |
| 2023-11-28 12:30:00 | AAPL | Stock | 190.5101 | 190.52 | 190.225 | 190.3 | 1192080.0 |
| 2023-11-28 13:00:00 | AAPL | Stock | 190.3 | 190.3 | 189.76 | 189.9701 | 1873936.0 |
| 2023-11-28 13:30:00 | AAPL | Stock | 189.975 | 190.12 | 189.87 | 189.91 | 1422571.0 |
| 2023-11-28 14:00:00 | AAPL | Stock | 189.915 | 189.97 | 189.66 | 189.814 | 1240456.0 |
| 2023-11-28 14:30:00 | AAPL | Stock | 189.81 | 190.11 | 189.67 | 190.035 | 1293840.0 |
| 2023-11-28 15:00:00 | AAPL | Stock | 190.05 | 190.0577 | 189.585 | 189.83 | 1511431.0 |
| 2023-11-28 15:30:00 | AAPL | Stock | 189.82 | 190.4 | 189.78 | 190.39 | 4164991.0 |
| 2023-11-28 16:00:00 | AAPL | Stock | 190.39 | 190.45 | 189.03 | 189.25 | 5445884.0 |
| 2023-11-28 16:30:00 | AAPL | Stock | 189.22 | 190.4 | 189.0 | 189.35 | 140355.0 |
| 2023-11-28 17:00:00 | AAPL | Stock | 189.39 | 189.5 | 189.32 | 189.46 | 45663.0 |
| 2023-11-28 17:30:00 | AAPL | Stock | 189.46 | 190.4 | 189.23 | 189.5 | 29597.0 |
| 2023-11-28 18:00:00 | AAPL | Stock | 189.46 | 189.57 | 189.45 | 189.51 | 14528.0 |
| 2023-11-28 18:30:00 | AAPL | Stock | 189.59 | 189.8012 | 189.59 | 189.77 | 14744.0 |
| 2023-11-28 19:00:00 | AAPL | Stock | 189.77 | 189.77 | 189.55 | 189.74 | 2490.0 |
| 2023-11-28 19:30:00 | AAPL | Stock | 189.7 | 189.95 | 189.65 | 189.94 | 11262.0 |
| 2023-11-28 04:00:00 | MSFT | Stock | 378.51 | 378.51 | 378.32 | 378.32 | 1352.0 |
| 2023-11-28 04:30:00 | MSFT | Stock | 378.5 | 378.52 | 378.5 | 378.52 | 1050.0 |
| 2023-11-28 05:00:00 | MSFT | Stock | 378.61 | 378.61 | 378.61 | 378.61 | 150.0 |
| 2023-11-28 05:30:00 | MSFT | Stock | 378.7 | 379.1 | 378.7 | 379.1 | 408.0 |
| 2023-11-28 06:00:00 | MSFT | Stock | 378.55 | 378.55 | 378.5 | 378.5 | 1190.0 |
| 2023-11-28 06:30:00 | MSFT | Stock | 378.42 | 378.42 | 378.32 | 378.32 | 1107.0 |
| 2023-11-28 07:00:00 | MSFT | Stock | 378.42 | 378.7 | 377.89 | 378.2 | 11891.0 |
| 2023-11-28 07:30:00 | MSFT | Stock | 378.18 | 378.18 | 377.8 | 377.9 | 4140.0 |
| 2023-11-28 08:00:00 | MSFT | Stock | 378.5 | 379.25 | 377.0 | 377.66 | 29380.0 |
| 2023-11-28 08:30:00 | MSFT | Stock | 377.75 | 377.9489 | 377.35 | 377.9489 | 14549.0 |
| 2023-11-28 09:00:00 | MSFT | Stock | 377.95 | 378.34 | 377.22 | 378.34 | 38492.0 |
| 2023-11-28 09:30:00 | MSFT | Stock | 378.35 | 381.97 | 378.16 | 380.32 | 2627848.0 |
| 2023-11-28 10:00:00 | MSFT | Stock | 380.3299 | 381.95 | 379.96 | 381.1499 | 1239882.0 |
| 2023-11-28 10:30:00 | MSFT | Stock | 381.11 | 382.77 | 380.95 | 381.755 | 1189632.0 |
| 2023-11-28 11:00:00 | MSFT | Stock | 381.79 | 382.6 | 381.295 | 382.55 | 672971.0 |
| 2023-11-28 11:30:00 | MSFT | Stock | 382.55 | 383.0 | 382.02 | 382.31 | 656323.0 |
| 2023-11-28 12:00:00 | MSFT | Stock | 382.32 | 382.76 | 381.93 | 382.36 | 570725.0 |
| 2023-11-28 12:30:00 | MSFT | Stock | 382.36 | 382.37 | 381.35 | 381.9484 | 451148.0 |
> showing 50 of 97,974 rows — these rows as CSV