PREVIEW / stock_30min / 2010-12-06
file: by_date/stock_30min/2010/2010-12-06.parquet size: 1.4 MB rows: 75,569 symbols: 3,528
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-06 05:00:00 | AAPL | Stock | 11.3154 | 11.3154 | 11.3154 | 11.3154 | 2800.0 |
| 2010-12-06 06:00:00 | AAPL | Stock | 11.3332 | 11.3332 | 11.3332 | 11.3332 | 5600.0 |
| 2010-12-06 07:00:00 | AAPL | Stock | 11.3554 | 11.3707 | 11.3554 | 11.3689 | 52920.0 |
| 2010-12-06 07:30:00 | AAPL | Stock | 11.3575 | 11.3621 | 11.35 | 11.35 | 30044.0 |
| 2010-12-06 08:00:00 | AAPL | Stock | 11.3532 | 11.3571 | 11.3375 | 11.3443 | 1019368.0 |
| 2010-12-06 08:30:00 | AAPL | Stock | 11.3432 | 11.3696 | 11.3232 | 11.3664 | 1557640.0 |
| 2010-12-06 09:00:00 | AAPL | Stock | 11.3679 | 11.3904 | 11.3614 | 11.3786 | 1974672.0 |
| 2010-12-06 09:30:00 | AAPL | Stock | 11.3786 | 11.4643 | 11.3721 | 11.4536 | 106967924.0 |
| 2010-12-06 10:00:00 | AAPL | Stock | 11.4532 | 11.5118 | 11.4493 | 11.5018 | 75212200.0 |
| 2010-12-06 10:30:00 | AAPL | Stock | 11.5004 | 11.5043 | 11.4404 | 11.4502 | 37954924.0 |
| 2010-12-06 11:00:00 | AAPL | Stock | 11.4511 | 11.4675 | 11.4254 | 11.4337 | 26152028.0 |
| 2010-12-06 11:30:00 | AAPL | Stock | 11.4343 | 11.4418 | 11.4111 | 11.4279 | 25280556.0 |
| 2010-12-06 12:00:00 | AAPL | Stock | 11.4282 | 11.4386 | 11.4132 | 11.4254 | 14680596.0 |
| 2010-12-06 12:30:00 | AAPL | Stock | 11.4254 | 11.435 | 11.395 | 11.42 | 17118556.0 |
| 2010-12-06 13:00:00 | AAPL | Stock | 11.4196 | 11.4375 | 11.4114 | 11.4282 | 13256684.0 |
| 2010-12-06 13:30:00 | AAPL | Stock | 11.4279 | 11.4514 | 11.4257 | 11.4375 | 16102968.0 |
| 2010-12-06 14:00:00 | AAPL | Stock | 11.4375 | 11.4405 | 11.4161 | 11.4193 | 14711872.0 |
| 2010-12-06 14:30:00 | AAPL | Stock | 11.4193 | 11.46 | 11.4179 | 11.4429 | 20932240.0 |
| 2010-12-06 15:00:00 | AAPL | Stock | 11.4429 | 11.4679 | 11.4404 | 11.4557 | 22018864.0 |
| 2010-12-06 15:30:00 | AAPL | Stock | 11.4564 | 11.4621 | 11.4214 | 11.4346 | 38812984.0 |
| 2010-12-06 16:00:00 | AAPL | Stock | 11.4364 | 11.4479 | 11.3393 | 11.4279 | 6542368.0 |
| 2010-12-06 16:30:00 | AAPL | Stock | 11.425 | 11.4551 | 11.3721 | 11.4314 | 243236.0 |
| 2010-12-06 17:00:00 | AAPL | Stock | 11.4289 | 11.4329 | 11.4286 | 11.43 | 157164.0 |
| 2010-12-06 17:30:00 | AAPL | Stock | 11.4257 | 11.4371 | 11.4193 | 11.4364 | 549696.0 |
| 2010-12-06 18:00:00 | AAPL | Stock | 11.4368 | 11.4446 | 11.4339 | 11.4375 | 1160740.0 |
| 2010-12-06 18:30:00 | AAPL | Stock | 11.4429 | 11.45 | 11.4375 | 11.4418 | 601580.0 |
| 2010-12-06 19:00:00 | AAPL | Stock | 11.4429 | 11.4725 | 11.4429 | 11.4714 | 863408.0 |
| 2010-12-06 19:30:00 | AAPL | Stock | 11.4646 | 11.4646 | 11.4432 | 11.4432 | 563584.0 |
| 2010-12-06 04:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.79 | 26.79 | 530.0 |
| 2010-12-06 05:30:00 | MSFT | Stock | 26.8 | 26.8 | 26.76 | 26.76 | 700.0 |
| 2010-12-06 06:00:00 | MSFT | Stock | 26.76 | 26.76 | 26.76 | 26.76 | 200.0 |
| 2010-12-06 06:30:00 | MSFT | Stock | 26.8 | 26.8 | 26.8 | 26.8 | 3500.0 |
| 2010-12-06 07:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.9 | 26.9 | 400.0 |
| 2010-12-06 07:30:00 | MSFT | Stock | 26.92 | 26.92 | 26.92 | 26.92 | 3725.0 |
| 2010-12-06 08:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.91 | 26.92 | 3415.0 |
| 2010-12-06 08:30:00 | MSFT | Stock | 26.92 | 26.94 | 26.9 | 26.92 | 3689.0 |
| 2010-12-06 09:00:00 | MSFT | Stock | 26.96 | 26.97 | 26.91 | 26.94 | 91564.0 |
| 2010-12-06 09:30:00 | MSFT | Stock | 26.94 | 26.98 | 26.76 | 26.822 | 6449490.0 |
| 2010-12-06 10:00:00 | MSFT | Stock | 26.83 | 26.87 | 26.79 | 26.805 | 4247395.0 |
| 2010-12-06 10:30:00 | MSFT | Stock | 26.805 | 26.83 | 26.79 | 26.79 | 2592233.0 |
| 2010-12-06 11:00:00 | MSFT | Stock | 26.791 | 26.83 | 26.79 | 26.83 | 1896205.0 |
| 2010-12-06 11:30:00 | MSFT | Stock | 26.83 | 26.85 | 26.79 | 26.825 | 1945567.0 |
| 2010-12-06 12:00:00 | MSFT | Stock | 26.83 | 26.85 | 26.81 | 26.829 | 2145222.0 |
| 2010-12-06 12:30:00 | MSFT | Stock | 26.825 | 26.84 | 26.8 | 26.838 | 1220937.0 |
| 2010-12-06 13:00:00 | MSFT | Stock | 26.83 | 26.86 | 26.83 | 26.855 | 1141902.0 |
| 2010-12-06 13:30:00 | MSFT | Stock | 26.85 | 26.87 | 26.82 | 26.829 | 1251374.0 |
| 2010-12-06 14:00:00 | MSFT | Stock | 26.83 | 26.83 | 26.81 | 26.825 | 1026451.0 |
| 2010-12-06 14:30:00 | MSFT | Stock | 26.82 | 26.88 | 26.82 | 26.85 | 1561445.0 |
| 2010-12-06 15:00:00 | MSFT | Stock | 26.845 | 26.86 | 26.83 | 26.86 | 2288586.0 |
| 2010-12-06 15:30:00 | MSFT | Stock | 26.85 | 26.88 | 26.82 | 26.84 | 5491310.0 |
> showing 50 of 75,569 rows — these rows as CSV