PREVIEW / stock_30min / 2020-11-30
file: by_date/stock_30min/2020/2020-11-30.parquet size: 2.2 MB rows: 110,141 symbols: 2,627
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-30 04:00:00 | AAPL | Stock | 116.44 | 116.49 | 116.29 | 116.29 | 22369.0 |
| 2020-11-30 04:30:00 | AAPL | Stock | 116.25 | 116.4 | 116.22 | 116.25 | 4304.0 |
| 2020-11-30 05:00:00 | AAPL | Stock | 116.3 | 116.35 | 116.24 | 116.25 | 2765.0 |
| 2020-11-30 05:30:00 | AAPL | Stock | 116.25 | 116.6 | 116.25 | 116.6 | 6112.0 |
| 2020-11-30 06:00:00 | AAPL | Stock | 116.6 | 117.3 | 116.55 | 117.05 | 33461.0 |
| 2020-11-30 06:30:00 | AAPL | Stock | 117.03 | 117.25 | 116.76 | 117.16 | 25717.0 |
| 2020-11-30 07:00:00 | AAPL | Stock | 117.15 | 117.25 | 116.76 | 116.98 | 202789.0 |
| 2020-11-30 07:30:00 | AAPL | Stock | 116.98 | 117.21 | 116.96 | 117.04 | 104393.0 |
| 2020-11-30 08:00:00 | AAPL | Stock | 117.03 | 117.25 | 116.61 | 116.84 | 402107.0 |
| 2020-11-30 08:30:00 | AAPL | Stock | 116.85 | 117.05 | 116.81 | 117.0 | 184929.0 |
| 2020-11-30 09:00:00 | AAPL | Stock | 117.01 | 117.3 | 116.9 | 116.94 | 392811.0 |
| 2020-11-30 09:30:00 | AAPL | Stock | 116.94 | 119.39 | 116.81 | 118.95 | 18381023.0 |
| 2020-11-30 10:00:00 | AAPL | Stock | 118.95 | 119.5 | 118.62 | 118.7 | 9649610.0 |
| 2020-11-30 10:30:00 | AAPL | Stock | 118.704 | 118.79 | 116.91 | 118.13 | 11452007.0 |
| 2020-11-30 11:00:00 | AAPL | Stock | 118.13 | 118.19 | 117.665 | 117.77 | 6000731.0 |
| 2020-11-30 11:30:00 | AAPL | Stock | 117.77 | 119.01 | 117.5 | 118.88 | 6888275.0 |
| 2020-11-30 12:00:00 | AAPL | Stock | 118.87 | 119.07 | 118.61 | 119.035 | 5066841.0 |
| 2020-11-30 12:30:00 | AAPL | Stock | 119.04 | 119.11 | 118.68 | 119.045 | 3691903.0 |
| 2020-11-30 13:00:00 | AAPL | Stock | 119.045 | 119.22 | 118.81 | 119.07 | 3988256.0 |
| 2020-11-30 13:30:00 | AAPL | Stock | 119.07 | 119.76 | 118.98 | 119.735 | 6309525.0 |
| 2020-11-30 14:00:00 | AAPL | Stock | 119.735 | 120.2 | 119.59 | 120.19 | 7481566.0 |
| 2020-11-30 14:30:00 | AAPL | Stock | 120.18 | 120.83 | 120.13 | 120.565 | 9754151.0 |
| 2020-11-30 15:00:00 | AAPL | Stock | 120.57 | 120.97 | 120.29 | 120.41 | 7940803.0 |
| 2020-11-30 15:30:00 | AAPL | Stock | 120.41 | 120.68 | 119.05 | 119.06 | 18405264.0 |
| 2020-11-30 16:00:00 | AAPL | Stock | 119.62 | 119.92 | 119.038 | 119.4 | 32517605.0 |
| 2020-11-30 16:30:00 | AAPL | Stock | 119.4 | 120.16 | 119.05 | 119.86 | 167033.0 |
| 2020-11-30 17:00:00 | AAPL | Stock | 119.88 | 119.95 | 119.035 | 119.55 | 194316.0 |
| 2020-11-30 17:30:00 | AAPL | Stock | 119.56 | 120.6 | 119.53 | 120.56 | 285455.0 |
| 2020-11-30 18:00:00 | AAPL | Stock | 120.56 | 120.8 | 120.2 | 120.33 | 227544.0 |
| 2020-11-30 18:30:00 | AAPL | Stock | 120.28 | 120.68 | 120.25 | 120.55 | 97652.0 |
| 2020-11-30 19:00:00 | AAPL | Stock | 120.53 | 120.87 | 120.51 | 120.83 | 102614.0 |
| 2020-11-30 19:30:00 | AAPL | Stock | 120.84 | 120.88 | 120.57 | 120.81 | 135541.0 |
| 2020-11-30 04:00:00 | MSFT | Stock | 214.98 | 214.98 | 214.9 | 214.9 | 235.0 |
| 2020-11-30 04:30:00 | MSFT | Stock | 215.0 | 215.0 | 215.0 | 215.0 | 158.0 |
| 2020-11-30 05:00:00 | MSFT | Stock | 214.67 | 214.67 | 214.67 | 214.67 | 336.0 |
| 2020-11-30 05:30:00 | MSFT | Stock | 214.72 | 214.9 | 214.6 | 214.9 | 575.0 |
| 2020-11-30 06:00:00 | MSFT | Stock | 214.81 | 214.97 | 214.68 | 214.97 | 1188.0 |
| 2020-11-30 06:30:00 | MSFT | Stock | 214.76 | 214.82 | 214.62 | 214.82 | 366.0 |
| 2020-11-30 07:00:00 | MSFT | Stock | 214.94 | 215.81 | 214.77 | 215.53 | 13025.0 |
| 2020-11-30 07:30:00 | MSFT | Stock | 215.5 | 215.5 | 215.3 | 215.39 | 9294.0 |
| 2020-11-30 08:00:00 | MSFT | Stock | 215.32 | 215.94 | 214.39 | 215.04 | 23215.0 |
| 2020-11-30 08:30:00 | MSFT | Stock | 215.0 | 215.35 | 214.5 | 214.98 | 8016.0 |
| 2020-11-30 09:00:00 | MSFT | Stock | 214.805 | 215.15 | 214.09 | 214.16 | 37319.0 |
| 2020-11-30 09:30:00 | MSFT | Stock | 214.16 | 214.76 | 212.92 | 213.94 | 2899574.0 |
| 2020-11-30 10:00:00 | MSFT | Stock | 213.94 | 214.17 | 212.62 | 213.295 | 1482558.0 |
| 2020-11-30 10:30:00 | MSFT | Stock | 213.27 | 213.3 | 210.93 | 211.93 | 1861072.0 |
| 2020-11-30 11:00:00 | MSFT | Stock | 211.92 | 212.2 | 211.363 | 211.38 | 1151258.0 |
| 2020-11-30 11:30:00 | MSFT | Stock | 211.36 | 212.03 | 210.835 | 211.58 | 1560588.0 |
| 2020-11-30 12:00:00 | MSFT | Stock | 211.575 | 212.45 | 211.36 | 212.36 | 1275735.0 |
| 2020-11-30 12:30:00 | MSFT | Stock | 212.37 | 212.58 | 212.114 | 212.405 | 695466.0 |
> showing 50 of 110,141 rows — these rows as CSV