PREVIEW / stock_30min / 2021-12-29
file: by_date/stock_30min/2021/2021-12-29.parquet size: 2.2 MB rows: 109,308 symbols: 2,638
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-29 04:00:00 | AAPL | Stock | 179.85 | 180.1 | 179.55 | 179.65 | 18672.0 |
| 2021-12-29 04:30:00 | AAPL | Stock | 179.65 | 179.68 | 179.65 | 179.68 | 790.0 |
| 2021-12-29 05:00:00 | AAPL | Stock | 179.72 | 179.72 | 179.51 | 179.54 | 2642.0 |
| 2021-12-29 05:30:00 | AAPL | Stock | 179.53 | 179.57 | 179.45 | 179.5 | 3797.0 |
| 2021-12-29 06:00:00 | AAPL | Stock | 179.48 | 179.5 | 179.25 | 179.27 | 4487.0 |
| 2021-12-29 06:30:00 | AAPL | Stock | 179.3 | 179.37 | 179.27 | 179.29 | 1914.0 |
| 2021-12-29 07:00:00 | AAPL | Stock | 179.47 | 179.61 | 179.2 | 179.6 | 58650.0 |
| 2021-12-29 07:30:00 | AAPL | Stock | 179.63 | 179.63 | 179.4 | 179.42 | 44551.0 |
| 2021-12-29 08:00:00 | AAPL | Stock | 179.4399 | 179.738 | 179.1 | 179.17 | 212003.0 |
| 2021-12-29 08:30:00 | AAPL | Stock | 179.19 | 179.27 | 179.02 | 179.27 | 100706.0 |
| 2021-12-29 09:00:00 | AAPL | Stock | 179.27 | 179.42 | 179.25 | 179.34 | 99911.0 |
| 2021-12-29 09:30:00 | AAPL | Stock | 179.39 | 180.63 | 179.25 | 180.32 | 8450585.0 |
| 2021-12-29 10:00:00 | AAPL | Stock | 180.31 | 180.37 | 178.14 | 179.1922 | 7200216.0 |
| 2021-12-29 10:30:00 | AAPL | Stock | 179.19 | 179.94 | 178.82 | 179.825 | 4450530.0 |
| 2021-12-29 11:00:00 | AAPL | Stock | 179.82 | 179.94 | 179.24 | 179.27 | 3155999.0 |
| 2021-12-29 11:30:00 | AAPL | Stock | 179.27 | 179.54 | 178.85 | 179.075 | 3690674.0 |
| 2021-12-29 12:00:00 | AAPL | Stock | 179.0769 | 179.146 | 178.675 | 178.89 | 2365951.0 |
| 2021-12-29 12:30:00 | AAPL | Stock | 178.875 | 179.3672 | 178.8115 | 179.325 | 1888422.0 |
| 2021-12-29 13:00:00 | AAPL | Stock | 179.33 | 179.4745 | 179.01 | 179.0978 | 2053418.0 |
| 2021-12-29 13:30:00 | AAPL | Stock | 179.1 | 179.3 | 179.04 | 179.13 | 1813203.0 |
| 2021-12-29 14:00:00 | AAPL | Stock | 179.12 | 179.51 | 178.98 | 179.4174 | 2125977.0 |
| 2021-12-29 14:30:00 | AAPL | Stock | 179.4172 | 179.6434 | 179.31 | 179.57 | 2283513.0 |
| 2021-12-29 15:00:00 | AAPL | Stock | 179.56 | 179.68 | 179.36 | 179.4714 | 3147929.0 |
| 2021-12-29 15:30:00 | AAPL | Stock | 179.47 | 179.8 | 179.35 | 179.38 | 5388622.0 |
| 2021-12-29 16:00:00 | AAPL | Stock | 179.38 | 179.52 | 179.2 | 179.25 | 4805484.0 |
| 2021-12-29 16:30:00 | AAPL | Stock | 179.25 | 179.26 | 179.2 | 179.26 | 8212.0 |
| 2021-12-29 17:00:00 | AAPL | Stock | 179.26 | 179.26 | 179.16 | 179.17 | 11097.0 |
| 2021-12-29 17:30:00 | AAPL | Stock | 179.18 | 179.25 | 179.16 | 179.1701 | 12752.0 |
| 2021-12-29 18:00:00 | AAPL | Stock | 179.25 | 179.28 | 179.1 | 179.1 | 19079.0 |
| 2021-12-29 18:30:00 | AAPL | Stock | 179.1 | 179.1 | 179.01 | 179.01 | 14191.0 |
| 2021-12-29 19:00:00 | AAPL | Stock | 179.01 | 179.03 | 178.87 | 179.02 | 31271.0 |
| 2021-12-29 19:30:00 | AAPL | Stock | 179.05 | 179.05 | 178.88 | 178.88 | 12502.0 |
| 2021-12-29 04:00:00 | MSFT | Stock | 342.8 | 342.8 | 340.5 | 342.17 | 1683.0 |
| 2021-12-29 04:30:00 | MSFT | Stock | 342.07 | 342.07 | 342.05 | 342.05 | 1023.0 |
| 2021-12-29 05:00:00 | MSFT | Stock | 342.07 | 342.17 | 342.07 | 342.08 | 1019.0 |
| 2021-12-29 05:30:00 | MSFT | Stock | 342.05 | 342.53 | 342.05 | 342.14 | 2124.0 |
| 2021-12-29 06:00:00 | MSFT | Stock | 342.11 | 342.11 | 341.95 | 341.95 | 363.0 |
| 2021-12-29 06:30:00 | MSFT | Stock | 342.04 | 342.04 | 342.04 | 342.04 | 100.0 |
| 2021-12-29 07:00:00 | MSFT | Stock | 341.93 | 341.93 | 341.52 | 341.81 | 2063.0 |
| 2021-12-29 07:30:00 | MSFT | Stock | 341.74 | 341.8 | 341.65 | 341.65 | 2268.0 |
| 2021-12-29 08:00:00 | MSFT | Stock | 341.6553 | 342.1599 | 341.0 | 341.0 | 10326.0 |
| 2021-12-29 08:30:00 | MSFT | Stock | 340.99 | 341.25 | 340.99 | 341.25 | 1239.0 |
| 2021-12-29 09:00:00 | MSFT | Stock | 341.3 | 341.7151 | 341.3 | 341.55 | 4765.0 |
| 2021-12-29 09:30:00 | MSFT | Stock | 341.55 | 344.3 | 341.25 | 343.865 | 2212580.0 |
| 2021-12-29 10:00:00 | MSFT | Stock | 343.9096 | 343.9669 | 340.94 | 341.925 | 1190341.0 |
| 2021-12-29 10:30:00 | MSFT | Stock | 341.94 | 342.6299 | 341.46 | 341.925 | 610801.0 |
| 2021-12-29 11:00:00 | MSFT | Stock | 341.9 | 342.4 | 341.04 | 341.28 | 548159.0 |
| 2021-12-29 11:30:00 | MSFT | Stock | 341.29 | 341.43 | 340.57 | 340.755 | 575001.0 |
| 2021-12-29 12:00:00 | MSFT | Stock | 340.78 | 340.81 | 339.9 | 339.9015 | 505630.0 |
| 2021-12-29 12:30:00 | MSFT | Stock | 339.9 | 340.73 | 339.68 | 340.72 | 397913.0 |
> showing 50 of 109,308 rows — these rows as CSV