PREVIEW / stock_30min / 2022-11-22
file: by_date/stock_30min/2022/2022-11-22.parquet size: 2.1 MB rows: 100,904 symbols: 2,045
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-22 04:00:00 | AAPL | Stock | 147.91 | 148.05 | 147.65 | 148.05 | 10204.0 |
| 2022-11-22 04:30:00 | AAPL | Stock | 148.13 | 148.69 | 148.13 | 148.4 | 8322.0 |
| 2022-11-22 05:00:00 | AAPL | Stock | 148.44 | 148.44 | 148.09 | 148.11 | 1150.0 |
| 2022-11-22 05:30:00 | AAPL | Stock | 148.1 | 148.27 | 148.03 | 148.23 | 4120.0 |
| 2022-11-22 06:00:00 | AAPL | Stock | 148.23 | 148.23 | 147.74 | 147.77 | 4645.0 |
| 2022-11-22 06:30:00 | AAPL | Stock | 147.97 | 148.02 | 147.7 | 147.95 | 16677.0 |
| 2022-11-22 07:00:00 | AAPL | Stock | 147.99 | 148.21 | 147.9 | 148.21 | 30793.0 |
| 2022-11-22 07:30:00 | AAPL | Stock | 148.24 | 148.35 | 148.13 | 148.22 | 23619.0 |
| 2022-11-22 08:00:00 | AAPL | Stock | 147.95 | 148.57 | 146.86 | 148.3 | 92403.0 |
| 2022-11-22 08:30:00 | AAPL | Stock | 148.36 | 148.64 | 148.3504 | 148.43 | 56254.0 |
| 2022-11-22 09:00:00 | AAPL | Stock | 148.45 | 148.5 | 147.65 | 148.16 | 144863.0 |
| 2022-11-22 09:30:00 | AAPL | Stock | 148.13 | 148.55 | 146.925 | 147.51 | 5369494.0 |
| 2022-11-22 10:00:00 | AAPL | Stock | 147.5 | 148.51 | 147.41 | 148.26 | 4162916.0 |
| 2022-11-22 10:30:00 | AAPL | Stock | 148.25 | 148.83 | 147.99 | 148.71 | 3257619.0 |
| 2022-11-22 11:00:00 | AAPL | Stock | 148.715 | 148.98 | 148.38 | 148.95 | 2497724.0 |
| 2022-11-22 11:30:00 | AAPL | Stock | 148.96 | 148.97 | 148.51 | 148.865 | 2096005.0 |
| 2022-11-22 12:00:00 | AAPL | Stock | 148.86 | 149.4411 | 148.8471 | 149.25 | 2745646.0 |
| 2022-11-22 12:30:00 | AAPL | Stock | 149.24 | 149.53 | 149.1 | 149.2 | 1788669.0 |
| 2022-11-22 13:00:00 | AAPL | Stock | 149.19 | 149.77 | 149.04 | 149.68 | 2193144.0 |
| 2022-11-22 13:30:00 | AAPL | Stock | 149.675 | 150.04 | 149.635 | 149.97 | 2157330.0 |
| 2022-11-22 14:00:00 | AAPL | Stock | 149.97 | 150.05 | 149.46 | 149.6527 | 2009816.0 |
| 2022-11-22 14:30:00 | AAPL | Stock | 149.65 | 149.89 | 149.51 | 149.79 | 2203339.0 |
| 2022-11-22 15:00:00 | AAPL | Stock | 149.7905 | 150.15 | 149.74 | 150.045 | 2527143.0 |
| 2022-11-22 15:30:00 | AAPL | Stock | 150.045 | 150.42 | 149.965 | 150.25 | 5201976.0 |
| 2022-11-22 16:00:00 | AAPL | Stock | 150.22 | 150.26 | 150.08 | 150.0977 | 7740436.0 |
| 2022-11-22 16:30:00 | AAPL | Stock | 150.0931 | 150.18 | 150.01 | 150.03 | 69754.0 |
| 2022-11-22 17:00:00 | AAPL | Stock | 150.02 | 150.08 | 149.99 | 150.04 | 17230.0 |
| 2022-11-22 17:30:00 | AAPL | Stock | 150.03 | 150.06 | 150.03 | 150.05 | 2975.0 |
| 2022-11-22 18:00:00 | AAPL | Stock | 150.06 | 150.14 | 150.04 | 150.11 | 16814.0 |
| 2022-11-22 18:30:00 | AAPL | Stock | 150.1 | 150.1 | 150.01 | 150.09 | 15540.0 |
| 2022-11-22 19:00:00 | AAPL | Stock | 150.06 | 150.35 | 150.06 | 150.1 | 12946.0 |
| 2022-11-22 19:30:00 | AAPL | Stock | 150.1 | 150.17 | 150.05 | 150.1 | 27460.0 |
| 2022-11-22 04:00:00 | MSFT | Stock | 241.9 | 241.95 | 241.41 | 241.95 | 1859.0 |
| 2022-11-22 04:30:00 | MSFT | Stock | 242.37 | 242.59 | 242.31 | 242.59 | 794.0 |
| 2022-11-22 05:00:00 | MSFT | Stock | 242.15 | 242.15 | 242.15 | 242.15 | 100.0 |
| 2022-11-22 05:30:00 | MSFT | Stock | 242.15 | 242.32 | 242.15 | 242.23 | 573.0 |
| 2022-11-22 06:00:00 | MSFT | Stock | 242.11 | 242.15 | 241.56 | 241.56 | 1403.0 |
| 2022-11-22 06:30:00 | MSFT | Stock | 241.65 | 241.76 | 240.86 | 241.76 | 7338.0 |
| 2022-11-22 07:00:00 | MSFT | Stock | 241.59 | 242.14 | 241.59 | 242.14 | 1350.0 |
| 2022-11-22 07:30:00 | MSFT | Stock | 242.23 | 242.23 | 242.08 | 242.12 | 400.0 |
| 2022-11-22 08:00:00 | MSFT | Stock | 241.86 | 242.9989 | 241.86 | 242.65 | 7362.0 |
| 2022-11-22 08:30:00 | MSFT | Stock | 242.58 | 243.35 | 242.58 | 243.1312 | 4699.0 |
| 2022-11-22 09:00:00 | MSFT | Stock | 243.14 | 243.7 | 242.62 | 243.6 | 14794.0 |
| 2022-11-22 09:30:00 | MSFT | Stock | 243.59 | 243.9 | 240.71 | 241.43 | 1857504.0 |
| 2022-11-22 10:00:00 | MSFT | Stock | 241.41 | 242.83 | 241.32 | 242.1 | 1137924.0 |
| 2022-11-22 10:30:00 | MSFT | Stock | 242.1 | 243.16 | 241.66 | 243.1 | 955500.0 |
| 2022-11-22 11:00:00 | MSFT | Stock | 243.11 | 243.1495 | 242.54 | 242.79 | 656836.0 |
| 2022-11-22 11:30:00 | MSFT | Stock | 242.79 | 242.9 | 242.11 | 242.55 | 586348.0 |
| 2022-11-22 12:00:00 | MSFT | Stock | 242.53 | 243.29 | 242.5 | 242.755 | 714831.0 |
| 2022-11-22 12:30:00 | MSFT | Stock | 242.7428 | 242.985 | 242.55 | 242.9 | 486393.0 |
> showing 50 of 100,904 rows — these rows as CSV