PREVIEW / stock_30min / 2011-12-28
file: by_date/stock_30min/2011/2011-12-28.parquet size: 1.4 MB rows: 73,762 symbols: 3,558
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-28 04:00:00 | AAPL | Stock | 14.4779 | 14.4779 | 14.4643 | 14.4643 | 8400.0 |
| 2011-12-28 04:30:00 | AAPL | Stock | 14.4829 | 14.4829 | 14.4829 | 14.4829 | 5600.0 |
| 2011-12-28 05:00:00 | AAPL | Stock | 14.475 | 14.4875 | 14.475 | 14.4875 | 8400.0 |
| 2011-12-28 05:30:00 | AAPL | Stock | 14.5 | 14.5036 | 14.5 | 14.5036 | 8400.0 |
| 2011-12-28 06:00:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 2800.0 |
| 2011-12-28 07:00:00 | AAPL | Stock | 14.5382 | 14.5696 | 14.5268 | 14.5693 | 197820.0 |
| 2011-12-28 07:30:00 | AAPL | Stock | 14.5686 | 14.58 | 14.53 | 14.5446 | 296660.0 |
| 2011-12-28 08:00:00 | AAPL | Stock | 14.5536 | 14.5643 | 14.5464 | 14.5464 | 311472.0 |
| 2011-12-28 08:30:00 | AAPL | Stock | 14.5464 | 14.5732 | 14.5464 | 14.5661 | 613928.0 |
| 2011-12-28 09:00:00 | AAPL | Stock | 14.5661 | 14.5779 | 14.5339 | 14.5339 | 1094996.0 |
| 2011-12-28 09:30:00 | AAPL | Stock | 14.5339 | 14.5804 | 14.4464 | 14.4625 | 47619908.0 |
| 2011-12-28 10:00:00 | AAPL | Stock | 14.465 | 14.5032 | 14.45 | 14.4557 | 21807016.0 |
| 2011-12-28 10:30:00 | AAPL | Stock | 14.4535 | 14.4743 | 14.4464 | 14.4575 | 15849400.0 |
| 2011-12-28 11:00:00 | AAPL | Stock | 14.4571 | 14.4871 | 14.4536 | 14.4646 | 17828300.0 |
| 2011-12-28 11:30:00 | AAPL | Stock | 14.4654 | 14.47 | 14.4464 | 14.4518 | 12588184.0 |
| 2011-12-28 12:00:00 | AAPL | Stock | 14.4518 | 14.465 | 14.4121 | 14.4225 | 15739892.0 |
| 2011-12-28 12:30:00 | AAPL | Stock | 14.4204 | 14.4379 | 14.4 | 14.4175 | 8802668.0 |
| 2011-12-28 13:00:00 | AAPL | Stock | 14.4154 | 14.4257 | 14.4075 | 14.4143 | 5276796.0 |
| 2011-12-28 13:30:00 | AAPL | Stock | 14.4143 | 14.4464 | 14.4125 | 14.4404 | 7944776.0 |
| 2011-12-28 14:00:00 | AAPL | Stock | 14.4421 | 14.4427 | 14.4161 | 14.4339 | 7304416.0 |
| 2011-12-28 14:30:00 | AAPL | Stock | 14.4329 | 14.4357 | 14.4211 | 14.4254 | 6625780.0 |
| 2011-12-28 15:00:00 | AAPL | Stock | 14.4254 | 14.4307 | 14.3582 | 14.3607 | 15486800.0 |
| 2011-12-28 15:30:00 | AAPL | Stock | 14.3607 | 14.4079 | 14.3336 | 14.3846 | 33780348.0 |
| 2011-12-28 16:00:00 | AAPL | Stock | 14.3779 | 14.4477 | 14.3757 | 14.3821 | 6083728.0 |
| 2011-12-28 16:30:00 | AAPL | Stock | 14.3839 | 14.4034 | 14.3839 | 14.395 | 232876.0 |
| 2011-12-28 17:00:00 | AAPL | Stock | 14.3893 | 14.3975 | 14.3882 | 14.3975 | 52136.0 |
| 2011-12-28 17:30:00 | AAPL | Stock | 14.3957 | 14.3964 | 14.3875 | 14.3889 | 33600.0 |
| 2011-12-28 18:00:00 | AAPL | Stock | 14.3875 | 14.3929 | 14.38 | 14.3879 | 190120.0 |
| 2011-12-28 18:30:00 | AAPL | Stock | 14.3893 | 14.3893 | 14.3893 | 14.3893 | 2800.0 |
| 2011-12-28 19:00:00 | AAPL | Stock | 14.3921 | 14.3957 | 14.3875 | 14.3893 | 62356.0 |
| 2011-12-28 19:30:00 | AAPL | Stock | 14.39 | 14.3964 | 14.3875 | 14.3929 | 130592.0 |
| 2011-12-28 06:30:00 | MSFT | Stock | 26.02 | 26.02 | 26.02 | 26.02 | 200.0 |
| 2011-12-28 07:00:00 | MSFT | Stock | 26.08 | 26.08 | 26.08 | 26.08 | 200.0 |
| 2011-12-28 07:30:00 | MSFT | Stock | 26.04 | 26.04 | 26.04 | 26.04 | 1000.0 |
| 2011-12-28 08:00:00 | MSFT | Stock | 26.06 | 26.1 | 26.05 | 26.09 | 10371.0 |
| 2011-12-28 08:30:00 | MSFT | Stock | 26.12 | 26.14 | 26.11 | 26.14 | 3970.0 |
| 2011-12-28 09:00:00 | MSFT | Stock | 26.14 | 26.14 | 26.08 | 26.1 | 17828.0 |
| 2011-12-28 09:30:00 | MSFT | Stock | 26.11 | 26.15 | 25.83 | 25.88 | 3552566.0 |
| 2011-12-28 10:00:00 | MSFT | Stock | 25.88 | 26.03 | 25.88 | 25.98 | 1943658.0 |
| 2011-12-28 10:30:00 | MSFT | Stock | 25.97 | 26.01 | 25.94 | 25.985 | 1587696.0 |
| 2011-12-28 11:00:00 | MSFT | Stock | 25.985 | 26.0 | 25.96 | 25.966 | 1191835.0 |
| 2011-12-28 11:30:00 | MSFT | Stock | 25.967 | 26.01 | 25.9 | 25.959 | 2137730.0 |
| 2011-12-28 12:00:00 | MSFT | Stock | 25.96 | 26.02 | 25.94 | 25.975 | 2013800.0 |
| 2011-12-28 12:30:00 | MSFT | Stock | 25.976 | 25.98 | 25.85 | 25.855 | 1084578.0 |
| 2011-12-28 13:00:00 | MSFT | Stock | 25.86 | 25.87 | 25.85 | 25.866 | 760820.0 |
| 2011-12-28 13:30:00 | MSFT | Stock | 25.87 | 25.95 | 25.86 | 25.928 | 1144920.0 |
| 2011-12-28 14:00:00 | MSFT | Stock | 25.925 | 25.94 | 25.873 | 25.9 | 1334565.0 |
| 2011-12-28 14:30:00 | MSFT | Stock | 25.9 | 25.9 | 25.86 | 25.88 | 1414865.0 |
| 2011-12-28 15:00:00 | MSFT | Stock | 25.87 | 25.89 | 25.765 | 25.777 | 2205351.0 |
| 2011-12-28 15:30:00 | MSFT | Stock | 25.775 | 25.83 | 25.76 | 25.82 | 4646307.0 |
> showing 50 of 73,762 rows — these rows as CSV