PREVIEW / stock_30min / 2010-12-08
file: by_date/stock_30min/2010/2010-12-08.parquet size: 1.4 MB rows: 74,789 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-08 05:00:00 | AAPL | Stock | 11.3857 | 11.3857 | 11.3725 | 11.3725 | 5600.0 |
| 2010-12-08 05:30:00 | AAPL | Stock | 11.3725 | 11.3725 | 11.3725 | 11.3725 | 2800.0 |
| 2010-12-08 06:30:00 | AAPL | Stock | 11.4079 | 11.4079 | 11.4079 | 11.4079 | 2800.0 |
| 2010-12-08 07:00:00 | AAPL | Stock | 11.3843 | 11.3914 | 11.3839 | 11.3914 | 46200.0 |
| 2010-12-08 07:30:00 | AAPL | Stock | 11.3886 | 11.3886 | 11.3786 | 11.3786 | 40600.0 |
| 2010-12-08 08:00:00 | AAPL | Stock | 11.3882 | 11.4357 | 11.3839 | 11.4318 | 1566152.0 |
| 2010-12-08 08:30:00 | AAPL | Stock | 11.4304 | 11.4393 | 11.4157 | 11.4179 | 960260.0 |
| 2010-12-08 09:00:00 | AAPL | Stock | 11.4182 | 11.4293 | 11.4018 | 11.4179 | 1054956.0 |
| 2010-12-08 09:30:00 | AAPL | Stock | 11.4189 | 11.4418 | 11.3857 | 11.4186 | 47069540.0 |
| 2010-12-08 10:00:00 | AAPL | Stock | 11.4211 | 11.4211 | 11.3661 | 11.3868 | 35955416.0 |
| 2010-12-08 10:30:00 | AAPL | Stock | 11.3825 | 11.3875 | 11.3254 | 11.3571 | 35146888.0 |
| 2010-12-08 11:00:00 | AAPL | Stock | 11.3568 | 11.375 | 11.3543 | 11.3609 | 14791728.0 |
| 2010-12-08 11:30:00 | AAPL | Stock | 11.3614 | 11.3818 | 11.3496 | 11.3721 | 17635324.0 |
| 2010-12-08 12:00:00 | AAPL | Stock | 11.3714 | 11.3768 | 11.3582 | 11.36 | 9634548.0 |
| 2010-12-08 12:30:00 | AAPL | Stock | 11.3605 | 11.3668 | 11.345 | 11.3554 | 12521152.0 |
| 2010-12-08 13:00:00 | AAPL | Stock | 11.3571 | 11.3764 | 11.3546 | 11.3616 | 11632740.0 |
| 2010-12-08 13:30:00 | AAPL | Stock | 11.3625 | 11.3911 | 11.3575 | 11.3864 | 11939200.0 |
| 2010-12-08 14:00:00 | AAPL | Stock | 11.3864 | 11.4268 | 11.3793 | 11.415 | 20785184.0 |
| 2010-12-08 14:30:00 | AAPL | Stock | 11.4167 | 11.4418 | 11.4132 | 11.4271 | 22698704.0 |
| 2010-12-08 15:00:00 | AAPL | Stock | 11.4257 | 11.4461 | 11.4121 | 11.4154 | 23812488.0 |
| 2010-12-08 15:30:00 | AAPL | Stock | 11.4161 | 11.465 | 11.4107 | 11.4646 | 37830240.0 |
| 2010-12-08 16:00:00 | AAPL | Stock | 11.4646 | 11.4711 | 11.3981 | 11.4589 | 11513348.0 |
| 2010-12-08 16:30:00 | AAPL | Stock | 11.4639 | 11.4661 | 11.4002 | 11.4625 | 408912.0 |
| 2010-12-08 17:00:00 | AAPL | Stock | 11.465 | 11.4714 | 11.4554 | 11.4621 | 448308.0 |
| 2010-12-08 17:30:00 | AAPL | Stock | 11.4625 | 11.4639 | 11.4571 | 11.4629 | 66248.0 |
| 2010-12-08 18:00:00 | AAPL | Stock | 11.4646 | 11.4646 | 11.4564 | 11.4564 | 211428.0 |
| 2010-12-08 18:30:00 | AAPL | Stock | 11.4621 | 11.4821 | 11.4607 | 11.4779 | 288400.0 |
| 2010-12-08 19:00:00 | AAPL | Stock | 11.4736 | 11.4871 | 11.4736 | 11.4832 | 200928.0 |
| 2010-12-08 19:30:00 | AAPL | Stock | 11.4868 | 11.4975 | 11.4868 | 11.4957 | 505932.0 |
| 2010-12-08 05:00:00 | MSFT | Stock | 26.59 | 26.59 | 26.59 | 26.59 | 100.0 |
| 2010-12-08 07:00:00 | MSFT | Stock | 26.72 | 26.76 | 26.7 | 26.73 | 2400.0 |
| 2010-12-08 07:30:00 | MSFT | Stock | 26.75 | 26.8 | 26.75 | 26.8 | 7200.0 |
| 2010-12-08 08:00:00 | MSFT | Stock | 26.8 | 26.84 | 26.78 | 26.84 | 6915.0 |
| 2010-12-08 08:30:00 | MSFT | Stock | 26.85 | 26.88 | 26.84 | 26.88 | 13670.0 |
| 2010-12-08 09:00:00 | MSFT | Stock | 26.87 | 26.94 | 26.83 | 26.83 | 59897.0 |
| 2010-12-08 09:30:00 | MSFT | Stock | 26.83 | 27.09 | 26.8 | 27.04 | 4665919.0 |
| 2010-12-08 10:00:00 | MSFT | Stock | 27.045 | 27.08 | 26.97 | 27.02 | 4030757.0 |
| 2010-12-08 10:30:00 | MSFT | Stock | 27.03 | 27.04 | 26.97 | 27.01 | 3744625.0 |
| 2010-12-08 11:00:00 | MSFT | Stock | 27.015 | 27.1 | 27.01 | 27.092 | 2781484.0 |
| 2010-12-08 11:30:00 | MSFT | Stock | 27.09 | 27.17 | 27.07 | 27.135 | 2670557.0 |
| 2010-12-08 12:00:00 | MSFT | Stock | 27.139 | 27.18 | 27.11 | 27.11 | 1710361.0 |
| 2010-12-08 12:30:00 | MSFT | Stock | 27.11 | 27.17 | 27.05 | 27.161 | 2864519.0 |
| 2010-12-08 13:00:00 | MSFT | Stock | 27.16 | 27.22 | 27.13 | 27.15 | 3175603.0 |
| 2010-12-08 13:30:00 | MSFT | Stock | 27.14 | 27.23 | 27.14 | 27.19 | 1842924.0 |
| 2010-12-08 14:00:00 | MSFT | Stock | 27.19 | 27.2 | 27.15 | 27.155 | 1656660.0 |
| 2010-12-08 14:30:00 | MSFT | Stock | 27.159 | 27.21 | 27.15 | 27.185 | 1940112.0 |
| 2010-12-08 15:00:00 | MSFT | Stock | 27.18 | 27.21 | 27.15 | 27.16 | 2252334.0 |
| 2010-12-08 15:30:00 | MSFT | Stock | 27.165 | 27.24 | 27.15 | 27.23 | 4902242.0 |
| 2010-12-08 16:00:00 | MSFT | Stock | 27.21 | 27.24 | 27.101 | 27.2 | 1806498.0 |
| 2010-12-08 16:30:00 | MSFT | Stock | 27.104 | 27.24 | 27.104 | 27.23 | 119009.0 |
> showing 50 of 74,789 rows — these rows as CSV