PREVIEW / stock_30min / 2021-11-04
file: by_date/stock_30min/2021/2021-11-04.parquet size: 2.3 MB rows: 114,220 symbols: 2,690
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-11-04 04:00:00 | AAPL | Stock | 152.0 | 152.0 | 151.68 | 151.88 | 14722.0 |
| 2021-11-04 04:30:00 | AAPL | Stock | 151.97 | 151.97 | 151.6 | 151.65 | 5719.0 |
| 2021-11-04 05:00:00 | AAPL | Stock | 151.73 | 151.75 | 151.62 | 151.68 | 6671.0 |
| 2021-11-04 05:30:00 | AAPL | Stock | 151.68 | 151.71 | 151.64 | 151.7 | 3694.0 |
| 2021-11-04 06:00:00 | AAPL | Stock | 151.69 | 151.75 | 151.5 | 151.5 | 11901.0 |
| 2021-11-04 06:30:00 | AAPL | Stock | 151.6 | 151.67 | 151.6 | 151.64 | 3056.0 |
| 2021-11-04 07:00:00 | AAPL | Stock | 151.67 | 151.84 | 151.61 | 151.77 | 47429.0 |
| 2021-11-04 07:30:00 | AAPL | Stock | 151.77 | 151.9 | 151.73 | 151.82 | 52226.0 |
| 2021-11-04 08:00:00 | AAPL | Stock | 151.7708 | 151.9 | 151.112 | 151.81 | 140115.0 |
| 2021-11-04 08:30:00 | AAPL | Stock | 151.81 | 151.82 | 151.63 | 151.78 | 102745.0 |
| 2021-11-04 09:00:00 | AAPL | Stock | 151.79 | 151.79 | 151.51 | 151.61 | 137330.0 |
| 2021-11-04 09:30:00 | AAPL | Stock | 151.62 | 152.43 | 151.28 | 152.075 | 7331151.0 |
| 2021-11-04 10:00:00 | AAPL | Stock | 152.08 | 152.1 | 151.55 | 151.748 | 3717227.0 |
| 2021-11-04 10:30:00 | AAPL | Stock | 151.75 | 151.99 | 151.57 | 151.915 | 3158894.0 |
| 2021-11-04 11:00:00 | AAPL | Stock | 151.92 | 151.95 | 150.84 | 151.11 | 4174568.0 |
| 2021-11-04 11:30:00 | AAPL | Stock | 151.1111 | 151.43 | 151.02 | 151.37 | 2674806.0 |
| 2021-11-04 12:00:00 | AAPL | Stock | 151.37 | 151.67 | 151.22 | 151.32 | 2072230.0 |
| 2021-11-04 12:30:00 | AAPL | Stock | 151.315 | 151.42 | 151.145 | 151.22 | 1564197.0 |
| 2021-11-04 13:00:00 | AAPL | Stock | 151.221 | 151.27 | 151.02 | 151.22 | 2135079.0 |
| 2021-11-04 13:30:00 | AAPL | Stock | 151.21 | 151.57 | 151.17 | 151.5301 | 2066632.0 |
| 2021-11-04 14:00:00 | AAPL | Stock | 151.53 | 151.55 | 151.13 | 151.135 | 2025879.0 |
| 2021-11-04 14:30:00 | AAPL | Stock | 151.135 | 151.36 | 151.12 | 151.18 | 1768390.0 |
| 2021-11-04 15:00:00 | AAPL | Stock | 151.175 | 151.49 | 151.13 | 151.44 | 1997712.0 |
| 2021-11-04 15:30:00 | AAPL | Stock | 151.45 | 151.54 | 150.64 | 150.96 | 5467517.0 |
| 2021-11-04 16:00:00 | AAPL | Stock | 150.96 | 151.08 | 150.84 | 151.0 | 9446387.0 |
| 2021-11-04 16:30:00 | AAPL | Stock | 151.0 | 151.01 | 150.94 | 150.98 | 53183.0 |
| 2021-11-04 17:00:00 | AAPL | Stock | 151.01 | 151.03 | 150.86 | 150.86 | 29278.0 |
| 2021-11-04 17:30:00 | AAPL | Stock | 150.9 | 150.93 | 150.87 | 150.89 | 14038.0 |
| 2021-11-04 18:00:00 | AAPL | Stock | 150.92 | 151.03 | 150.92 | 151.03 | 6272.0 |
| 2021-11-04 18:30:00 | AAPL | Stock | 150.98 | 151.02 | 150.97 | 150.99 | 9939.0 |
| 2021-11-04 19:00:00 | AAPL | Stock | 150.99 | 151.0 | 150.97 | 150.98 | 6584.0 |
| 2021-11-04 19:30:00 | AAPL | Stock | 150.98 | 150.99 | 150.89 | 150.95 | 26650.0 |
| 2021-11-04 04:00:00 | MSFT | Stock | 335.0 | 335.92 | 334.92 | 334.95 | 2408.0 |
| 2021-11-04 04:30:00 | MSFT | Stock | 334.99 | 335.13 | 334.65 | 334.65 | 1728.0 |
| 2021-11-04 05:00:00 | MSFT | Stock | 334.75 | 334.85 | 334.53 | 334.84 | 6408.0 |
| 2021-11-04 05:30:00 | MSFT | Stock | 334.55 | 334.55 | 334.5 | 334.5 | 1514.0 |
| 2021-11-04 06:00:00 | MSFT | Stock | 334.47 | 334.55 | 334.01 | 334.01 | 8327.0 |
| 2021-11-04 06:30:00 | MSFT | Stock | 334.21 | 334.58 | 334.2 | 334.58 | 5422.0 |
| 2021-11-04 07:00:00 | MSFT | Stock | 334.58 | 334.6 | 334.3 | 334.35 | 10215.0 |
| 2021-11-04 07:30:00 | MSFT | Stock | 334.35 | 334.5 | 334.3 | 334.5 | 2827.0 |
| 2021-11-04 08:00:00 | MSFT | Stock | 334.5166 | 334.835 | 334.3 | 334.55 | 18441.0 |
| 2021-11-04 08:30:00 | MSFT | Stock | 334.31 | 334.39 | 334.0 | 334.05 | 8267.0 |
| 2021-11-04 09:00:00 | MSFT | Stock | 334.23 | 334.28 | 332.61 | 332.97 | 29961.0 |
| 2021-11-04 09:30:00 | MSFT | Stock | 333.07 | 333.63 | 329.51 | 333.485 | 3273904.0 |
| 2021-11-04 10:00:00 | MSFT | Stock | 333.52 | 335.93 | 333.21 | 335.87 | 1573892.0 |
| 2021-11-04 10:30:00 | MSFT | Stock | 335.885 | 336.13 | 334.87 | 334.98 | 1410426.0 |
| 2021-11-04 11:00:00 | MSFT | Stock | 335.0 | 335.31 | 334.29 | 334.9 | 984324.0 |
| 2021-11-04 11:30:00 | MSFT | Stock | 334.93 | 335.54 | 334.605 | 335.45 | 669857.0 |
| 2021-11-04 12:00:00 | MSFT | Stock | 335.41 | 335.68 | 334.9 | 335.08 | 515827.0 |
| 2021-11-04 12:30:00 | MSFT | Stock | 335.09 | 335.505 | 334.815 | 335.5 | 453069.0 |
> showing 50 of 114,220 rows — these rows as CSV