PREVIEW / stock_30min / 2022-11-15
file: by_date/stock_30min/2022/2022-11-15.parquet size: 2.2 MB rows: 106,200 symbols: 2,085
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-15 04:00:00 | AAPL | Stock | 149.51 | 149.98 | 149.49 | 149.58 | 32192.0 |
| 2022-11-15 04:30:00 | AAPL | Stock | 149.66 | 150.0 | 149.66 | 150.0 | 10445.0 |
| 2022-11-15 05:00:00 | AAPL | Stock | 149.99 | 150.27 | 149.99 | 150.03 | 6864.0 |
| 2022-11-15 05:30:00 | AAPL | Stock | 150.13 | 150.17 | 150.1 | 150.14 | 9979.0 |
| 2022-11-15 06:00:00 | AAPL | Stock | 150.19 | 150.34 | 150.08 | 150.16 | 24092.0 |
| 2022-11-15 06:30:00 | AAPL | Stock | 150.14 | 150.15 | 149.88 | 149.94 | 29169.0 |
| 2022-11-15 07:00:00 | AAPL | Stock | 149.92 | 150.09 | 149.71 | 150.0 | 70423.0 |
| 2022-11-15 07:30:00 | AAPL | Stock | 149.99 | 150.25 | 149.98 | 150.25 | 30882.0 |
| 2022-11-15 08:00:00 | AAPL | Stock | 149.9264 | 150.7 | 147.91 | 150.55 | 207445.0 |
| 2022-11-15 08:30:00 | AAPL | Stock | 150.58 | 152.73 | 150.5 | 152.37 | 528725.0 |
| 2022-11-15 09:00:00 | AAPL | Stock | 152.34 | 152.49 | 151.85 | 152.25 | 342396.0 |
| 2022-11-15 09:30:00 | AAPL | Stock | 152.23 | 153.22 | 151.68 | 152.64 | 10891566.0 |
| 2022-11-15 10:00:00 | AAPL | Stock | 152.635 | 153.59 | 152.56 | 153.17 | 7033261.0 |
| 2022-11-15 10:30:00 | AAPL | Stock | 153.178 | 153.21 | 152.12 | 152.481 | 4379098.0 |
| 2022-11-15 11:00:00 | AAPL | Stock | 152.48 | 152.5619 | 151.79 | 152.155 | 4092418.0 |
| 2022-11-15 11:30:00 | AAPL | Stock | 152.16 | 153.03 | 152.14 | 152.7249 | 3392761.0 |
| 2022-11-15 12:00:00 | AAPL | Stock | 152.73 | 152.7689 | 151.9 | 151.97 | 4313307.0 |
| 2022-11-15 12:30:00 | AAPL | Stock | 151.96 | 152.11 | 151.21 | 151.42 | 3570527.0 |
| 2022-11-15 13:00:00 | AAPL | Stock | 151.4242 | 151.7 | 149.685 | 149.87 | 4931006.0 |
| 2022-11-15 13:30:00 | AAPL | Stock | 149.88 | 150.3 | 148.695 | 149.4844 | 6095865.0 |
| 2022-11-15 14:00:00 | AAPL | Stock | 149.485 | 150.61 | 148.5613 | 150.369 | 5916432.0 |
| 2022-11-15 14:30:00 | AAPL | Stock | 150.3877 | 150.75 | 149.78 | 150.4758 | 3887543.0 |
| 2022-11-15 15:00:00 | AAPL | Stock | 150.48 | 150.89 | 150.2 | 150.555 | 4120359.0 |
| 2022-11-15 15:30:00 | AAPL | Stock | 150.56 | 150.6 | 149.63 | 150.07 | 6575334.0 |
| 2022-11-15 16:00:00 | AAPL | Stock | 150.07 | 150.45 | 149.95 | 149.95 | 9270251.0 |
| 2022-11-15 16:30:00 | AAPL | Stock | 149.95 | 150.16 | 149.84 | 150.07 | 79673.0 |
| 2022-11-15 17:00:00 | AAPL | Stock | 150.07 | 150.09 | 149.82 | 150.04 | 42200.0 |
| 2022-11-15 17:30:00 | AAPL | Stock | 150.04 | 150.04 | 149.75 | 149.9 | 51026.0 |
| 2022-11-15 18:00:00 | AAPL | Stock | 149.9 | 149.9 | 149.59 | 149.83 | 20348.0 |
| 2022-11-15 18:30:00 | AAPL | Stock | 149.8 | 150.07 | 149.75 | 150.03 | 12771.0 |
| 2022-11-15 19:00:00 | AAPL | Stock | 150.04 | 150.28 | 149.72 | 149.72 | 18320.0 |
| 2022-11-15 19:30:00 | AAPL | Stock | 149.79 | 149.97 | 149.69 | 149.7 | 10415.0 |
| 2022-11-15 04:00:00 | MSFT | Stock | 243.9 | 244.01 | 242.79 | 243.0 | 29482.0 |
| 2022-11-15 04:30:00 | MSFT | Stock | 243.1 | 243.5 | 242.9 | 243.5 | 16620.0 |
| 2022-11-15 05:00:00 | MSFT | Stock | 243.76 | 244.29 | 243.65 | 243.65 | 2580.0 |
| 2022-11-15 05:30:00 | MSFT | Stock | 243.87 | 244.15 | 243.85 | 243.87 | 700.0 |
| 2022-11-15 06:00:00 | MSFT | Stock | 244.14 | 244.15 | 243.99 | 243.99 | 20182.0 |
| 2022-11-15 06:30:00 | MSFT | Stock | 243.8 | 243.97 | 243.8 | 243.97 | 5072.0 |
| 2022-11-15 07:00:00 | MSFT | Stock | 243.97 | 244.42 | 243.62 | 244.35 | 12454.0 |
| 2022-11-15 07:30:00 | MSFT | Stock | 244.32 | 244.87 | 244.32 | 244.81 | 13192.0 |
| 2022-11-15 08:00:00 | MSFT | Stock | 243.8 | 245.44 | 240.947 | 245.0 | 53771.0 |
| 2022-11-15 08:30:00 | MSFT | Stock | 245.48 | 249.83 | 245.25 | 248.4 | 123843.0 |
| 2022-11-15 09:00:00 | MSFT | Stock | 248.69 | 248.69 | 245.46 | 245.75 | 77883.0 |
| 2022-11-15 09:30:00 | MSFT | Stock | 245.59 | 247.0 | 244.02 | 245.33 | 3286764.0 |
| 2022-11-15 10:00:00 | MSFT | Stock | 245.34 | 246.1 | 244.94 | 245.08 | 1843550.0 |
| 2022-11-15 10:30:00 | MSFT | Stock | 245.085 | 245.35 | 243.6 | 244.525 | 1278193.0 |
| 2022-11-15 11:00:00 | MSFT | Stock | 244.49 | 245.13 | 243.67 | 244.66 | 900406.0 |
| 2022-11-15 11:30:00 | MSFT | Stock | 244.67 | 245.6 | 244.6584 | 245.28 | 931397.0 |
| 2022-11-15 12:00:00 | MSFT | Stock | 245.3 | 245.31 | 244.13 | 244.4 | 854252.0 |
| 2022-11-15 12:30:00 | MSFT | Stock | 244.4 | 245.025 | 244.21 | 244.69 | 557758.0 |
> showing 50 of 106,200 rows — these rows as CSV