PREVIEW / stock_5min / 2010-12-10
file: by_date/stock_5min/2010/2010-12-10.parquet size: 4.8 MB rows: 333,353 symbols: 3,534
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-10 05:15:00 | AAPL | Stock | 11.4786 | 11.4786 | 11.4786 | 11.4786 | 2800.0 |
| 2010-12-10 06:35:00 | AAPL | Stock | 11.4779 | 11.4779 | 11.4779 | 11.4779 | 2800.0 |
| 2010-12-10 06:45:00 | AAPL | Stock | 11.4232 | 11.4232 | 11.42 | 11.42 | 16800.0 |
| 2010-12-10 07:15:00 | AAPL | Stock | 11.4411 | 11.4411 | 11.4286 | 11.4286 | 5600.0 |
| 2010-12-10 07:20:00 | AAPL | Stock | 11.4421 | 11.4482 | 11.4421 | 11.4482 | 5600.0 |
| 2010-12-10 07:25:00 | AAPL | Stock | 11.4286 | 11.4339 | 11.4286 | 11.4286 | 16800.0 |
| 2010-12-10 07:30:00 | AAPL | Stock | 11.4286 | 11.4464 | 11.4286 | 11.4464 | 109200.0 |
| 2010-12-10 07:35:00 | AAPL | Stock | 11.4536 | 11.4536 | 11.4536 | 11.4536 | 5600.0 |
| 2010-12-10 07:55:00 | AAPL | Stock | 11.4464 | 11.4464 | 11.4464 | 11.4464 | 2800.0 |
| 2010-12-10 08:00:00 | AAPL | Stock | 11.4464 | 11.4464 | 11.4357 | 11.4429 | 67228.0 |
| 2010-12-10 08:05:00 | AAPL | Stock | 11.4429 | 11.4482 | 11.4429 | 11.4479 | 91420.0 |
| 2010-12-10 08:10:00 | AAPL | Stock | 11.4479 | 11.4518 | 11.4436 | 11.4436 | 109900.0 |
| 2010-12-10 08:15:00 | AAPL | Stock | 11.4436 | 11.4486 | 11.4429 | 11.4461 | 61600.0 |
| 2010-12-10 08:20:00 | AAPL | Stock | 11.4457 | 11.4464 | 11.4429 | 11.4429 | 152040.0 |
| 2010-12-10 08:25:00 | AAPL | Stock | 11.4429 | 11.4432 | 11.4429 | 11.4429 | 29848.0 |
| 2010-12-10 08:30:00 | AAPL | Stock | 11.4457 | 11.4457 | 11.4393 | 11.4396 | 61180.0 |
| 2010-12-10 08:35:00 | AAPL | Stock | 11.4421 | 11.4457 | 11.4289 | 11.4339 | 320796.0 |
| 2010-12-10 08:40:00 | AAPL | Stock | 11.4357 | 11.4386 | 11.4357 | 11.4386 | 7448.0 |
| 2010-12-10 08:45:00 | AAPL | Stock | 11.4343 | 11.4357 | 11.4114 | 11.4204 | 144620.0 |
| 2010-12-10 08:50:00 | AAPL | Stock | 11.4214 | 11.4214 | 11.4061 | 11.4079 | 146748.0 |
| 2010-12-10 08:55:00 | AAPL | Stock | 11.4064 | 11.4193 | 11.4064 | 11.4071 | 191044.0 |
| 2010-12-10 09:00:00 | AAPL | Stock | 11.4071 | 11.4104 | 11.4 | 11.4025 | 72604.0 |
| 2010-12-10 09:05:00 | AAPL | Stock | 11.4018 | 11.4036 | 11.3954 | 11.3954 | 144900.0 |
| 2010-12-10 09:10:00 | AAPL | Stock | 11.3946 | 11.4 | 11.3946 | 11.3964 | 62720.0 |
| 2010-12-10 09:15:00 | AAPL | Stock | 11.3964 | 11.4104 | 11.3964 | 11.4104 | 41636.0 |
| 2010-12-10 09:20:00 | AAPL | Stock | 11.4089 | 11.4193 | 11.4054 | 11.4107 | 160132.0 |
| 2010-12-10 09:25:00 | AAPL | Stock | 11.4143 | 11.4282 | 11.4143 | 11.4143 | 40768.0 |
| 2010-12-10 09:30:00 | AAPL | Stock | 11.4143 | 11.45 | 11.4018 | 11.4386 | 10701880.0 |
| 2010-12-10 09:35:00 | AAPL | Stock | 11.4393 | 11.4421 | 11.4204 | 11.4225 | 6248340.0 |
| 2010-12-10 09:40:00 | AAPL | Stock | 11.4229 | 11.4386 | 11.4157 | 11.4259 | 5125960.0 |
| 2010-12-10 09:45:00 | AAPL | Stock | 11.4239 | 11.4264 | 11.4114 | 11.4218 | 4867128.0 |
| 2010-12-10 09:50:00 | AAPL | Stock | 11.4204 | 11.425 | 11.4143 | 11.4207 | 3333764.0 |
| 2010-12-10 09:55:00 | AAPL | Stock | 11.4186 | 11.4329 | 11.3846 | 11.3957 | 8328460.0 |
| 2010-12-10 10:00:00 | AAPL | Stock | 11.3957 | 11.4018 | 11.3786 | 11.3839 | 7062384.0 |
| 2010-12-10 10:05:00 | AAPL | Stock | 11.3864 | 11.3968 | 11.3807 | 11.3918 | 5857488.0 |
| 2010-12-10 10:10:00 | AAPL | Stock | 11.3921 | 11.3936 | 11.3814 | 11.3904 | 4265212.0 |
| 2010-12-10 10:15:00 | AAPL | Stock | 11.3882 | 11.4086 | 11.3821 | 11.4068 | 4797016.0 |
| 2010-12-10 10:20:00 | AAPL | Stock | 11.4075 | 11.4161 | 11.3986 | 11.4014 | 3299940.0 |
| 2010-12-10 10:25:00 | AAPL | Stock | 11.4027 | 11.4315 | 11.4 | 11.4236 | 4193448.0 |
| 2010-12-10 10:30:00 | AAPL | Stock | 11.4246 | 11.4357 | 11.4221 | 11.4264 | 3660216.0 |
| 2010-12-10 10:35:00 | AAPL | Stock | 11.4268 | 11.4286 | 11.415 | 11.4182 | 1903020.0 |
| 2010-12-10 10:40:00 | AAPL | Stock | 11.415 | 11.4329 | 11.4114 | 11.4243 | 3225936.0 |
| 2010-12-10 10:45:00 | AAPL | Stock | 11.4243 | 11.4296 | 11.4179 | 11.4273 | 1628620.0 |
| 2010-12-10 10:50:00 | AAPL | Stock | 11.4282 | 11.4334 | 11.4254 | 11.4272 | 1811796.0 |
| 2010-12-10 10:55:00 | AAPL | Stock | 11.4286 | 11.4304 | 11.4214 | 11.425 | 1791888.0 |
| 2010-12-10 11:00:00 | AAPL | Stock | 11.4243 | 11.4318 | 11.4232 | 11.4304 | 1399328.0 |
| 2010-12-10 11:05:00 | AAPL | Stock | 11.4304 | 11.4411 | 11.4261 | 11.4286 | 4449172.0 |
| 2010-12-10 11:10:00 | AAPL | Stock | 11.4286 | 11.4318 | 11.4254 | 11.4259 | 1837332.0 |
| 2010-12-10 11:15:00 | AAPL | Stock | 11.4264 | 11.4304 | 11.4218 | 11.4239 | 2081716.0 |
| 2010-12-10 11:20:00 | AAPL | Stock | 11.4243 | 11.4282 | 11.4157 | 11.4193 | 1980720.0 |
> showing 50 of 333,353 rows — these rows as CSV