PREVIEW / stock_30min / 2021-06-08
file: by_date/stock_30min/2021/2021-06-08.parquet size: 2.3 MB rows: 114,425 symbols: 2,972
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-06-08 04:00:00 | AAPL | Stock | 126.1 | 126.17 | 125.96 | 126.17 | 20868.0 |
| 2021-06-08 04:30:00 | AAPL | Stock | 126.23 | 126.3 | 126.23 | 126.3 | 12077.0 |
| 2021-06-08 05:00:00 | AAPL | Stock | 126.27 | 126.32 | 126.22 | 126.23 | 7089.0 |
| 2021-06-08 05:30:00 | AAPL | Stock | 126.23 | 126.4 | 126.23 | 126.38 | 7483.0 |
| 2021-06-08 06:00:00 | AAPL | Stock | 126.38 | 126.38 | 125.9 | 125.9 | 18386.0 |
| 2021-06-08 06:30:00 | AAPL | Stock | 125.9 | 126.6 | 125.84 | 126.49 | 21116.0 |
| 2021-06-08 07:00:00 | AAPL | Stock | 126.44 | 126.75 | 126.4 | 126.66 | 89805.0 |
| 2021-06-08 07:30:00 | AAPL | Stock | 126.67 | 126.85 | 126.56 | 126.83 | 70793.0 |
| 2021-06-08 08:00:00 | AAPL | Stock | 126.4101 | 126.95 | 126.3999 | 126.87 | 298933.0 |
| 2021-06-08 08:30:00 | AAPL | Stock | 126.85 | 126.94 | 126.7 | 126.93 | 165328.0 |
| 2021-06-08 09:00:00 | AAPL | Stock | 126.92 | 126.92 | 126.6 | 126.62 | 271268.0 |
| 2021-06-08 09:30:00 | AAPL | Stock | 126.62 | 128.46 | 126.4485 | 127.025 | 16214831.0 |
| 2021-06-08 10:00:00 | AAPL | Stock | 127.02 | 127.64 | 126.78 | 127.495 | 7385711.0 |
| 2021-06-08 10:30:00 | AAPL | Stock | 127.495 | 127.51 | 126.93 | 127.135 | 4761543.0 |
| 2021-06-08 11:00:00 | AAPL | Stock | 127.14 | 127.47 | 126.2101 | 126.455 | 5250059.0 |
| 2021-06-08 11:30:00 | AAPL | Stock | 126.453 | 126.82 | 126.41 | 126.61 | 4237630.0 |
| 2021-06-08 12:00:00 | AAPL | Stock | 126.61 | 126.82 | 126.53 | 126.6788 | 2693475.0 |
| 2021-06-08 12:30:00 | AAPL | Stock | 126.6799 | 126.84 | 126.6 | 126.825 | 2075368.0 |
| 2021-06-08 13:00:00 | AAPL | Stock | 126.82 | 126.83 | 126.46 | 126.4628 | 1637623.0 |
| 2021-06-08 13:30:00 | AAPL | Stock | 126.46 | 126.93 | 126.43 | 126.7072 | 2623721.0 |
| 2021-06-08 14:00:00 | AAPL | Stock | 126.709 | 127.0279 | 126.67 | 127.0279 | 2225761.0 |
| 2021-06-08 14:30:00 | AAPL | Stock | 127.03 | 127.3183 | 126.983 | 127.285 | 2370108.0 |
| 2021-06-08 15:00:00 | AAPL | Stock | 127.29 | 127.42 | 127.0 | 127.005 | 3210465.0 |
| 2021-06-08 15:30:00 | AAPL | Stock | 127.015 | 127.0782 | 126.68 | 126.74 | 5598829.0 |
| 2021-06-08 16:00:00 | AAPL | Stock | 126.74 | 126.85 | 126.7 | 126.75 | 5259725.0 |
| 2021-06-08 16:30:00 | AAPL | Stock | 126.75 | 126.79 | 126.54 | 126.66 | 47760.0 |
| 2021-06-08 17:00:00 | AAPL | Stock | 126.69 | 126.85 | 126.67 | 126.74 | 28119.0 |
| 2021-06-08 17:30:00 | AAPL | Stock | 126.74 | 126.74 | 126.65 | 126.66 | 12690.0 |
| 2021-06-08 18:00:00 | AAPL | Stock | 126.69 | 126.74 | 126.66 | 126.71 | 25236.0 |
| 2021-06-08 18:30:00 | AAPL | Stock | 126.71 | 126.74 | 126.67 | 126.73 | 20342.0 |
| 2021-06-08 19:00:00 | AAPL | Stock | 126.725 | 126.76 | 126.71 | 126.76 | 14326.0 |
| 2021-06-08 19:30:00 | AAPL | Stock | 126.74 | 126.74 | 126.64 | 126.64 | 20911.0 |
| 2021-06-08 04:00:00 | MSFT | Stock | 254.34 | 254.34 | 253.58 | 253.88 | 644.0 |
| 2021-06-08 04:30:00 | MSFT | Stock | 254.24 | 254.3 | 254.24 | 254.3 | 266.0 |
| 2021-06-08 05:00:00 | MSFT | Stock | 254.23 | 254.3 | 254.22 | 254.25 | 2977.0 |
| 2021-06-08 05:30:00 | MSFT | Stock | 254.22 | 254.65 | 254.22 | 254.25 | 2550.0 |
| 2021-06-08 06:00:00 | MSFT | Stock | 254.36 | 254.47 | 253.66 | 253.66 | 1502.0 |
| 2021-06-08 06:30:00 | MSFT | Stock | 253.64 | 254.36 | 253.64 | 254.2 | 901.0 |
| 2021-06-08 07:00:00 | MSFT | Stock | 254.6 | 254.87 | 254.6 | 254.8 | 4106.0 |
| 2021-06-08 07:30:00 | MSFT | Stock | 254.79 | 255.54 | 254.79 | 255.45 | 19452.0 |
| 2021-06-08 08:00:00 | MSFT | Stock | 254.3601 | 255.7 | 253.176 | 255.51 | 23292.0 |
| 2021-06-08 08:30:00 | MSFT | Stock | 255.67 | 255.68 | 255.32 | 255.48 | 10385.0 |
| 2021-06-08 09:00:00 | MSFT | Stock | 255.47 | 255.68 | 255.0 | 255.32 | 35383.0 |
| 2021-06-08 09:30:00 | MSFT | Stock | 255.3 | 256.01 | 254.31 | 254.81 | 2898024.0 |
| 2021-06-08 10:00:00 | MSFT | Stock | 254.78 | 255.32 | 254.22 | 254.2595 | 1319978.0 |
| 2021-06-08 10:30:00 | MSFT | Stock | 254.23 | 254.66 | 253.94 | 254.19 | 1155983.0 |
| 2021-06-08 11:00:00 | MSFT | Stock | 254.2 | 254.29 | 252.99 | 253.4435 | 1327695.0 |
| 2021-06-08 11:30:00 | MSFT | Stock | 253.44 | 253.66 | 252.8701 | 252.97 | 874075.0 |
| 2021-06-08 12:00:00 | MSFT | Stock | 252.95 | 253.14 | 252.7 | 253.059 | 801113.0 |
| 2021-06-08 12:30:00 | MSFT | Stock | 253.04 | 253.42 | 252.95 | 253.315 | 576622.0 |
> showing 50 of 114,425 rows — these rows as CSV