PREVIEW / stock_30min / 2021-11-29
file: by_date/stock_30min/2021/2021-11-29.parquet size: 2.3 MB rows: 114,914 symbols: 2,679
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-29 04:00:00 | AAPL | Stock | 158.11 | 158.95 | 157.4 | 158.76 | 38392.0 |
| 2021-11-29 04:30:00 | AAPL | Stock | 158.8 | 158.82 | 158.35 | 158.35 | 15677.0 |
| 2021-11-29 05:00:00 | AAPL | Stock | 158.4 | 159.0 | 158.4 | 158.92 | 16389.0 |
| 2021-11-29 05:30:00 | AAPL | Stock | 158.99 | 159.2 | 158.81 | 159.18 | 20989.0 |
| 2021-11-29 06:00:00 | AAPL | Stock | 159.15 | 159.22 | 158.92 | 159.08 | 31647.0 |
| 2021-11-29 06:30:00 | AAPL | Stock | 159.05 | 159.1 | 158.8 | 158.98 | 24721.0 |
| 2021-11-29 07:00:00 | AAPL | Stock | 159.0 | 159.03 | 158.52 | 158.74 | 117828.0 |
| 2021-11-29 07:30:00 | AAPL | Stock | 158.72 | 159.16 | 158.72 | 159.13 | 78320.0 |
| 2021-11-29 08:00:00 | AAPL | Stock | 158.75 | 159.43 | 158.52 | 159.25 | 512698.0 |
| 2021-11-29 08:30:00 | AAPL | Stock | 159.26 | 159.88 | 159.25 | 159.81 | 306149.0 |
| 2021-11-29 09:00:00 | AAPL | Stock | 159.81 | 159.86 | 159.18 | 159.36 | 262367.0 |
| 2021-11-29 09:30:00 | AAPL | Stock | 159.37 | 160.58 | 159.08 | 160.24 | 13002471.0 |
| 2021-11-29 10:00:00 | AAPL | Stock | 160.23 | 160.53 | 159.33 | 159.4099 | 7213776.0 |
| 2021-11-29 10:30:00 | AAPL | Stock | 159.405 | 159.54 | 158.7901 | 159.2 | 5543743.0 |
| 2021-11-29 11:00:00 | AAPL | Stock | 159.21 | 159.72 | 158.95 | 159.52 | 3937422.0 |
| 2021-11-29 11:30:00 | AAPL | Stock | 159.52 | 160.44 | 159.45 | 160.36 | 3992641.0 |
| 2021-11-29 12:00:00 | AAPL | Stock | 160.3643 | 160.7 | 160.19 | 160.555 | 4242076.0 |
| 2021-11-29 12:30:00 | AAPL | Stock | 160.555 | 160.88 | 160.38 | 160.525 | 3503252.0 |
| 2021-11-29 13:00:00 | AAPL | Stock | 160.53 | 160.71 | 160.45 | 160.675 | 2525503.0 |
| 2021-11-29 13:30:00 | AAPL | Stock | 160.6748 | 161.19 | 160.62 | 161.01 | 3180196.0 |
| 2021-11-29 14:00:00 | AAPL | Stock | 161.01 | 161.11 | 160.4 | 160.485 | 3035340.0 |
| 2021-11-29 14:30:00 | AAPL | Stock | 160.49 | 160.98 | 160.475 | 160.76 | 2904306.0 |
| 2021-11-29 15:00:00 | AAPL | Stock | 160.76 | 160.85 | 160.27 | 160.345 | 3304981.0 |
| 2021-11-29 15:30:00 | AAPL | Stock | 160.33 | 160.5 | 159.98 | 160.23 | 7862940.0 |
| 2021-11-29 16:00:00 | AAPL | Stock | 160.48 | 160.54 | 160.1 | 160.45 | 8594614.0 |
| 2021-11-29 16:30:00 | AAPL | Stock | 160.47 | 160.54 | 160.24 | 160.5 | 42070.0 |
| 2021-11-29 17:00:00 | AAPL | Stock | 160.51 | 160.54 | 160.4 | 160.4 | 17836.0 |
| 2021-11-29 17:30:00 | AAPL | Stock | 160.42 | 160.43 | 160.31 | 160.36 | 5104.0 |
| 2021-11-29 18:00:00 | AAPL | Stock | 160.36 | 160.57 | 160.36 | 160.52 | 24628.0 |
| 2021-11-29 18:30:00 | AAPL | Stock | 160.55 | 160.58 | 160.5 | 160.57 | 12762.0 |
| 2021-11-29 19:00:00 | AAPL | Stock | 160.52 | 160.56 | 160.52 | 160.55 | 20711.0 |
| 2021-11-29 19:30:00 | AAPL | Stock | 160.53 | 160.63 | 160.52 | 160.63 | 25992.0 |
| 2021-11-29 04:00:00 | MSFT | Stock | 332.35 | 334.4 | 332.35 | 333.59 | 3831.0 |
| 2021-11-29 04:30:00 | MSFT | Stock | 333.5 | 333.5 | 333.2 | 333.3 | 500.0 |
| 2021-11-29 05:00:00 | MSFT | Stock | 333.1 | 333.42 | 333.1 | 333.42 | 1857.0 |
| 2021-11-29 05:30:00 | MSFT | Stock | 333.49 | 334.27 | 333.49 | 334.27 | 4677.0 |
| 2021-11-29 06:00:00 | MSFT | Stock | 334.12 | 334.33 | 333.85 | 334.01 | 3523.0 |
| 2021-11-29 06:30:00 | MSFT | Stock | 334.03 | 334.3 | 333.78 | 333.78 | 3901.0 |
| 2021-11-29 07:00:00 | MSFT | Stock | 333.96 | 333.98 | 333.2 | 333.6 | 14519.0 |
| 2021-11-29 07:30:00 | MSFT | Stock | 333.49 | 333.87 | 333.49 | 333.7 | 8684.0 |
| 2021-11-29 08:00:00 | MSFT | Stock | 333.32 | 334.0 | 333.2 | 333.68 | 42218.0 |
| 2021-11-29 08:30:00 | MSFT | Stock | 333.6 | 334.41 | 329.68 | 334.3 | 127907.0 |
| 2021-11-29 09:00:00 | MSFT | Stock | 334.25 | 334.98 | 334.0 | 334.98 | 27649.0 |
| 2021-11-29 09:30:00 | MSFT | Stock | 334.98 | 337.66 | 334.74 | 337.205 | 3256319.0 |
| 2021-11-29 10:00:00 | MSFT | Stock | 337.17 | 339.03 | 336.87 | 337.8 | 1980942.0 |
| 2021-11-29 10:30:00 | MSFT | Stock | 337.83 | 338.48 | 337.11 | 337.54 | 1393297.0 |
| 2021-11-29 11:00:00 | MSFT | Stock | 337.55 | 337.74 | 336.1 | 336.29 | 1028647.0 |
| 2021-11-29 11:30:00 | MSFT | Stock | 336.27 | 338.1 | 336.27 | 337.97 | 889842.0 |
| 2021-11-29 12:00:00 | MSFT | Stock | 337.98 | 338.13 | 337.305 | 337.33 | 689135.0 |
| 2021-11-29 12:30:00 | MSFT | Stock | 337.35 | 338.0599 | 337.26 | 337.72 | 711024.0 |
> showing 50 of 114,914 rows — these rows as CSV