PREVIEW / stock_30min / 2021-05-26
file: by_date/stock_30min/2021/2021-05-26.parquet size: 2.2 MB rows: 109,550 symbols: 2,996
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-05-26 04:00:00 | AAPL | Stock | 127.27 | 127.27 | 127.1 | 127.1 | 8174.0 |
| 2021-05-26 04:30:00 | AAPL | Stock | 127.11 | 127.11 | 127.03 | 127.04 | 1237.0 |
| 2021-05-26 05:00:00 | AAPL | Stock | 127.07 | 127.15 | 127.07 | 127.15 | 432.0 |
| 2021-05-26 05:30:00 | AAPL | Stock | 127.23 | 127.29 | 127.04 | 127.14 | 6632.0 |
| 2021-05-26 06:00:00 | AAPL | Stock | 127.12 | 127.14 | 127.12 | 127.12 | 707.0 |
| 2021-05-26 06:30:00 | AAPL | Stock | 127.14 | 127.2 | 127.14 | 127.2 | 3652.0 |
| 2021-05-26 07:00:00 | AAPL | Stock | 127.23 | 127.44 | 127.2 | 127.35 | 50018.0 |
| 2021-05-26 07:30:00 | AAPL | Stock | 127.34 | 127.38 | 127.27 | 127.27 | 23205.0 |
| 2021-05-26 08:00:00 | AAPL | Stock | 127.3501 | 127.4434 | 127.19 | 127.4 | 127812.0 |
| 2021-05-26 08:30:00 | AAPL | Stock | 127.39 | 127.47 | 127.2 | 127.26 | 126420.0 |
| 2021-05-26 09:00:00 | AAPL | Stock | 127.29 | 127.29 | 126.67 | 126.93 | 469614.0 |
| 2021-05-26 09:30:00 | AAPL | Stock | 126.93 | 127.39 | 126.79 | 126.93 | 6678128.0 |
| 2021-05-26 10:00:00 | AAPL | Stock | 126.93 | 127.06 | 126.64 | 127.046 | 4929180.0 |
| 2021-05-26 10:30:00 | AAPL | Stock | 127.045 | 127.18 | 126.93 | 127.02 | 4432615.0 |
| 2021-05-26 11:00:00 | AAPL | Stock | 127.02 | 127.26 | 126.975 | 126.985 | 2634162.0 |
| 2021-05-26 11:30:00 | AAPL | Stock | 126.98 | 127.0 | 126.74 | 126.955 | 2628780.0 |
| 2021-05-26 12:00:00 | AAPL | Stock | 126.96 | 127.1 | 126.9 | 126.93 | 2268311.0 |
| 2021-05-26 12:30:00 | AAPL | Stock | 126.93 | 126.97 | 126.71 | 126.71 | 2284384.0 |
| 2021-05-26 13:00:00 | AAPL | Stock | 126.71 | 126.92 | 126.61 | 126.75 | 2509180.0 |
| 2021-05-26 13:30:00 | AAPL | Stock | 126.74 | 126.78 | 126.42 | 126.565 | 2612932.0 |
| 2021-05-26 14:00:00 | AAPL | Stock | 126.56 | 126.8 | 126.485 | 126.795 | 2526915.0 |
| 2021-05-26 14:30:00 | AAPL | Stock | 126.795 | 126.855 | 126.63 | 126.785 | 2185338.0 |
| 2021-05-26 15:00:00 | AAPL | Stock | 126.78 | 126.81 | 126.65 | 126.765 | 2479683.0 |
| 2021-05-26 15:30:00 | AAPL | Stock | 126.77 | 126.87 | 126.6298 | 126.85 | 5092978.0 |
| 2021-05-26 16:00:00 | AAPL | Stock | 126.85 | 126.87 | 126.71 | 126.78 | 5454585.0 |
| 2021-05-26 16:30:00 | AAPL | Stock | 126.78 | 126.85 | 126.71 | 126.82 | 28278.0 |
| 2021-05-26 17:00:00 | AAPL | Stock | 126.82 | 126.83 | 126.75 | 126.7601 | 14696.0 |
| 2021-05-26 17:30:00 | AAPL | Stock | 126.77 | 126.8 | 126.75 | 126.8 | 14345.0 |
| 2021-05-26 18:00:00 | AAPL | Stock | 126.8 | 126.85 | 126.78 | 126.82 | 23353.0 |
| 2021-05-26 18:30:00 | AAPL | Stock | 126.82 | 126.82 | 126.76 | 126.8 | 23918.0 |
| 2021-05-26 19:00:00 | AAPL | Stock | 126.8 | 126.8 | 126.76 | 126.8 | 11183.0 |
| 2021-05-26 19:30:00 | AAPL | Stock | 126.8 | 126.8 | 126.7 | 126.7 | 20048.0 |
| 2021-05-26 05:00:00 | MSFT | Stock | 252.27 | 252.3 | 252.27 | 252.3 | 2427.0 |
| 2021-05-26 05:30:00 | MSFT | Stock | 252.3 | 252.3 | 251.98 | 251.98 | 749.0 |
| 2021-05-26 06:00:00 | MSFT | Stock | 252.14 | 252.14 | 252.14 | 252.14 | 225.0 |
| 2021-05-26 06:30:00 | MSFT | Stock | 252.19 | 252.24 | 252.19 | 252.24 | 663.0 |
| 2021-05-26 07:00:00 | MSFT | Stock | 252.28 | 252.87 | 252.25 | 252.86 | 8015.0 |
| 2021-05-26 07:30:00 | MSFT | Stock | 252.8 | 252.8 | 252.35 | 252.42 | 7188.0 |
| 2021-05-26 08:00:00 | MSFT | Stock | 252.3498 | 252.86 | 251.091 | 252.67 | 9795.0 |
| 2021-05-26 08:30:00 | MSFT | Stock | 252.71 | 252.8 | 252.05 | 252.31 | 15534.0 |
| 2021-05-26 09:00:00 | MSFT | Stock | 252.26 | 252.26 | 251.0 | 251.27 | 514234.0 |
| 2021-05-26 09:30:00 | MSFT | Stock | 251.28 | 252.94 | 251.03 | 251.31 | 1687733.0 |
| 2021-05-26 10:00:00 | MSFT | Stock | 251.305 | 251.76 | 250.875 | 251.67 | 996749.0 |
| 2021-05-26 10:30:00 | MSFT | Stock | 251.68 | 251.79 | 251.5001 | 251.5392 | 656128.0 |
| 2021-05-26 11:00:00 | MSFT | Stock | 251.56 | 251.77 | 251.31 | 251.46 | 705671.0 |
| 2021-05-26 11:30:00 | MSFT | Stock | 251.46 | 251.46 | 251.05 | 251.35 | 532726.0 |
| 2021-05-26 12:00:00 | MSFT | Stock | 251.35 | 251.64 | 251.27 | 251.3 | 437910.0 |
| 2021-05-26 12:30:00 | MSFT | Stock | 251.31 | 251.59 | 251.25 | 251.3709 | 446752.0 |
| 2021-05-26 13:00:00 | MSFT | Stock | 251.37 | 251.48 | 250.97 | 251.13 | 558388.0 |
| 2021-05-26 13:30:00 | MSFT | Stock | 251.12 | 251.23 | 250.81 | 250.9803 | 592715.0 |
> showing 50 of 109,550 rows — these rows as CSV