PREVIEW / stock_30min / 2021-01-28
file: by_date/stock_30min/2021/2021-01-28.parquet size: 2.3 MB rows: 119,572 symbols: 2,739
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-01-28 04:00:00 | AAPL | Stock | 137.59 | 137.95 | 134.5 | 135.23 | 133112.0 |
| 2021-01-28 04:30:00 | AAPL | Stock | 135.12 | 136.96 | 135.12 | 136.88 | 93259.0 |
| 2021-01-28 05:00:00 | AAPL | Stock | 136.83 | 138.15 | 136.52 | 137.78 | 79072.0 |
| 2021-01-28 05:30:00 | AAPL | Stock | 137.72 | 138.95 | 137.5 | 137.6 | 73885.0 |
| 2021-01-28 06:00:00 | AAPL | Stock | 137.62 | 139.3 | 137.0 | 138.74 | 55566.0 |
| 2021-01-28 06:30:00 | AAPL | Stock | 138.7 | 139.3 | 138.29 | 139.22 | 33656.0 |
| 2021-01-28 07:00:00 | AAPL | Stock | 139.16 | 140.05 | 137.73 | 139.8 | 583885.0 |
| 2021-01-28 07:30:00 | AAPL | Stock | 139.81 | 139.9 | 138.62 | 138.88 | 308257.0 |
| 2021-01-28 08:00:00 | AAPL | Stock | 138.85 | 140.04 | 137.81 | 138.58 | 646930.0 |
| 2021-01-28 08:30:00 | AAPL | Stock | 138.58 | 140.48 | 138.27 | 140.2 | 590849.0 |
| 2021-01-28 09:00:00 | AAPL | Stock | 140.22 | 142.12 | 139.31 | 139.52 | 1241788.0 |
| 2021-01-28 09:30:00 | AAPL | Stock | 139.47 | 140.0 | 138.0 | 138.26 | 16532715.0 |
| 2021-01-28 10:00:00 | AAPL | Stock | 138.26 | 140.338 | 138.0 | 139.57 | 10588347.0 |
| 2021-01-28 10:30:00 | AAPL | Stock | 139.61 | 140.17 | 138.52 | 139.22 | 8009592.0 |
| 2021-01-28 11:00:00 | AAPL | Stock | 139.23 | 140.025 | 138.85 | 138.94 | 7226055.0 |
| 2021-01-28 11:30:00 | AAPL | Stock | 138.96 | 139.24 | 138.49 | 139.07 | 5164757.0 |
| 2021-01-28 12:00:00 | AAPL | Stock | 139.07 | 141.99 | 139.005 | 141.159 | 11603826.0 |
| 2021-01-28 12:30:00 | AAPL | Stock | 141.16 | 141.62 | 140.58 | 140.7 | 7231497.0 |
| 2021-01-28 13:00:00 | AAPL | Stock | 140.72 | 140.93 | 139.9 | 140.15 | 5502760.0 |
| 2021-01-28 13:30:00 | AAPL | Stock | 140.17 | 140.54 | 140.03 | 140.2 | 4191109.0 |
| 2021-01-28 14:00:00 | AAPL | Stock | 140.215 | 140.34 | 139.03 | 139.78 | 6476941.0 |
| 2021-01-28 14:30:00 | AAPL | Stock | 139.8 | 139.85 | 139.05 | 139.32 | 4263590.0 |
| 2021-01-28 15:00:00 | AAPL | Stock | 139.32 | 139.33 | 138.3 | 138.31 | 6572408.0 |
| 2021-01-28 15:30:00 | AAPL | Stock | 138.308 | 138.55 | 136.7 | 137.04 | 14809637.0 |
| 2021-01-28 16:00:00 | AAPL | Stock | 137.09 | 137.15 | 136.3 | 136.47 | 9981631.0 |
| 2021-01-28 16:30:00 | AAPL | Stock | 136.47 | 137.1 | 136.01 | 137.07 | 511683.0 |
| 2021-01-28 17:00:00 | AAPL | Stock | 137.09 | 137.53 | 137.03 | 137.22 | 307419.0 |
| 2021-01-28 17:30:00 | AAPL | Stock | 137.28 | 137.5 | 137.09 | 137.43 | 319373.0 |
| 2021-01-28 18:00:00 | AAPL | Stock | 137.44 | 137.55 | 136.9 | 137.5 | 187339.0 |
| 2021-01-28 18:30:00 | AAPL | Stock | 137.48 | 137.57 | 136.75 | 136.91 | 159004.0 |
| 2021-01-28 19:00:00 | AAPL | Stock | 136.92 | 137.11 | 136.7 | 136.7 | 140940.0 |
| 2021-01-28 19:30:00 | AAPL | Stock | 136.7 | 136.75 | 136.12 | 136.63 | 261449.0 |
| 2021-01-28 04:00:00 | MSFT | Stock | 230.62 | 230.69 | 229.09 | 229.7 | 29291.0 |
| 2021-01-28 04:30:00 | MSFT | Stock | 229.67 | 230.28 | 228.97 | 229.95 | 21884.0 |
| 2021-01-28 05:00:00 | MSFT | Stock | 230.0 | 231.01 | 230.0 | 231.0 | 15673.0 |
| 2021-01-28 05:30:00 | MSFT | Stock | 230.8 | 231.76 | 230.5 | 230.55 | 13341.0 |
| 2021-01-28 06:00:00 | MSFT | Stock | 230.55 | 231.5 | 229.56 | 231.3 | 14698.0 |
| 2021-01-28 06:30:00 | MSFT | Stock | 231.4 | 231.98 | 230.61 | 231.98 | 6070.0 |
| 2021-01-28 07:00:00 | MSFT | Stock | 231.72 | 233.0 | 230.7 | 232.17 | 38570.0 |
| 2021-01-28 07:30:00 | MSFT | Stock | 232.3 | 232.58 | 231.6 | 232.3 | 45269.0 |
| 2021-01-28 08:00:00 | MSFT | Stock | 232.34 | 233.25 | 229.25 | 230.5 | 213426.0 |
| 2021-01-28 08:30:00 | MSFT | Stock | 230.5 | 234.32 | 230.33 | 234.02 | 92561.0 |
| 2021-01-28 09:00:00 | MSFT | Stock | 234.0 | 236.864 | 234.0 | 235.57 | 173578.0 |
| 2021-01-28 09:30:00 | MSFT | Stock | 235.57 | 238.0 | 235.09 | 236.585 | 4567935.0 |
| 2021-01-28 10:00:00 | MSFT | Stock | 236.66 | 239.08 | 236.27 | 237.955 | 3005841.0 |
| 2021-01-28 10:30:00 | MSFT | Stock | 237.945 | 240.38 | 237.77 | 239.67 | 3957642.0 |
| 2021-01-28 11:00:00 | MSFT | Stock | 239.72 | 239.93 | 238.593 | 238.6 | 1924070.0 |
| 2021-01-28 11:30:00 | MSFT | Stock | 238.6 | 240.16 | 238.16 | 240.05 | 1750368.0 |
| 2021-01-28 12:00:00 | MSFT | Stock | 240.04 | 241.66 | 239.962 | 241.62 | 2742737.0 |
| 2021-01-28 12:30:00 | MSFT | Stock | 241.615 | 242.5 | 241.305 | 242.46 | 2237793.0 |
> showing 50 of 119,572 rows — these rows as CSV