PREVIEW / stock_30min / 2021-10-13
file: by_date/stock_30min/2021/2021-10-13.parquet size: 2.2 MB rows: 108,134 symbols: 2,693
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-13 04:00:00 | AAPL | Stock | 140.2 | 140.52 | 139.93 | 140.43 | 26635.0 |
| 2021-10-13 04:30:00 | AAPL | Stock | 140.39 | 140.72 | 140.32 | 140.5 | 31263.0 |
| 2021-10-13 05:00:00 | AAPL | Stock | 140.45 | 140.75 | 140.26 | 140.56 | 14474.0 |
| 2021-10-13 05:30:00 | AAPL | Stock | 140.57 | 140.75 | 140.41 | 140.59 | 9254.0 |
| 2021-10-13 06:00:00 | AAPL | Stock | 140.56 | 141.1 | 140.56 | 140.75 | 18758.0 |
| 2021-10-13 06:30:00 | AAPL | Stock | 140.75 | 140.79 | 140.26 | 140.26 | 11125.0 |
| 2021-10-13 07:00:00 | AAPL | Stock | 140.4 | 140.72 | 140.05 | 140.63 | 156049.0 |
| 2021-10-13 07:30:00 | AAPL | Stock | 140.65 | 140.89 | 140.61 | 140.61 | 148523.0 |
| 2021-10-13 08:00:00 | AAPL | Stock | 140.4701 | 141.157 | 140.03 | 140.53 | 436599.0 |
| 2021-10-13 08:30:00 | AAPL | Stock | 140.53 | 140.99 | 140.11 | 140.51 | 370132.0 |
| 2021-10-13 09:00:00 | AAPL | Stock | 140.49 | 141.5512 | 140.42 | 141.17 | 391136.0 |
| 2021-10-13 09:30:00 | AAPL | Stock | 141.2 | 141.4 | 139.56 | 139.73 | 11793835.0 |
| 2021-10-13 10:00:00 | AAPL | Stock | 139.73 | 140.1832 | 139.5 | 139.66 | 6296138.0 |
| 2021-10-13 10:30:00 | AAPL | Stock | 139.66 | 140.11 | 139.5301 | 139.805 | 3940377.0 |
| 2021-10-13 11:00:00 | AAPL | Stock | 139.8 | 140.03 | 139.51 | 139.6 | 3682310.0 |
| 2021-10-13 11:30:00 | AAPL | Stock | 139.6 | 140.1354 | 139.2 | 140.125 | 5566400.0 |
| 2021-10-13 12:00:00 | AAPL | Stock | 140.12 | 140.148 | 139.8 | 140.1181 | 2888384.0 |
| 2021-10-13 12:30:00 | AAPL | Stock | 140.1101 | 140.1182 | 139.82 | 140.02 | 2161348.0 |
| 2021-10-13 13:00:00 | AAPL | Stock | 140.02 | 140.45 | 140.0 | 140.43 | 2999122.0 |
| 2021-10-13 13:30:00 | AAPL | Stock | 140.43 | 140.677 | 140.405 | 140.435 | 2735756.0 |
| 2021-10-13 14:00:00 | AAPL | Stock | 140.45 | 140.99 | 140.28 | 140.47 | 4077908.0 |
| 2021-10-13 14:30:00 | AAPL | Stock | 140.45 | 140.608 | 140.19 | 140.375 | 3015381.0 |
| 2021-10-13 15:00:00 | AAPL | Stock | 140.37 | 140.69 | 140.271 | 140.43 | 3200187.0 |
| 2021-10-13 15:30:00 | AAPL | Stock | 140.42 | 141.03 | 140.42 | 140.96 | 6264279.0 |
| 2021-10-13 16:00:00 | AAPL | Stock | 140.91 | 140.98 | 140.83 | 140.85 | 8988369.0 |
| 2021-10-13 16:30:00 | AAPL | Stock | 140.84 | 140.94 | 140.84 | 140.9 | 15562.0 |
| 2021-10-13 17:00:00 | AAPL | Stock | 140.88 | 140.94 | 140.84 | 140.84 | 6553.0 |
| 2021-10-13 17:30:00 | AAPL | Stock | 140.86 | 140.92 | 140.82 | 140.91 | 9718.0 |
| 2021-10-13 18:00:00 | AAPL | Stock | 140.96 | 141.1 | 140.84 | 141.08 | 22397.0 |
| 2021-10-13 18:30:00 | AAPL | Stock | 141.0699 | 141.12 | 141.0 | 141.01 | 16679.0 |
| 2021-10-13 19:00:00 | AAPL | Stock | 141.05 | 141.2 | 141.03 | 141.03 | 11421.0 |
| 2021-10-13 19:30:00 | AAPL | Stock | 141.04 | 141.255 | 141.04 | 141.24 | 22352.0 |
| 2021-10-13 04:00:00 | MSFT | Stock | 293.34 | 294.5 | 293.0 | 294.23 | 2242.0 |
| 2021-10-13 04:30:00 | MSFT | Stock | 294.2 | 294.99 | 294.2 | 294.58 | 4609.0 |
| 2021-10-13 05:00:00 | MSFT | Stock | 294.78 | 294.95 | 294.72 | 294.77 | 1583.0 |
| 2021-10-13 05:30:00 | MSFT | Stock | 294.95 | 295.0 | 294.8 | 294.8 | 2127.0 |
| 2021-10-13 06:00:00 | MSFT | Stock | 294.72 | 295.37 | 294.72 | 295.1 | 6337.0 |
| 2021-10-13 06:30:00 | MSFT | Stock | 295.02 | 295.02 | 294.7 | 294.7 | 1085.0 |
| 2021-10-13 07:00:00 | MSFT | Stock | 294.89 | 294.89 | 294.15 | 294.8 | 32030.0 |
| 2021-10-13 07:30:00 | MSFT | Stock | 294.83 | 295.0 | 294.62 | 294.8 | 6799.0 |
| 2021-10-13 08:00:00 | MSFT | Stock | 294.25 | 295.14 | 294.25 | 294.7 | 26056.0 |
| 2021-10-13 08:30:00 | MSFT | Stock | 294.66 | 295.48 | 292.97 | 293.65 | 48246.0 |
| 2021-10-13 09:00:00 | MSFT | Stock | 293.7 | 295.54 | 293.62 | 294.93 | 48002.0 |
| 2021-10-13 09:30:00 | MSFT | Stock | 294.91 | 297.28 | 294.5 | 295.52 | 1980878.0 |
| 2021-10-13 10:00:00 | MSFT | Stock | 295.53 | 296.0899 | 294.09 | 294.18 | 1144693.0 |
| 2021-10-13 10:30:00 | MSFT | Stock | 294.2 | 295.13 | 293.8204 | 294.16 | 871774.0 |
| 2021-10-13 11:00:00 | MSFT | Stock | 294.14 | 294.62 | 294.03 | 294.245 | 594691.0 |
| 2021-10-13 11:30:00 | MSFT | Stock | 294.21 | 294.96 | 293.49 | 294.49 | 839694.0 |
| 2021-10-13 12:00:00 | MSFT | Stock | 294.51 | 294.57 | 294.03 | 294.41 | 414806.0 |
| 2021-10-13 12:30:00 | MSFT | Stock | 294.39 | 294.46 | 293.7 | 294.045 | 471471.0 |
> showing 50 of 108,134 rows — these rows as CSV