PREVIEW / stock_30min / 2022-12-23
file: by_date/stock_30min/2022/2022-12-23.parquet size: 2.0 MB rows: 99,169 symbols: 1,938
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-23 04:00:00 | AAPL | Stock | 131.42 | 132.17 | 131.3 | 131.73 | 11870.0 |
| 2022-12-23 04:30:00 | AAPL | Stock | 131.75 | 131.9 | 131.73 | 131.84 | 8842.0 |
| 2022-12-23 05:00:00 | AAPL | Stock | 131.88 | 132.14 | 131.88 | 132.14 | 3406.0 |
| 2022-12-23 05:30:00 | AAPL | Stock | 132.2 | 132.54 | 132.2 | 132.51 | 12750.0 |
| 2022-12-23 06:00:00 | AAPL | Stock | 132.5 | 132.79 | 132.37 | 132.37 | 6652.0 |
| 2022-12-23 06:30:00 | AAPL | Stock | 132.24 | 132.35 | 132.19 | 132.19 | 4208.0 |
| 2022-12-23 07:00:00 | AAPL | Stock | 132.12 | 132.38 | 132.05 | 132.38 | 17432.0 |
| 2022-12-23 07:30:00 | AAPL | Stock | 132.38 | 132.44 | 132.01 | 132.2 | 26177.0 |
| 2022-12-23 08:00:00 | AAPL | Stock | 132.2 | 132.5 | 131.04 | 132.37 | 105324.0 |
| 2022-12-23 08:30:00 | AAPL | Stock | 132.17 | 133.4 | 131.1 | 132.09 | 297429.0 |
| 2022-12-23 09:00:00 | AAPL | Stock | 132.06 | 132.15 | 130.81 | 130.93 | 321844.0 |
| 2022-12-23 09:30:00 | AAPL | Stock | 130.92 | 131.7689 | 129.64 | 130.0179 | 8742424.0 |
| 2022-12-23 10:00:00 | AAPL | Stock | 130.02 | 131.46 | 129.6605 | 131.39 | 7021071.0 |
| 2022-12-23 10:30:00 | AAPL | Stock | 131.395 | 132.415 | 130.75 | 130.8701 | 5219095.0 |
| 2022-12-23 11:00:00 | AAPL | Stock | 130.88 | 131.38 | 130.2531 | 131.0085 | 4164999.0 |
| 2022-12-23 11:30:00 | AAPL | Stock | 131.01 | 131.69 | 130.73 | 130.875 | 3191295.0 |
| 2022-12-23 12:00:00 | AAPL | Stock | 130.88 | 131.73 | 130.83 | 131.4887 | 2680574.0 |
| 2022-12-23 12:30:00 | AAPL | Stock | 131.485 | 131.76 | 130.99 | 131.14 | 2390449.0 |
| 2022-12-23 13:00:00 | AAPL | Stock | 131.14 | 131.39 | 130.8601 | 131.31 | 2364711.0 |
| 2022-12-23 13:30:00 | AAPL | Stock | 131.32 | 131.5 | 130.81 | 131.1799 | 2148987.0 |
| 2022-12-23 14:00:00 | AAPL | Stock | 131.17 | 131.43 | 130.93 | 131.235 | 2171657.0 |
| 2022-12-23 14:30:00 | AAPL | Stock | 131.25 | 131.76 | 131.23 | 131.7189 | 2290845.0 |
| 2022-12-23 15:00:00 | AAPL | Stock | 131.7189 | 131.999 | 131.35 | 131.42 | 3168842.0 |
| 2022-12-23 15:30:00 | AAPL | Stock | 131.42 | 131.9 | 131.2 | 131.86 | 5091893.0 |
| 2022-12-23 16:00:00 | AAPL | Stock | 131.85 | 131.99 | 131.59 | 131.77 | 4221556.0 |
| 2022-12-23 16:30:00 | AAPL | Stock | 131.76 | 131.86 | 131.7125 | 131.75 | 19374.0 |
| 2022-12-23 17:00:00 | AAPL | Stock | 131.75 | 131.76 | 131.71 | 131.73 | 21285.0 |
| 2022-12-23 17:30:00 | AAPL | Stock | 131.71 | 131.79 | 131.71 | 131.78 | 9145.0 |
| 2022-12-23 18:00:00 | AAPL | Stock | 131.77 | 131.78 | 131.71 | 131.74 | 3892.0 |
| 2022-12-23 18:30:00 | AAPL | Stock | 131.74 | 131.77 | 131.71 | 131.74 | 9180.0 |
| 2022-12-23 19:00:00 | AAPL | Stock | 131.75 | 131.75 | 131.74 | 131.74 | 9276.0 |
| 2022-12-23 19:30:00 | AAPL | Stock | 131.74 | 131.75 | 131.65 | 131.65 | 11799.0 |
| 2022-12-23 04:00:00 | MSFT | Stock | 237.87 | 238.07 | 237.87 | 238.04 | 1210.0 |
| 2022-12-23 04:30:00 | MSFT | Stock | 237.97 | 237.98 | 237.96 | 237.97 | 1200.0 |
| 2022-12-23 05:00:00 | MSFT | Stock | 237.97 | 237.98 | 237.97 | 237.98 | 1526.0 |
| 2022-12-23 05:30:00 | MSFT | Stock | 238.75 | 238.99 | 238.75 | 238.99 | 2184.0 |
| 2022-12-23 06:00:00 | MSFT | Stock | 239.25 | 239.7 | 239.05 | 239.05 | 407.0 |
| 2022-12-23 06:30:00 | MSFT | Stock | 238.63 | 238.63 | 238.13 | 238.13 | 1230.0 |
| 2022-12-23 07:00:00 | MSFT | Stock | 238.17 | 238.72 | 238.17 | 238.72 | 2131.0 |
| 2022-12-23 07:30:00 | MSFT | Stock | 238.73 | 239.3 | 238.73 | 239.3 | 3530.0 |
| 2022-12-23 08:00:00 | MSFT | Stock | 238.23 | 239.59 | 237.09 | 238.8 | 18391.0 |
| 2022-12-23 08:30:00 | MSFT | Stock | 238.64 | 240.87 | 236.82 | 238.34 | 34393.0 |
| 2022-12-23 09:00:00 | MSFT | Stock | 237.95 | 237.95 | 235.54 | 235.89 | 36192.0 |
| 2022-12-23 09:30:00 | MSFT | Stock | 235.89 | 237.0 | 234.209 | 234.51 | 2604348.0 |
| 2022-12-23 10:00:00 | MSFT | Stock | 234.48 | 237.54 | 233.9428 | 237.24 | 1544263.0 |
| 2022-12-23 10:30:00 | MSFT | Stock | 237.265 | 238.701 | 236.62 | 236.94 | 1154858.0 |
| 2022-12-23 11:00:00 | MSFT | Stock | 236.92 | 237.75 | 235.82 | 237.338 | 1064536.0 |
| 2022-12-23 11:30:00 | MSFT | Stock | 237.3763 | 238.55 | 237.16 | 237.94 | 777868.0 |
| 2022-12-23 12:00:00 | MSFT | Stock | 238.0 | 238.7 | 237.51 | 238.24 | 739989.0 |
| 2022-12-23 12:30:00 | MSFT | Stock | 238.27 | 238.84 | 237.61 | 237.88 | 647167.0 |
> showing 50 of 99,169 rows — these rows as CSV