PREVIEW / stock_30min / 2021-08-16
file: by_date/stock_30min/2021/2021-08-16.parquet size: 2.2 MB rows: 110,959 symbols: 2,812
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-08-16 04:00:00 | AAPL | Stock | 148.99 | 148.99 | 148.6 | 148.81 | 7334.0 |
| 2021-08-16 04:30:00 | AAPL | Stock | 148.79 | 148.81 | 148.65 | 148.74 | 4591.0 |
| 2021-08-16 05:00:00 | AAPL | Stock | 148.67 | 148.72 | 148.65 | 148.65 | 2264.0 |
| 2021-08-16 05:30:00 | AAPL | Stock | 148.65 | 148.69 | 148.51 | 148.69 | 1116.0 |
| 2021-08-16 06:00:00 | AAPL | Stock | 148.6 | 148.65 | 148.31 | 148.33 | 6796.0 |
| 2021-08-16 06:30:00 | AAPL | Stock | 148.36 | 148.55 | 148.34 | 148.48 | 5457.0 |
| 2021-08-16 07:00:00 | AAPL | Stock | 148.52 | 148.66 | 148.32 | 148.38 | 34296.0 |
| 2021-08-16 07:30:00 | AAPL | Stock | 148.38 | 148.48 | 148.32 | 148.48 | 20755.0 |
| 2021-08-16 08:00:00 | AAPL | Stock | 148.55 | 148.728 | 148.21 | 148.41 | 118012.0 |
| 2021-08-16 08:30:00 | AAPL | Stock | 148.4 | 148.579 | 148.38 | 148.5 | 88337.0 |
| 2021-08-16 09:00:00 | AAPL | Stock | 148.49 | 148.7 | 148.3 | 148.53 | 139327.0 |
| 2021-08-16 09:30:00 | AAPL | Stock | 148.57 | 150.59 | 148.07 | 148.64 | 19230708.0 |
| 2021-08-16 10:00:00 | AAPL | Stock | 148.64 | 148.8989 | 146.66 | 146.81 | 10046169.0 |
| 2021-08-16 10:30:00 | AAPL | Stock | 146.7912 | 147.24 | 146.47 | 147.085 | 6374497.0 |
| 2021-08-16 11:00:00 | AAPL | Stock | 147.085 | 147.74 | 147.03 | 147.715 | 4097406.0 |
| 2021-08-16 11:30:00 | AAPL | Stock | 147.715 | 148.55 | 147.59 | 148.325 | 4267390.0 |
| 2021-08-16 12:00:00 | AAPL | Stock | 148.3293 | 148.835 | 148.274 | 148.64 | 3039728.0 |
| 2021-08-16 12:30:00 | AAPL | Stock | 148.6483 | 149.73 | 148.645 | 149.495 | 5327394.0 |
| 2021-08-16 13:00:00 | AAPL | Stock | 149.5 | 149.6474 | 149.19 | 149.405 | 3666881.0 |
| 2021-08-16 13:30:00 | AAPL | Stock | 149.41 | 150.68 | 149.34 | 150.5057 | 7183490.0 |
| 2021-08-16 14:00:00 | AAPL | Stock | 150.502 | 150.619 | 150.12 | 150.435 | 4390486.0 |
| 2021-08-16 14:30:00 | AAPL | Stock | 150.435 | 150.81 | 150.3791 | 150.5 | 3983607.0 |
| 2021-08-16 15:00:00 | AAPL | Stock | 150.49 | 150.86 | 150.43 | 150.835 | 4306204.0 |
| 2021-08-16 15:30:00 | AAPL | Stock | 150.835 | 151.13 | 150.58 | 151.125 | 8579211.0 |
| 2021-08-16 16:00:00 | AAPL | Stock | 151.19 | 151.68 | 151.06 | 151.44 | 5734527.0 |
| 2021-08-16 16:30:00 | AAPL | Stock | 151.43 | 151.44 | 151.27 | 151.44 | 89759.0 |
| 2021-08-16 17:00:00 | AAPL | Stock | 151.41 | 151.41 | 151.33 | 151.33 | 27922.0 |
| 2021-08-16 17:30:00 | AAPL | Stock | 151.37 | 151.38 | 151.27 | 151.35 | 38055.0 |
| 2021-08-16 18:00:00 | AAPL | Stock | 151.36 | 151.36 | 151.27 | 151.34 | 36862.0 |
| 2021-08-16 18:30:00 | AAPL | Stock | 151.33 | 151.36 | 151.25 | 151.29 | 25661.0 |
| 2021-08-16 19:00:00 | AAPL | Stock | 151.29 | 151.55 | 151.29 | 151.51 | 60079.0 |
| 2021-08-16 19:30:00 | AAPL | Stock | 151.52 | 151.7 | 151.51 | 151.67 | 60630.0 |
| 2021-08-16 04:00:00 | MSFT | Stock | 292.9 | 292.9 | 292.6 | 292.77 | 1498.0 |
| 2021-08-16 04:30:00 | MSFT | Stock | 292.45 | 292.45 | 292.25 | 292.25 | 647.0 |
| 2021-08-16 05:00:00 | MSFT | Stock | 292.46 | 292.46 | 292.46 | 292.46 | 132.0 |
| 2021-08-16 05:30:00 | MSFT | Stock | 292.39 | 292.46 | 292.39 | 292.46 | 200.0 |
| 2021-08-16 06:00:00 | MSFT | Stock | 292.38 | 292.41 | 291.79 | 291.8 | 4875.0 |
| 2021-08-16 06:30:00 | MSFT | Stock | 291.8 | 292.38 | 291.8 | 292.38 | 5472.0 |
| 2021-08-16 07:00:00 | MSFT | Stock | 292.25 | 292.6 | 292.22 | 292.32 | 8569.0 |
| 2021-08-16 07:30:00 | MSFT | Stock | 292.33 | 292.33 | 292.08 | 292.15 | 7778.0 |
| 2021-08-16 08:00:00 | MSFT | Stock | 292.51 | 292.64 | 291.93 | 292.11 | 17485.0 |
| 2021-08-16 08:30:00 | MSFT | Stock | 292.15 | 292.48 | 292.1 | 292.1 | 13447.0 |
| 2021-08-16 09:00:00 | MSFT | Stock | 292.2 | 293.38 | 292.13 | 293.38 | 20554.0 |
| 2021-08-16 09:30:00 | MSFT | Stock | 293.14 | 294.59 | 292.16 | 293.15 | 2731322.0 |
| 2021-08-16 10:00:00 | MSFT | Stock | 293.15 | 293.29 | 290.44 | 290.83 | 1886147.0 |
| 2021-08-16 10:30:00 | MSFT | Stock | 290.84 | 291.13 | 290.02 | 290.57 | 1316854.0 |
| 2021-08-16 11:00:00 | MSFT | Stock | 290.5251 | 291.1296 | 290.48 | 291.05 | 834534.0 |
| 2021-08-16 11:30:00 | MSFT | Stock | 291.04 | 292.08 | 290.88 | 291.71 | 707795.0 |
| 2021-08-16 12:00:00 | MSFT | Stock | 291.72 | 292.64 | 291.6301 | 292.41 | 520267.0 |
| 2021-08-16 12:30:00 | MSFT | Stock | 292.4152 | 292.94 | 292.23 | 292.765 | 491444.0 |
> showing 50 of 110,959 rows — these rows as CSV