PREVIEW / stock_30min / 2021-02-02
file: by_date/stock_30min/2021/2021-02-02.parquet size: 2.3 MB rows: 117,845 symbols: 2,747
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-02-02 04:00:00 | AAPL | Stock | 135.51 | 135.8 | 135.22 | 135.52 | 30585.0 |
| 2021-02-02 04:30:00 | AAPL | Stock | 135.43 | 135.6 | 135.4 | 135.6 | 13224.0 |
| 2021-02-02 05:00:00 | AAPL | Stock | 135.66 | 135.78 | 135.48 | 135.59 | 11746.0 |
| 2021-02-02 05:30:00 | AAPL | Stock | 135.6 | 135.8 | 135.58 | 135.69 | 13843.0 |
| 2021-02-02 06:00:00 | AAPL | Stock | 135.74 | 135.8 | 135.22 | 135.36 | 21198.0 |
| 2021-02-02 06:30:00 | AAPL | Stock | 135.43 | 135.6 | 135.4 | 135.49 | 19218.0 |
| 2021-02-02 07:00:00 | AAPL | Stock | 135.45 | 135.55 | 135.25 | 135.41 | 148394.0 |
| 2021-02-02 07:30:00 | AAPL | Stock | 135.4 | 135.5 | 135.34 | 135.479 | 122613.0 |
| 2021-02-02 08:00:00 | AAPL | Stock | 135.3 | 136.0 | 134.47 | 135.85 | 488181.0 |
| 2021-02-02 08:30:00 | AAPL | Stock | 135.86 | 136.45 | 135.85 | 136.03 | 379810.0 |
| 2021-02-02 09:00:00 | AAPL | Stock | 136.03 | 136.09 | 134.14 | 135.62 | 705634.0 |
| 2021-02-02 09:30:00 | AAPL | Stock | 135.62 | 136.31 | 134.96 | 135.43 | 12086937.0 |
| 2021-02-02 10:00:00 | AAPL | Stock | 135.435 | 136.03 | 135.11 | 135.161 | 6785412.0 |
| 2021-02-02 10:30:00 | AAPL | Stock | 135.161 | 135.69 | 135.02 | 135.48 | 5412885.0 |
| 2021-02-02 11:00:00 | AAPL | Stock | 135.475 | 135.66 | 135.14 | 135.25 | 3457443.0 |
| 2021-02-02 11:30:00 | AAPL | Stock | 135.26 | 135.289 | 134.85 | 135.03 | 4403776.0 |
| 2021-02-02 12:00:00 | AAPL | Stock | 135.04 | 135.29 | 134.96 | 135.265 | 3061716.0 |
| 2021-02-02 12:30:00 | AAPL | Stock | 135.265 | 135.48 | 134.9 | 135.0 | 2945193.0 |
| 2021-02-02 13:00:00 | AAPL | Stock | 135.01 | 135.08 | 134.62 | 134.765 | 3034041.0 |
| 2021-02-02 13:30:00 | AAPL | Stock | 134.77 | 135.19 | 134.72 | 134.989 | 2834243.0 |
| 2021-02-02 14:00:00 | AAPL | Stock | 134.98 | 135.13 | 134.82 | 135.06 | 2377374.0 |
| 2021-02-02 14:30:00 | AAPL | Stock | 135.07 | 135.08 | 134.74 | 134.86 | 2834389.0 |
| 2021-02-02 15:00:00 | AAPL | Stock | 134.87 | 134.99 | 134.61 | 134.955 | 3429151.0 |
| 2021-02-02 15:30:00 | AAPL | Stock | 134.96 | 135.45 | 134.822 | 134.98 | 7726686.0 |
| 2021-02-02 16:00:00 | AAPL | Stock | 134.98 | 135.3 | 134.53 | 134.84 | 7017389.0 |
| 2021-02-02 16:30:00 | AAPL | Stock | 134.83 | 135.07 | 134.8 | 135.05 | 419486.0 |
| 2021-02-02 17:00:00 | AAPL | Stock | 135.06 | 135.26 | 135.0 | 135.21 | 120172.0 |
| 2021-02-02 17:30:00 | AAPL | Stock | 135.2 | 135.21 | 135.02 | 135.08 | 59274.0 |
| 2021-02-02 18:00:00 | AAPL | Stock | 135.07 | 135.11 | 134.81 | 135.0 | 101859.0 |
| 2021-02-02 18:30:00 | AAPL | Stock | 135.05 | 135.12 | 134.9 | 134.95 | 58752.0 |
| 2021-02-02 19:00:00 | AAPL | Stock | 134.91 | 135.15 | 134.9 | 135.0 | 101504.0 |
| 2021-02-02 19:30:00 | AAPL | Stock | 134.99 | 135.4 | 134.99 | 135.35 | 137966.0 |
| 2021-02-02 04:00:00 | MSFT | Stock | 240.65 | 241.19 | 240.65 | 241.19 | 516.0 |
| 2021-02-02 04:30:00 | MSFT | Stock | 241.2 | 241.32 | 241.14 | 241.32 | 732.0 |
| 2021-02-02 05:00:00 | MSFT | Stock | 241.74 | 241.79 | 241.51 | 241.51 | 813.0 |
| 2021-02-02 05:30:00 | MSFT | Stock | 241.23 | 241.65 | 241.22 | 241.65 | 3545.0 |
| 2021-02-02 06:00:00 | MSFT | Stock | 241.65 | 241.65 | 241.25 | 241.5 | 3704.0 |
| 2021-02-02 06:30:00 | MSFT | Stock | 241.71 | 241.71 | 241.25 | 241.25 | 1620.0 |
| 2021-02-02 07:00:00 | MSFT | Stock | 241.35 | 241.88 | 241.28 | 241.79 | 34536.0 |
| 2021-02-02 07:30:00 | MSFT | Stock | 241.86 | 241.95 | 241.5 | 241.79 | 19979.0 |
| 2021-02-02 08:00:00 | MSFT | Stock | 241.7 | 241.95 | 239.06 | 241.54 | 69720.0 |
| 2021-02-02 08:30:00 | MSFT | Stock | 241.31 | 241.75 | 241.3 | 241.35 | 16463.0 |
| 2021-02-02 09:00:00 | MSFT | Stock | 241.32 | 241.5 | 240.27 | 241.17 | 43098.0 |
| 2021-02-02 09:30:00 | MSFT | Stock | 241.17 | 242.31 | 239.68 | 240.665 | 3207041.0 |
| 2021-02-02 10:00:00 | MSFT | Stock | 240.67 | 241.28 | 239.43 | 240.205 | 1352277.0 |
| 2021-02-02 10:30:00 | MSFT | Stock | 240.23 | 240.765 | 239.19 | 240.16 | 1435996.0 |
| 2021-02-02 11:00:00 | MSFT | Stock | 240.13 | 240.17 | 239.07 | 239.38 | 1043412.0 |
| 2021-02-02 11:30:00 | MSFT | Stock | 239.37 | 240.5 | 238.69 | 240.45 | 1396597.0 |
| 2021-02-02 12:00:00 | MSFT | Stock | 240.45 | 240.45 | 239.66 | 240.02 | 901517.0 |
| 2021-02-02 12:30:00 | MSFT | Stock | 240.005 | 240.28 | 239.76 | 240.205 | 658179.0 |
> showing 50 of 117,845 rows — these rows as CSV