PREVIEW / stock_30min / 2021-10-22
file: by_date/stock_30min/2021/2021-10-22.parquet size: 2.2 MB rows: 110,430 symbols: 2,647
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-22 04:00:00 | AAPL | Stock | 149.23 | 149.93 | 149.13 | 149.39 | 6797.0 |
| 2021-10-22 04:30:00 | AAPL | Stock | 149.46 | 149.59 | 149.41 | 149.59 | 9684.0 |
| 2021-10-22 05:00:00 | AAPL | Stock | 149.54 | 149.75 | 149.5 | 149.51 | 7040.0 |
| 2021-10-22 05:30:00 | AAPL | Stock | 149.5 | 149.74 | 149.46 | 149.69 | 5648.0 |
| 2021-10-22 06:00:00 | AAPL | Stock | 149.66 | 149.73 | 149.61 | 149.62 | 3109.0 |
| 2021-10-22 06:30:00 | AAPL | Stock | 149.61 | 149.75 | 149.6 | 149.75 | 7506.0 |
| 2021-10-22 07:00:00 | AAPL | Stock | 149.71 | 150.1 | 149.6 | 150.06 | 116496.0 |
| 2021-10-22 07:30:00 | AAPL | Stock | 150.06 | 150.06 | 149.71 | 149.72 | 40278.0 |
| 2021-10-22 08:00:00 | AAPL | Stock | 149.9799 | 150.1129 | 149.107 | 149.87 | 224717.0 |
| 2021-10-22 08:30:00 | AAPL | Stock | 149.86 | 149.9 | 149.65 | 149.6999 | 125107.0 |
| 2021-10-22 09:00:00 | AAPL | Stock | 149.71 | 149.77 | 149.4 | 149.71 | 143278.0 |
| 2021-10-22 09:30:00 | AAPL | Stock | 149.64 | 150.18 | 148.845 | 149.865 | 9064338.0 |
| 2021-10-22 10:00:00 | AAPL | Stock | 149.87 | 150.17 | 149.69 | 150.105 | 4267082.0 |
| 2021-10-22 10:30:00 | AAPL | Stock | 150.1 | 150.11 | 149.32 | 149.54 | 3596976.0 |
| 2021-10-22 11:00:00 | AAPL | Stock | 149.5403 | 149.65 | 148.95 | 149.225 | 3572603.0 |
| 2021-10-22 11:30:00 | AAPL | Stock | 149.22 | 149.28 | 148.64 | 148.95 | 3641316.0 |
| 2021-10-22 12:00:00 | AAPL | Stock | 148.945 | 149.16 | 148.78 | 149.14 | 2459240.0 |
| 2021-10-22 12:30:00 | AAPL | Stock | 149.13 | 149.48 | 149.05 | 149.11 | 2467310.0 |
| 2021-10-22 13:00:00 | AAPL | Stock | 149.11 | 149.19 | 148.98 | 149.015 | 1887909.0 |
| 2021-10-22 13:30:00 | AAPL | Stock | 149.02 | 149.3 | 148.9 | 148.93 | 2107195.0 |
| 2021-10-22 14:00:00 | AAPL | Stock | 148.94 | 149.43 | 148.8923 | 149.425 | 2239877.0 |
| 2021-10-22 14:30:00 | AAPL | Stock | 149.43 | 149.6716 | 149.085 | 149.105 | 2367437.0 |
| 2021-10-22 15:00:00 | AAPL | Stock | 149.11 | 149.17 | 148.87 | 148.945 | 2760435.0 |
| 2021-10-22 15:30:00 | AAPL | Stock | 148.94 | 149.18 | 148.64 | 148.69 | 5151179.0 |
| 2021-10-22 16:00:00 | AAPL | Stock | 148.69 | 148.7 | 148.55 | 148.63 | 4617828.0 |
| 2021-10-22 16:30:00 | AAPL | Stock | 148.62 | 148.69 | 148.55 | 148.55 | 27679.0 |
| 2021-10-22 17:00:00 | AAPL | Stock | 148.55 | 148.55 | 148.46 | 148.53 | 41918.0 |
| 2021-10-22 17:30:00 | AAPL | Stock | 148.53 | 148.57 | 148.41 | 148.48 | 28247.0 |
| 2021-10-22 18:00:00 | AAPL | Stock | 148.47 | 148.61 | 148.43 | 148.61 | 21821.0 |
| 2021-10-22 18:30:00 | AAPL | Stock | 148.6 | 148.6 | 148.55 | 148.57 | 6328.0 |
| 2021-10-22 19:00:00 | AAPL | Stock | 148.59 | 148.62 | 148.49 | 148.49 | 6225.0 |
| 2021-10-22 19:30:00 | AAPL | Stock | 148.5 | 148.52 | 148.43 | 148.46 | 14648.0 |
| 2021-10-22 04:00:00 | MSFT | Stock | 310.27 | 310.7 | 310.27 | 310.46 | 324.0 |
| 2021-10-22 04:30:00 | MSFT | Stock | 310.72 | 311.15 | 310.72 | 310.8 | 3978.0 |
| 2021-10-22 05:00:00 | MSFT | Stock | 310.85 | 310.85 | 310.8 | 310.8 | 2953.0 |
| 2021-10-22 05:30:00 | MSFT | Stock | 310.8 | 310.8 | 310.8 | 310.8 | 623.0 |
| 2021-10-22 06:00:00 | MSFT | Stock | 310.99 | 311.02 | 310.95 | 311.02 | 10829.0 |
| 2021-10-22 06:30:00 | MSFT | Stock | 310.9 | 311.0 | 310.9 | 311.0 | 212.0 |
| 2021-10-22 07:00:00 | MSFT | Stock | 311.03 | 311.2 | 311.0 | 311.2 | 3700.0 |
| 2021-10-22 07:30:00 | MSFT | Stock | 311.18 | 311.3 | 310.55 | 310.56 | 23638.0 |
| 2021-10-22 08:00:00 | MSFT | Stock | 311.03 | 311.3396 | 309.984 | 310.94 | 18831.0 |
| 2021-10-22 08:30:00 | MSFT | Stock | 310.9 | 311.0 | 310.7601 | 310.9399 | 8851.0 |
| 2021-10-22 09:00:00 | MSFT | Stock | 310.76 | 310.85 | 310.05 | 310.71 | 22314.0 |
| 2021-10-22 09:30:00 | MSFT | Stock | 310.4 | 311.09 | 308.5 | 309.59 | 1925174.0 |
| 2021-10-22 10:00:00 | MSFT | Stock | 309.595 | 310.25 | 309.22 | 310.24 | 779181.0 |
| 2021-10-22 10:30:00 | MSFT | Stock | 310.25 | 310.26 | 309.12 | 309.919 | 726303.0 |
| 2021-10-22 11:00:00 | MSFT | Stock | 309.92 | 310.1454 | 308.58 | 308.92 | 745064.0 |
| 2021-10-22 11:30:00 | MSFT | Stock | 308.93 | 309.01 | 307.8 | 308.31 | 1095025.0 |
| 2021-10-22 12:00:00 | MSFT | Stock | 308.28 | 308.83 | 307.99 | 308.83 | 590038.0 |
| 2021-10-22 12:30:00 | MSFT | Stock | 308.81 | 310.01 | 308.765 | 309.1992 | 640259.0 |
> showing 50 of 110,430 rows — these rows as CSV