PREVIEW / stock_30min / 2021-05-10
file: by_date/stock_30min/2021/2021-05-10.parquet size: 2.3 MB rows: 113,840 symbols: 2,983
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-10 04:00:00 | AAPL | Stock | 129.98 | 130.18 | 129.8 | 129.99 | 13528.0 |
| 2021-05-10 04:30:00 | AAPL | Stock | 129.97 | 129.97 | 129.7 | 129.7 | 3772.0 |
| 2021-05-10 05:00:00 | AAPL | Stock | 129.6 | 129.8 | 129.6 | 129.79 | 2985.0 |
| 2021-05-10 05:30:00 | AAPL | Stock | 129.7 | 129.9 | 129.69 | 129.9 | 3578.0 |
| 2021-05-10 06:00:00 | AAPL | Stock | 129.85 | 130.11 | 129.85 | 130.01 | 4921.0 |
| 2021-05-10 06:30:00 | AAPL | Stock | 130.05 | 130.16 | 129.96 | 130.16 | 4479.0 |
| 2021-05-10 07:00:00 | AAPL | Stock | 130.14 | 130.17 | 129.91 | 130.0 | 62828.0 |
| 2021-05-10 07:30:00 | AAPL | Stock | 129.98 | 130.01 | 129.7 | 129.78 | 37258.0 |
| 2021-05-10 08:00:00 | AAPL | Stock | 129.9599 | 130.18 | 129.7 | 129.83 | 169229.0 |
| 2021-05-10 08:30:00 | AAPL | Stock | 129.82 | 130.0 | 129.82 | 129.86 | 61366.0 |
| 2021-05-10 09:00:00 | AAPL | Stock | 129.86 | 130.04 | 129.25 | 129.4 | 261272.0 |
| 2021-05-10 09:30:00 | AAPL | Stock | 129.4 | 129.54 | 128.174 | 128.45 | 10439955.0 |
| 2021-05-10 10:00:00 | AAPL | Stock | 128.46 | 128.65 | 128.06 | 128.385 | 6079619.0 |
| 2021-05-10 10:30:00 | AAPL | Stock | 128.38 | 128.59 | 127.865 | 128.185 | 5627065.0 |
| 2021-05-10 11:00:00 | AAPL | Stock | 128.19 | 128.48 | 127.89 | 128.315 | 4334956.0 |
| 2021-05-10 11:30:00 | AAPL | Stock | 128.315 | 128.5471 | 128.11 | 128.5339 | 3217212.0 |
| 2021-05-10 12:00:00 | AAPL | Stock | 128.54 | 128.705 | 128.37 | 128.4 | 2861050.0 |
| 2021-05-10 12:30:00 | AAPL | Stock | 128.4018 | 128.475 | 128.16 | 128.32 | 2755306.0 |
| 2021-05-10 13:00:00 | AAPL | Stock | 128.32 | 128.5 | 128.21 | 128.2685 | 2203947.0 |
| 2021-05-10 13:30:00 | AAPL | Stock | 128.26 | 128.29 | 127.97 | 128.055 | 2978102.0 |
| 2021-05-10 14:00:00 | AAPL | Stock | 128.06 | 128.11 | 127.09 | 127.1915 | 5620586.0 |
| 2021-05-10 14:30:00 | AAPL | Stock | 127.19 | 127.345 | 126.82 | 127.06 | 5533575.0 |
| 2021-05-10 15:00:00 | AAPL | Stock | 127.065 | 127.33 | 127.01 | 127.19 | 4057647.0 |
| 2021-05-10 15:30:00 | AAPL | Stock | 127.195 | 127.5 | 126.81 | 126.86 | 10084618.0 |
| 2021-05-10 16:00:00 | AAPL | Stock | 126.85 | 127.05 | 126.65 | 126.7 | 9329743.0 |
| 2021-05-10 16:30:00 | AAPL | Stock | 126.7 | 127.9881 | 126.324 | 126.45 | 98514.0 |
| 2021-05-10 17:00:00 | AAPL | Stock | 126.5 | 126.61 | 126.31 | 126.44 | 79279.0 |
| 2021-05-10 17:30:00 | AAPL | Stock | 126.46 | 126.5 | 126.38 | 126.46 | 66060.0 |
| 2021-05-10 18:00:00 | AAPL | Stock | 126.46 | 126.53 | 126.31 | 126.3499 | 79357.0 |
| 2021-05-10 18:30:00 | AAPL | Stock | 126.33 | 126.48 | 126.31 | 126.42 | 63322.0 |
| 2021-05-10 19:00:00 | AAPL | Stock | 126.41 | 126.47 | 126.32 | 126.35 | 59841.0 |
| 2021-05-10 19:30:00 | AAPL | Stock | 126.35 | 126.45 | 126.3 | 126.32 | 69010.0 |
| 2021-05-10 04:00:00 | MSFT | Stock | 251.83 | 252.03 | 251.79 | 251.92 | 4652.0 |
| 2021-05-10 04:30:00 | MSFT | Stock | 251.91 | 251.91 | 251.81 | 251.87 | 731.0 |
| 2021-05-10 05:00:00 | MSFT | Stock | 251.76 | 251.98 | 251.76 | 251.9 | 860.0 |
| 2021-05-10 05:30:00 | MSFT | Stock | 251.81 | 251.81 | 251.0 | 251.0 | 8753.0 |
| 2021-05-10 06:00:00 | MSFT | Stock | 251.05 | 251.5 | 251.05 | 251.5 | 2116.0 |
| 2021-05-10 06:30:00 | MSFT | Stock | 251.42 | 251.45 | 251.03 | 251.23 | 3053.0 |
| 2021-05-10 07:00:00 | MSFT | Stock | 251.45 | 251.7 | 251.08 | 251.08 | 7588.0 |
| 2021-05-10 07:30:00 | MSFT | Stock | 251.06 | 251.06 | 250.59 | 250.87 | 11379.0 |
| 2021-05-10 08:00:00 | MSFT | Stock | 251.5001 | 251.9 | 250.76 | 251.45 | 24956.0 |
| 2021-05-10 08:30:00 | MSFT | Stock | 251.47 | 251.76 | 251.41 | 251.45 | 14718.0 |
| 2021-05-10 09:00:00 | MSFT | Stock | 251.44 | 251.44 | 250.52 | 250.75 | 29581.0 |
| 2021-05-10 09:30:00 | MSFT | Stock | 250.87 | 251.55 | 249.34 | 251.38 | 2240355.0 |
| 2021-05-10 10:00:00 | MSFT | Stock | 251.41 | 251.73 | 250.77 | 250.78 | 1016604.0 |
| 2021-05-10 10:30:00 | MSFT | Stock | 250.77 | 250.89 | 250.01 | 250.31 | 876678.0 |
| 2021-05-10 11:00:00 | MSFT | Stock | 250.33 | 250.74 | 249.83 | 250.35 | 829401.0 |
| 2021-05-10 11:30:00 | MSFT | Stock | 250.37 | 250.53 | 249.95 | 250.3529 | 901205.0 |
| 2021-05-10 12:00:00 | MSFT | Stock | 250.36 | 251.08 | 250.27 | 250.825 | 554531.0 |
| 2021-05-10 12:30:00 | MSFT | Stock | 250.84 | 250.84 | 249.916 | 249.96 | 713944.0 |
> showing 50 of 113,840 rows — these rows as CSV