PREVIEW / stock_30min / 2022-12-28
file: by_date/stock_30min/2022/2022-12-28.parquet size: 2.1 MB rows: 103,327 symbols: 1,961
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-12-28 04:00:00 | AAPL | Stock | 130.52 | 130.52 | 129.52 | 129.6 | 22788.0 |
| 2022-12-28 04:30:00 | AAPL | Stock | 129.61 | 129.84 | 129.61 | 129.84 | 4246.0 |
| 2022-12-28 05:00:00 | AAPL | Stock | 129.89 | 129.96 | 129.89 | 129.91 | 10242.0 |
| 2022-12-28 05:30:00 | AAPL | Stock | 129.81 | 130.0 | 129.73 | 130.0 | 15715.0 |
| 2022-12-28 06:00:00 | AAPL | Stock | 129.97 | 130.1 | 129.85 | 129.85 | 9601.0 |
| 2022-12-28 06:30:00 | AAPL | Stock | 129.84 | 130.24 | 129.81 | 130.1 | 6561.0 |
| 2022-12-28 07:00:00 | AAPL | Stock | 130.1 | 130.48 | 129.96 | 130.26 | 18258.0 |
| 2022-12-28 07:30:00 | AAPL | Stock | 130.27 | 130.42 | 130.2 | 130.25 | 6828.0 |
| 2022-12-28 08:00:00 | AAPL | Stock | 130.15 | 130.43 | 129.54 | 130.04 | 98187.0 |
| 2022-12-28 08:30:00 | AAPL | Stock | 130.04 | 130.04 | 129.78 | 129.87 | 66830.0 |
| 2022-12-28 09:00:00 | AAPL | Stock | 129.84 | 130.23 | 129.5 | 129.6 | 122013.0 |
| 2022-12-28 09:30:00 | AAPL | Stock | 129.73 | 131.0275 | 129.13 | 129.99 | 7955103.0 |
| 2022-12-28 10:00:00 | AAPL | Stock | 129.975 | 130.51 | 129.54 | 129.655 | 4560555.0 |
| 2022-12-28 10:30:00 | AAPL | Stock | 129.64 | 129.965 | 128.06 | 128.06 | 5620498.0 |
| 2022-12-28 11:00:00 | AAPL | Stock | 128.07 | 128.22 | 127.3 | 127.62 | 7088878.0 |
| 2022-12-28 11:30:00 | AAPL | Stock | 127.6299 | 127.88 | 126.46 | 126.6245 | 7149064.0 |
| 2022-12-28 12:00:00 | AAPL | Stock | 126.6153 | 126.88 | 126.41 | 126.79 | 4429556.0 |
| 2022-12-28 12:30:00 | AAPL | Stock | 126.81 | 127.735 | 126.79 | 127.635 | 4627151.0 |
| 2022-12-28 13:00:00 | AAPL | Stock | 127.64 | 128.39 | 127.34 | 127.437 | 4137807.0 |
| 2022-12-28 13:30:00 | AAPL | Stock | 127.43 | 127.44 | 126.84 | 127.085 | 3256515.0 |
| 2022-12-28 14:00:00 | AAPL | Stock | 127.09 | 127.19 | 126.87 | 127.0382 | 2606195.0 |
| 2022-12-28 14:30:00 | AAPL | Stock | 127.04 | 127.5 | 126.81 | 126.84 | 3539914.0 |
| 2022-12-28 15:00:00 | AAPL | Stock | 126.83 | 126.84 | 125.92 | 126.19 | 5706923.0 |
| 2022-12-28 15:30:00 | AAPL | Stock | 126.185 | 126.27 | 125.87 | 126.05 | 7942348.0 |
| 2022-12-28 16:00:00 | AAPL | Stock | 126.05 | 126.3159 | 126.0 | 126.13 | 5806265.0 |
| 2022-12-28 16:30:00 | AAPL | Stock | 126.1201 | 126.28 | 126.04 | 126.26 | 157549.0 |
| 2022-12-28 17:00:00 | AAPL | Stock | 126.22 | 126.2753 | 126.04 | 126.1 | 175708.0 |
| 2022-12-28 17:30:00 | AAPL | Stock | 126.06 | 126.15 | 126.05 | 126.1 | 36228.0 |
| 2022-12-28 18:00:00 | AAPL | Stock | 126.14 | 126.28 | 126.14 | 126.22 | 35932.0 |
| 2022-12-28 18:30:00 | AAPL | Stock | 126.22 | 126.26 | 126.21 | 126.26 | 12694.0 |
| 2022-12-28 19:00:00 | AAPL | Stock | 126.26 | 126.29 | 126.16 | 126.19 | 27679.0 |
| 2022-12-28 19:30:00 | AAPL | Stock | 126.2 | 126.32 | 126.17 | 126.32 | 19602.0 |
| 2022-12-28 04:00:00 | MSFT | Stock | 236.4 | 237.1 | 236.33 | 236.33 | 8100.0 |
| 2022-12-28 04:30:00 | MSFT | Stock | 236.53 | 237.33 | 236.53 | 237.33 | 921.0 |
| 2022-12-28 05:30:00 | MSFT | Stock | 237.28 | 237.31 | 237.05 | 237.31 | 1522.0 |
| 2022-12-28 06:00:00 | MSFT | Stock | 237.33 | 237.33 | 237.04 | 237.04 | 1441.0 |
| 2022-12-28 06:30:00 | MSFT | Stock | 237.0 | 237.4 | 237.0 | 237.35 | 1400.0 |
| 2022-12-28 07:00:00 | MSFT | Stock | 237.34 | 237.5 | 237.32 | 237.37 | 1177.0 |
| 2022-12-28 07:30:00 | MSFT | Stock | 237.5 | 237.54 | 237.32 | 237.32 | 2750.0 |
| 2022-12-28 08:00:00 | MSFT | Stock | 237.18 | 237.82 | 236.368 | 237.15 | 10080.0 |
| 2022-12-28 08:30:00 | MSFT | Stock | 237.06 | 237.19 | 236.89 | 236.89 | 2784.0 |
| 2022-12-28 09:00:00 | MSFT | Stock | 237.09 | 237.39 | 236.56 | 237.11 | 17189.0 |
| 2022-12-28 09:30:00 | MSFT | Stock | 237.23 | 239.25 | 236.55 | 238.5235 | 1464846.0 |
| 2022-12-28 10:00:00 | MSFT | Stock | 238.53 | 239.72 | 237.8 | 238.03 | 1047597.0 |
| 2022-12-28 10:30:00 | MSFT | Stock | 238.01 | 238.72 | 236.9 | 236.99 | 822547.0 |
| 2022-12-28 11:00:00 | MSFT | Stock | 236.95 | 237.18 | 236.09 | 236.47 | 1000288.0 |
| 2022-12-28 11:30:00 | MSFT | Stock | 236.47 | 236.58 | 235.56 | 235.77 | 749474.0 |
| 2022-12-28 12:00:00 | MSFT | Stock | 235.76 | 236.055 | 235.2513 | 235.87 | 648244.0 |
| 2022-12-28 12:30:00 | MSFT | Stock | 235.89 | 236.98 | 235.86 | 236.86 | 572606.0 |
| 2022-12-28 13:00:00 | MSFT | Stock | 236.88 | 237.73 | 236.6533 | 236.85 | 762977.0 |
> showing 50 of 103,327 rows — these rows as CSV