PREVIEW / stock_30min / 2022-12-09
file: by_date/stock_30min/2022/2022-12-09.parquet size: 2.1 MB rows: 101,123 symbols: 2,028
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-09 04:00:00 | AAPL | Stock | 143.69 | 143.69 | 143.0 | 143.38 | 6493.0 |
| 2022-12-09 04:30:00 | AAPL | Stock | 143.32 | 143.32 | 143.15 | 143.2 | 5386.0 |
| 2022-12-09 05:00:00 | AAPL | Stock | 143.13 | 143.2 | 142.97 | 143.2 | 9956.0 |
| 2022-12-09 05:30:00 | AAPL | Stock | 143.23 | 143.38 | 143.2 | 143.35 | 3181.0 |
| 2022-12-09 06:00:00 | AAPL | Stock | 143.35 | 143.49 | 143.34 | 143.49 | 20798.0 |
| 2022-12-09 06:30:00 | AAPL | Stock | 143.59 | 143.72 | 143.45 | 143.61 | 10335.0 |
| 2022-12-09 07:00:00 | AAPL | Stock | 143.64 | 143.98 | 143.55 | 143.97 | 43797.0 |
| 2022-12-09 07:30:00 | AAPL | Stock | 143.97 | 144.12 | 143.94 | 144.03 | 28066.0 |
| 2022-12-09 08:00:00 | AAPL | Stock | 143.6492 | 144.1 | 142.294 | 143.92 | 117477.0 |
| 2022-12-09 08:30:00 | AAPL | Stock | 143.88 | 144.09 | 141.49 | 142.75 | 356058.0 |
| 2022-12-09 09:00:00 | AAPL | Stock | 142.86 | 142.89 | 142.0 | 142.35 | 149882.0 |
| 2022-12-09 09:30:00 | AAPL | Stock | 142.34 | 142.55 | 140.9 | 141.765 | 6389567.0 |
| 2022-12-09 10:00:00 | AAPL | Stock | 141.81 | 142.55 | 141.2 | 142.4194 | 4658554.0 |
| 2022-12-09 10:30:00 | AAPL | Stock | 142.4299 | 144.31 | 142.38 | 144.295 | 5088333.0 |
| 2022-12-09 11:00:00 | AAPL | Stock | 144.29 | 144.65 | 143.83 | 144.582 | 5339988.0 |
| 2022-12-09 11:30:00 | AAPL | Stock | 144.58 | 145.12 | 144.2201 | 145.009 | 4670299.0 |
| 2022-12-09 12:00:00 | AAPL | Stock | 145.01 | 145.57 | 144.75 | 144.83 | 3587528.0 |
| 2022-12-09 12:30:00 | AAPL | Stock | 144.83 | 145.08 | 144.38 | 144.4347 | 2470242.0 |
| 2022-12-09 13:00:00 | AAPL | Stock | 144.43 | 144.43 | 143.84 | 144.11 | 3179794.0 |
| 2022-12-09 13:30:00 | AAPL | Stock | 144.1166 | 144.47 | 144.05 | 144.2 | 2191164.0 |
| 2022-12-09 14:00:00 | AAPL | Stock | 144.195 | 144.32 | 143.75 | 144.215 | 2474563.0 |
| 2022-12-09 14:30:00 | AAPL | Stock | 144.22 | 144.2668 | 143.77 | 143.85 | 2288480.0 |
| 2022-12-09 15:00:00 | AAPL | Stock | 143.84 | 144.15 | 143.59 | 143.6 | 2908654.0 |
| 2022-12-09 15:30:00 | AAPL | Stock | 143.5957 | 143.73 | 142.07 | 142.19 | 7014880.0 |
| 2022-12-09 16:00:00 | AAPL | Stock | 142.2 | 142.3 | 142.0 | 142.08 | 13764460.0 |
| 2022-12-09 16:30:00 | AAPL | Stock | 142.1 | 142.16 | 141.95 | 141.96 | 54845.0 |
| 2022-12-09 17:00:00 | AAPL | Stock | 142.0 | 142.07 | 141.99 | 142.02 | 8466.0 |
| 2022-12-09 17:30:00 | AAPL | Stock | 142.03 | 142.03 | 141.94 | 141.98 | 11978.0 |
| 2022-12-09 18:00:00 | AAPL | Stock | 141.98 | 142.02 | 141.95 | 142.0 | 5998.0 |
| 2022-12-09 18:30:00 | AAPL | Stock | 142.0 | 142.06 | 141.99 | 141.99 | 5033.0 |
| 2022-12-09 19:00:00 | AAPL | Stock | 141.99 | 142.0499 | 141.97 | 142.0399 | 1946.0 |
| 2022-12-09 19:30:00 | AAPL | Stock | 142.01 | 142.01 | 141.9 | 141.95 | 7627.0 |
| 2022-12-09 04:00:00 | MSFT | Stock | 247.7 | 248.31 | 247.7 | 247.8 | 1224.0 |
| 2022-12-09 04:30:00 | MSFT | Stock | 247.56 | 247.56 | 247.4 | 247.4 | 699.0 |
| 2022-12-09 05:00:00 | MSFT | Stock | 247.49 | 247.61 | 247.3 | 247.6 | 923.0 |
| 2022-12-09 05:30:00 | MSFT | Stock | 247.7 | 247.99 | 247.7 | 247.99 | 796.0 |
| 2022-12-09 06:30:00 | MSFT | Stock | 247.86 | 247.98 | 247.8 | 247.98 | 606.0 |
| 2022-12-09 07:00:00 | MSFT | Stock | 248.08 | 248.4 | 247.93 | 248.4 | 3543.0 |
| 2022-12-09 07:30:00 | MSFT | Stock | 248.41 | 248.75 | 248.26 | 248.75 | 10784.0 |
| 2022-12-09 08:00:00 | MSFT | Stock | 248.0 | 248.9789 | 246.782 | 248.8 | 15925.0 |
| 2022-12-09 08:30:00 | MSFT | Stock | 248.6 | 248.6 | 243.51 | 246.5 | 57232.0 |
| 2022-12-09 09:00:00 | MSFT | Stock | 246.47 | 246.47 | 244.7 | 244.8 | 18766.0 |
| 2022-12-09 09:30:00 | MSFT | Stock | 244.75 | 246.62 | 244.56 | 245.48 | 1258973.0 |
| 2022-12-09 10:00:00 | MSFT | Stock | 245.51 | 246.29 | 244.16 | 245.51 | 1163063.0 |
| 2022-12-09 10:30:00 | MSFT | Stock | 245.53 | 247.7699 | 245.5 | 247.75 | 1398006.0 |
| 2022-12-09 11:00:00 | MSFT | Stock | 247.79 | 248.31 | 246.478 | 247.14 | 1217801.0 |
| 2022-12-09 11:30:00 | MSFT | Stock | 247.1257 | 247.71 | 246.43 | 247.41 | 950505.0 |
| 2022-12-09 12:00:00 | MSFT | Stock | 247.42 | 247.6 | 246.86 | 247.24 | 602461.0 |
| 2022-12-09 12:30:00 | MSFT | Stock | 247.2316 | 247.91 | 247.13 | 247.3801 | 482395.0 |
| 2022-12-09 13:00:00 | MSFT | Stock | 247.38 | 247.38 | 246.31 | 246.87 | 558912.0 |
> showing 50 of 101,123 rows — these rows as CSV