PREVIEW / stock_30min / 2022-12-15
file: by_date/stock_30min/2022/2022-12-15.parquet size: 2.1 MB rows: 104,371 symbols: 2,038
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-15 04:00:00 | AAPL | Stock | 142.68 | 142.73 | 141.3 | 141.52 | 24767.0 |
| 2022-12-15 04:30:00 | AAPL | Stock | 141.55 | 141.55 | 141.2 | 141.45 | 10059.0 |
| 2022-12-15 05:00:00 | AAPL | Stock | 141.32 | 141.5 | 141.28 | 141.29 | 5648.0 |
| 2022-12-15 05:30:00 | AAPL | Stock | 141.32 | 141.57 | 141.29 | 141.35 | 12715.0 |
| 2022-12-15 06:00:00 | AAPL | Stock | 141.3 | 141.72 | 141.22 | 141.72 | 13753.0 |
| 2022-12-15 06:30:00 | AAPL | Stock | 141.65 | 141.77 | 141.6 | 141.77 | 14356.0 |
| 2022-12-15 07:00:00 | AAPL | Stock | 141.88 | 142.11 | 141.67 | 141.75 | 41046.0 |
| 2022-12-15 07:30:00 | AAPL | Stock | 141.78 | 141.79 | 141.45 | 141.66 | 41493.0 |
| 2022-12-15 08:00:00 | AAPL | Stock | 142.08 | 142.3 | 141.2215 | 141.36 | 117234.0 |
| 2022-12-15 08:30:00 | AAPL | Stock | 141.4 | 141.677 | 140.83 | 141.43 | 157682.0 |
| 2022-12-15 09:00:00 | AAPL | Stock | 141.37 | 141.66 | 141.0 | 141.12 | 158725.0 |
| 2022-12-15 09:30:00 | AAPL | Stock | 141.11 | 141.8 | 138.9 | 139.08 | 9475178.0 |
| 2022-12-15 10:00:00 | AAPL | Stock | 139.1 | 139.35 | 138.49 | 138.8701 | 6001669.0 |
| 2022-12-15 10:30:00 | AAPL | Stock | 138.87 | 139.38 | 138.46 | 138.77 | 5109782.0 |
| 2022-12-15 11:00:00 | AAPL | Stock | 138.78 | 139.09 | 137.94 | 138.25 | 5582978.0 |
| 2022-12-15 11:30:00 | AAPL | Stock | 138.25 | 138.4 | 137.71 | 137.87 | 4128553.0 |
| 2022-12-15 12:00:00 | AAPL | Stock | 137.865 | 138.2277 | 137.81 | 137.9 | 3086924.0 |
| 2022-12-15 12:30:00 | AAPL | Stock | 137.89 | 138.18 | 137.21 | 137.27 | 3481998.0 |
| 2022-12-15 13:00:00 | AAPL | Stock | 137.28 | 137.37 | 136.68 | 136.965 | 4248237.0 |
| 2022-12-15 13:30:00 | AAPL | Stock | 136.96 | 137.22 | 136.5 | 136.775 | 3954444.0 |
| 2022-12-15 14:00:00 | AAPL | Stock | 136.78 | 136.89 | 136.19 | 136.39 | 3852375.0 |
| 2022-12-15 14:30:00 | AAPL | Stock | 136.4 | 137.09 | 136.38 | 136.91 | 4139270.0 |
| 2022-12-15 15:00:00 | AAPL | Stock | 136.91 | 137.25 | 136.6 | 137.125 | 5132211.0 |
| 2022-12-15 15:30:00 | AAPL | Stock | 137.1299 | 137.145 | 136.025 | 136.49 | 10579548.0 |
| 2022-12-15 16:00:00 | AAPL | Stock | 136.5 | 136.85 | 136.22 | 136.23 | 13425468.0 |
| 2022-12-15 16:30:00 | AAPL | Stock | 136.22 | 136.5 | 136.21 | 136.28 | 112997.0 |
| 2022-12-15 17:00:00 | AAPL | Stock | 136.32 | 136.5 | 136.32 | 136.4 | 143506.0 |
| 2022-12-15 17:30:00 | AAPL | Stock | 136.38 | 136.42 | 136.26 | 136.35 | 44621.0 |
| 2022-12-15 18:00:00 | AAPL | Stock | 136.36 | 136.5 | 136.36 | 136.46 | 26937.0 |
| 2022-12-15 18:30:00 | AAPL | Stock | 136.46 | 136.49 | 136.43 | 136.4805 | 14199.0 |
| 2022-12-15 19:00:00 | AAPL | Stock | 136.49 | 136.67 | 136.49 | 136.63 | 23067.0 |
| 2022-12-15 19:30:00 | AAPL | Stock | 136.61 | 136.68 | 136.6 | 136.62 | 28930.0 |
| 2022-12-15 04:00:00 | MSFT | Stock | 255.71 | 255.71 | 253.71 | 254.06 | 7470.0 |
| 2022-12-15 04:30:00 | MSFT | Stock | 254.4 | 254.6 | 254.15 | 254.33 | 2624.0 |
| 2022-12-15 05:00:00 | MSFT | Stock | 254.26 | 254.37 | 254.25 | 254.37 | 1077.0 |
| 2022-12-15 05:30:00 | MSFT | Stock | 254.26 | 254.26 | 253.92 | 253.92 | 2134.0 |
| 2022-12-15 06:00:00 | MSFT | Stock | 253.92 | 254.33 | 253.84 | 254.33 | 500.0 |
| 2022-12-15 06:30:00 | MSFT | Stock | 254.19 | 254.19 | 254.08 | 254.1 | 562.0 |
| 2022-12-15 07:00:00 | MSFT | Stock | 254.23 | 255.41 | 254.23 | 255.29 | 26385.0 |
| 2022-12-15 07:30:00 | MSFT | Stock | 255.27 | 255.37 | 254.9 | 255.23 | 11760.0 |
| 2022-12-15 08:00:00 | MSFT | Stock | 254.28 | 256.577 | 254.15 | 254.69 | 31708.0 |
| 2022-12-15 08:30:00 | MSFT | Stock | 254.85 | 254.85 | 253.25 | 254.35 | 20597.0 |
| 2022-12-15 09:00:00 | MSFT | Stock | 254.3 | 254.65 | 253.32 | 253.72 | 31795.0 |
| 2022-12-15 09:30:00 | MSFT | Stock | 253.71 | 254.2 | 250.895 | 251.25 | 2436772.0 |
| 2022-12-15 10:00:00 | MSFT | Stock | 251.26 | 251.6 | 250.19 | 250.66 | 1357112.0 |
| 2022-12-15 10:30:00 | MSFT | Stock | 250.64 | 251.32 | 249.55 | 249.7949 | 1400914.0 |
| 2022-12-15 11:00:00 | MSFT | Stock | 249.79 | 250.25 | 248.51 | 249.25 | 1297550.0 |
| 2022-12-15 11:30:00 | MSFT | Stock | 249.23 | 249.435 | 248.38 | 248.6191 | 1040774.0 |
| 2022-12-15 12:00:00 | MSFT | Stock | 248.58 | 249.33 | 248.44 | 248.89 | 977725.0 |
| 2022-12-15 12:30:00 | MSFT | Stock | 248.87 | 249.46 | 248.16 | 248.4999 | 811434.0 |
> showing 50 of 104,371 rows — these rows as CSV