PREVIEW / stock_30min / 2022-06-01
file: by_date/stock_30min/2022/2022-06-01.parquet size: 2.1 MB rows: 104,417 symbols: 2,416
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-06-01 04:00:00 | AAPL | Stock | 148.95 | 149.48 | 148.35 | 148.75 | 18880.0 |
| 2022-06-01 04:30:00 | AAPL | Stock | 148.75 | 148.88 | 148.51 | 148.76 | 5135.0 |
| 2022-06-01 05:00:00 | AAPL | Stock | 148.85 | 149.0 | 148.76 | 149.0 | 3222.0 |
| 2022-06-01 05:30:00 | AAPL | Stock | 149.04 | 149.04 | 148.85 | 148.85 | 2934.0 |
| 2022-06-01 06:00:00 | AAPL | Stock | 148.84 | 148.96 | 148.76 | 148.76 | 7398.0 |
| 2022-06-01 06:30:00 | AAPL | Stock | 148.9 | 148.9 | 148.6 | 148.75 | 11675.0 |
| 2022-06-01 07:00:00 | AAPL | Stock | 148.75 | 148.89 | 148.52 | 148.77 | 40646.0 |
| 2022-06-01 07:30:00 | AAPL | Stock | 148.81 | 149.27 | 148.76 | 149.27 | 34790.0 |
| 2022-06-01 08:00:00 | AAPL | Stock | 148.75 | 149.89 | 148.5312 | 149.8 | 264111.0 |
| 2022-06-01 08:30:00 | AAPL | Stock | 149.78 | 149.85 | 149.54 | 149.6 | 163639.0 |
| 2022-06-01 09:00:00 | AAPL | Stock | 149.56 | 150.23 | 149.51 | 149.91 | 216056.0 |
| 2022-06-01 09:30:00 | AAPL | Stock | 149.91 | 151.52 | 149.88 | 151.3401 | 10264265.0 |
| 2022-06-01 10:00:00 | AAPL | Stock | 151.3687 | 151.74 | 149.02 | 149.1572 | 7717897.0 |
| 2022-06-01 10:30:00 | AAPL | Stock | 149.14 | 149.99 | 148.66 | 149.815 | 4769601.0 |
| 2022-06-01 11:00:00 | AAPL | Stock | 149.81 | 149.81 | 148.19 | 148.68 | 4131614.0 |
| 2022-06-01 11:30:00 | AAPL | Stock | 148.7 | 148.775 | 147.91 | 148.24 | 3271770.0 |
| 2022-06-01 12:00:00 | AAPL | Stock | 148.2309 | 148.51 | 147.68 | 148.06 | 3012369.0 |
| 2022-06-01 12:30:00 | AAPL | Stock | 148.06 | 148.59 | 147.9 | 148.25 | 2138135.0 |
| 2022-06-01 13:00:00 | AAPL | Stock | 148.25 | 148.88 | 148.19 | 148.3322 | 2859350.0 |
| 2022-06-01 13:30:00 | AAPL | Stock | 148.35 | 148.84 | 148.01 | 148.575 | 2479034.0 |
| 2022-06-01 14:00:00 | AAPL | Stock | 148.57 | 149.7949 | 148.5115 | 149.59 | 3611068.0 |
| 2022-06-01 14:30:00 | AAPL | Stock | 149.6 | 149.86 | 149.032 | 149.2175 | 2985070.0 |
| 2022-06-01 15:00:00 | AAPL | Stock | 149.215 | 149.88 | 148.8141 | 149.668 | 3675677.0 |
| 2022-06-01 15:30:00 | AAPL | Stock | 149.67 | 149.99 | 148.52 | 148.7 | 6798522.0 |
| 2022-06-01 16:00:00 | AAPL | Stock | 148.7 | 148.79 | 148.39 | 148.46 | 5509239.0 |
| 2022-06-01 16:30:00 | AAPL | Stock | 148.4792 | 148.59 | 148.39 | 148.4075 | 31554.0 |
| 2022-06-01 17:00:00 | AAPL | Stock | 148.5 | 148.65 | 148.4902 | 148.59 | 13801.0 |
| 2022-06-01 17:30:00 | AAPL | Stock | 148.6 | 148.65 | 148.51 | 148.62 | 14378.0 |
| 2022-06-01 18:00:00 | AAPL | Stock | 148.63 | 148.69 | 148.42 | 148.61 | 29445.0 |
| 2022-06-01 18:30:00 | AAPL | Stock | 148.58 | 148.6499 | 148.46 | 148.53 | 30142.0 |
| 2022-06-01 19:00:00 | AAPL | Stock | 148.48 | 148.5 | 148.38 | 148.5 | 20378.0 |
| 2022-06-01 19:30:00 | AAPL | Stock | 148.5 | 148.5 | 147.9 | 148.01 | 56647.0 |
| 2022-06-01 04:00:00 | MSFT | Stock | 272.22 | 272.22 | 271.23 | 271.23 | 300.0 |
| 2022-06-01 04:30:00 | MSFT | Stock | 271.62 | 271.67 | 271.41 | 271.67 | 1893.0 |
| 2022-06-01 05:00:00 | MSFT | Stock | 271.68 | 271.85 | 271.68 | 271.85 | 392.0 |
| 2022-06-01 05:30:00 | MSFT | Stock | 271.87 | 271.9 | 271.71 | 271.9 | 1585.0 |
| 2022-06-01 06:00:00 | MSFT | Stock | 271.95 | 272.05 | 271.82 | 271.9 | 2344.0 |
| 2022-06-01 06:30:00 | MSFT | Stock | 272.23 | 272.25 | 271.8 | 271.87 | 6101.0 |
| 2022-06-01 07:00:00 | MSFT | Stock | 272.0 | 273.01 | 271.94 | 273.0 | 9131.0 |
| 2022-06-01 07:30:00 | MSFT | Stock | 272.99 | 273.87 | 272.8 | 273.87 | 19351.0 |
| 2022-06-01 08:00:00 | MSFT | Stock | 272.8 | 274.8 | 272.0209 | 274.1 | 42572.0 |
| 2022-06-01 08:30:00 | MSFT | Stock | 274.5 | 274.5 | 274.0 | 274.0 | 16426.0 |
| 2022-06-01 09:00:00 | MSFT | Stock | 274.03 | 275.88 | 273.76 | 275.05 | 30110.0 |
| 2022-06-01 09:30:00 | MSFT | Stock | 275.195 | 277.69 | 275.0 | 277.295 | 2939364.0 |
| 2022-06-01 10:00:00 | MSFT | Stock | 277.285 | 277.51 | 272.27 | 272.46 | 1867335.0 |
| 2022-06-01 10:30:00 | MSFT | Stock | 272.42 | 273.98 | 271.62 | 273.515 | 1249902.0 |
| 2022-06-01 11:00:00 | MSFT | Stock | 273.49 | 273.5 | 271.1 | 271.9 | 1130079.0 |
| 2022-06-01 11:30:00 | MSFT | Stock | 271.86 | 272.05 | 270.95 | 271.28 | 680089.0 |
| 2022-06-01 12:00:00 | MSFT | Stock | 271.25 | 271.375 | 270.25 | 270.62 | 869162.0 |
| 2022-06-01 12:30:00 | MSFT | Stock | 270.62 | 271.38 | 270.04 | 270.8 | 666426.0 |
> showing 50 of 104,417 rows — these rows as CSV