PREVIEW / stock_30min / 2021-06-02
file: by_date/stock_30min/2021/2021-06-02.parquet size: 2.2 MB rows: 113,381 symbols: 2,955
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-06-02 04:00:00 | AAPL | Stock | 124.24 | 124.24 | 124.15 | 124.15 | 4518.0 |
| 2021-06-02 04:30:00 | AAPL | Stock | 124.17 | 124.17 | 123.98 | 124.0 | 7978.0 |
| 2021-06-02 05:00:00 | AAPL | Stock | 124.0 | 124.07 | 124.0 | 124.05 | 4454.0 |
| 2021-06-02 05:30:00 | AAPL | Stock | 124.08 | 124.18 | 124.08 | 124.18 | 3003.0 |
| 2021-06-02 06:00:00 | AAPL | Stock | 124.12 | 124.12 | 124.12 | 124.12 | 107.0 |
| 2021-06-02 06:30:00 | AAPL | Stock | 124.18 | 124.24 | 124.18 | 124.24 | 3180.0 |
| 2021-06-02 07:00:00 | AAPL | Stock | 124.19 | 124.27 | 124.1 | 124.23 | 43306.0 |
| 2021-06-02 07:30:00 | AAPL | Stock | 124.24 | 124.37 | 124.2 | 124.32 | 33977.0 |
| 2021-06-02 08:00:00 | AAPL | Stock | 124.21 | 124.59 | 124.11 | 124.42 | 136030.0 |
| 2021-06-02 08:30:00 | AAPL | Stock | 124.4 | 124.47 | 124.34 | 124.45 | 112382.0 |
| 2021-06-02 09:00:00 | AAPL | Stock | 124.45 | 124.57 | 124.27 | 124.28 | 740103.0 |
| 2021-06-02 09:30:00 | AAPL | Stock | 124.29 | 125.13 | 124.11 | 125.035 | 8554863.0 |
| 2021-06-02 10:00:00 | AAPL | Stock | 125.035 | 125.19 | 124.75 | 125.085 | 5006156.0 |
| 2021-06-02 10:30:00 | AAPL | Stock | 125.0797 | 125.24 | 124.83 | 124.905 | 3709477.0 |
| 2021-06-02 11:00:00 | AAPL | Stock | 124.89 | 125.01 | 124.65 | 124.97 | 3565271.0 |
| 2021-06-02 11:30:00 | AAPL | Stock | 124.97 | 125.18 | 124.93 | 124.985 | 2412164.0 |
| 2021-06-02 12:00:00 | AAPL | Stock | 124.99 | 125.02 | 124.62 | 124.7068 | 2324705.0 |
| 2021-06-02 12:30:00 | AAPL | Stock | 124.705 | 124.71 | 124.41 | 124.415 | 2193378.0 |
| 2021-06-02 13:00:00 | AAPL | Stock | 124.41 | 124.56 | 124.07 | 124.195 | 2706285.0 |
| 2021-06-02 13:30:00 | AAPL | Stock | 124.2 | 124.35 | 124.115 | 124.31 | 2087532.0 |
| 2021-06-02 14:00:00 | AAPL | Stock | 124.31 | 124.51 | 124.05 | 124.48 | 2626034.0 |
| 2021-06-02 14:30:00 | AAPL | Stock | 124.485 | 124.695 | 124.41 | 124.6822 | 2368138.0 |
| 2021-06-02 15:00:00 | AAPL | Stock | 124.68 | 124.795 | 124.51 | 124.785 | 2573904.0 |
| 2021-06-02 15:30:00 | AAPL | Stock | 124.79 | 125.169 | 124.66 | 125.09 | 5719939.0 |
| 2021-06-02 16:00:00 | AAPL | Stock | 125.06 | 125.16 | 124.96 | 124.97 | 4382595.0 |
| 2021-06-02 16:30:00 | AAPL | Stock | 124.97 | 125.05 | 124.9 | 124.96 | 38562.0 |
| 2021-06-02 17:00:00 | AAPL | Stock | 124.98 | 125.04 | 124.96 | 124.96 | 17248.0 |
| 2021-06-02 17:30:00 | AAPL | Stock | 124.96 | 125.0 | 124.9 | 124.97 | 25553.0 |
| 2021-06-02 18:00:00 | AAPL | Stock | 124.97 | 125.05 | 124.97 | 125.01 | 10889.0 |
| 2021-06-02 18:30:00 | AAPL | Stock | 125.03 | 125.05 | 125.0 | 125.02 | 24071.0 |
| 2021-06-02 19:00:00 | AAPL | Stock | 125.02 | 125.04 | 125.01 | 125.02 | 12986.0 |
| 2021-06-02 19:30:00 | AAPL | Stock | 125.01 | 125.09 | 125.0 | 125.08 | 32496.0 |
| 2021-06-02 04:00:00 | MSFT | Stock | 247.14 | 247.4 | 247.14 | 247.26 | 655.0 |
| 2021-06-02 04:30:00 | MSFT | Stock | 247.02 | 247.02 | 246.29 | 246.5 | 1072.0 |
| 2021-06-02 05:30:00 | MSFT | Stock | 247.0 | 247.0 | 247.0 | 247.0 | 160.0 |
| 2021-06-02 06:30:00 | MSFT | Stock | 247.21 | 247.21 | 247.21 | 247.21 | 166.0 |
| 2021-06-02 07:00:00 | MSFT | Stock | 247.36 | 247.72 | 247.29 | 247.43 | 5001.0 |
| 2021-06-02 07:30:00 | MSFT | Stock | 247.41 | 247.65 | 247.41 | 247.65 | 2109.0 |
| 2021-06-02 08:00:00 | MSFT | Stock | 247.51 | 247.75 | 247.4 | 247.72 | 8278.0 |
| 2021-06-02 08:30:00 | MSFT | Stock | 247.7201 | 247.8 | 247.5 | 247.66 | 8912.0 |
| 2021-06-02 09:00:00 | MSFT | Stock | 247.7 | 248.5 | 247.4 | 248.21 | 159911.0 |
| 2021-06-02 09:30:00 | MSFT | Stock | 248.07 | 248.91 | 247.26 | 248.49 | 2200207.0 |
| 2021-06-02 10:00:00 | MSFT | Stock | 248.48 | 249.04 | 247.94 | 248.86 | 1299832.0 |
| 2021-06-02 10:30:00 | MSFT | Stock | 248.85 | 249.27 | 248.37 | 248.665 | 1142815.0 |
| 2021-06-02 11:00:00 | MSFT | Stock | 248.67 | 248.92 | 248.45 | 248.65 | 962800.0 |
| 2021-06-02 11:30:00 | MSFT | Stock | 248.67 | 248.715 | 248.07 | 248.12 | 568306.0 |
| 2021-06-02 12:00:00 | MSFT | Stock | 248.13 | 248.29 | 247.19 | 247.31 | 957170.0 |
| 2021-06-02 12:30:00 | MSFT | Stock | 247.29 | 247.55 | 247.16 | 247.305 | 583133.0 |
| 2021-06-02 13:00:00 | MSFT | Stock | 247.31 | 247.33 | 246.37 | 246.404 | 702469.0 |
| 2021-06-02 13:30:00 | MSFT | Stock | 246.39 | 246.53 | 245.97 | 246.29 | 761771.0 |
> showing 50 of 113,381 rows — these rows as CSV