PREVIEW / stock_30min / 2023-06-13
file: by_date/stock_30min/2023/2023-06-13.parquet size: 2.1 MB rows: 104,605 symbols: 1,637
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-06-13 04:00:00 | AAPL | Stock | 182.76 | 182.87 | 182.01 | 182.52 | 37939.0 |
| 2023-06-13 04:30:00 | AAPL | Stock | 182.67 | 182.68 | 182.5 | 182.53 | 6551.0 |
| 2023-06-13 05:00:00 | AAPL | Stock | 182.53 | 182.53 | 182.24 | 182.25 | 47499.0 |
| 2023-06-13 05:30:00 | AAPL | Stock | 182.21 | 182.32 | 182.15 | 182.26 | 13949.0 |
| 2023-06-13 06:00:00 | AAPL | Stock | 182.17 | 182.28 | 182.13 | 182.25 | 12689.0 |
| 2023-06-13 06:30:00 | AAPL | Stock | 182.28 | 182.35 | 182.15 | 182.2 | 17980.0 |
| 2023-06-13 07:00:00 | AAPL | Stock | 182.25 | 182.75 | 182.25 | 182.45 | 63845.0 |
| 2023-06-13 07:30:00 | AAPL | Stock | 182.45 | 182.52 | 182.15 | 182.29 | 46156.0 |
| 2023-06-13 08:00:00 | AAPL | Stock | 182.2485 | 183.4 | 182.17 | 183.33 | 273457.0 |
| 2023-06-13 08:30:00 | AAPL | Stock | 183.2 | 183.75 | 182.45 | 183.07 | 361486.0 |
| 2023-06-13 09:00:00 | AAPL | Stock | 183.07 | 183.38 | 182.65 | 182.79 | 395382.0 |
| 2023-06-13 09:30:00 | AAPL | Stock | 182.79 | 184.15 | 182.71 | 183.22 | 7880839.0 |
| 2023-06-13 10:00:00 | AAPL | Stock | 183.26 | 183.63 | 182.62 | 182.76 | 4124265.0 |
| 2023-06-13 10:30:00 | AAPL | Stock | 182.77 | 183.155 | 182.46 | 182.95 | 2812803.0 |
| 2023-06-13 11:00:00 | AAPL | Stock | 182.95 | 183.7505 | 182.82 | 183.4 | 2356070.0 |
| 2023-06-13 11:30:00 | AAPL | Stock | 183.4 | 183.469 | 183.02 | 183.12 | 1812527.0 |
| 2023-06-13 12:00:00 | AAPL | Stock | 183.12 | 183.36 | 182.9601 | 183.17 | 1662759.0 |
| 2023-06-13 12:30:00 | AAPL | Stock | 183.18 | 183.53 | 183.01 | 183.46 | 1417496.0 |
| 2023-06-13 13:00:00 | AAPL | Stock | 183.465 | 183.55 | 182.885 | 183.0208 | 1799767.0 |
| 2023-06-13 13:30:00 | AAPL | Stock | 183.03 | 183.14 | 182.76 | 183.0199 | 1741681.0 |
| 2023-06-13 14:00:00 | AAPL | Stock | 183.02 | 183.09 | 182.72 | 182.84 | 1671561.0 |
| 2023-06-13 14:30:00 | AAPL | Stock | 182.84 | 183.02 | 182.44 | 182.92 | 2145218.0 |
| 2023-06-13 15:00:00 | AAPL | Stock | 182.9197 | 183.13 | 182.68 | 182.98 | 1787799.0 |
| 2023-06-13 15:30:00 | AAPL | Stock | 182.975 | 183.38 | 182.92 | 183.32 | 3573834.0 |
| 2023-06-13 16:00:00 | AAPL | Stock | 183.32 | 183.34 | 183.17 | 183.19 | 5233612.0 |
| 2023-06-13 16:30:00 | AAPL | Stock | 183.2 | 183.31 | 183.17 | 183.21 | 31462.0 |
| 2023-06-13 17:00:00 | AAPL | Stock | 183.22 | 183.31 | 183.2 | 183.2612 | 22684.0 |
| 2023-06-13 17:30:00 | AAPL | Stock | 183.25 | 183.25 | 183.22 | 183.23 | 11286.0 |
| 2023-06-13 18:00:00 | AAPL | Stock | 183.22 | 183.25 | 183.2 | 183.24 | 10707.0 |
| 2023-06-13 18:30:00 | AAPL | Stock | 183.25 | 183.28 | 183.23 | 183.26 | 6177.0 |
| 2023-06-13 19:00:00 | AAPL | Stock | 183.26 | 183.26 | 183.15 | 183.24 | 16874.0 |
| 2023-06-13 19:30:00 | AAPL | Stock | 183.21 | 183.22 | 183.05 | 183.0799 | 16946.0 |
| 2023-06-13 04:00:00 | MSFT | Stock | 335.75 | 335.75 | 333.68 | 334.6 | 3345.0 |
| 2023-06-13 04:30:00 | MSFT | Stock | 334.98 | 334.98 | 334.85 | 334.88 | 1572.0 |
| 2023-06-13 05:00:00 | MSFT | Stock | 334.76 | 334.77 | 334.76 | 334.76 | 425.0 |
| 2023-06-13 05:30:00 | MSFT | Stock | 334.61 | 334.61 | 333.8 | 333.96 | 2285.0 |
| 2023-06-13 06:00:00 | MSFT | Stock | 334.0 | 334.15 | 333.0 | 333.24 | 2183.0 |
| 2023-06-13 06:30:00 | MSFT | Stock | 333.71 | 333.73 | 333.45 | 333.54 | 1892.0 |
| 2023-06-13 07:00:00 | MSFT | Stock | 333.65 | 333.75 | 333.18 | 333.44 | 6336.0 |
| 2023-06-13 07:30:00 | MSFT | Stock | 333.62 | 333.62 | 332.66 | 332.66 | 5495.0 |
| 2023-06-13 08:00:00 | MSFT | Stock | 333.3 | 336.1 | 332.5 | 333.02 | 23708.0 |
| 2023-06-13 08:30:00 | MSFT | Stock | 333.02 | 334.88 | 332.12 | 334.472 | 39531.0 |
| 2023-06-13 09:00:00 | MSFT | Stock | 334.48 | 336.65 | 334.08 | 334.46 | 61746.0 |
| 2023-06-13 09:30:00 | MSFT | Stock | 334.465 | 336.98 | 332.05 | 332.4 | 2807775.0 |
| 2023-06-13 10:00:00 | MSFT | Stock | 332.46 | 333.08 | 330.39 | 331.22 | 1537025.0 |
| 2023-06-13 10:30:00 | MSFT | Stock | 331.24 | 332.86 | 330.99 | 332.3 | 1012583.0 |
| 2023-06-13 11:00:00 | MSFT | Stock | 332.305 | 333.31 | 331.54 | 333.11 | 810678.0 |
| 2023-06-13 11:30:00 | MSFT | Stock | 333.12 | 333.22 | 331.73 | 331.755 | 600256.0 |
| 2023-06-13 12:00:00 | MSFT | Stock | 331.8 | 332.66 | 331.4 | 332.36 | 548336.0 |
| 2023-06-13 12:30:00 | MSFT | Stock | 332.38 | 333.64 | 332.34 | 333.6101 | 484065.0 |
> showing 50 of 104,605 rows — these rows as CSV