PREVIEW / stock_5min / 2011-02-07
file: by_date/stock_5min/2011/2011-02-07.parquet size: 4.9 MB rows: 330,033 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-07 04:00:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 2800.0 |
| 2011-02-07 04:20:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 2800.0 |
| 2011-02-07 04:25:00 | AAPL | Stock | 12.4614 | 12.4643 | 12.4614 | 12.4643 | 11200.0 |
| 2011-02-07 04:30:00 | AAPL | Stock | 12.4643 | 12.49 | 12.4643 | 12.49 | 16520.0 |
| 2011-02-07 04:35:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-02-07 04:40:00 | AAPL | Stock | 12.4668 | 12.4668 | 12.4668 | 12.4668 | 2800.0 |
| 2011-02-07 04:45:00 | AAPL | Stock | 12.48 | 12.48 | 12.48 | 12.48 | 2800.0 |
| 2011-02-07 04:55:00 | AAPL | Stock | 12.4736 | 12.4736 | 12.4736 | 12.4736 | 14000.0 |
| 2011-02-07 05:05:00 | AAPL | Stock | 12.4714 | 12.4714 | 12.4714 | 12.4714 | 14000.0 |
| 2011-02-07 05:30:00 | AAPL | Stock | 12.4546 | 12.4575 | 12.4546 | 12.4575 | 5600.0 |
| 2011-02-07 06:00:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4518 | 12.4518 | 8400.0 |
| 2011-02-07 06:05:00 | AAPL | Stock | 12.4411 | 12.4411 | 12.4411 | 12.4411 | 14000.0 |
| 2011-02-07 06:45:00 | AAPL | Stock | 12.4321 | 12.4321 | 12.4321 | 12.4321 | 2800.0 |
| 2011-02-07 06:55:00 | AAPL | Stock | 12.4418 | 12.4421 | 12.4418 | 12.4421 | 11200.0 |
| 2011-02-07 07:00:00 | AAPL | Stock | 12.4429 | 12.4464 | 12.4429 | 12.445 | 22400.0 |
| 2011-02-07 07:05:00 | AAPL | Stock | 12.4446 | 12.4446 | 12.4375 | 12.4375 | 5600.0 |
| 2011-02-07 07:10:00 | AAPL | Stock | 12.4421 | 12.4464 | 12.4421 | 12.4464 | 22400.0 |
| 2011-02-07 07:15:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4364 | 12.4371 | 36736.0 |
| 2011-02-07 07:20:00 | AAPL | Stock | 12.4379 | 12.4379 | 12.4286 | 12.4286 | 15400.0 |
| 2011-02-07 07:25:00 | AAPL | Stock | 12.4246 | 12.4286 | 12.4246 | 12.4282 | 20524.0 |
| 2011-02-07 07:30:00 | AAPL | Stock | 12.4282 | 12.4282 | 12.4196 | 12.4196 | 36400.0 |
| 2011-02-07 07:35:00 | AAPL | Stock | 12.4214 | 12.4286 | 12.4214 | 12.4286 | 45500.0 |
| 2011-02-07 07:40:00 | AAPL | Stock | 12.4218 | 12.4218 | 12.4214 | 12.4214 | 16800.0 |
| 2011-02-07 07:45:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 5600.0 |
| 2011-02-07 07:50:00 | AAPL | Stock | 12.4268 | 12.4271 | 12.4111 | 12.425 | 59920.0 |
| 2011-02-07 07:55:00 | AAPL | Stock | 12.4261 | 12.4261 | 12.4214 | 12.4214 | 24780.0 |
| 2011-02-07 08:00:00 | AAPL | Stock | 12.425 | 12.4286 | 12.4143 | 12.4268 | 535332.0 |
| 2011-02-07 08:05:00 | AAPL | Stock | 12.4286 | 12.4464 | 12.4279 | 12.4454 | 493696.0 |
| 2011-02-07 08:10:00 | AAPL | Stock | 12.4439 | 12.4589 | 12.4432 | 12.4571 | 572432.0 |
| 2011-02-07 08:15:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4386 | 12.4393 | 443436.0 |
| 2011-02-07 08:20:00 | AAPL | Stock | 12.4411 | 12.4418 | 12.4357 | 12.4357 | 114800.0 |
| 2011-02-07 08:25:00 | AAPL | Stock | 12.4364 | 12.4389 | 12.4343 | 12.4382 | 80220.0 |
| 2011-02-07 08:30:00 | AAPL | Stock | 12.4386 | 12.4525 | 12.4386 | 12.4461 | 291396.0 |
| 2011-02-07 08:35:00 | AAPL | Stock | 12.4479 | 12.4525 | 12.4454 | 12.4518 | 187936.0 |
| 2011-02-07 08:40:00 | AAPL | Stock | 12.45 | 12.4571 | 12.4493 | 12.4561 | 354172.0 |
| 2011-02-07 08:45:00 | AAPL | Stock | 12.4561 | 12.4589 | 12.4464 | 12.4464 | 238532.0 |
| 2011-02-07 08:50:00 | AAPL | Stock | 12.45 | 12.4536 | 12.4486 | 12.4529 | 89600.0 |
| 2011-02-07 08:55:00 | AAPL | Stock | 12.4496 | 12.4511 | 12.4468 | 12.45 | 117880.0 |
| 2011-02-07 09:00:00 | AAPL | Stock | 12.4496 | 12.4532 | 12.4479 | 12.4479 | 49476.0 |
| 2011-02-07 09:05:00 | AAPL | Stock | 12.4511 | 12.4518 | 12.4475 | 12.45 | 122920.0 |
| 2011-02-07 09:10:00 | AAPL | Stock | 12.45 | 12.45 | 12.4482 | 12.4489 | 75404.0 |
| 2011-02-07 09:15:00 | AAPL | Stock | 12.45 | 12.45 | 12.4429 | 12.4429 | 143976.0 |
| 2011-02-07 09:20:00 | AAPL | Stock | 12.4429 | 12.4496 | 12.4411 | 12.4496 | 280000.0 |
| 2011-02-07 09:25:00 | AAPL | Stock | 12.45 | 12.45 | 12.4161 | 12.4246 | 666456.0 |
| 2011-02-07 09:30:00 | AAPL | Stock | 12.4221 | 12.4718 | 12.4154 | 12.459 | 24394048.0 |
| 2011-02-07 09:35:00 | AAPL | Stock | 12.4604 | 12.4821 | 12.4593 | 12.4718 | 12243560.0 |
| 2011-02-07 09:40:00 | AAPL | Stock | 12.4721 | 12.4921 | 12.47 | 12.4854 | 12154492.0 |
| 2011-02-07 09:45:00 | AAPL | Stock | 12.4853 | 12.4975 | 12.4821 | 12.491 | 9173584.0 |
| 2011-02-07 09:50:00 | AAPL | Stock | 12.4923 | 12.4982 | 12.4893 | 12.4906 | 7769804.0 |
| 2011-02-07 09:55:00 | AAPL | Stock | 12.4905 | 12.4986 | 12.4793 | 12.4982 | 8344112.0 |
> showing 50 of 330,033 rows — these rows as CSV