PREVIEW / stock_5min / 2014-03-26
file: by_date/stock_5min/2014/2014-03-26.parquet size: 5.6 MB rows: 368,729 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 |
|---|---|---|---|---|---|---|---|
| 2014-03-26 05:10:00 | AAPL | Stock | 19.5257 | 19.5257 | 19.5257 | 19.5257 | 5600.0 |
| 2014-03-26 05:30:00 | AAPL | Stock | 19.4857 | 19.4857 | 19.4857 | 19.4857 | 22400.0 |
| 2014-03-26 06:15:00 | AAPL | Stock | 19.5296 | 19.5296 | 19.5296 | 19.5296 | 2800.0 |
| 2014-03-26 06:25:00 | AAPL | Stock | 19.5314 | 19.5314 | 19.5314 | 19.5314 | 2800.0 |
| 2014-03-26 06:40:00 | AAPL | Stock | 19.5286 | 19.5286 | 19.5286 | 19.5286 | 10500.0 |
| 2014-03-26 06:55:00 | AAPL | Stock | 19.5179 | 19.5218 | 19.5179 | 19.5218 | 38052.0 |
| 2014-03-26 07:00:00 | AAPL | Stock | 19.5357 | 19.5357 | 19.5357 | 19.5357 | 4760.0 |
| 2014-03-26 07:10:00 | AAPL | Stock | 19.5318 | 19.5318 | 19.5318 | 19.5318 | 2800.0 |
| 2014-03-26 07:15:00 | AAPL | Stock | 19.5318 | 19.5318 | 19.5236 | 19.5236 | 28000.0 |
| 2014-03-26 07:20:00 | AAPL | Stock | 19.5107 | 19.5107 | 19.5107 | 19.5107 | 2800.0 |
| 2014-03-26 07:25:00 | AAPL | Stock | 19.5093 | 19.5093 | 19.5011 | 19.5071 | 30800.0 |
| 2014-03-26 07:30:00 | AAPL | Stock | 19.5011 | 19.5011 | 19.4829 | 19.4989 | 25396.0 |
| 2014-03-26 07:35:00 | AAPL | Stock | 19.4989 | 19.5175 | 19.4989 | 19.5175 | 19600.0 |
| 2014-03-26 07:40:00 | AAPL | Stock | 19.5139 | 19.5139 | 19.5089 | 19.5139 | 14252.0 |
| 2014-03-26 07:45:00 | AAPL | Stock | 19.5143 | 19.5175 | 19.5089 | 19.5175 | 27748.0 |
| 2014-03-26 07:50:00 | AAPL | Stock | 19.5168 | 19.5175 | 19.5114 | 19.5175 | 22820.0 |
| 2014-03-26 07:55:00 | AAPL | Stock | 19.5214 | 19.5286 | 19.5214 | 19.5286 | 22624.0 |
| 2014-03-26 08:00:00 | AAPL | Stock | 19.5314 | 19.5425 | 19.4989 | 19.5421 | 311556.0 |
| 2014-03-26 08:05:00 | AAPL | Stock | 19.5361 | 19.5479 | 19.5361 | 19.5375 | 362488.0 |
| 2014-03-26 08:10:00 | AAPL | Stock | 19.5393 | 19.5411 | 19.5182 | 19.52 | 178332.0 |
| 2014-03-26 08:15:00 | AAPL | Stock | 19.535 | 19.535 | 19.535 | 19.535 | 19600.0 |
| 2014-03-26 08:20:00 | AAPL | Stock | 19.5232 | 19.535 | 19.5229 | 19.5286 | 41160.0 |
| 2014-03-26 08:25:00 | AAPL | Stock | 19.5221 | 19.5311 | 19.5221 | 19.5311 | 5600.0 |
| 2014-03-26 08:30:00 | AAPL | Stock | 19.5304 | 19.5304 | 19.5179 | 19.5257 | 243768.0 |
| 2014-03-26 08:35:00 | AAPL | Stock | 19.53 | 19.5396 | 19.525 | 19.5396 | 67760.0 |
| 2014-03-26 08:40:00 | AAPL | Stock | 19.5382 | 19.5404 | 19.5382 | 19.5393 | 14000.0 |
| 2014-03-26 08:45:00 | AAPL | Stock | 19.5429 | 19.5457 | 19.5357 | 19.5446 | 120848.0 |
| 2014-03-26 08:50:00 | AAPL | Stock | 19.5446 | 19.5464 | 19.5357 | 19.5357 | 219044.0 |
| 2014-03-26 08:55:00 | AAPL | Stock | 19.5357 | 19.5428 | 19.5339 | 19.5404 | 123312.0 |
| 2014-03-26 09:00:00 | AAPL | Stock | 19.5411 | 19.5475 | 19.5364 | 19.5446 | 169512.0 |
| 2014-03-26 09:05:00 | AAPL | Stock | 19.5475 | 19.55 | 19.5475 | 19.5482 | 51380.0 |
| 2014-03-26 09:10:00 | AAPL | Stock | 19.5436 | 19.5439 | 19.5407 | 19.5432 | 30800.0 |
| 2014-03-26 09:15:00 | AAPL | Stock | 19.5436 | 19.55 | 19.5404 | 19.55 | 129892.0 |
| 2014-03-26 09:20:00 | AAPL | Stock | 19.5532 | 19.5536 | 19.5468 | 19.5536 | 58744.0 |
| 2014-03-26 09:25:00 | AAPL | Stock | 19.5536 | 19.5539 | 19.52 | 19.5268 | 532868.0 |
| 2014-03-26 09:30:00 | AAPL | Stock | 19.5186 | 19.5861 | 19.5186 | 19.5693 | 13540940.0 |
| 2014-03-26 09:35:00 | AAPL | Stock | 19.5711 | 19.5711 | 19.5382 | 19.5418 | 4771788.0 |
| 2014-03-26 09:40:00 | AAPL | Stock | 19.5396 | 19.5536 | 19.5186 | 19.5475 | 3648484.0 |
| 2014-03-26 09:45:00 | AAPL | Stock | 19.5496 | 19.5793 | 19.5489 | 19.5686 | 5267248.0 |
| 2014-03-26 09:50:00 | AAPL | Stock | 19.5721 | 19.5832 | 19.5611 | 19.5714 | 5749268.0 |
| 2014-03-26 09:55:00 | AAPL | Stock | 19.5696 | 19.605 | 19.565 | 19.6046 | 4607736.0 |
| 2014-03-26 10:00:00 | AAPL | Stock | 19.6046 | 19.6071 | 19.5868 | 19.5932 | 6586860.0 |
| 2014-03-26 10:05:00 | AAPL | Stock | 19.5929 | 19.6004 | 19.5789 | 19.5921 | 2627828.0 |
| 2014-03-26 10:10:00 | AAPL | Stock | 19.5939 | 19.6029 | 19.5811 | 19.5929 | 3110632.0 |
| 2014-03-26 10:15:00 | AAPL | Stock | 19.5921 | 19.6071 | 19.5732 | 19.5904 | 3754464.0 |
| 2014-03-26 10:20:00 | AAPL | Stock | 19.5879 | 19.5893 | 19.5429 | 19.5567 | 3677072.0 |
| 2014-03-26 10:25:00 | AAPL | Stock | 19.5536 | 19.5675 | 19.54 | 19.5536 | 2894444.0 |
| 2014-03-26 10:30:00 | AAPL | Stock | 19.5511 | 19.576 | 19.5464 | 19.5689 | 2253944.0 |
| 2014-03-26 10:35:00 | AAPL | Stock | 19.5652 | 19.5821 | 19.5529 | 19.5807 | 1664908.0 |
| 2014-03-26 10:40:00 | AAPL | Stock | 19.5789 | 19.5996 | 19.5789 | 19.5854 | 2284772.0 |
> showing 50 of 368,729 rows — these rows as CSV