PREVIEW / stock_30min / 2022-10-26
file: by_date/stock_30min/2022/2022-10-26.parquet size: 2.1 MB rows: 103,887 symbols: 2,178
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-26 04:00:00 | AAPL | Stock | 151.06 | 151.78 | 151.06 | 151.5 | 46283.0 |
| 2022-10-26 04:30:00 | AAPL | Stock | 151.25 | 151.6 | 151.17 | 151.47 | 16228.0 |
| 2022-10-26 05:00:00 | AAPL | Stock | 151.31 | 151.41 | 150.91 | 150.92 | 19005.0 |
| 2022-10-26 05:30:00 | AAPL | Stock | 150.9 | 151.0 | 150.81 | 150.86 | 8712.0 |
| 2022-10-26 06:00:00 | AAPL | Stock | 150.85 | 151.14 | 150.66 | 151.14 | 25333.0 |
| 2022-10-26 06:30:00 | AAPL | Stock | 151.21 | 151.3 | 150.97 | 151.27 | 18943.0 |
| 2022-10-26 07:00:00 | AAPL | Stock | 151.1 | 151.38 | 150.78 | 151.37 | 107322.0 |
| 2022-10-26 07:30:00 | AAPL | Stock | 151.4 | 151.71 | 150.85 | 151.1 | 84636.0 |
| 2022-10-26 08:00:00 | AAPL | Stock | 151.09 | 151.96 | 150.42 | 150.94 | 175509.0 |
| 2022-10-26 08:30:00 | AAPL | Stock | 150.94 | 150.97 | 150.58 | 150.71 | 114909.0 |
| 2022-10-26 09:00:00 | AAPL | Stock | 150.71 | 151.1 | 150.4 | 150.84 | 342211.0 |
| 2022-10-26 09:30:00 | AAPL | Stock | 150.9 | 151.32 | 149.53 | 149.62 | 10109901.0 |
| 2022-10-26 10:00:00 | AAPL | Stock | 149.63 | 150.95 | 149.625 | 150.5609 | 7225115.0 |
| 2022-10-26 10:30:00 | AAPL | Stock | 150.57 | 150.9699 | 150.3 | 150.4837 | 4154437.0 |
| 2022-10-26 11:00:00 | AAPL | Stock | 150.49 | 151.77 | 150.49 | 151.47 | 4104954.0 |
| 2022-10-26 11:30:00 | AAPL | Stock | 151.47 | 151.89 | 151.14 | 151.5568 | 3702831.0 |
| 2022-10-26 12:00:00 | AAPL | Stock | 151.5599 | 151.99 | 151.49 | 151.53 | 3183067.0 |
| 2022-10-26 12:30:00 | AAPL | Stock | 151.52 | 151.92 | 150.5 | 150.58 | 3430681.0 |
| 2022-10-26 13:00:00 | AAPL | Stock | 150.5598 | 150.56 | 149.41 | 149.48 | 4909487.0 |
| 2022-10-26 13:30:00 | AAPL | Stock | 149.4899 | 149.5171 | 148.8784 | 149.4591 | 4475042.0 |
| 2022-10-26 14:00:00 | AAPL | Stock | 149.455 | 149.52 | 148.04 | 148.25 | 4176423.0 |
| 2022-10-26 14:30:00 | AAPL | Stock | 148.25 | 148.84 | 148.09 | 148.81 | 3688230.0 |
| 2022-10-26 15:00:00 | AAPL | Stock | 148.8 | 149.35 | 148.49 | 149.2421 | 4327259.0 |
| 2022-10-26 15:30:00 | AAPL | Stock | 149.24 | 149.53 | 148.81 | 149.51 | 7831323.0 |
| 2022-10-26 16:00:00 | AAPL | Stock | 149.35 | 150.7 | 148.49 | 149.31 | 8878245.0 |
| 2022-10-26 16:30:00 | AAPL | Stock | 149.32 | 149.94 | 149.3 | 149.88 | 156702.0 |
| 2022-10-26 17:00:00 | AAPL | Stock | 149.8 | 149.8 | 149.22 | 149.38 | 90661.0 |
| 2022-10-26 17:30:00 | AAPL | Stock | 149.37 | 149.4 | 149.2 | 149.2 | 50656.0 |
| 2022-10-26 18:00:00 | AAPL | Stock | 149.11 | 149.6 | 149.01 | 149.5 | 60820.0 |
| 2022-10-26 18:30:00 | AAPL | Stock | 149.5 | 149.5 | 148.99 | 149.2 | 104708.0 |
| 2022-10-26 19:00:00 | AAPL | Stock | 149.16 | 149.85 | 149.16 | 149.47 | 29782.0 |
| 2022-10-26 19:30:00 | AAPL | Stock | 149.5 | 149.99 | 149.5 | 149.8 | 44674.0 |
| 2022-10-26 04:00:00 | MSFT | Stock | 235.26 | 236.81 | 235.2 | 236.7 | 53477.0 |
| 2022-10-26 04:30:00 | MSFT | Stock | 236.59 | 237.34 | 236.32 | 236.8 | 21777.0 |
| 2022-10-26 05:00:00 | MSFT | Stock | 236.62 | 236.86 | 235.67 | 236.0 | 18346.0 |
| 2022-10-26 05:30:00 | MSFT | Stock | 235.99 | 236.05 | 235.5 | 235.52 | 41758.0 |
| 2022-10-26 06:00:00 | MSFT | Stock | 235.54 | 235.9 | 234.8 | 234.98 | 58014.0 |
| 2022-10-26 06:30:00 | MSFT | Stock | 234.95 | 235.48 | 234.66 | 234.7 | 59826.0 |
| 2022-10-26 07:00:00 | MSFT | Stock | 234.96 | 235.03 | 233.27 | 234.67 | 198448.0 |
| 2022-10-26 07:30:00 | MSFT | Stock | 234.67 | 235.89 | 233.9 | 234.75 | 187221.0 |
| 2022-10-26 08:00:00 | MSFT | Stock | 234.9 | 235.8 | 233.4 | 234.0 | 313551.0 |
| 2022-10-26 08:30:00 | MSFT | Stock | 234.0 | 234.15 | 233.35 | 233.96 | 254514.0 |
| 2022-10-26 09:00:00 | MSFT | Stock | 233.9 | 234.63 | 230.3 | 230.97 | 622258.0 |
| 2022-10-26 09:30:00 | MSFT | Stock | 231.0 | 233.34 | 230.17 | 231.12 | 14528133.0 |
| 2022-10-26 10:00:00 | MSFT | Stock | 231.13 | 233.66 | 230.81 | 233.64 | 7331708.0 |
| 2022-10-26 10:30:00 | MSFT | Stock | 233.65 | 237.23 | 233.63 | 235.22 | 7141604.0 |
| 2022-10-26 11:00:00 | MSFT | Stock | 235.25 | 237.13 | 235.25 | 236.9501 | 3764878.0 |
| 2022-10-26 11:30:00 | MSFT | Stock | 236.965 | 238.3 | 236.31 | 236.525 | 3436361.0 |
| 2022-10-26 12:00:00 | MSFT | Stock | 236.52 | 236.75 | 235.51 | 236.24 | 2824953.0 |
| 2022-10-26 12:30:00 | MSFT | Stock | 236.24 | 237.17 | 234.82 | 234.93 | 2503121.0 |
> showing 50 of 103,887 rows — these rows as CSV