PREVIEW / stock_30min / 2008-09-10
file: by_date/stock_30min/2008/2008-09-10.parquet size: 1.2 MB rows: 68,914 symbols: 3,314
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-10 04:00:00 | AAPL | Stock | 5.4357 | 5.4357 | 5.4357 | 5.4357 | 3444.0 |
| 2008-09-10 04:30:00 | AAPL | Stock | 5.4943 | 5.4943 | 5.4943 | 5.4943 | 2800.0 |
| 2008-09-10 05:00:00 | AAPL | Stock | 5.4736 | 5.4736 | 5.4732 | 5.4732 | 8400.0 |
| 2008-09-10 07:00:00 | AAPL | Stock | 5.4554 | 5.4925 | 5.4539 | 5.4604 | 156800.0 |
| 2008-09-10 07:30:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4429 | 5.4475 | 480088.0 |
| 2008-09-10 08:00:00 | AAPL | Stock | 5.4529 | 5.4529 | 5.4054 | 5.4357 | 1130556.0 |
| 2008-09-10 08:30:00 | AAPL | Stock | 5.4354 | 5.4543 | 5.4286 | 5.4496 | 1319220.0 |
| 2008-09-10 09:00:00 | AAPL | Stock | 5.4532 | 5.4539 | 5.4339 | 5.4457 | 531384.0 |
| 2008-09-10 09:30:00 | AAPL | Stock | 5.4457 | 5.4457 | 5.3143 | 5.3686 | 132805400.0 |
| 2008-09-10 10:00:00 | AAPL | Stock | 5.3686 | 5.4596 | 5.3561 | 5.4279 | 100194808.0 |
| 2008-09-10 10:30:00 | AAPL | Stock | 5.4279 | 5.4386 | 5.3625 | 5.3836 | 61828536.0 |
| 2008-09-10 11:00:00 | AAPL | Stock | 5.3839 | 5.4282 | 5.3671 | 5.4089 | 46716040.0 |
| 2008-09-10 11:30:00 | AAPL | Stock | 5.4086 | 5.4918 | 5.4014 | 5.4539 | 61568080.0 |
| 2008-09-10 12:00:00 | AAPL | Stock | 5.4543 | 5.5129 | 5.4536 | 5.4971 | 53954684.0 |
| 2008-09-10 12:30:00 | AAPL | Stock | 5.4979 | 5.5354 | 5.4779 | 5.4936 | 48780004.0 |
| 2008-09-10 13:00:00 | AAPL | Stock | 5.4939 | 5.5046 | 5.4489 | 5.4532 | 39066552.0 |
| 2008-09-10 13:30:00 | AAPL | Stock | 5.4529 | 5.4611 | 5.3514 | 5.3696 | 80492692.0 |
| 2008-09-10 14:00:00 | AAPL | Stock | 5.37 | 5.4464 | 5.3618 | 5.44 | 74729340.0 |
| 2008-09-10 14:30:00 | AAPL | Stock | 5.4408 | 5.4764 | 5.4221 | 5.4314 | 80851960.0 |
| 2008-09-10 15:00:00 | AAPL | Stock | 5.4314 | 5.4836 | 5.4286 | 5.4557 | 78585528.0 |
| 2008-09-10 15:30:00 | AAPL | Stock | 5.4561 | 5.4743 | 5.4061 | 5.4129 | 81577552.0 |
| 2008-09-10 16:00:00 | AAPL | Stock | 5.4117 | 5.4289 | 5.4018 | 5.4189 | 18897060.0 |
| 2008-09-10 16:30:00 | AAPL | Stock | 5.4218 | 5.425 | 5.4146 | 5.4232 | 1405516.0 |
| 2008-09-10 17:00:00 | AAPL | Stock | 5.4186 | 5.4343 | 5.4186 | 5.4286 | 154000.0 |
| 2008-09-10 17:30:00 | AAPL | Stock | 5.4314 | 5.4336 | 5.4304 | 5.4304 | 21756.0 |
| 2008-09-10 18:00:00 | AAPL | Stock | 5.4286 | 5.4314 | 5.4146 | 5.4214 | 140896.0 |
| 2008-09-10 18:30:00 | AAPL | Stock | 5.4214 | 5.4214 | 5.4161 | 5.4161 | 43932.0 |
| 2008-09-10 19:00:00 | AAPL | Stock | 5.4154 | 5.4179 | 5.4154 | 5.4179 | 11732.0 |
| 2008-09-10 19:30:00 | AAPL | Stock | 5.4182 | 5.4196 | 5.4146 | 5.4146 | 43148.0 |
| 2008-09-10 07:30:00 | MSFT | Stock | 26.24 | 26.24 | 26.24 | 26.24 | 300.0 |
| 2008-09-10 08:00:00 | MSFT | Stock | 26.24 | 26.25 | 26.16 | 26.25 | 1200.0 |
| 2008-09-10 08:30:00 | MSFT | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 800.0 |
| 2008-09-10 09:00:00 | MSFT | Stock | 26.35 | 26.56 | 26.35 | 26.55 | 129200.0 |
| 2008-09-10 09:30:00 | MSFT | Stock | 26.56 | 26.56 | 26.262 | 26.43 | 6772025.0 |
| 2008-09-10 10:00:00 | MSFT | Stock | 26.43 | 26.45 | 26.25 | 26.37 | 4437495.0 |
| 2008-09-10 10:30:00 | MSFT | Stock | 26.37 | 26.45 | 26.28 | 26.33 | 4498928.0 |
| 2008-09-10 11:00:00 | MSFT | Stock | 26.32 | 26.47 | 26.27 | 26.4 | 3043386.0 |
| 2008-09-10 11:30:00 | MSFT | Stock | 26.39 | 26.53 | 26.39 | 26.45 | 5653226.0 |
| 2008-09-10 12:00:00 | MSFT | Stock | 26.45 | 26.57 | 26.43 | 26.474 | 3284535.0 |
| 2008-09-10 12:30:00 | MSFT | Stock | 26.48 | 26.6 | 26.46 | 26.49 | 3495981.0 |
| 2008-09-10 13:00:00 | MSFT | Stock | 26.49 | 26.67 | 26.45 | 26.6 | 4628109.0 |
| 2008-09-10 13:30:00 | MSFT | Stock | 26.59 | 26.72 | 26.53 | 26.55 | 5297584.0 |
| 2008-09-10 14:00:00 | MSFT | Stock | 26.55 | 26.75 | 26.55 | 26.7 | 6013749.0 |
| 2008-09-10 14:30:00 | MSFT | Stock | 26.703 | 26.86 | 26.65 | 26.72 | 4977479.0 |
| 2008-09-10 15:00:00 | MSFT | Stock | 26.72 | 26.83 | 26.61 | 26.66 | 6516245.0 |
| 2008-09-10 15:30:00 | MSFT | Stock | 26.655 | 26.75 | 26.39 | 26.46 | 9384600.0 |
| 2008-09-10 16:00:00 | MSFT | Stock | 26.44 | 26.549 | 26.43 | 26.44 | 3470157.0 |
| 2008-09-10 16:30:00 | MSFT | Stock | 26.461 | 26.461 | 26.44 | 26.44 | 410961.0 |
| 2008-09-10 18:00:00 | MSFT | Stock | 26.47 | 26.53 | 26.44 | 26.53 | 22370.0 |
| 2008-09-10 18:30:00 | MSFT | Stock | 26.47 | 26.47 | 26.45 | 26.45 | 300.0 |
> showing 50 of 68,914 rows — these rows as CSV