PREVIEW / stock_30min / 2010-06-02
file: by_date/stock_30min/2010/2010-06-02.parquet size: 1.5 MB rows: 78,383 symbols: 3,475
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-06-02 04:00:00 | AAPL | Stock | 9.3932 | 9.4314 | 9.3654 | 9.3664 | 89600.0 |
| 2010-06-02 05:30:00 | AAPL | Stock | 9.4204 | 9.4261 | 9.4204 | 9.4261 | 5600.0 |
| 2010-06-02 06:00:00 | AAPL | Stock | 9.425 | 9.4407 | 9.4186 | 9.4407 | 24920.0 |
| 2010-06-02 06:30:00 | AAPL | Stock | 9.425 | 9.425 | 9.425 | 9.425 | 5600.0 |
| 2010-06-02 07:00:00 | AAPL | Stock | 9.425 | 9.4321 | 9.4096 | 9.4321 | 296940.0 |
| 2010-06-02 07:30:00 | AAPL | Stock | 9.4368 | 9.4368 | 9.3946 | 9.4071 | 385028.0 |
| 2010-06-02 08:00:00 | AAPL | Stock | 9.4071 | 9.455 | 9.4018 | 9.4382 | 4452364.0 |
| 2010-06-02 08:30:00 | AAPL | Stock | 9.44 | 9.445 | 9.4164 | 9.4254 | 1958712.0 |
| 2010-06-02 09:00:00 | AAPL | Stock | 9.4257 | 9.4525 | 9.4214 | 9.4479 | 2817136.0 |
| 2010-06-02 09:30:00 | AAPL | Stock | 9.4479 | 9.4571 | 9.325 | 9.3843 | 114340912.0 |
| 2010-06-02 10:00:00 | AAPL | Stock | 9.3864 | 9.4225 | 9.3732 | 9.3937 | 66017196.0 |
| 2010-06-02 10:30:00 | AAPL | Stock | 9.3946 | 9.4143 | 9.3393 | 9.3649 | 46677652.0 |
| 2010-06-02 11:00:00 | AAPL | Stock | 9.3646 | 9.3968 | 9.3646 | 9.3814 | 34391560.0 |
| 2010-06-02 11:30:00 | AAPL | Stock | 9.3821 | 9.4061 | 9.3721 | 9.3921 | 36088360.0 |
| 2010-06-02 12:00:00 | AAPL | Stock | 9.3932 | 9.4207 | 9.3857 | 9.3949 | 25499488.0 |
| 2010-06-02 12:30:00 | AAPL | Stock | 9.395 | 9.4136 | 9.3864 | 9.4086 | 17262588.0 |
| 2010-06-02 13:00:00 | AAPL | Stock | 9.4086 | 9.4232 | 9.3732 | 9.3845 | 31428152.0 |
| 2010-06-02 13:30:00 | AAPL | Stock | 9.3825 | 9.3982 | 9.3446 | 9.3561 | 37188116.0 |
| 2010-06-02 14:00:00 | AAPL | Stock | 9.3575 | 9.3625 | 9.2977 | 9.3312 | 61156312.0 |
| 2010-06-02 14:30:00 | AAPL | Stock | 9.3314 | 9.3814 | 9.3214 | 9.3571 | 58395792.0 |
| 2010-06-02 15:00:00 | AAPL | Stock | 9.3564 | 9.3996 | 9.3486 | 9.3922 | 46304384.0 |
| 2010-06-02 15:30:00 | AAPL | Stock | 9.3943 | 9.4268 | 9.3732 | 9.4264 | 77557928.0 |
| 2010-06-02 16:00:00 | AAPL | Stock | 9.4268 | 9.4268 | 9.3807 | 9.4207 | 13206256.0 |
| 2010-06-02 16:30:00 | AAPL | Stock | 9.4204 | 9.4268 | 9.3926 | 9.4161 | 495068.0 |
| 2010-06-02 17:00:00 | AAPL | Stock | 9.4179 | 9.4268 | 9.4146 | 9.4232 | 2179156.0 |
| 2010-06-02 17:30:00 | AAPL | Stock | 9.4246 | 9.4418 | 9.4246 | 9.4409 | 736652.0 |
| 2010-06-02 18:00:00 | AAPL | Stock | 9.4409 | 9.4411 | 9.4196 | 9.4196 | 521584.0 |
| 2010-06-02 18:30:00 | AAPL | Stock | 9.4239 | 9.4264 | 9.4107 | 9.4107 | 143696.0 |
| 2010-06-02 19:00:00 | AAPL | Stock | 9.4207 | 9.4214 | 9.4107 | 9.4186 | 83636.0 |
| 2010-06-02 19:30:00 | AAPL | Stock | 9.4214 | 9.425 | 9.4154 | 9.4246 | 484792.0 |
| 2010-06-02 20:00:00 | AAPL | Stock | 9.3932 | 9.3932 | 9.3932 | 9.3932 | 184800.0 |
| 2010-06-02 07:00:00 | MSFT | Stock | 26.05 | 26.05 | 26.05 | 26.05 | 500.0 |
| 2010-06-02 08:00:00 | MSFT | Stock | 25.89 | 26.12 | 25.89 | 26.05 | 36790.0 |
| 2010-06-02 08:30:00 | MSFT | Stock | 26.05 | 26.05 | 25.99 | 26.04 | 8969.0 |
| 2010-06-02 09:00:00 | MSFT | Stock | 26.03 | 26.09 | 26.03 | 26.07 | 10140.0 |
| 2010-06-02 09:30:00 | MSFT | Stock | 26.07 | 26.08 | 25.73 | 25.82 | 8082324.0 |
| 2010-06-02 10:00:00 | MSFT | Stock | 25.815 | 25.95 | 25.79 | 25.85 | 4837177.0 |
| 2010-06-02 10:30:00 | MSFT | Stock | 25.85 | 25.939 | 25.83 | 25.92 | 3216822.0 |
| 2010-06-02 11:00:00 | MSFT | Stock | 25.91 | 25.98 | 25.9 | 25.97 | 2903442.0 |
| 2010-06-02 11:30:00 | MSFT | Stock | 25.965 | 26.04 | 25.95 | 26.025 | 2715837.0 |
| 2010-06-02 12:00:00 | MSFT | Stock | 26.02 | 26.06 | 26.01 | 26.032 | 2486841.0 |
| 2010-06-02 12:30:00 | MSFT | Stock | 26.04 | 26.055 | 26.02 | 26.035 | 3385049.0 |
| 2010-06-02 13:00:00 | MSFT | Stock | 26.035 | 26.08 | 26.03 | 26.042 | 2446342.0 |
| 2010-06-02 13:30:00 | MSFT | Stock | 26.05 | 26.07 | 26.03 | 26.055 | 1839660.0 |
| 2010-06-02 14:00:00 | MSFT | Stock | 26.052 | 26.055 | 25.975 | 26.039 | 3649974.0 |
| 2010-06-02 14:30:00 | MSFT | Stock | 26.04 | 26.23 | 26.04 | 26.21 | 4959983.0 |
| 2010-06-02 15:00:00 | MSFT | Stock | 26.2 | 26.34 | 26.19 | 26.315 | 6256717.0 |
| 2010-06-02 15:30:00 | MSFT | Stock | 26.312 | 26.48 | 26.22 | 26.43 | 12193618.0 |
| 2010-06-02 16:00:00 | MSFT | Stock | 26.43 | 26.47 | 26.078 | 26.36 | 4532812.0 |
| 2010-06-02 16:30:00 | MSFT | Stock | 26.36 | 26.43 | 26.096 | 26.43 | 122418.0 |
> showing 50 of 78,383 rows — these rows as CSV