PREVIEW / stock_30min / 2020-10-05
file: by_date/stock_30min/2020/2020-10-05.parquet size: 1.9 MB rows: 98,033 symbols: 2,515
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-05 04:00:00 | AAPL | Stock | 113.75 | 114.35 | 113.48 | 114.15 | 39719.0 |
| 2020-10-05 04:30:00 | AAPL | Stock | 114.13 | 114.4 | 114.12 | 114.3 | 25986.0 |
| 2020-10-05 05:00:00 | AAPL | Stock | 114.27 | 114.28 | 114.09 | 114.23 | 11893.0 |
| 2020-10-05 05:30:00 | AAPL | Stock | 114.22 | 114.43 | 114.19 | 114.4 | 12374.0 |
| 2020-10-05 06:00:00 | AAPL | Stock | 114.44 | 114.71 | 114.35 | 114.35 | 26315.0 |
| 2020-10-05 06:30:00 | AAPL | Stock | 114.39 | 114.54 | 114.25 | 114.53 | 25895.0 |
| 2020-10-05 07:00:00 | AAPL | Stock | 114.49 | 114.6 | 114.01 | 114.15 | 261182.0 |
| 2020-10-05 07:30:00 | AAPL | Stock | 114.18 | 114.35 | 113.98 | 113.98 | 161281.0 |
| 2020-10-05 08:00:00 | AAPL | Stock | 114.0 | 114.5 | 113.3 | 113.92 | 515117.0 |
| 2020-10-05 08:30:00 | AAPL | Stock | 113.93 | 114.0 | 113.7 | 113.89 | 314523.0 |
| 2020-10-05 09:00:00 | AAPL | Stock | 113.95 | 114.09 | 113.85 | 113.94 | 296663.0 |
| 2020-10-05 09:30:00 | AAPL | Stock | 113.92 | 114.68 | 113.55 | 114.58 | 13253864.0 |
| 2020-10-05 10:00:00 | AAPL | Stock | 114.6 | 115.2 | 114.585 | 114.96 | 8417623.0 |
| 2020-10-05 10:30:00 | AAPL | Stock | 114.97 | 115.49 | 114.957 | 115.13 | 6758224.0 |
| 2020-10-05 11:00:00 | AAPL | Stock | 115.13 | 115.49 | 114.82 | 115.325 | 6408186.0 |
| 2020-10-05 11:30:00 | AAPL | Stock | 115.325 | 115.36 | 114.91 | 115.175 | 4513020.0 |
| 2020-10-05 12:00:00 | AAPL | Stock | 115.175 | 115.78 | 115.06 | 115.71 | 4932394.0 |
| 2020-10-05 12:30:00 | AAPL | Stock | 115.71 | 115.84 | 115.52 | 115.812 | 3500921.0 |
| 2020-10-05 13:00:00 | AAPL | Stock | 115.81 | 116.11 | 115.75 | 115.9 | 4761853.0 |
| 2020-10-05 13:30:00 | AAPL | Stock | 115.9 | 115.949 | 115.34 | 115.47 | 4719917.0 |
| 2020-10-05 14:00:00 | AAPL | Stock | 115.48 | 115.5 | 115.18 | 115.255 | 4511679.0 |
| 2020-10-05 14:30:00 | AAPL | Stock | 115.255 | 115.98 | 115.24 | 115.97 | 4691715.0 |
| 2020-10-05 15:00:00 | AAPL | Stock | 115.96 | 116.4 | 115.87 | 116.315 | 7154084.0 |
| 2020-10-05 15:30:00 | AAPL | Stock | 116.315 | 116.65 | 116.07 | 116.54 | 10797690.0 |
| 2020-10-05 16:00:00 | AAPL | Stock | 116.55 | 116.66 | 116.3 | 116.39 | 7408760.0 |
| 2020-10-05 16:30:00 | AAPL | Stock | 116.39 | 116.56 | 116.35 | 116.38 | 98461.0 |
| 2020-10-05 17:00:00 | AAPL | Stock | 116.38 | 116.49 | 116.34 | 116.36 | 45385.0 |
| 2020-10-05 17:30:00 | AAPL | Stock | 116.37 | 116.44 | 116.35 | 116.38 | 38480.0 |
| 2020-10-05 18:00:00 | AAPL | Stock | 116.39 | 116.5 | 116.36 | 116.5 | 43590.0 |
| 2020-10-05 18:30:00 | AAPL | Stock | 116.49 | 116.55 | 116.4 | 116.49 | 38177.0 |
| 2020-10-05 19:00:00 | AAPL | Stock | 116.48 | 116.48 | 115.62 | 115.8 | 257139.0 |
| 2020-10-05 19:30:00 | AAPL | Stock | 115.76 | 116.06 | 115.61 | 115.76 | 155646.0 |
| 2020-10-05 04:00:00 | MSFT | Stock | 208.0 | 208.02 | 207.8 | 207.9 | 1561.0 |
| 2020-10-05 04:30:00 | MSFT | Stock | 208.0 | 208.09 | 208.0 | 208.04 | 300.0 |
| 2020-10-05 05:00:00 | MSFT | Stock | 208.09 | 208.09 | 207.99 | 207.99 | 419.0 |
| 2020-10-05 05:30:00 | MSFT | Stock | 208.09 | 208.1 | 208.07 | 208.1 | 2813.0 |
| 2020-10-05 06:00:00 | MSFT | Stock | 208.1 | 208.4 | 208.1 | 208.21 | 4046.0 |
| 2020-10-05 06:30:00 | MSFT | Stock | 208.01 | 208.44 | 208.01 | 208.44 | 2486.0 |
| 2020-10-05 07:00:00 | MSFT | Stock | 208.24 | 208.39 | 207.7 | 207.98 | 38790.0 |
| 2020-10-05 07:30:00 | MSFT | Stock | 207.85 | 208.2 | 207.8 | 207.82 | 9803.0 |
| 2020-10-05 08:00:00 | MSFT | Stock | 208.25 | 208.35 | 205.68 | 207.82 | 44586.0 |
| 2020-10-05 08:30:00 | MSFT | Stock | 207.76 | 207.99 | 207.31 | 207.93 | 18844.0 |
| 2020-10-05 09:00:00 | MSFT | Stock | 207.909 | 207.95 | 207.21 | 207.22 | 34965.0 |
| 2020-10-05 09:30:00 | MSFT | Stock | 207.21 | 208.1 | 206.98 | 207.795 | 2242904.0 |
| 2020-10-05 10:00:00 | MSFT | Stock | 207.82 | 209.11 | 207.82 | 208.66 | 1280261.0 |
| 2020-10-05 10:30:00 | MSFT | Stock | 208.69 | 209.25 | 208.56 | 208.66 | 1034738.0 |
| 2020-10-05 11:00:00 | MSFT | Stock | 208.65 | 209.225 | 208.511 | 209.075 | 1068939.0 |
| 2020-10-05 11:30:00 | MSFT | Stock | 209.08 | 209.165 | 208.32 | 208.87 | 989645.0 |
| 2020-10-05 12:00:00 | MSFT | Stock | 208.88 | 209.23 | 208.63 | 209.19 | 577004.0 |
| 2020-10-05 12:30:00 | MSFT | Stock | 209.2 | 209.319 | 209.03 | 209.29 | 508608.0 |
> showing 50 of 98,033 rows — these rows as CSV