PREVIEW / stock_30min / 2022-10-31
file: by_date/stock_30min/2022/2022-10-31.parquet size: 2.1 MB rows: 103,676 symbols: 2,133
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-10-31 04:00:00 | AAPL | Stock | 155.0 | 155.66 | 154.54 | 154.71 | 61366.0 |
| 2022-10-31 04:30:00 | AAPL | Stock | 154.68 | 154.75 | 154.45 | 154.68 | 19807.0 |
| 2022-10-31 05:00:00 | AAPL | Stock | 154.72 | 154.99 | 154.67 | 154.88 | 14294.0 |
| 2022-10-31 05:30:00 | AAPL | Stock | 154.88 | 155.1 | 154.78 | 154.78 | 15681.0 |
| 2022-10-31 06:00:00 | AAPL | Stock | 154.78 | 154.93 | 154.75 | 154.79 | 18505.0 |
| 2022-10-31 06:30:00 | AAPL | Stock | 154.85 | 154.85 | 154.58 | 154.8 | 12626.0 |
| 2022-10-31 07:00:00 | AAPL | Stock | 154.89 | 155.02 | 154.57 | 154.83 | 72458.0 |
| 2022-10-31 07:30:00 | AAPL | Stock | 154.81 | 154.87 | 154.59 | 154.61 | 49272.0 |
| 2022-10-31 08:00:00 | AAPL | Stock | 154.9778 | 155.0526 | 154.57 | 154.57 | 256909.0 |
| 2022-10-31 08:30:00 | AAPL | Stock | 154.58 | 154.58 | 153.46 | 153.79 | 504120.0 |
| 2022-10-31 09:00:00 | AAPL | Stock | 153.79 | 153.79 | 153.0 | 153.19 | 549517.0 |
| 2022-10-31 09:30:00 | AAPL | Stock | 153.19 | 154.07 | 152.33 | 153.01 | 12961128.0 |
| 2022-10-31 10:00:00 | AAPL | Stock | 153.005 | 153.4 | 151.92 | 152.47 | 7339415.0 |
| 2022-10-31 10:30:00 | AAPL | Stock | 152.46 | 153.17 | 152.2411 | 152.69 | 5320195.0 |
| 2022-10-31 11:00:00 | AAPL | Stock | 152.68 | 153.56 | 152.5737 | 153.3 | 5105836.0 |
| 2022-10-31 11:30:00 | AAPL | Stock | 153.3 | 154.01 | 152.82 | 153.28 | 4454508.0 |
| 2022-10-31 12:00:00 | AAPL | Stock | 153.26 | 154.1499 | 153.01 | 153.985 | 4129652.0 |
| 2022-10-31 12:30:00 | AAPL | Stock | 153.9703 | 153.975 | 153.09 | 153.59 | 3097254.0 |
| 2022-10-31 13:00:00 | AAPL | Stock | 153.595 | 154.12 | 153.37 | 153.9699 | 3167011.0 |
| 2022-10-31 13:30:00 | AAPL | Stock | 153.95 | 154.09 | 153.39 | 153.73 | 2640891.0 |
| 2022-10-31 14:00:00 | AAPL | Stock | 153.72 | 153.96 | 153.29 | 153.77 | 3003847.0 |
| 2022-10-31 14:30:00 | AAPL | Stock | 153.77 | 154.24 | 153.46 | 153.6 | 3529547.0 |
| 2022-10-31 15:00:00 | AAPL | Stock | 153.61 | 153.65 | 152.62 | 153.34 | 4214336.0 |
| 2022-10-31 15:30:00 | AAPL | Stock | 153.34 | 153.6 | 152.78 | 153.45 | 8309601.0 |
| 2022-10-31 16:00:00 | AAPL | Stock | 153.34 | 153.48 | 153.15 | 153.35 | 13967882.0 |
| 2022-10-31 16:30:00 | AAPL | Stock | 153.35 | 153.65 | 153.33 | 153.4 | 78170.0 |
| 2022-10-31 17:00:00 | AAPL | Stock | 153.4 | 153.49 | 153.23 | 153.266 | 73459.0 |
| 2022-10-31 17:30:00 | AAPL | Stock | 153.25 | 153.2887 | 153.21 | 153.2399 | 17465.0 |
| 2022-10-31 18:00:00 | AAPL | Stock | 153.25 | 153.32 | 152.91 | 153.17 | 31208.0 |
| 2022-10-31 18:30:00 | AAPL | Stock | 153.3 | 153.38 | 153.16 | 153.3 | 14120.0 |
| 2022-10-31 19:00:00 | AAPL | Stock | 153.31 | 153.47 | 153.31 | 153.44 | 29288.0 |
| 2022-10-31 19:30:00 | AAPL | Stock | 153.47 | 153.5 | 153.43 | 153.46 | 20005.0 |
| 2022-10-31 04:00:00 | MSFT | Stock | 234.7 | 234.7 | 233.86 | 234.09 | 5057.0 |
| 2022-10-31 04:30:00 | MSFT | Stock | 233.31 | 233.55 | 233.31 | 233.52 | 769.0 |
| 2022-10-31 05:00:00 | MSFT | Stock | 233.79 | 233.9 | 233.61 | 233.9 | 1708.0 |
| 2022-10-31 05:30:00 | MSFT | Stock | 234.0 | 234.15 | 234.0 | 234.0 | 603.0 |
| 2022-10-31 06:00:00 | MSFT | Stock | 233.99 | 233.99 | 233.75 | 233.75 | 550.0 |
| 2022-10-31 06:30:00 | MSFT | Stock | 233.87 | 233.87 | 233.1 | 233.2 | 5713.0 |
| 2022-10-31 07:00:00 | MSFT | Stock | 233.79 | 234.64 | 233.76 | 234.51 | 9733.0 |
| 2022-10-31 07:30:00 | MSFT | Stock | 234.51 | 234.53 | 234.0 | 234.24 | 5675.0 |
| 2022-10-31 08:00:00 | MSFT | Stock | 233.7817 | 236.459 | 232.1 | 234.01 | 26395.0 |
| 2022-10-31 08:30:00 | MSFT | Stock | 233.94 | 233.98 | 233.51 | 233.75 | 20230.0 |
| 2022-10-31 09:00:00 | MSFT | Stock | 233.8423 | 234.1 | 232.79 | 233.78 | 40563.0 |
| 2022-10-31 09:30:00 | MSFT | Stock | 233.78 | 234.92 | 231.67 | 232.18 | 2657169.0 |
| 2022-10-31 10:00:00 | MSFT | Stock | 232.16 | 233.26 | 231.15 | 231.64 | 1375665.0 |
| 2022-10-31 10:30:00 | MSFT | Stock | 231.615 | 232.5 | 231.2 | 231.97 | 1038320.0 |
| 2022-10-31 11:00:00 | MSFT | Stock | 231.95 | 233.51 | 231.95 | 233.35 | 1163520.0 |
| 2022-10-31 11:30:00 | MSFT | Stock | 233.36 | 234.19 | 232.78 | 233.32 | 1189869.0 |
| 2022-10-31 12:00:00 | MSFT | Stock | 233.35 | 234.41 | 233.01 | 233.47 | 806134.0 |
| 2022-10-31 12:30:00 | MSFT | Stock | 233.475 | 233.5 | 232.5 | 232.77 | 602313.0 |
> showing 50 of 103,676 rows — these rows as CSV