PREVIEW / stock_30min / 2021-12-21
file: by_date/stock_30min/2021/2021-12-21.parquet size: 2.2 MB rows: 111,039 symbols: 2,608
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-12-21 04:00:00 | AAPL | Stock | 171.84 | 171.84 | 171.28 | 171.65 | 17095.0 |
| 2021-12-21 04:30:00 | AAPL | Stock | 171.61 | 171.61 | 170.93 | 171.0 | 21228.0 |
| 2021-12-21 05:00:00 | AAPL | Stock | 170.97 | 171.18 | 170.77 | 170.9 | 17379.0 |
| 2021-12-21 05:30:00 | AAPL | Stock | 170.8 | 171.05 | 170.64 | 170.85 | 25126.0 |
| 2021-12-21 06:00:00 | AAPL | Stock | 170.85 | 171.55 | 170.85 | 171.55 | 23236.0 |
| 2021-12-21 06:30:00 | AAPL | Stock | 171.74 | 171.74 | 171.39 | 171.52 | 20679.0 |
| 2021-12-21 07:00:00 | AAPL | Stock | 171.51 | 172.0 | 171.4 | 171.96 | 76887.0 |
| 2021-12-21 07:30:00 | AAPL | Stock | 171.99 | 172.33 | 171.86 | 172.15 | 88335.0 |
| 2021-12-21 08:00:00 | AAPL | Stock | 171.5201 | 172.28 | 171.4 | 171.94 | 299766.0 |
| 2021-12-21 08:30:00 | AAPL | Stock | 171.97 | 172.49 | 169.75 | 169.75 | 273328.0 |
| 2021-12-21 09:00:00 | AAPL | Stock | 172.43 | 172.5 | 171.55 | 171.56 | 375342.0 |
| 2021-12-21 09:30:00 | AAPL | Stock | 171.55 | 172.32 | 170.02 | 170.3311 | 10713162.0 |
| 2021-12-21 10:00:00 | AAPL | Stock | 170.34 | 170.96 | 169.35 | 169.5729 | 6993186.0 |
| 2021-12-21 10:30:00 | AAPL | Stock | 169.585 | 169.97 | 169.12 | 169.85 | 5017585.0 |
| 2021-12-21 11:00:00 | AAPL | Stock | 169.84 | 170.7 | 169.82 | 170.2991 | 4796481.0 |
| 2021-12-21 11:30:00 | AAPL | Stock | 170.3 | 171.25 | 170.14 | 170.735 | 4847740.0 |
| 2021-12-21 12:00:00 | AAPL | Stock | 170.74 | 171.54 | 170.46 | 171.485 | 3898505.0 |
| 2021-12-21 12:30:00 | AAPL | Stock | 171.49 | 171.53 | 170.7117 | 170.995 | 3722798.0 |
| 2021-12-21 13:00:00 | AAPL | Stock | 171.0 | 171.1 | 170.66 | 170.9612 | 3078911.0 |
| 2021-12-21 13:30:00 | AAPL | Stock | 170.9751 | 171.315 | 170.81 | 171.24 | 3431827.0 |
| 2021-12-21 14:00:00 | AAPL | Stock | 171.25 | 172.09 | 171.1901 | 172.0899 | 4035512.0 |
| 2021-12-21 14:30:00 | AAPL | Stock | 172.09 | 173.03 | 172.02 | 172.9382 | 5676586.0 |
| 2021-12-21 15:00:00 | AAPL | Stock | 172.94 | 173.04 | 172.37 | 172.577 | 4408207.0 |
| 2021-12-21 15:30:00 | AAPL | Stock | 172.575 | 173.2 | 172.191 | 172.98 | 7295611.0 |
| 2021-12-21 16:00:00 | AAPL | Stock | 172.975 | 173.14 | 170.82 | 172.84 | 6857747.0 |
| 2021-12-21 16:30:00 | AAPL | Stock | 172.8 | 172.99 | 172.8 | 172.92 | 694162.0 |
| 2021-12-21 17:00:00 | AAPL | Stock | 172.96 | 173.05 | 172.89 | 173.03 | 24285.0 |
| 2021-12-21 17:30:00 | AAPL | Stock | 173.08 | 173.08 | 172.91 | 173.03 | 10266.0 |
| 2021-12-21 18:00:00 | AAPL | Stock | 172.98 | 172.98 | 172.79 | 172.8 | 10887.0 |
| 2021-12-21 18:30:00 | AAPL | Stock | 172.8 | 172.88 | 172.6 | 172.6 | 19501.0 |
| 2021-12-21 19:00:00 | AAPL | Stock | 172.6 | 172.72 | 172.57 | 172.65 | 11361.0 |
| 2021-12-21 19:30:00 | AAPL | Stock | 172.65 | 172.65 | 172.53 | 172.58 | 19059.0 |
| 2021-12-21 04:00:00 | MSFT | Stock | 322.62 | 323.55 | 322.61 | 323.49 | 12171.0 |
| 2021-12-21 04:30:00 | MSFT | Stock | 322.94 | 322.95 | 322.07 | 322.07 | 891.0 |
| 2021-12-21 05:00:00 | MSFT | Stock | 322.6 | 322.7 | 322.55 | 322.55 | 300.0 |
| 2021-12-21 05:30:00 | MSFT | Stock | 322.7 | 322.7 | 322.25 | 322.3 | 4274.0 |
| 2021-12-21 06:00:00 | MSFT | Stock | 322.7 | 323.26 | 322.7 | 323.14 | 3725.0 |
| 2021-12-21 06:30:00 | MSFT | Stock | 323.5 | 323.58 | 323.35 | 323.36 | 3228.0 |
| 2021-12-21 07:00:00 | MSFT | Stock | 323.4 | 323.4 | 323.01 | 323.05 | 7433.0 |
| 2021-12-21 07:30:00 | MSFT | Stock | 323.1 | 323.42 | 323.04 | 323.42 | 7580.0 |
| 2021-12-21 08:00:00 | MSFT | Stock | 323.0016 | 323.51 | 320.709 | 323.41 | 40810.0 |
| 2021-12-21 08:30:00 | MSFT | Stock | 323.48 | 323.5 | 323.15 | 323.4 | 14759.0 |
| 2021-12-21 09:00:00 | MSFT | Stock | 323.34 | 323.64 | 322.34 | 323.3 | 26074.0 |
| 2021-12-21 09:30:00 | MSFT | Stock | 323.1 | 324.47 | 321.36 | 322.14 | 1991978.0 |
| 2021-12-21 10:00:00 | MSFT | Stock | 322.18 | 322.6199 | 319.8 | 319.95 | 1162183.0 |
| 2021-12-21 10:30:00 | MSFT | Stock | 320.0 | 321.45 | 319.8 | 321.23 | 982423.0 |
| 2021-12-21 11:00:00 | MSFT | Stock | 321.23 | 322.62 | 321.08 | 322.05 | 960386.0 |
| 2021-12-21 11:30:00 | MSFT | Stock | 322.06 | 324.03 | 322.0431 | 323.325 | 1010312.0 |
| 2021-12-21 12:00:00 | MSFT | Stock | 323.31 | 325.08 | 322.995 | 325.03 | 822414.0 |
| 2021-12-21 12:30:00 | MSFT | Stock | 325.04 | 325.95 | 324.98 | 325.78 | 891382.0 |
> showing 50 of 111,039 rows — these rows as CSV