PREVIEW / stock_30min / 2021-12-02
file: by_date/stock_30min/2021/2021-12-02.parquet size: 2.3 MB rows: 114,587 symbols: 2,671
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-12-02 04:00:00 | AAPL | Stock | 163.2 | 163.45 | 162.33 | 163.13 | 163248.0 |
| 2021-12-02 04:30:00 | AAPL | Stock | 163.04 | 163.09 | 161.61 | 161.71 | 84510.0 |
| 2021-12-02 05:00:00 | AAPL | Stock | 161.71 | 161.88 | 161.0 | 161.68 | 95848.0 |
| 2021-12-02 05:30:00 | AAPL | Stock | 161.6 | 162.26 | 161.2 | 162.1 | 74104.0 |
| 2021-12-02 06:00:00 | AAPL | Stock | 162.06 | 162.48 | 161.43 | 161.43 | 88764.0 |
| 2021-12-02 06:30:00 | AAPL | Stock | 161.44 | 161.6 | 161.22 | 161.51 | 102586.0 |
| 2021-12-02 07:00:00 | AAPL | Stock | 161.54 | 161.57 | 159.7 | 160.03 | 464029.0 |
| 2021-12-02 07:30:00 | AAPL | Stock | 160.02 | 160.16 | 159.4 | 159.96 | 321194.0 |
| 2021-12-02 08:00:00 | AAPL | Stock | 159.7801 | 164.359 | 159.44 | 159.69 | 798117.0 |
| 2021-12-02 08:30:00 | AAPL | Stock | 159.67 | 159.78 | 158.5 | 159.73 | 897116.0 |
| 2021-12-02 09:00:00 | AAPL | Stock | 159.72 | 160.16 | 158.45 | 158.73 | 1073371.0 |
| 2021-12-02 09:30:00 | AAPL | Stock | 158.74 | 161.63 | 157.8 | 161.369 | 22251029.0 |
| 2021-12-02 10:00:00 | AAPL | Stock | 161.37 | 161.37 | 159.48 | 160.1401 | 10026230.0 |
| 2021-12-02 10:30:00 | AAPL | Stock | 160.15 | 160.7399 | 159.03 | 160.4901 | 8200186.0 |
| 2021-12-02 11:00:00 | AAPL | Stock | 160.49 | 162.13 | 160.21 | 161.965 | 8611751.0 |
| 2021-12-02 11:30:00 | AAPL | Stock | 161.97 | 162.48 | 160.95 | 162.375 | 7244317.0 |
| 2021-12-02 12:00:00 | AAPL | Stock | 162.37 | 163.7 | 162.0801 | 163.43 | 7328890.0 |
| 2021-12-02 12:30:00 | AAPL | Stock | 163.425 | 163.65 | 162.68 | 163.09 | 6565838.0 |
| 2021-12-02 13:00:00 | AAPL | Stock | 163.11 | 163.54 | 162.56 | 162.84 | 5434415.0 |
| 2021-12-02 13:30:00 | AAPL | Stock | 162.85 | 163.45 | 162.54 | 163.4198 | 4161443.0 |
| 2021-12-02 14:00:00 | AAPL | Stock | 163.42 | 163.98 | 163.22 | 163.78 | 5940984.0 |
| 2021-12-02 14:30:00 | AAPL | Stock | 163.77 | 163.9699 | 162.93 | 163.42 | 4635520.0 |
| 2021-12-02 15:00:00 | AAPL | Stock | 163.42 | 163.89 | 163.31 | 163.46 | 4469632.0 |
| 2021-12-02 15:30:00 | AAPL | Stock | 163.45 | 164.2 | 163.13 | 163.79 | 9397623.0 |
| 2021-12-02 16:00:00 | AAPL | Stock | 163.76 | 164.05 | 163.44 | 163.95 | 9190034.0 |
| 2021-12-02 16:30:00 | AAPL | Stock | 163.95 | 164.18 | 163.76 | 163.85 | 47089.0 |
| 2021-12-02 17:00:00 | AAPL | Stock | 163.8799 | 164.1 | 163.85 | 163.9 | 21496.0 |
| 2021-12-02 17:30:00 | AAPL | Stock | 163.86 | 164.0 | 163.8 | 163.95 | 16116.0 |
| 2021-12-02 18:00:00 | AAPL | Stock | 163.86 | 163.92 | 163.2 | 163.31 | 47738.0 |
| 2021-12-02 18:30:00 | AAPL | Stock | 163.31 | 163.32 | 162.67 | 162.77 | 51501.0 |
| 2021-12-02 19:00:00 | AAPL | Stock | 162.68 | 162.76 | 162.12 | 162.5 | 65318.0 |
| 2021-12-02 19:30:00 | AAPL | Stock | 162.5 | 162.98 | 162.2 | 162.28 | 75146.0 |
| 2021-12-02 04:00:00 | MSFT | Stock | 331.95 | 333.29 | 331.95 | 332.42 | 5327.0 |
| 2021-12-02 04:30:00 | MSFT | Stock | 332.44 | 332.44 | 331.8 | 332.14 | 2789.0 |
| 2021-12-02 05:00:00 | MSFT | Stock | 331.91 | 332.04 | 330.71 | 331.64 | 6012.0 |
| 2021-12-02 05:30:00 | MSFT | Stock | 331.63 | 332.1 | 331.51 | 331.71 | 2354.0 |
| 2021-12-02 06:00:00 | MSFT | Stock | 331.69 | 332.12 | 331.08 | 331.21 | 3573.0 |
| 2021-12-02 06:30:00 | MSFT | Stock | 330.99 | 331.68 | 330.99 | 331.4 | 2992.0 |
| 2021-12-02 07:00:00 | MSFT | Stock | 331.49 | 331.66 | 329.37 | 330.0 | 30497.0 |
| 2021-12-02 07:30:00 | MSFT | Stock | 330.0 | 331.07 | 329.5 | 330.95 | 16319.0 |
| 2021-12-02 08:00:00 | MSFT | Stock | 331.7737 | 331.81 | 329.5 | 329.82 | 29231.0 |
| 2021-12-02 08:30:00 | MSFT | Stock | 330.0 | 330.82 | 329.5 | 330.31 | 20760.0 |
| 2021-12-02 09:00:00 | MSFT | Stock | 330.48 | 331.2831 | 329.8 | 330.48 | 46779.0 |
| 2021-12-02 09:30:00 | MSFT | Stock | 330.3 | 333.49 | 328.52 | 332.21 | 2173927.0 |
| 2021-12-02 10:00:00 | MSFT | Stock | 332.2 | 332.64 | 328.5601 | 330.3 | 1567722.0 |
| 2021-12-02 10:30:00 | MSFT | Stock | 330.2784 | 330.67 | 327.8028 | 329.609 | 1436883.0 |
| 2021-12-02 11:00:00 | MSFT | Stock | 329.57 | 331.15 | 328.7097 | 330.3 | 1041179.0 |
| 2021-12-02 11:30:00 | MSFT | Stock | 330.31 | 330.47 | 328.59 | 329.84 | 938429.0 |
| 2021-12-02 12:00:00 | MSFT | Stock | 329.845 | 331.76 | 329.59 | 331.5033 | 965954.0 |
| 2021-12-02 12:30:00 | MSFT | Stock | 331.5 | 331.76 | 330.42 | 330.955 | 757161.0 |
> showing 50 of 114,587 rows — these rows as CSV