PREVIEW / stock_30min / 2022-10-07
file: by_date/stock_30min/2022/2022-10-07.parquet size: 2.0 MB rows: 101,040 symbols: 2,100
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-07 04:00:00 | AAPL | Stock | 144.83 | 144.83 | 144.15 | 144.69 | 9918.0 |
| 2022-10-07 04:30:00 | AAPL | Stock | 144.63 | 144.83 | 144.63 | 144.82 | 4477.0 |
| 2022-10-07 05:00:00 | AAPL | Stock | 144.9 | 145.13 | 144.88 | 145.04 | 8261.0 |
| 2022-10-07 05:30:00 | AAPL | Stock | 145.09 | 145.1 | 145.0 | 145.0 | 986.0 |
| 2022-10-07 06:00:00 | AAPL | Stock | 144.96 | 144.96 | 144.65 | 144.65 | 4689.0 |
| 2022-10-07 06:30:00 | AAPL | Stock | 144.67 | 144.82 | 144.52 | 144.66 | 12996.0 |
| 2022-10-07 07:00:00 | AAPL | Stock | 144.71 | 144.91 | 144.64 | 144.72 | 15859.0 |
| 2022-10-07 07:30:00 | AAPL | Stock | 144.69 | 144.8 | 144.41 | 144.65 | 46823.0 |
| 2022-10-07 08:00:00 | AAPL | Stock | 144.8892 | 145.25 | 144.39 | 145.25 | 136094.0 |
| 2022-10-07 08:30:00 | AAPL | Stock | 144.77 | 144.77 | 141.64 | 142.6 | 799715.0 |
| 2022-10-07 09:00:00 | AAPL | Stock | 142.58 | 142.7 | 142.0 | 142.58 | 314510.0 |
| 2022-10-07 09:30:00 | AAPL | Stock | 142.58 | 143.1 | 141.39 | 141.54 | 9274957.0 |
| 2022-10-07 10:00:00 | AAPL | Stock | 141.54 | 141.86 | 141.07 | 141.12 | 5627886.0 |
| 2022-10-07 10:30:00 | AAPL | Stock | 141.12 | 141.7 | 140.88 | 141.334 | 4886681.0 |
| 2022-10-07 11:00:00 | AAPL | Stock | 141.33 | 141.645 | 140.981 | 141.23 | 3648699.0 |
| 2022-10-07 11:30:00 | AAPL | Stock | 141.24 | 141.48 | 140.79 | 141.1206 | 3612729.0 |
| 2022-10-07 12:00:00 | AAPL | Stock | 141.12 | 141.37 | 140.639 | 140.67 | 2941746.0 |
| 2022-10-07 12:30:00 | AAPL | Stock | 140.6637 | 140.72 | 140.1825 | 140.3 | 3228790.0 |
| 2022-10-07 13:00:00 | AAPL | Stock | 140.3 | 140.54 | 139.94 | 140.26 | 3254536.0 |
| 2022-10-07 13:30:00 | AAPL | Stock | 140.265 | 140.6 | 140.02 | 140.15 | 2589984.0 |
| 2022-10-07 14:00:00 | AAPL | Stock | 140.1335 | 140.56 | 140.045 | 140.0779 | 2851502.0 |
| 2022-10-07 14:30:00 | AAPL | Stock | 140.07 | 140.325 | 139.92 | 140.18 | 2937523.0 |
| 2022-10-07 15:00:00 | AAPL | Stock | 140.1704 | 140.535 | 139.6 | 139.7219 | 4139660.0 |
| 2022-10-07 15:30:00 | AAPL | Stock | 139.72 | 140.49 | 139.445 | 140.1 | 11994375.0 |
| 2022-10-07 16:00:00 | AAPL | Stock | 140.14 | 140.35 | 139.99 | 140.0 | 12665273.0 |
| 2022-10-07 16:30:00 | AAPL | Stock | 140.0 | 140.09 | 139.93 | 140.01 | 260746.0 |
| 2022-10-07 17:00:00 | AAPL | Stock | 140.01 | 140.04 | 139.95 | 140.0 | 44579.0 |
| 2022-10-07 17:30:00 | AAPL | Stock | 140.0543 | 140.06 | 139.99 | 140.0 | 16499.0 |
| 2022-10-07 18:00:00 | AAPL | Stock | 140.0 | 140.02 | 139.98 | 139.99 | 18199.0 |
| 2022-10-07 18:30:00 | AAPL | Stock | 140.0 | 140.0 | 139.91 | 139.92 | 8247.0 |
| 2022-10-07 19:00:00 | AAPL | Stock | 139.95 | 139.95 | 139.9 | 139.91 | 5124.0 |
| 2022-10-07 19:30:00 | AAPL | Stock | 139.92 | 140.02 | 139.9 | 140.02 | 24352.0 |
| 2022-10-07 04:00:00 | MSFT | Stock | 245.23 | 245.62 | 244.56 | 245.62 | 1027.0 |
| 2022-10-07 04:30:00 | MSFT | Stock | 245.67 | 245.7 | 245.32 | 245.7 | 2177.0 |
| 2022-10-07 05:30:00 | MSFT | Stock | 246.01 | 246.01 | 246.01 | 246.01 | 491.0 |
| 2022-10-07 06:00:00 | MSFT | Stock | 245.8 | 245.8 | 245.41 | 245.41 | 1095.0 |
| 2022-10-07 06:30:00 | MSFT | Stock | 245.42 | 245.98 | 245.37 | 245.37 | 962.0 |
| 2022-10-07 07:00:00 | MSFT | Stock | 245.85 | 246.0 | 245.65 | 245.82 | 1720.0 |
| 2022-10-07 07:30:00 | MSFT | Stock | 245.9 | 246.0 | 245.52 | 245.55 | 3198.0 |
| 2022-10-07 08:00:00 | MSFT | Stock | 245.4008 | 246.18 | 245.4008 | 245.65 | 32184.0 |
| 2022-10-07 08:30:00 | MSFT | Stock | 246.3 | 246.3 | 241.4 | 242.62 | 152100.0 |
| 2022-10-07 09:00:00 | MSFT | Stock | 242.61 | 242.76 | 240.55 | 241.15 | 126334.0 |
| 2022-10-07 09:30:00 | MSFT | Stock | 241.16 | 241.32 | 236.82 | 237.25 | 4384041.0 |
| 2022-10-07 10:00:00 | MSFT | Stock | 237.27 | 237.33 | 235.91 | 236.16 | 2055501.0 |
| 2022-10-07 10:30:00 | MSFT | Stock | 236.18 | 236.42 | 235.16 | 235.97 | 2185048.0 |
| 2022-10-07 11:00:00 | MSFT | Stock | 235.97 | 236.65 | 235.53 | 236.3799 | 1156074.0 |
| 2022-10-07 11:30:00 | MSFT | Stock | 236.39 | 236.72 | 235.4601 | 236.01 | 974420.0 |
| 2022-10-07 12:00:00 | MSFT | Stock | 236.0 | 236.28 | 235.22 | 235.23 | 1036218.0 |
| 2022-10-07 12:30:00 | MSFT | Stock | 235.21 | 235.36 | 234.56 | 234.81 | 1191539.0 |
| 2022-10-07 13:00:00 | MSFT | Stock | 234.81 | 235.13 | 234.38 | 234.77 | 921236.0 |
> showing 50 of 101,040 rows — these rows as CSV