PREVIEW / stock_30min / 2021-02-22
file: by_date/stock_30min/2021/2021-02-22.parquet size: 2.4 MB rows: 125,651 symbols: 2,838
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-02-22 04:00:00 | AAPL | Stock | 127.8 | 127.97 | 127.29 | 127.52 | 34996.0 |
| 2021-02-22 04:30:00 | AAPL | Stock | 127.4 | 127.79 | 127.16 | 127.75 | 13990.0 |
| 2021-02-22 05:00:00 | AAPL | Stock | 127.75 | 127.94 | 127.71 | 127.88 | 8951.0 |
| 2021-02-22 05:30:00 | AAPL | Stock | 127.84 | 128.0 | 127.57 | 127.57 | 20872.0 |
| 2021-02-22 06:00:00 | AAPL | Stock | 127.61 | 127.78 | 127.34 | 127.4 | 17606.0 |
| 2021-02-22 06:30:00 | AAPL | Stock | 127.46 | 127.55 | 127.0 | 127.55 | 42333.0 |
| 2021-02-22 07:00:00 | AAPL | Stock | 127.5 | 128.06 | 127.5 | 127.78 | 189994.0 |
| 2021-02-22 07:30:00 | AAPL | Stock | 127.8 | 127.9 | 127.33 | 127.9 | 184428.0 |
| 2021-02-22 08:00:00 | AAPL | Stock | 127.88 | 130.194 | 127.33 | 127.52 | 333530.0 |
| 2021-02-22 08:30:00 | AAPL | Stock | 127.52 | 128.09 | 127.52 | 127.88 | 227930.0 |
| 2021-02-22 09:00:00 | AAPL | Stock | 127.87 | 128.12 | 127.46 | 128.05 | 404990.0 |
| 2021-02-22 09:30:00 | AAPL | Stock | 128.03 | 129.72 | 127.82 | 128.485 | 11634867.0 |
| 2021-02-22 10:00:00 | AAPL | Stock | 128.48 | 128.85 | 126.82 | 127.13 | 10073993.0 |
| 2021-02-22 10:30:00 | AAPL | Stock | 127.11 | 127.25 | 125.6 | 125.926 | 11477236.0 |
| 2021-02-22 11:00:00 | AAPL | Stock | 125.92 | 126.98 | 125.79 | 126.86 | 6589550.0 |
| 2021-02-22 11:30:00 | AAPL | Stock | 126.86 | 127.25 | 126.63 | 126.905 | 4423170.0 |
| 2021-02-22 12:00:00 | AAPL | Stock | 126.9 | 126.9 | 126.5 | 126.718 | 3384292.0 |
| 2021-02-22 12:30:00 | AAPL | Stock | 126.715 | 127.257 | 126.64 | 127.257 | 3217727.0 |
| 2021-02-22 13:00:00 | AAPL | Stock | 127.25 | 127.32 | 126.94 | 127.26 | 2599786.0 |
| 2021-02-22 13:30:00 | AAPL | Stock | 127.25 | 127.96 | 127.241 | 127.76 | 3619147.0 |
| 2021-02-22 14:00:00 | AAPL | Stock | 127.77 | 127.82 | 127.486 | 127.665 | 2753248.0 |
| 2021-02-22 14:30:00 | AAPL | Stock | 127.66 | 127.71 | 127.19 | 127.29 | 2992159.0 |
| 2021-02-22 15:00:00 | AAPL | Stock | 127.285 | 127.295 | 126.461 | 126.489 | 5119302.0 |
| 2021-02-22 15:30:00 | AAPL | Stock | 126.485 | 126.75 | 126.0 | 126.01 | 11814814.0 |
| 2021-02-22 16:00:00 | AAPL | Stock | 126.01 | 126.3 | 125.75 | 125.8 | 7538692.0 |
| 2021-02-22 16:30:00 | AAPL | Stock | 125.78 | 126.15 | 125.77 | 126.1 | 140149.0 |
| 2021-02-22 17:00:00 | AAPL | Stock | 126.1 | 126.14 | 126.02 | 126.06 | 71513.0 |
| 2021-02-22 17:30:00 | AAPL | Stock | 126.09 | 126.1 | 126.0 | 126.05 | 50607.0 |
| 2021-02-22 18:00:00 | AAPL | Stock | 126.05 | 126.2 | 126.04 | 126.19 | 51453.0 |
| 2021-02-22 18:30:00 | AAPL | Stock | 126.19 | 126.19 | 126.03 | 126.11 | 58785.0 |
| 2021-02-22 19:00:00 | AAPL | Stock | 126.11 | 126.16 | 125.79 | 125.94 | 86471.0 |
| 2021-02-22 19:30:00 | AAPL | Stock | 125.95 | 125.98 | 125.79 | 125.82 | 76813.0 |
| 2021-02-22 04:00:00 | MSFT | Stock | 237.99 | 237.99 | 236.49 | 237.01 | 14382.0 |
| 2021-02-22 04:30:00 | MSFT | Stock | 236.8 | 237.5 | 236.8 | 237.5 | 1228.0 |
| 2021-02-22 05:00:00 | MSFT | Stock | 237.39 | 237.52 | 237.39 | 237.51 | 713.0 |
| 2021-02-22 05:30:00 | MSFT | Stock | 237.65 | 237.65 | 237.65 | 237.65 | 210.0 |
| 2021-02-22 06:00:00 | MSFT | Stock | 237.1 | 237.2 | 237.0 | 237.0 | 2809.0 |
| 2021-02-22 06:30:00 | MSFT | Stock | 236.7 | 237.21 | 236.61 | 236.99 | 1820.0 |
| 2021-02-22 07:00:00 | MSFT | Stock | 237.0 | 237.56 | 237.0 | 237.33 | 17041.0 |
| 2021-02-22 07:30:00 | MSFT | Stock | 237.33 | 237.35 | 236.59 | 237.0 | 8267.0 |
| 2021-02-22 08:00:00 | MSFT | Stock | 237.57 | 237.57 | 236.75 | 237.4 | 34048.0 |
| 2021-02-22 08:30:00 | MSFT | Stock | 237.37 | 237.94 | 237.36 | 237.7 | 21192.0 |
| 2021-02-22 09:00:00 | MSFT | Stock | 237.501 | 237.85 | 236.886 | 237.44 | 71865.0 |
| 2021-02-22 09:30:00 | MSFT | Stock | 237.42 | 237.93 | 236.236 | 236.44 | 2938929.0 |
| 2021-02-22 10:00:00 | MSFT | Stock | 236.42 | 236.55 | 233.81 | 234.39 | 3654957.0 |
| 2021-02-22 10:30:00 | MSFT | Stock | 234.38 | 234.8 | 233.99 | 234.21 | 2194940.0 |
| 2021-02-22 11:00:00 | MSFT | Stock | 234.19 | 235.028 | 233.32 | 234.163 | 2147275.0 |
| 2021-02-22 11:30:00 | MSFT | Stock | 234.18 | 234.3 | 232.54 | 232.73 | 2226171.0 |
| 2021-02-22 12:00:00 | MSFT | Stock | 232.75 | 233.26 | 232.4 | 233.16 | 1511307.0 |
| 2021-02-22 12:30:00 | MSFT | Stock | 233.18 | 234.57 | 233.09 | 234.181 | 1147843.0 |
> showing 50 of 125,651 rows — these rows as CSV