PREVIEW / stock_5min / 2011-08-12
file: by_date/stock_5min/2011/2011-08-12.parquet size: 5.0 MB rows: 335,971 symbols: 3,526
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-08-12 04:00:00 | AAPL | Stock | 13.2561 | 13.2561 | 13.2561 | 13.2561 | 8400.0 |
| 2011-08-12 04:05:00 | AAPL | Stock | 13.2554 | 13.2554 | 13.2554 | 13.2554 | 2800.0 |
| 2011-08-12 04:15:00 | AAPL | Stock | 13.2304 | 13.2304 | 13.2304 | 13.2304 | 11200.0 |
| 2011-08-12 04:40:00 | AAPL | Stock | 13.2839 | 13.3036 | 13.2839 | 13.3036 | 33600.0 |
| 2011-08-12 04:50:00 | AAPL | Stock | 13.3025 | 13.3025 | 13.3 | 13.3025 | 8400.0 |
| 2011-08-12 04:55:00 | AAPL | Stock | 13.3 | 13.3025 | 13.3 | 13.3025 | 5600.0 |
| 2011-08-12 05:00:00 | AAPL | Stock | 13.3025 | 13.3025 | 13.3025 | 13.3025 | 2800.0 |
| 2011-08-12 05:35:00 | AAPL | Stock | 13.3893 | 13.3893 | 13.3893 | 13.3893 | 8400.0 |
| 2011-08-12 05:50:00 | AAPL | Stock | 13.3893 | 13.3893 | 13.3893 | 13.3893 | 14000.0 |
| 2011-08-12 06:05:00 | AAPL | Stock | 13.4136 | 13.4136 | 13.4136 | 13.4136 | 5600.0 |
| 2011-08-12 06:20:00 | AAPL | Stock | 13.3857 | 13.3857 | 13.3857 | 13.3857 | 2800.0 |
| 2011-08-12 06:25:00 | AAPL | Stock | 13.38 | 13.38 | 13.3796 | 13.3796 | 5600.0 |
| 2011-08-12 06:30:00 | AAPL | Stock | 13.3546 | 13.3546 | 13.3546 | 13.3546 | 2800.0 |
| 2011-08-12 07:00:00 | AAPL | Stock | 13.3496 | 13.3557 | 13.3464 | 13.3554 | 63000.0 |
| 2011-08-12 07:05:00 | AAPL | Stock | 13.3482 | 13.3568 | 13.3393 | 13.3454 | 134820.0 |
| 2011-08-12 07:10:00 | AAPL | Stock | 13.3446 | 13.3679 | 13.3446 | 13.3571 | 75796.0 |
| 2011-08-12 07:15:00 | AAPL | Stock | 13.3504 | 13.3571 | 13.35 | 13.3571 | 11200.0 |
| 2011-08-12 07:20:00 | AAPL | Stock | 13.3661 | 13.3736 | 13.3625 | 13.3736 | 82180.0 |
| 2011-08-12 07:25:00 | AAPL | Stock | 13.3821 | 13.4093 | 13.3789 | 13.3929 | 117880.0 |
| 2011-08-12 07:30:00 | AAPL | Stock | 13.4061 | 13.4075 | 13.3929 | 13.3929 | 36120.0 |
| 2011-08-12 07:35:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3789 | 13.3839 | 26768.0 |
| 2011-08-12 07:40:00 | AAPL | Stock | 13.3925 | 13.4179 | 13.3925 | 13.4143 | 120400.0 |
| 2011-08-12 07:45:00 | AAPL | Stock | 13.4139 | 13.4464 | 13.4 | 13.4304 | 105028.0 |
| 2011-08-12 07:50:00 | AAPL | Stock | 13.4296 | 13.4496 | 13.4264 | 13.4286 | 208152.0 |
| 2011-08-12 07:55:00 | AAPL | Stock | 13.4296 | 13.4375 | 13.4257 | 13.4375 | 72408.0 |
| 2011-08-12 08:00:00 | AAPL | Stock | 13.4411 | 13.4411 | 13.4064 | 13.4175 | 847728.0 |
| 2011-08-12 08:05:00 | AAPL | Stock | 13.4175 | 13.4286 | 13.4143 | 13.4225 | 323540.0 |
| 2011-08-12 08:10:00 | AAPL | Stock | 13.4218 | 13.4221 | 13.4146 | 13.4186 | 457100.0 |
| 2011-08-12 08:15:00 | AAPL | Stock | 13.4186 | 13.4339 | 13.4171 | 13.4293 | 252280.0 |
| 2011-08-12 08:20:00 | AAPL | Stock | 13.4289 | 13.4296 | 13.3975 | 13.3975 | 241780.0 |
| 2011-08-12 08:25:00 | AAPL | Stock | 13.3975 | 13.4125 | 13.3879 | 13.4 | 351484.0 |
| 2011-08-12 08:30:00 | AAPL | Stock | 13.4168 | 13.4804 | 13.4168 | 13.4804 | 1539076.0 |
| 2011-08-12 08:35:00 | AAPL | Stock | 13.4786 | 13.485 | 13.4293 | 13.4696 | 542752.0 |
| 2011-08-12 08:40:00 | AAPL | Stock | 13.4682 | 13.4714 | 13.4393 | 13.455 | 368704.0 |
| 2011-08-12 08:45:00 | AAPL | Stock | 13.4607 | 13.4614 | 13.4482 | 13.4557 | 206332.0 |
| 2011-08-12 08:50:00 | AAPL | Stock | 13.4571 | 13.4757 | 13.4518 | 13.4746 | 209608.0 |
| 2011-08-12 08:55:00 | AAPL | Stock | 13.4754 | 13.4761 | 13.4621 | 13.4696 | 275268.0 |
| 2011-08-12 09:00:00 | AAPL | Stock | 13.4689 | 13.4746 | 13.4536 | 13.4571 | 346668.0 |
| 2011-08-12 09:05:00 | AAPL | Stock | 13.4564 | 13.4643 | 13.4525 | 13.4643 | 231084.0 |
| 2011-08-12 09:10:00 | AAPL | Stock | 13.4643 | 13.5071 | 13.4604 | 13.5011 | 601020.0 |
| 2011-08-12 09:15:00 | AAPL | Stock | 13.5032 | 13.5079 | 13.4921 | 13.5036 | 530292.0 |
| 2011-08-12 09:20:00 | AAPL | Stock | 13.5046 | 13.5071 | 13.4954 | 13.5014 | 600180.0 |
| 2011-08-12 09:25:00 | AAPL | Stock | 13.5 | 13.5357 | 13.4971 | 13.5 | 1047844.0 |
| 2011-08-12 09:30:00 | AAPL | Stock | 13.5 | 13.5268 | 13.4536 | 13.5061 | 26000800.0 |
| 2011-08-12 09:35:00 | AAPL | Stock | 13.507 | 13.5075 | 13.4343 | 13.4636 | 17733520.0 |
| 2011-08-12 09:40:00 | AAPL | Stock | 13.4643 | 13.4804 | 13.4391 | 13.4668 | 11348876.0 |
| 2011-08-12 09:45:00 | AAPL | Stock | 13.465 | 13.4889 | 13.4557 | 13.4736 | 10405472.0 |
| 2011-08-12 09:50:00 | AAPL | Stock | 13.4749 | 13.48 | 13.42 | 13.4232 | 11504248.0 |
| 2011-08-12 09:55:00 | AAPL | Stock | 13.4232 | 13.4379 | 13.3932 | 13.4293 | 17354260.0 |
| 2011-08-12 10:00:00 | AAPL | Stock | 13.4266 | 13.4411 | 13.3771 | 13.4061 | 16071888.0 |
> showing 50 of 335,971 rows — these rows as CSV