PREVIEW / stock_30min / 2021-11-02
file: by_date/stock_30min/2021/2021-11-02.parquet size: 2.3 MB rows: 113,474 symbols: 2,681
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-11-02 04:00:00 | AAPL | Stock | 148.67 | 148.95 | 148.55 | 148.84 | 13843.0 |
| 2021-11-02 04:30:00 | AAPL | Stock | 148.79 | 148.93 | 148.7 | 148.71 | 6553.0 |
| 2021-11-02 05:00:00 | AAPL | Stock | 148.68 | 148.92 | 148.68 | 148.85 | 11935.0 |
| 2021-11-02 05:30:00 | AAPL | Stock | 148.87 | 148.91 | 148.69 | 148.78 | 6528.0 |
| 2021-11-02 06:00:00 | AAPL | Stock | 148.79 | 148.79 | 148.67 | 148.67 | 2302.0 |
| 2021-11-02 06:30:00 | AAPL | Stock | 148.68 | 148.8 | 148.67 | 148.7 | 5879.0 |
| 2021-11-02 07:00:00 | AAPL | Stock | 148.7 | 148.79 | 148.61 | 148.68 | 45243.0 |
| 2021-11-02 07:30:00 | AAPL | Stock | 148.69 | 148.77 | 148.59 | 148.59 | 30099.0 |
| 2021-11-02 08:00:00 | AAPL | Stock | 148.77 | 148.79 | 148.59 | 148.69 | 99841.0 |
| 2021-11-02 08:30:00 | AAPL | Stock | 148.67 | 148.72 | 148.59 | 148.59 | 73904.0 |
| 2021-11-02 09:00:00 | AAPL | Stock | 148.59 | 148.69 | 148.46 | 148.69 | 106165.0 |
| 2021-11-02 09:30:00 | AAPL | Stock | 148.67 | 150.4894 | 148.65 | 149.93 | 9619410.0 |
| 2021-11-02 10:00:00 | AAPL | Stock | 149.94 | 150.08 | 149.3335 | 150.0698 | 4208985.0 |
| 2021-11-02 10:30:00 | AAPL | Stock | 150.07 | 150.915 | 150.0699 | 150.8601 | 5571468.0 |
| 2021-11-02 11:00:00 | AAPL | Stock | 150.87 | 151.22 | 150.62 | 151.15 | 3635485.0 |
| 2021-11-02 11:30:00 | AAPL | Stock | 151.14 | 151.57 | 150.89 | 150.9401 | 4572006.0 |
| 2021-11-02 12:00:00 | AAPL | Stock | 150.94 | 151.07 | 150.585 | 150.99 | 2854957.0 |
| 2021-11-02 12:30:00 | AAPL | Stock | 151.0026 | 151.48 | 150.8427 | 151.4 | 2834544.0 |
| 2021-11-02 13:00:00 | AAPL | Stock | 151.41 | 151.47 | 150.99 | 151.035 | 2308239.0 |
| 2021-11-02 13:30:00 | AAPL | Stock | 151.035 | 151.13 | 150.86 | 150.9576 | 2122085.0 |
| 2021-11-02 14:00:00 | AAPL | Stock | 150.955 | 150.99 | 150.44 | 150.505 | 2541297.0 |
| 2021-11-02 14:30:00 | AAPL | Stock | 150.5 | 150.5784 | 150.07 | 150.365 | 2826421.0 |
| 2021-11-02 15:00:00 | AAPL | Stock | 150.3684 | 150.435 | 150.115 | 150.275 | 1974671.0 |
| 2021-11-02 15:30:00 | AAPL | Stock | 150.27 | 150.42 | 149.82 | 150.0 | 5546049.0 |
| 2021-11-02 16:00:00 | AAPL | Stock | 150.02 | 150.04 | 149.82 | 149.93 | 5441482.0 |
| 2021-11-02 16:30:00 | AAPL | Stock | 149.95 | 150.02 | 149.82 | 149.95 | 51822.0 |
| 2021-11-02 17:00:00 | AAPL | Stock | 149.93 | 149.9899 | 149.92 | 149.92 | 7892.0 |
| 2021-11-02 17:30:00 | AAPL | Stock | 149.91 | 149.95 | 149.81 | 149.83 | 17689.0 |
| 2021-11-02 18:00:00 | AAPL | Stock | 149.83 | 149.86 | 149.8 | 149.85 | 10866.0 |
| 2021-11-02 18:30:00 | AAPL | Stock | 149.81 | 149.85 | 149.81 | 149.84 | 5580.0 |
| 2021-11-02 19:00:00 | AAPL | Stock | 149.83 | 149.94 | 149.82 | 149.92 | 11519.0 |
| 2021-11-02 19:30:00 | AAPL | Stock | 149.92 | 149.92 | 149.82 | 149.85 | 24856.0 |
| 2021-11-02 04:00:00 | MSFT | Stock | 329.9 | 330.0 | 329.37 | 329.88 | 3051.0 |
| 2021-11-02 04:30:00 | MSFT | Stock | 330.0 | 330.19 | 329.97 | 329.97 | 2143.0 |
| 2021-11-02 05:00:00 | MSFT | Stock | 329.79 | 331.45 | 329.79 | 330.8 | 5873.0 |
| 2021-11-02 05:30:00 | MSFT | Stock | 331.0 | 331.27 | 330.2 | 330.54 | 2257.0 |
| 2021-11-02 06:00:00 | MSFT | Stock | 330.39 | 330.46 | 329.84 | 330.45 | 1081.0 |
| 2021-11-02 06:30:00 | MSFT | Stock | 330.73 | 330.8 | 330.73 | 330.73 | 1587.0 |
| 2021-11-02 07:00:00 | MSFT | Stock | 330.5 | 330.93 | 330.5 | 330.71 | 6805.0 |
| 2021-11-02 07:30:00 | MSFT | Stock | 330.74 | 330.83 | 330.28 | 330.28 | 3954.0 |
| 2021-11-02 08:00:00 | MSFT | Stock | 330.8 | 330.95 | 330.11 | 330.35 | 32078.0 |
| 2021-11-02 08:30:00 | MSFT | Stock | 330.32 | 330.45 | 330.0 | 330.36 | 12899.0 |
| 2021-11-02 09:00:00 | MSFT | Stock | 330.38 | 330.6 | 329.85 | 330.48 | 22067.0 |
| 2021-11-02 09:30:00 | MSFT | Stock | 330.31 | 333.0 | 330.0 | 332.1099 | 2514397.0 |
| 2021-11-02 10:00:00 | MSFT | Stock | 332.11 | 332.3 | 331.0196 | 331.96 | 1302532.0 |
| 2021-11-02 10:30:00 | MSFT | Stock | 331.98 | 332.48 | 331.8001 | 332.185 | 959551.0 |
| 2021-11-02 11:00:00 | MSFT | Stock | 332.23 | 333.17 | 331.77 | 332.12 | 1583471.0 |
| 2021-11-02 11:30:00 | MSFT | Stock | 332.1299 | 333.28 | 332.09 | 332.83 | 988591.0 |
| 2021-11-02 12:00:00 | MSFT | Stock | 332.842 | 333.0 | 332.06 | 332.5 | 770461.0 |
| 2021-11-02 12:30:00 | MSFT | Stock | 332.51 | 332.84 | 332.16 | 332.565 | 783662.0 |
> showing 50 of 113,474 rows — these rows as CSV