PREVIEW / stock_30min / 2021-05-25
file: by_date/stock_30min/2021/2021-05-25.parquet size: 2.1 MB rows: 108,825 symbols: 2,977
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-25 04:00:00 | AAPL | Stock | 127.99 | 128.0 | 127.76 | 127.96 | 14375.0 |
| 2021-05-25 04:30:00 | AAPL | Stock | 127.94 | 127.94 | 127.87 | 127.87 | 5249.0 |
| 2021-05-25 05:00:00 | AAPL | Stock | 127.91 | 127.91 | 127.83 | 127.89 | 6554.0 |
| 2021-05-25 05:30:00 | AAPL | Stock | 127.89 | 127.89 | 127.83 | 127.85 | 5411.0 |
| 2021-05-25 06:00:00 | AAPL | Stock | 127.88 | 127.9 | 127.8 | 127.8 | 3604.0 |
| 2021-05-25 06:30:00 | AAPL | Stock | 127.63 | 127.69 | 127.63 | 127.69 | 209.0 |
| 2021-05-25 07:00:00 | AAPL | Stock | 127.65 | 127.89 | 127.6 | 127.89 | 36337.0 |
| 2021-05-25 07:30:00 | AAPL | Stock | 127.91 | 127.96 | 127.85 | 127.89 | 29111.0 |
| 2021-05-25 08:00:00 | AAPL | Stock | 127.6701 | 127.97 | 127.58 | 127.78 | 165816.0 |
| 2021-05-25 08:30:00 | AAPL | Stock | 127.76 | 127.88 | 127.1 | 127.66 | 234267.0 |
| 2021-05-25 09:00:00 | AAPL | Stock | 127.64 | 127.97 | 127.63 | 127.84 | 203438.0 |
| 2021-05-25 09:30:00 | AAPL | Stock | 127.84 | 128.32 | 126.89 | 126.945 | 10560718.0 |
| 2021-05-25 10:00:00 | AAPL | Stock | 126.945 | 127.28 | 126.86 | 127.165 | 5620237.0 |
| 2021-05-25 10:30:00 | AAPL | Stock | 127.165 | 127.2 | 126.76 | 127.125 | 4682985.0 |
| 2021-05-25 11:00:00 | AAPL | Stock | 127.13 | 127.17 | 126.73 | 126.83 | 3789073.0 |
| 2021-05-25 11:30:00 | AAPL | Stock | 126.83 | 126.93 | 126.665 | 126.8 | 3084042.0 |
| 2021-05-25 12:00:00 | AAPL | Stock | 126.8 | 127.04 | 126.72 | 126.99 | 2416602.0 |
| 2021-05-25 12:30:00 | AAPL | Stock | 126.99 | 127.07 | 126.74 | 126.82 | 1892554.0 |
| 2021-05-25 13:00:00 | AAPL | Stock | 126.825 | 126.99 | 126.61 | 126.96 | 2394413.0 |
| 2021-05-25 13:30:00 | AAPL | Stock | 126.96 | 127.0 | 126.8 | 126.88 | 1883186.0 |
| 2021-05-25 14:00:00 | AAPL | Stock | 126.885 | 126.92 | 126.64 | 126.745 | 2028388.0 |
| 2021-05-25 14:30:00 | AAPL | Stock | 126.7402 | 126.81 | 126.56 | 126.66 | 2236282.0 |
| 2021-05-25 15:00:00 | AAPL | Stock | 126.655 | 126.71 | 126.32 | 126.675 | 3166527.0 |
| 2021-05-25 15:30:00 | AAPL | Stock | 126.675 | 126.96 | 126.52 | 126.94 | 5706265.0 |
| 2021-05-25 16:00:00 | AAPL | Stock | 126.9 | 126.98 | 126.87 | 126.96 | 5499032.0 |
| 2021-05-25 16:30:00 | AAPL | Stock | 126.95 | 126.96 | 126.9 | 126.92 | 24775.0 |
| 2021-05-25 17:00:00 | AAPL | Stock | 126.94 | 126.94 | 126.92 | 126.9399 | 9507.0 |
| 2021-05-25 17:30:00 | AAPL | Stock | 126.93 | 127.15 | 126.91 | 126.94 | 41429.0 |
| 2021-05-25 18:00:00 | AAPL | Stock | 126.95 | 126.97 | 126.65 | 126.95 | 50456.0 |
| 2021-05-25 18:30:00 | AAPL | Stock | 126.95 | 127.15 | 126.92 | 127.1 | 23796.0 |
| 2021-05-25 19:00:00 | AAPL | Stock | 127.1 | 127.18 | 127.05 | 127.13 | 20839.0 |
| 2021-05-25 19:30:00 | AAPL | Stock | 127.14 | 127.19 | 127.06 | 127.11 | 37111.0 |
| 2021-05-25 04:00:00 | MSFT | Stock | 252.0 | 252.0 | 251.76 | 251.77 | 725.0 |
| 2021-05-25 04:30:00 | MSFT | Stock | 251.81 | 251.81 | 251.5 | 251.5 | 2547.0 |
| 2021-05-25 05:00:00 | MSFT | Stock | 251.8 | 251.8 | 251.3 | 251.72 | 2072.0 |
| 2021-05-25 05:30:00 | MSFT | Stock | 251.75 | 252.1 | 251.75 | 252.1 | 2408.0 |
| 2021-05-25 06:00:00 | MSFT | Stock | 252.2 | 252.2 | 251.92 | 251.92 | 1301.0 |
| 2021-05-25 06:30:00 | MSFT | Stock | 251.89 | 251.89 | 251.89 | 251.89 | 1222.0 |
| 2021-05-25 07:00:00 | MSFT | Stock | 251.62 | 252.33 | 251.56 | 252.3 | 7636.0 |
| 2021-05-25 07:30:00 | MSFT | Stock | 252.29 | 252.48 | 252.16 | 252.48 | 2943.0 |
| 2021-05-25 08:00:00 | MSFT | Stock | 252.1201 | 252.4957 | 250.154 | 252.3 | 15349.0 |
| 2021-05-25 08:30:00 | MSFT | Stock | 252.3 | 252.35 | 251.63 | 251.97 | 6402.0 |
| 2021-05-25 09:00:00 | MSFT | Stock | 251.99 | 252.29 | 251.55 | 251.65 | 17678.0 |
| 2021-05-25 09:30:00 | MSFT | Stock | 251.65 | 252.75 | 250.82 | 251.38 | 1888723.0 |
| 2021-05-25 10:00:00 | MSFT | Stock | 251.4 | 251.8 | 250.89 | 251.18 | 778658.0 |
| 2021-05-25 10:30:00 | MSFT | Stock | 251.18 | 251.8516 | 250.82 | 251.69 | 761788.0 |
| 2021-05-25 11:00:00 | MSFT | Stock | 251.71 | 252.01 | 251.34 | 251.54 | 803257.0 |
| 2021-05-25 11:30:00 | MSFT | Stock | 251.54 | 251.71 | 251.13 | 251.7 | 746013.0 |
| 2021-05-25 12:00:00 | MSFT | Stock | 251.72 | 251.92 | 251.53 | 251.75 | 541431.0 |
| 2021-05-25 12:30:00 | MSFT | Stock | 251.78 | 251.94 | 251.31 | 251.33 | 499883.0 |
> showing 50 of 108,825 rows — these rows as CSV