PREVIEW / stock_30min / 2022-11-03
file: by_date/stock_30min/2022/2022-11-03.parquet size: 2.1 MB rows: 102,245 symbols: 2,107
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-03 04:00:00 | AAPL | Stock | 144.92 | 144.92 | 144.1 | 144.23 | 13780.0 |
| 2022-11-03 04:30:00 | AAPL | Stock | 144.21 | 144.36 | 143.82 | 144.0 | 26029.0 |
| 2022-11-03 05:00:00 | AAPL | Stock | 144.05 | 144.15 | 143.7 | 144.05 | 23639.0 |
| 2022-11-03 05:30:00 | AAPL | Stock | 143.95 | 144.05 | 143.8 | 143.99 | 4744.0 |
| 2022-11-03 06:00:00 | AAPL | Stock | 143.99 | 144.2 | 143.36 | 143.36 | 29455.0 |
| 2022-11-03 06:30:00 | AAPL | Stock | 143.47 | 143.68 | 143.27 | 143.53 | 10085.0 |
| 2022-11-03 07:00:00 | AAPL | Stock | 143.64 | 143.74 | 143.09 | 143.22 | 53277.0 |
| 2022-11-03 07:30:00 | AAPL | Stock | 143.24 | 143.25 | 142.59 | 142.75 | 70483.0 |
| 2022-11-03 08:00:00 | AAPL | Stock | 143.78 | 143.8015 | 142.433 | 142.433 | 184513.0 |
| 2022-11-03 08:30:00 | AAPL | Stock | 142.45 | 142.54 | 141.73 | 141.92 | 344130.0 |
| 2022-11-03 09:00:00 | AAPL | Stock | 141.92 | 142.36 | 141.83 | 142.06 | 447061.0 |
| 2022-11-03 09:30:00 | AAPL | Stock | 142.07 | 142.8 | 139.3601 | 139.6749 | 14480234.0 |
| 2022-11-03 10:00:00 | AAPL | Stock | 139.69 | 141.01 | 139.65 | 140.98 | 8830356.0 |
| 2022-11-03 10:30:00 | AAPL | Stock | 140.99 | 141.328 | 139.88 | 141.055 | 6726814.0 |
| 2022-11-03 11:00:00 | AAPL | Stock | 141.045 | 141.134 | 139.74 | 139.75 | 4668849.0 |
| 2022-11-03 11:30:00 | AAPL | Stock | 139.75 | 140.26 | 139.26 | 139.49 | 4448441.0 |
| 2022-11-03 12:00:00 | AAPL | Stock | 139.4763 | 140.54 | 139.27 | 140.2228 | 4084199.0 |
| 2022-11-03 12:30:00 | AAPL | Stock | 140.22 | 140.77 | 139.86 | 140.6426 | 3372948.0 |
| 2022-11-03 13:00:00 | AAPL | Stock | 140.64 | 140.79 | 139.96 | 140.055 | 2642152.0 |
| 2022-11-03 13:30:00 | AAPL | Stock | 140.05 | 140.2 | 139.52 | 139.53 | 2415747.0 |
| 2022-11-03 14:00:00 | AAPL | Stock | 139.54 | 140.18 | 139.085 | 140.085 | 4323027.0 |
| 2022-11-03 14:30:00 | AAPL | Stock | 140.085 | 140.35 | 139.75 | 140.24 | 3450492.0 |
| 2022-11-03 15:00:00 | AAPL | Stock | 140.24 | 140.33 | 139.65 | 139.77 | 3826921.0 |
| 2022-11-03 15:30:00 | AAPL | Stock | 139.765 | 140.03 | 138.75 | 138.88 | 10016761.0 |
| 2022-11-03 16:00:00 | AAPL | Stock | 138.88 | 139.12 | 138.5102 | 139.0 | 8095893.0 |
| 2022-11-03 16:30:00 | AAPL | Stock | 139.0 | 139.23 | 138.82 | 139.12 | 186688.0 |
| 2022-11-03 17:00:00 | AAPL | Stock | 139.12 | 139.2 | 139.01 | 139.1 | 48805.0 |
| 2022-11-03 17:30:00 | AAPL | Stock | 139.1085 | 139.15 | 137.8 | 137.91 | 284489.0 |
| 2022-11-03 18:00:00 | AAPL | Stock | 137.9 | 137.96 | 137.4 | 137.71 | 250269.0 |
| 2022-11-03 18:30:00 | AAPL | Stock | 137.72 | 137.95 | 137.67 | 137.92 | 57099.0 |
| 2022-11-03 19:00:00 | AAPL | Stock | 137.9 | 137.93 | 137.81 | 137.92 | 44941.0 |
| 2022-11-03 19:30:00 | AAPL | Stock | 137.91 | 137.92 | 137.69 | 137.73 | 62869.0 |
| 2022-11-03 04:00:00 | MSFT | Stock | 220.89 | 221.17 | 220.7 | 220.8 | 3177.0 |
| 2022-11-03 04:30:00 | MSFT | Stock | 220.32 | 220.32 | 219.89 | 219.89 | 2365.0 |
| 2022-11-03 05:00:00 | MSFT | Stock | 220.65 | 220.73 | 220.24 | 220.24 | 2035.0 |
| 2022-11-03 05:30:00 | MSFT | Stock | 220.74 | 220.76 | 219.8 | 220.32 | 1938.0 |
| 2022-11-03 06:00:00 | MSFT | Stock | 220.0 | 220.0 | 219.1 | 219.1 | 5361.0 |
| 2022-11-03 06:30:00 | MSFT | Stock | 219.16 | 219.24 | 218.82 | 219.0 | 10741.0 |
| 2022-11-03 07:00:00 | MSFT | Stock | 219.21 | 219.33 | 218.85 | 219.0 | 11125.0 |
| 2022-11-03 07:30:00 | MSFT | Stock | 219.1 | 219.26 | 218.91 | 219.0 | 7919.0 |
| 2022-11-03 08:00:00 | MSFT | Stock | 219.25 | 219.6845 | 218.8201 | 219.59 | 26206.0 |
| 2022-11-03 08:30:00 | MSFT | Stock | 219.65 | 219.8 | 219.19 | 219.5 | 31063.0 |
| 2022-11-03 09:00:00 | MSFT | Stock | 219.41 | 220.49 | 219.26 | 220.09 | 58698.0 |
| 2022-11-03 09:30:00 | MSFT | Stock | 220.09 | 220.41 | 216.475 | 216.58 | 3598374.0 |
| 2022-11-03 10:00:00 | MSFT | Stock | 216.59 | 218.8 | 216.09 | 218.55 | 2079598.0 |
| 2022-11-03 10:30:00 | MSFT | Stock | 218.53 | 218.67 | 217.6 | 217.885 | 1779614.0 |
| 2022-11-03 11:00:00 | MSFT | Stock | 217.885 | 218.5501 | 216.5822 | 216.5822 | 1834420.0 |
| 2022-11-03 11:30:00 | MSFT | Stock | 216.58 | 217.045 | 215.9421 | 216.17 | 1517643.0 |
| 2022-11-03 12:00:00 | MSFT | Stock | 216.15 | 217.83 | 215.91 | 217.3332 | 1528174.0 |
| 2022-11-03 12:30:00 | MSFT | Stock | 217.325 | 218.4991 | 217.2 | 218.22 | 1685598.0 |
> showing 50 of 102,245 rows — these rows as CSV