PREVIEW / stock_5min / 2011-10-25
file: by_date/stock_5min/2011/2011-10-25.parquet size: 4.8 MB rows: 320,862 symbols: 3,476
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-10-25 04:00:00 | AAPL | Stock | 14.5282 | 14.5282 | 14.5282 | 14.5282 | 2800.0 |
| 2011-10-25 04:05:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-25 04:25:00 | AAPL | Stock | 14.5179 | 14.5179 | 14.5179 | 14.5179 | 2800.0 |
| 2011-10-25 04:55:00 | AAPL | Stock | 14.5146 | 14.5146 | 14.5146 | 14.5146 | 5600.0 |
| 2011-10-25 05:55:00 | AAPL | Stock | 14.5286 | 14.5386 | 14.5286 | 14.5386 | 5600.0 |
| 2011-10-25 06:15:00 | AAPL | Stock | 14.5429 | 14.5429 | 14.5429 | 14.5429 | 2800.0 |
| 2011-10-25 06:30:00 | AAPL | Stock | 14.5446 | 14.5446 | 14.5446 | 14.5446 | 2800.0 |
| 2011-10-25 06:50:00 | AAPL | Stock | 14.5429 | 14.5429 | 14.5429 | 14.5429 | 2800.0 |
| 2011-10-25 07:00:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5296 | 14.5296 | 10920.0 |
| 2011-10-25 07:05:00 | AAPL | Stock | 14.535 | 14.535 | 14.5125 | 14.5179 | 68936.0 |
| 2011-10-25 07:10:00 | AAPL | Stock | 14.525 | 14.5286 | 14.525 | 14.5286 | 28000.0 |
| 2011-10-25 07:15:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5321 | 14.5321 | 2800.0 |
| 2011-10-25 07:20:00 | AAPL | Stock | 14.5357 | 14.5407 | 14.5357 | 14.5407 | 16940.0 |
| 2011-10-25 07:25:00 | AAPL | Stock | 14.5429 | 14.5464 | 14.5429 | 14.5464 | 16800.0 |
| 2011-10-25 07:30:00 | AAPL | Stock | 14.5429 | 14.5493 | 14.5368 | 14.5368 | 37520.0 |
| 2011-10-25 07:40:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 8400.0 |
| 2011-10-25 07:45:00 | AAPL | Stock | 14.5536 | 14.5593 | 14.5321 | 14.5321 | 27300.0 |
| 2011-10-25 07:50:00 | AAPL | Stock | 14.5321 | 14.5321 | 14.5321 | 14.5321 | 5600.0 |
| 2011-10-25 07:55:00 | AAPL | Stock | 14.5196 | 14.5318 | 14.5096 | 14.5179 | 88620.0 |
| 2011-10-25 08:00:00 | AAPL | Stock | 14.52 | 14.5696 | 14.5 | 14.5107 | 400792.0 |
| 2011-10-25 08:05:00 | AAPL | Stock | 14.5057 | 14.5143 | 14.5036 | 14.5071 | 123312.0 |
| 2011-10-25 08:10:00 | AAPL | Stock | 14.5071 | 14.5093 | 14.4921 | 14.5071 | 119000.0 |
| 2011-10-25 08:15:00 | AAPL | Stock | 14.5 | 14.5004 | 14.4554 | 14.4561 | 280308.0 |
| 2011-10-25 08:20:00 | AAPL | Stock | 14.4564 | 14.48 | 14.4564 | 14.4621 | 19600.0 |
| 2011-10-25 08:25:00 | AAPL | Stock | 14.4571 | 14.4571 | 14.4379 | 14.4429 | 152880.0 |
| 2011-10-25 08:30:00 | AAPL | Stock | 14.4536 | 14.5 | 14.4436 | 14.4643 | 241276.0 |
| 2011-10-25 08:35:00 | AAPL | Stock | 14.4693 | 14.4821 | 14.4654 | 14.4686 | 272748.0 |
| 2011-10-25 08:40:00 | AAPL | Stock | 14.4707 | 14.4786 | 14.4643 | 14.4786 | 134288.0 |
| 2011-10-25 08:45:00 | AAPL | Stock | 14.4761 | 14.4761 | 14.4571 | 14.4607 | 219800.0 |
| 2011-10-25 08:50:00 | AAPL | Stock | 14.4571 | 14.4571 | 14.4468 | 14.4486 | 92092.0 |
| 2011-10-25 08:55:00 | AAPL | Stock | 14.4564 | 14.4571 | 14.45 | 14.45 | 82320.0 |
| 2011-10-25 09:00:00 | AAPL | Stock | 14.4536 | 14.4589 | 14.4329 | 14.4329 | 444976.0 |
| 2011-10-25 09:05:00 | AAPL | Stock | 14.4389 | 14.4396 | 14.4304 | 14.4393 | 137284.0 |
| 2011-10-25 09:10:00 | AAPL | Stock | 14.4429 | 14.4482 | 14.4411 | 14.4443 | 50400.0 |
| 2011-10-25 09:15:00 | AAPL | Stock | 14.4489 | 14.4536 | 14.4411 | 14.4525 | 177716.0 |
| 2011-10-25 09:20:00 | AAPL | Stock | 14.4518 | 14.4621 | 14.4457 | 14.4621 | 142660.0 |
| 2011-10-25 09:25:00 | AAPL | Stock | 14.4625 | 14.4746 | 14.4589 | 14.4618 | 151200.0 |
| 2011-10-25 09:30:00 | AAPL | Stock | 14.465 | 14.5196 | 14.4504 | 14.48 | 18173596.0 |
| 2011-10-25 09:35:00 | AAPL | Stock | 14.4743 | 14.4893 | 14.3129 | 14.3521 | 25565512.0 |
| 2011-10-25 09:40:00 | AAPL | Stock | 14.3514 | 14.3796 | 14.3371 | 14.3514 | 14835856.0 |
| 2011-10-25 09:45:00 | AAPL | Stock | 14.3545 | 14.3839 | 14.2807 | 14.3646 | 17347232.0 |
| 2011-10-25 09:50:00 | AAPL | Stock | 14.3629 | 14.3704 | 14.3157 | 14.3532 | 10662260.0 |
| 2011-10-25 09:55:00 | AAPL | Stock | 14.3528 | 14.3839 | 14.3486 | 14.3486 | 9750188.0 |
| 2011-10-25 10:00:00 | AAPL | Stock | 14.3579 | 14.3814 | 14.3261 | 14.3446 | 9503620.0 |
| 2011-10-25 10:05:00 | AAPL | Stock | 14.3418 | 14.3646 | 14.3104 | 14.3411 | 7627928.0 |
| 2011-10-25 10:10:00 | AAPL | Stock | 14.3444 | 14.3571 | 14.3329 | 14.345 | 6101984.0 |
| 2011-10-25 10:15:00 | AAPL | Stock | 14.3425 | 14.3704 | 14.3286 | 14.3661 | 5956608.0 |
| 2011-10-25 10:20:00 | AAPL | Stock | 14.3661 | 14.3718 | 14.3432 | 14.3564 | 5531484.0 |
| 2011-10-25 10:25:00 | AAPL | Stock | 14.361 | 14.3832 | 14.3536 | 14.3589 | 4183508.0 |
| 2011-10-25 10:30:00 | AAPL | Stock | 14.3561 | 14.3664 | 14.3418 | 14.3529 | 4724384.0 |
> showing 50 of 320,862 rows — these rows as CSV