PREVIEW / stock_5min / 2010-12-06
file: by_date/stock_5min/2010/2010-12-06.parquet size: 4.8 MB rows: 334,417 symbols: 3,528
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-06 05:10:00 | AAPL | Stock | 11.3154 | 11.3154 | 11.3154 | 11.3154 | 2800.0 |
| 2010-12-06 06:25:00 | AAPL | Stock | 11.3332 | 11.3332 | 11.3332 | 11.3332 | 5600.0 |
| 2010-12-06 07:10:00 | AAPL | Stock | 11.3554 | 11.3571 | 11.3554 | 11.3571 | 13160.0 |
| 2010-12-06 07:15:00 | AAPL | Stock | 11.3571 | 11.3596 | 11.3568 | 11.3596 | 17640.0 |
| 2010-12-06 07:20:00 | AAPL | Stock | 11.3571 | 11.3707 | 11.3571 | 11.3707 | 15820.0 |
| 2010-12-06 07:25:00 | AAPL | Stock | 11.3689 | 11.3689 | 11.3689 | 11.3689 | 6300.0 |
| 2010-12-06 07:30:00 | AAPL | Stock | 11.3575 | 11.3621 | 11.3575 | 11.3621 | 5600.0 |
| 2010-12-06 07:40:00 | AAPL | Stock | 11.3532 | 11.3532 | 11.3532 | 11.3532 | 5824.0 |
| 2010-12-06 07:55:00 | AAPL | Stock | 11.3539 | 11.3539 | 11.35 | 11.35 | 18620.0 |
| 2010-12-06 08:00:00 | AAPL | Stock | 11.3532 | 11.3554 | 11.3432 | 11.3518 | 327880.0 |
| 2010-12-06 08:05:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3536 | 11.3536 | 76804.0 |
| 2010-12-06 08:10:00 | AAPL | Stock | 11.3536 | 11.3557 | 11.3489 | 11.3489 | 195300.0 |
| 2010-12-06 08:15:00 | AAPL | Stock | 11.35 | 11.35 | 11.3407 | 11.3464 | 305704.0 |
| 2010-12-06 08:20:00 | AAPL | Stock | 11.3464 | 11.3464 | 11.3464 | 11.3464 | 27160.0 |
| 2010-12-06 08:25:00 | AAPL | Stock | 11.3407 | 11.3443 | 11.3375 | 11.3443 | 86520.0 |
| 2010-12-06 08:30:00 | AAPL | Stock | 11.3432 | 11.3436 | 11.3293 | 11.3321 | 206220.0 |
| 2010-12-06 08:35:00 | AAPL | Stock | 11.3304 | 11.3304 | 11.3282 | 11.33 | 106960.0 |
| 2010-12-06 08:40:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3232 | 11.3254 | 187348.0 |
| 2010-12-06 08:45:00 | AAPL | Stock | 11.3279 | 11.3368 | 11.3279 | 11.3368 | 54600.0 |
| 2010-12-06 08:50:00 | AAPL | Stock | 11.3364 | 11.3468 | 11.3364 | 11.3461 | 239400.0 |
| 2010-12-06 08:55:00 | AAPL | Stock | 11.3479 | 11.3696 | 11.3479 | 11.3664 | 763112.0 |
| 2010-12-06 09:00:00 | AAPL | Stock | 11.3679 | 11.3736 | 11.3643 | 11.3671 | 500976.0 |
| 2010-12-06 09:05:00 | AAPL | Stock | 11.3668 | 11.3696 | 11.3614 | 11.3679 | 147252.0 |
| 2010-12-06 09:10:00 | AAPL | Stock | 11.3693 | 11.3782 | 11.3632 | 11.3736 | 342300.0 |
| 2010-12-06 09:15:00 | AAPL | Stock | 11.3736 | 11.3904 | 11.3736 | 11.3839 | 548660.0 |
| 2010-12-06 09:20:00 | AAPL | Stock | 11.3861 | 11.3893 | 11.3843 | 11.3882 | 162120.0 |
| 2010-12-06 09:25:00 | AAPL | Stock | 11.3857 | 11.3875 | 11.3782 | 11.3786 | 273364.0 |
| 2010-12-06 09:30:00 | AAPL | Stock | 11.3786 | 11.425 | 11.3721 | 11.419 | 25372172.0 |
| 2010-12-06 09:35:00 | AAPL | Stock | 11.4218 | 11.4321 | 11.4018 | 11.4129 | 23581208.0 |
| 2010-12-06 09:40:00 | AAPL | Stock | 11.4136 | 11.4421 | 11.4086 | 11.4386 | 16112992.0 |
| 2010-12-06 09:45:00 | AAPL | Stock | 11.4375 | 11.4604 | 11.4343 | 11.4514 | 15758316.0 |
| 2010-12-06 09:50:00 | AAPL | Stock | 11.4521 | 11.4564 | 11.4218 | 11.4457 | 11372340.0 |
| 2010-12-06 09:55:00 | AAPL | Stock | 11.4432 | 11.4643 | 11.4425 | 11.4536 | 14770896.0 |
| 2010-12-06 10:00:00 | AAPL | Stock | 11.4532 | 11.4993 | 11.4493 | 11.4954 | 23539208.0 |
| 2010-12-06 10:05:00 | AAPL | Stock | 11.4954 | 11.5089 | 11.4846 | 11.5064 | 17365516.0 |
| 2010-12-06 10:10:00 | AAPL | Stock | 11.5081 | 11.5089 | 11.4857 | 11.4962 | 10836728.0 |
| 2010-12-06 10:15:00 | AAPL | Stock | 11.4957 | 11.5068 | 11.4886 | 11.4904 | 6629000.0 |
| 2010-12-06 10:20:00 | AAPL | Stock | 11.49 | 11.5036 | 11.4829 | 11.4964 | 7860244.0 |
| 2010-12-06 10:25:00 | AAPL | Stock | 11.4986 | 11.5118 | 11.4929 | 11.5018 | 8981504.0 |
| 2010-12-06 10:30:00 | AAPL | Stock | 11.5004 | 11.5043 | 11.4868 | 11.4882 | 4957288.0 |
| 2010-12-06 10:35:00 | AAPL | Stock | 11.4889 | 11.4914 | 11.4682 | 11.4752 | 7805252.0 |
| 2010-12-06 10:40:00 | AAPL | Stock | 11.475 | 11.4804 | 11.46 | 11.4627 | 7184800.0 |
| 2010-12-06 10:45:00 | AAPL | Stock | 11.4632 | 11.4654 | 11.4475 | 11.4529 | 6940752.0 |
| 2010-12-06 10:50:00 | AAPL | Stock | 11.4529 | 11.4586 | 11.4446 | 11.4518 | 5861548.0 |
| 2010-12-06 10:55:00 | AAPL | Stock | 11.45 | 11.4604 | 11.4404 | 11.4502 | 5205284.0 |
| 2010-12-06 11:00:00 | AAPL | Stock | 11.4511 | 11.4582 | 11.4414 | 11.4482 | 4393228.0 |
| 2010-12-06 11:05:00 | AAPL | Stock | 11.4493 | 11.4675 | 11.4482 | 11.46 | 2941288.0 |
| 2010-12-06 11:10:00 | AAPL | Stock | 11.46 | 11.4629 | 11.4404 | 11.4468 | 3788316.0 |
| 2010-12-06 11:15:00 | AAPL | Stock | 11.4444 | 11.4514 | 11.4343 | 11.4407 | 3964604.0 |
| 2010-12-06 11:20:00 | AAPL | Stock | 11.4404 | 11.4441 | 11.4332 | 11.4349 | 4366712.0 |
> showing 50 of 334,417 rows — these rows as CSV