PREVIEW / stock_30min / 2021-05-06
file: by_date/stock_30min/2021/2021-05-06.parquet size: 2.2 MB rows: 111,639 symbols: 2,984
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-06 04:00:00 | AAPL | Stock | 128.24 | 128.6 | 128.24 | 128.56 | 7885.0 |
| 2021-05-06 04:30:00 | AAPL | Stock | 128.55 | 128.55 | 128.25 | 128.31 | 5003.0 |
| 2021-05-06 05:00:00 | AAPL | Stock | 128.39 | 128.51 | 128.05 | 128.22 | 9560.0 |
| 2021-05-06 05:30:00 | AAPL | Stock | 128.22 | 128.22 | 127.98 | 128.16 | 8198.0 |
| 2021-05-06 06:00:00 | AAPL | Stock | 128.2 | 128.35 | 128.2 | 128.35 | 6500.0 |
| 2021-05-06 06:30:00 | AAPL | Stock | 128.34 | 128.44 | 128.03 | 128.13 | 4622.0 |
| 2021-05-06 07:00:00 | AAPL | Stock | 128.24 | 128.34 | 127.96 | 128.2 | 67584.0 |
| 2021-05-06 07:30:00 | AAPL | Stock | 128.21 | 128.23 | 128.07 | 128.11 | 19017.0 |
| 2021-05-06 08:00:00 | AAPL | Stock | 128.1499 | 128.31 | 127.78 | 127.94 | 195467.0 |
| 2021-05-06 08:30:00 | AAPL | Stock | 127.94 | 128.09 | 127.7 | 127.91 | 123567.0 |
| 2021-05-06 09:00:00 | AAPL | Stock | 127.91 | 128.01 | 127.75 | 127.9 | 189577.0 |
| 2021-05-06 09:30:00 | AAPL | Stock | 127.9 | 128.55 | 127.13 | 127.585 | 9783705.0 |
| 2021-05-06 10:00:00 | AAPL | Stock | 127.585 | 128.02 | 127.32 | 127.83 | 6276255.0 |
| 2021-05-06 10:30:00 | AAPL | Stock | 127.83 | 128.51 | 127.77 | 128.13 | 5355670.0 |
| 2021-05-06 11:00:00 | AAPL | Stock | 128.135 | 128.515 | 127.62 | 128.4701 | 4580639.0 |
| 2021-05-06 11:30:00 | AAPL | Stock | 128.48 | 129.06 | 128.36 | 128.725 | 5358594.0 |
| 2021-05-06 12:00:00 | AAPL | Stock | 128.73 | 129.188 | 128.149 | 129.14 | 3691202.0 |
| 2021-05-06 12:30:00 | AAPL | Stock | 129.1359 | 129.23 | 128.8 | 128.8804 | 3397381.0 |
| 2021-05-06 13:00:00 | AAPL | Stock | 128.88 | 129.01 | 128.5584 | 128.73 | 2291669.0 |
| 2021-05-06 13:30:00 | AAPL | Stock | 128.73 | 128.9799 | 128.6391 | 128.725 | 2239679.0 |
| 2021-05-06 14:00:00 | AAPL | Stock | 128.72 | 129.04 | 128.46 | 128.52 | 3371953.0 |
| 2021-05-06 14:30:00 | AAPL | Stock | 128.515 | 128.88 | 128.325 | 128.6799 | 3419116.0 |
| 2021-05-06 15:00:00 | AAPL | Stock | 128.68 | 129.19 | 128.6 | 129.1299 | 3433090.0 |
| 2021-05-06 15:30:00 | AAPL | Stock | 129.13 | 129.75 | 128.98 | 129.73 | 8360937.0 |
| 2021-05-06 16:00:00 | AAPL | Stock | 129.655 | 129.78 | 129.58 | 129.66 | 6680681.0 |
| 2021-05-06 16:30:00 | AAPL | Stock | 129.68 | 129.69 | 129.58 | 129.65 | 34540.0 |
| 2021-05-06 17:00:00 | AAPL | Stock | 129.66 | 129.74 | 129.66 | 129.72 | 24856.0 |
| 2021-05-06 17:30:00 | AAPL | Stock | 129.71 | 130.23 | 129.71 | 130.18 | 97846.0 |
| 2021-05-06 18:00:00 | AAPL | Stock | 130.18 | 130.19 | 130.0 | 130.03 | 52766.0 |
| 2021-05-06 18:30:00 | AAPL | Stock | 130.02 | 130.1 | 129.91 | 130.02 | 31020.0 |
| 2021-05-06 19:00:00 | AAPL | Stock | 130.01 | 130.09 | 129.96 | 130.0 | 21862.0 |
| 2021-05-06 19:30:00 | AAPL | Stock | 129.98 | 130.05 | 129.89 | 130.05 | 69469.0 |
| 2021-05-06 04:00:00 | MSFT | Stock | 246.82 | 247.39 | 246.82 | 247.39 | 2307.0 |
| 2021-05-06 04:30:00 | MSFT | Stock | 247.44 | 247.44 | 247.14 | 247.14 | 317.0 |
| 2021-05-06 05:00:00 | MSFT | Stock | 247.01 | 247.01 | 246.79 | 246.79 | 679.0 |
| 2021-05-06 05:30:00 | MSFT | Stock | 246.8 | 246.8 | 246.7 | 246.7 | 691.0 |
| 2021-05-06 06:00:00 | MSFT | Stock | 246.7 | 246.7 | 246.7 | 246.7 | 125.0 |
| 2021-05-06 06:30:00 | MSFT | Stock | 247.2 | 247.2 | 246.4 | 246.4 | 2591.0 |
| 2021-05-06 07:00:00 | MSFT | Stock | 246.54 | 246.8 | 246.08 | 246.57 | 8935.0 |
| 2021-05-06 07:30:00 | MSFT | Stock | 246.45 | 246.5 | 246.4 | 246.5 | 1195.0 |
| 2021-05-06 08:00:00 | MSFT | Stock | 246.94 | 247.086 | 246.0 | 246.16 | 11423.0 |
| 2021-05-06 08:30:00 | MSFT | Stock | 246.08 | 246.35 | 245.75 | 246.0 | 8522.0 |
| 2021-05-06 09:00:00 | MSFT | Stock | 246.1 | 246.71 | 245.9 | 246.52 | 10489.0 |
| 2021-05-06 09:30:00 | MSFT | Stock | 246.46 | 246.629 | 244.69 | 245.41 | 2101667.0 |
| 2021-05-06 10:00:00 | MSFT | Stock | 245.41 | 246.07 | 244.9 | 245.4273 | 1319727.0 |
| 2021-05-06 10:30:00 | MSFT | Stock | 245.42 | 246.97 | 245.3301 | 246.4 | 1138155.0 |
| 2021-05-06 11:00:00 | MSFT | Stock | 246.42 | 247.26 | 245.72 | 247.17 | 1101186.0 |
| 2021-05-06 11:30:00 | MSFT | Stock | 247.2 | 248.4701 | 246.99 | 247.81 | 1409128.0 |
| 2021-05-06 12:00:00 | MSFT | Stock | 247.83 | 248.16 | 246.4249 | 248.1099 | 998320.0 |
| 2021-05-06 12:30:00 | MSFT | Stock | 248.0901 | 248.35 | 247.81 | 247.85 | 538642.0 |
> showing 50 of 111,639 rows — these rows as CSV