PREVIEW / stock_5min / 2013-05-08
file: by_date/stock_5min/2013/2013-05-08.parquet size: 5.1 MB rows: 338,010 symbols: 3,490
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-08 04:00:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 2800.0 |
| 2013-05-08 05:25:00 | AAPL | Stock | 16.4304 | 16.4304 | 16.4304 | 16.4304 | 7728.0 |
| 2013-05-08 05:35:00 | AAPL | Stock | 16.4268 | 16.4268 | 16.4268 | 16.4268 | 2800.0 |
| 2013-05-08 05:55:00 | AAPL | Stock | 16.4161 | 16.4161 | 16.4161 | 16.4161 | 4704.0 |
| 2013-05-08 06:00:00 | AAPL | Stock | 16.42 | 16.42 | 16.42 | 16.42 | 2800.0 |
| 2013-05-08 06:10:00 | AAPL | Stock | 16.4289 | 16.4289 | 16.4289 | 16.4289 | 2800.0 |
| 2013-05-08 06:15:00 | AAPL | Stock | 16.4379 | 16.4379 | 16.4379 | 16.4379 | 2800.0 |
| 2013-05-08 06:20:00 | AAPL | Stock | 16.4429 | 16.4429 | 16.4429 | 16.4429 | 2800.0 |
| 2013-05-08 06:30:00 | AAPL | Stock | 16.4646 | 16.4646 | 16.4646 | 16.4646 | 2800.0 |
| 2013-05-08 06:40:00 | AAPL | Stock | 16.4889 | 16.4889 | 16.4889 | 16.4889 | 5376.0 |
| 2013-05-08 06:50:00 | AAPL | Stock | 16.465 | 16.465 | 16.4571 | 16.4571 | 5600.0 |
| 2013-05-08 06:55:00 | AAPL | Stock | 16.4439 | 16.4439 | 16.4432 | 16.4432 | 8400.0 |
| 2013-05-08 07:00:00 | AAPL | Stock | 16.4182 | 16.4182 | 16.4161 | 16.4161 | 5600.0 |
| 2013-05-08 07:05:00 | AAPL | Stock | 16.4282 | 16.4286 | 16.4232 | 16.4286 | 16800.0 |
| 2013-05-08 07:10:00 | AAPL | Stock | 16.4375 | 16.4436 | 16.4375 | 16.4436 | 26600.0 |
| 2013-05-08 07:15:00 | AAPL | Stock | 16.4604 | 16.4625 | 16.4604 | 16.4604 | 21000.0 |
| 2013-05-08 07:20:00 | AAPL | Stock | 16.4632 | 16.4725 | 16.4525 | 16.4725 | 35504.0 |
| 2013-05-08 07:25:00 | AAPL | Stock | 16.4786 | 16.4821 | 16.4696 | 16.4696 | 122416.0 |
| 2013-05-08 07:30:00 | AAPL | Stock | 16.4804 | 16.4821 | 16.4786 | 16.4821 | 31080.0 |
| 2013-05-08 07:35:00 | AAPL | Stock | 16.4893 | 16.5132 | 16.4893 | 16.5018 | 100520.0 |
| 2013-05-08 07:40:00 | AAPL | Stock | 16.5018 | 16.5018 | 16.4843 | 16.4843 | 120064.0 |
| 2013-05-08 07:45:00 | AAPL | Stock | 16.4807 | 16.4807 | 16.48 | 16.48 | 5600.0 |
| 2013-05-08 07:50:00 | AAPL | Stock | 16.4821 | 16.4904 | 16.4714 | 16.4829 | 135940.0 |
| 2013-05-08 07:55:00 | AAPL | Stock | 16.4839 | 16.4839 | 16.4468 | 16.4629 | 126980.0 |
| 2013-05-08 08:00:00 | AAPL | Stock | 16.4607 | 16.5064 | 16.4232 | 16.4768 | 304612.0 |
| 2013-05-08 08:05:00 | AAPL | Stock | 16.4764 | 16.4857 | 16.3571 | 16.4582 | 214060.0 |
| 2013-05-08 08:10:00 | AAPL | Stock | 16.4625 | 16.4639 | 16.4464 | 16.45 | 85960.0 |
| 2013-05-08 08:15:00 | AAPL | Stock | 16.4639 | 16.4643 | 16.4468 | 16.4468 | 80920.0 |
| 2013-05-08 08:20:00 | AAPL | Stock | 16.45 | 16.4532 | 16.4296 | 16.4339 | 159656.0 |
| 2013-05-08 08:25:00 | AAPL | Stock | 16.4293 | 16.4336 | 16.4225 | 16.4286 | 265860.0 |
| 2013-05-08 08:30:00 | AAPL | Stock | 16.4286 | 16.4339 | 16.4279 | 16.4286 | 327404.0 |
| 2013-05-08 08:35:00 | AAPL | Stock | 16.4289 | 16.4464 | 16.4289 | 16.4429 | 80248.0 |
| 2013-05-08 08:40:00 | AAPL | Stock | 16.4429 | 16.4461 | 16.4414 | 16.4457 | 43988.0 |
| 2013-05-08 08:45:00 | AAPL | Stock | 16.4418 | 16.4418 | 16.4286 | 16.435 | 180432.0 |
| 2013-05-08 08:50:00 | AAPL | Stock | 16.4339 | 16.4389 | 16.4286 | 16.4311 | 139300.0 |
| 2013-05-08 08:55:00 | AAPL | Stock | 16.4286 | 16.4336 | 16.4118 | 16.4121 | 275604.0 |
| 2013-05-08 09:00:00 | AAPL | Stock | 16.4164 | 16.4286 | 16.4164 | 16.4279 | 122640.0 |
| 2013-05-08 09:05:00 | AAPL | Stock | 16.4289 | 16.4289 | 16.415 | 16.4214 | 267372.0 |
| 2013-05-08 09:10:00 | AAPL | Stock | 16.4211 | 16.4211 | 16.3996 | 16.4114 | 369040.0 |
| 2013-05-08 09:15:00 | AAPL | Stock | 16.4143 | 16.4157 | 16.4 | 16.4054 | 189420.0 |
| 2013-05-08 09:20:00 | AAPL | Stock | 16.4014 | 16.4132 | 16.3929 | 16.3968 | 225540.0 |
| 2013-05-08 09:25:00 | AAPL | Stock | 16.3968 | 16.4079 | 16.3929 | 16.3932 | 196084.0 |
| 2013-05-08 09:30:00 | AAPL | Stock | 16.3943 | 16.4286 | 16.2896 | 16.29 | 17546228.0 |
| 2013-05-08 09:35:00 | AAPL | Stock | 16.29 | 16.3675 | 16.2789 | 16.3357 | 12804652.0 |
| 2013-05-08 09:40:00 | AAPL | Stock | 16.3321 | 16.3668 | 16.3039 | 16.3643 | 7941360.0 |
| 2013-05-08 09:45:00 | AAPL | Stock | 16.3668 | 16.4048 | 16.345 | 16.4022 | 9103892.0 |
| 2013-05-08 09:50:00 | AAPL | Stock | 16.3982 | 16.4461 | 16.3793 | 16.4409 | 10502576.0 |
| 2013-05-08 09:55:00 | AAPL | Stock | 16.4461 | 16.5421 | 16.4304 | 16.535 | 18703524.0 |
| 2013-05-08 10:00:00 | AAPL | Stock | 16.5375 | 16.5479 | 16.4907 | 16.5065 | 10605868.0 |
| 2013-05-08 10:05:00 | AAPL | Stock | 16.5107 | 16.5557 | 16.495 | 16.5089 | 10861620.0 |
> showing 50 of 338,010 rows — these rows as CSV