PREVIEW / stock_30min / 2022-11-01
file: by_date/stock_30min/2022/2022-11-01.parquet size: 2.1 MB rows: 103,614 symbols: 2,126
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-11-01 04:00:00 | AAPL | Stock | 153.59 | 154.6 | 153.04 | 154.51 | 25715.0 |
| 2022-11-01 04:30:00 | AAPL | Stock | 154.51 | 154.55 | 154.4 | 154.55 | 10636.0 |
| 2022-11-01 05:00:00 | AAPL | Stock | 154.4 | 154.55 | 154.26 | 154.55 | 3758.0 |
| 2022-11-01 05:30:00 | AAPL | Stock | 154.55 | 154.82 | 154.55 | 154.8 | 14098.0 |
| 2022-11-01 06:00:00 | AAPL | Stock | 154.82 | 155.04 | 154.64 | 155.0 | 18477.0 |
| 2022-11-01 06:30:00 | AAPL | Stock | 154.99 | 155.15 | 154.91 | 155.0 | 15276.0 |
| 2022-11-01 07:00:00 | AAPL | Stock | 154.9 | 155.06 | 154.69 | 154.84 | 36196.0 |
| 2022-11-01 07:30:00 | AAPL | Stock | 154.9 | 155.05 | 154.85 | 154.94 | 31583.0 |
| 2022-11-01 08:00:00 | AAPL | Stock | 154.79 | 155.24 | 154.0 | 155.24 | 152526.0 |
| 2022-11-01 08:30:00 | AAPL | Stock | 155.25 | 155.65 | 155.25 | 155.57 | 171181.0 |
| 2022-11-01 09:00:00 | AAPL | Stock | 155.57 | 155.6501 | 154.95 | 155.09 | 222278.0 |
| 2022-11-01 09:30:00 | AAPL | Stock | 155.07 | 155.45 | 152.68 | 152.863 | 9082558.0 |
| 2022-11-01 10:00:00 | AAPL | Stock | 152.87 | 152.99 | 150.37 | 151.04 | 9941230.0 |
| 2022-11-01 10:30:00 | AAPL | Stock | 151.03 | 151.03 | 149.66 | 150.05 | 6919019.0 |
| 2022-11-01 11:00:00 | AAPL | Stock | 150.05 | 150.31 | 149.56 | 149.9029 | 4724334.0 |
| 2022-11-01 11:30:00 | AAPL | Stock | 149.91 | 150.17 | 149.13 | 150.06 | 4183230.0 |
| 2022-11-01 12:00:00 | AAPL | Stock | 150.05 | 150.5 | 149.82 | 150.08 | 4111685.0 |
| 2022-11-01 12:30:00 | AAPL | Stock | 150.07 | 150.23 | 149.61 | 150.065 | 2693234.0 |
| 2022-11-01 13:00:00 | AAPL | Stock | 150.06 | 150.37 | 149.85 | 150.015 | 2401521.0 |
| 2022-11-01 13:30:00 | AAPL | Stock | 150.01 | 150.13 | 149.615 | 150.11 | 2190081.0 |
| 2022-11-01 14:00:00 | AAPL | Stock | 150.105 | 150.58 | 149.96 | 150.56 | 3028345.0 |
| 2022-11-01 14:30:00 | AAPL | Stock | 150.55 | 151.09 | 150.235 | 150.97 | 3387990.0 |
| 2022-11-01 15:00:00 | AAPL | Stock | 150.96 | 151.05 | 150.555 | 150.59 | 3963829.0 |
| 2022-11-01 15:30:00 | AAPL | Stock | 150.6 | 151.05 | 150.421 | 150.57 | 6306454.0 |
| 2022-11-01 16:00:00 | AAPL | Stock | 150.57 | 150.69 | 150.1 | 150.25 | 6514204.0 |
| 2022-11-01 16:30:00 | AAPL | Stock | 150.26 | 150.65 | 150.25 | 150.32 | 52523.0 |
| 2022-11-01 17:00:00 | AAPL | Stock | 150.31 | 150.4699 | 150.3 | 150.45 | 24451.0 |
| 2022-11-01 17:30:00 | AAPL | Stock | 150.45 | 150.45 | 150.25 | 150.25 | 10457.0 |
| 2022-11-01 18:00:00 | AAPL | Stock | 150.27 | 150.65 | 150.27 | 150.39 | 34718.0 |
| 2022-11-01 18:30:00 | AAPL | Stock | 150.37 | 150.46 | 150.37 | 150.46 | 3122.0 |
| 2022-11-01 19:00:00 | AAPL | Stock | 150.42 | 150.6 | 150.42 | 150.6 | 3816.0 |
| 2022-11-01 19:30:00 | AAPL | Stock | 150.56 | 150.63 | 150.38 | 150.41 | 28323.0 |
| 2022-11-01 04:00:00 | MSFT | Stock | 234.0 | 234.6 | 234.0 | 234.4 | 1470.0 |
| 2022-11-01 04:30:00 | MSFT | Stock | 234.44 | 234.44 | 234.22 | 234.35 | 1197.0 |
| 2022-11-01 05:00:00 | MSFT | Stock | 234.34 | 234.34 | 233.8 | 233.8 | 699.0 |
| 2022-11-01 05:30:00 | MSFT | Stock | 234.45 | 234.65 | 234.45 | 234.65 | 925.0 |
| 2022-11-01 06:00:00 | MSFT | Stock | 234.5 | 235.1 | 234.5 | 235.1 | 2020.0 |
| 2022-11-01 06:30:00 | MSFT | Stock | 235.3 | 235.45 | 235.19 | 235.19 | 1034.0 |
| 2022-11-01 07:00:00 | MSFT | Stock | 235.2 | 235.2 | 233.0 | 234.6 | 21849.0 |
| 2022-11-01 07:30:00 | MSFT | Stock | 234.72 | 234.76 | 234.5 | 234.75 | 4910.0 |
| 2022-11-01 08:00:00 | MSFT | Stock | 234.5549 | 235.0 | 234.4475 | 234.7 | 29634.0 |
| 2022-11-01 08:30:00 | MSFT | Stock | 234.68 | 234.84 | 234.26 | 234.7 | 13381.0 |
| 2022-11-01 09:00:00 | MSFT | Stock | 234.37 | 234.87 | 234.18 | 234.85 | 27162.0 |
| 2022-11-01 09:30:00 | MSFT | Stock | 234.6 | 235.74 | 230.32 | 230.63 | 2934380.0 |
| 2022-11-01 10:00:00 | MSFT | Stock | 230.66 | 230.91 | 228.1 | 229.775 | 2379922.0 |
| 2022-11-01 10:30:00 | MSFT | Stock | 229.81 | 230.105 | 228.12 | 228.735 | 1423155.0 |
| 2022-11-01 11:00:00 | MSFT | Stock | 228.76 | 230.59 | 228.64 | 230.0701 | 1537501.0 |
| 2022-11-01 11:30:00 | MSFT | Stock | 230.09 | 230.41 | 229.03 | 229.45 | 1010747.0 |
| 2022-11-01 12:00:00 | MSFT | Stock | 229.45 | 230.22 | 228.15 | 228.24 | 1251674.0 |
| 2022-11-01 12:30:00 | MSFT | Stock | 228.25 | 228.57 | 227.325 | 228.46 | 1165714.0 |
> showing 50 of 103,614 rows — these rows as CSV