PREVIEW / stock_5min / 2013-08-07
file: by_date/stock_5min/2013/2013-08-07.parquet size: 5.1 MB rows: 336,723 symbols: 3,503
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-07 07:15:00 | AAPL | Stock | 16.5571 | 16.5936 | 16.5571 | 16.5896 | 19600.0 |
| 2013-08-07 07:25:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5464 | 16.5464 | 16800.0 |
| 2013-08-07 07:30:00 | AAPL | Stock | 16.5643 | 16.5643 | 16.5539 | 16.5539 | 12880.0 |
| 2013-08-07 07:35:00 | AAPL | Stock | 16.5632 | 16.5632 | 16.5632 | 16.5632 | 2800.0 |
| 2013-08-07 07:40:00 | AAPL | Stock | 16.5579 | 16.5579 | 16.5543 | 16.5543 | 8400.0 |
| 2013-08-07 07:45:00 | AAPL | Stock | 16.5518 | 16.5589 | 16.5511 | 16.5589 | 11200.0 |
| 2013-08-07 07:50:00 | AAPL | Stock | 16.5586 | 16.5586 | 16.5586 | 16.5586 | 3472.0 |
| 2013-08-07 07:55:00 | AAPL | Stock | 16.5536 | 16.5625 | 16.5536 | 16.5589 | 83160.0 |
| 2013-08-07 08:00:00 | AAPL | Stock | 16.5536 | 16.5643 | 16.5482 | 16.5518 | 171472.0 |
| 2013-08-07 08:05:00 | AAPL | Stock | 16.5536 | 16.5589 | 16.5536 | 16.5589 | 152152.0 |
| 2013-08-07 08:10:00 | AAPL | Stock | 16.5607 | 16.5643 | 16.5607 | 16.5643 | 33180.0 |
| 2013-08-07 08:15:00 | AAPL | Stock | 16.5639 | 16.5711 | 16.5625 | 16.5639 | 33600.0 |
| 2013-08-07 08:20:00 | AAPL | Stock | 16.5679 | 16.5686 | 16.5679 | 16.5686 | 5600.0 |
| 2013-08-07 08:25:00 | AAPL | Stock | 16.5704 | 16.5786 | 16.5704 | 16.5729 | 41664.0 |
| 2013-08-07 08:30:00 | AAPL | Stock | 16.5746 | 16.5904 | 16.5746 | 16.5832 | 100800.0 |
| 2013-08-07 08:35:00 | AAPL | Stock | 16.5771 | 16.585 | 16.5718 | 16.5843 | 64400.0 |
| 2013-08-07 08:40:00 | AAPL | Stock | 16.5846 | 16.5871 | 16.5679 | 16.5714 | 184100.0 |
| 2013-08-07 08:45:00 | AAPL | Stock | 16.5714 | 16.5739 | 16.5582 | 16.565 | 99484.0 |
| 2013-08-07 08:50:00 | AAPL | Stock | 16.5686 | 16.5739 | 16.5625 | 16.5714 | 70560.0 |
| 2013-08-07 08:55:00 | AAPL | Stock | 16.5714 | 16.575 | 16.5714 | 16.575 | 39424.0 |
| 2013-08-07 09:00:00 | AAPL | Stock | 16.5746 | 16.575 | 16.565 | 16.5657 | 67172.0 |
| 2013-08-07 09:05:00 | AAPL | Stock | 16.5611 | 16.5679 | 16.5611 | 16.5668 | 19572.0 |
| 2013-08-07 09:10:00 | AAPL | Stock | 16.5664 | 16.5679 | 16.5593 | 16.5614 | 84000.0 |
| 2013-08-07 09:15:00 | AAPL | Stock | 16.5621 | 16.5675 | 16.5621 | 16.5646 | 50400.0 |
| 2013-08-07 09:20:00 | AAPL | Stock | 16.5646 | 16.5646 | 16.5625 | 16.5625 | 11200.0 |
| 2013-08-07 09:25:00 | AAPL | Stock | 16.5629 | 16.575 | 16.5571 | 16.5575 | 262136.0 |
| 2013-08-07 09:30:00 | AAPL | Stock | 16.5643 | 16.6005 | 16.5368 | 16.5786 | 10810016.0 |
| 2013-08-07 09:35:00 | AAPL | Stock | 16.5782 | 16.6218 | 16.5647 | 16.5779 | 8045772.0 |
| 2013-08-07 09:40:00 | AAPL | Stock | 16.5809 | 16.6107 | 16.5411 | 16.6071 | 7246680.0 |
| 2013-08-07 09:45:00 | AAPL | Stock | 16.6071 | 16.6786 | 16.6043 | 16.6532 | 9277100.0 |
| 2013-08-07 09:50:00 | AAPL | Stock | 16.657 | 16.6575 | 16.6014 | 16.6254 | 4912880.0 |
| 2013-08-07 09:55:00 | AAPL | Stock | 16.6257 | 16.6582 | 16.6071 | 16.6206 | 4826528.0 |
| 2013-08-07 10:00:00 | AAPL | Stock | 16.6204 | 16.6232 | 16.595 | 16.6179 | 4499460.0 |
| 2013-08-07 10:05:00 | AAPL | Stock | 16.6207 | 16.6293 | 16.6039 | 16.6168 | 3272500.0 |
| 2013-08-07 10:10:00 | AAPL | Stock | 16.6164 | 16.6225 | 16.5657 | 16.5757 | 4379732.0 |
| 2013-08-07 10:15:00 | AAPL | Stock | 16.5757 | 16.5829 | 16.4918 | 16.5218 | 9770152.0 |
| 2013-08-07 10:20:00 | AAPL | Stock | 16.5261 | 16.5514 | 16.5082 | 16.5371 | 4348008.0 |
| 2013-08-07 10:25:00 | AAPL | Stock | 16.5371 | 16.5464 | 16.5068 | 16.5339 | 5350240.0 |
| 2013-08-07 10:30:00 | AAPL | Stock | 16.5339 | 16.58 | 16.5261 | 16.5789 | 5674872.0 |
| 2013-08-07 10:35:00 | AAPL | Stock | 16.5773 | 16.58 | 16.5161 | 16.5218 | 7560756.0 |
| 2013-08-07 10:40:00 | AAPL | Stock | 16.5218 | 16.5428 | 16.5157 | 16.5243 | 3710952.0 |
| 2013-08-07 10:45:00 | AAPL | Stock | 16.5286 | 16.5507 | 16.525 | 16.5386 | 2359448.0 |
| 2013-08-07 10:50:00 | AAPL | Stock | 16.5379 | 16.5493 | 16.5243 | 16.5389 | 2381876.0 |
| 2013-08-07 10:55:00 | AAPL | Stock | 16.54 | 16.5707 | 16.54 | 16.5561 | 3012156.0 |
| 2013-08-07 11:00:00 | AAPL | Stock | 16.558 | 16.5642 | 16.5232 | 16.5246 | 2280992.0 |
| 2013-08-07 11:05:00 | AAPL | Stock | 16.5232 | 16.5457 | 16.5225 | 16.5404 | 2155720.0 |
| 2013-08-07 11:10:00 | AAPL | Stock | 16.5389 | 16.5504 | 16.5268 | 16.545 | 2059036.0 |
| 2013-08-07 11:15:00 | AAPL | Stock | 16.5454 | 16.5614 | 16.5389 | 16.5529 | 1452696.0 |
| 2013-08-07 11:20:00 | AAPL | Stock | 16.5529 | 16.5561 | 16.5418 | 16.5439 | 1259244.0 |
| 2013-08-07 11:25:00 | AAPL | Stock | 16.5439 | 16.5564 | 16.5371 | 16.5392 | 1453760.0 |
> showing 50 of 336,723 rows — these rows as CSV