PREVIEW / stock_5min / 2013-06-07
file: by_date/stock_5min/2013/2013-06-07.parquet size: 5.0 MB rows: 333,106 symbols: 3,529
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-06-07 04:20:00 | AAPL | Stock | 15.675 | 15.675 | 15.675 | 15.675 | 8400.0 |
| 2013-06-07 05:00:00 | AAPL | Stock | 15.6514 | 15.6514 | 15.6514 | 15.6514 | 12012.0 |
| 2013-06-07 05:10:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 5600.0 |
| 2013-06-07 05:45:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 11200.0 |
| 2013-06-07 05:55:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6429 | 15.6429 | 3080.0 |
| 2013-06-07 06:15:00 | AAPL | Stock | 15.6518 | 15.6518 | 15.6518 | 15.6518 | 9800.0 |
| 2013-06-07 07:05:00 | AAPL | Stock | 15.6607 | 15.6718 | 15.6607 | 15.6625 | 30800.0 |
| 2013-06-07 07:10:00 | AAPL | Stock | 15.6718 | 15.6786 | 15.6696 | 15.6696 | 8400.0 |
| 2013-06-07 07:15:00 | AAPL | Stock | 15.6607 | 15.6607 | 15.6607 | 15.6607 | 8400.0 |
| 2013-06-07 07:20:00 | AAPL | Stock | 15.6429 | 15.6529 | 15.6429 | 15.6429 | 11200.0 |
| 2013-06-07 07:25:00 | AAPL | Stock | 15.6518 | 15.6518 | 15.65 | 15.65 | 5600.0 |
| 2013-06-07 07:35:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6357 | 15.6357 | 26992.0 |
| 2013-06-07 07:40:00 | AAPL | Stock | 15.6371 | 15.6371 | 15.6357 | 15.6357 | 11200.0 |
| 2013-06-07 07:45:00 | AAPL | Stock | 15.6339 | 15.6368 | 15.5914 | 15.6071 | 121128.0 |
| 2013-06-07 07:50:00 | AAPL | Stock | 15.6118 | 15.6118 | 15.6071 | 15.6071 | 5600.0 |
| 2013-06-07 07:55:00 | AAPL | Stock | 15.6071 | 15.6089 | 15.6071 | 15.6071 | 42000.0 |
| 2013-06-07 08:00:00 | AAPL | Stock | 15.6239 | 15.6682 | 15.6086 | 15.6243 | 253372.0 |
| 2013-06-07 08:05:00 | AAPL | Stock | 15.6189 | 15.6246 | 15.6089 | 15.6096 | 76020.0 |
| 2013-06-07 08:10:00 | AAPL | Stock | 15.6146 | 15.6318 | 15.6136 | 15.6168 | 50512.0 |
| 2013-06-07 08:15:00 | AAPL | Stock | 15.6179 | 15.6179 | 15.5893 | 15.6071 | 107212.0 |
| 2013-06-07 08:20:00 | AAPL | Stock | 15.6071 | 15.6179 | 15.5954 | 15.6064 | 56980.0 |
| 2013-06-07 08:25:00 | AAPL | Stock | 15.6057 | 15.6182 | 15.6032 | 15.6071 | 133588.0 |
| 2013-06-07 08:30:00 | AAPL | Stock | 15.6043 | 15.6589 | 15.5929 | 15.5982 | 827596.0 |
| 2013-06-07 08:35:00 | AAPL | Stock | 15.6018 | 15.6293 | 15.5868 | 15.6293 | 491036.0 |
| 2013-06-07 08:40:00 | AAPL | Stock | 15.6346 | 15.6857 | 15.6346 | 15.675 | 621040.0 |
| 2013-06-07 08:45:00 | AAPL | Stock | 15.6743 | 15.6746 | 15.6543 | 15.6643 | 464604.0 |
| 2013-06-07 08:50:00 | AAPL | Stock | 15.6589 | 15.6721 | 15.6446 | 15.6446 | 401632.0 |
| 2013-06-07 08:55:00 | AAPL | Stock | 15.6436 | 15.6589 | 15.6436 | 15.6571 | 63000.0 |
| 2013-06-07 09:00:00 | AAPL | Stock | 15.6482 | 15.6657 | 15.6482 | 15.6611 | 75320.0 |
| 2013-06-07 09:05:00 | AAPL | Stock | 15.6554 | 15.6554 | 15.6271 | 15.6296 | 210392.0 |
| 2013-06-07 09:10:00 | AAPL | Stock | 15.6282 | 15.6389 | 15.6261 | 15.6286 | 64400.0 |
| 2013-06-07 09:15:00 | AAPL | Stock | 15.6375 | 15.6386 | 15.6296 | 15.6339 | 86800.0 |
| 2013-06-07 09:20:00 | AAPL | Stock | 15.6346 | 15.6593 | 15.5936 | 15.5975 | 445172.0 |
| 2013-06-07 09:25:00 | AAPL | Stock | 15.5996 | 15.6129 | 15.5586 | 15.5789 | 818636.0 |
| 2013-06-07 09:30:00 | AAPL | Stock | 15.5936 | 15.6304 | 15.5186 | 15.5229 | 19356568.0 |
| 2013-06-07 09:35:00 | AAPL | Stock | 15.5221 | 15.5232 | 15.4696 | 15.5104 | 13828136.0 |
| 2013-06-07 09:40:00 | AAPL | Stock | 15.515 | 15.5554 | 15.4836 | 15.5529 | 9490068.0 |
| 2013-06-07 09:45:00 | AAPL | Stock | 15.5543 | 15.5543 | 15.5007 | 15.5093 | 7857976.0 |
| 2013-06-07 09:50:00 | AAPL | Stock | 15.5079 | 15.5221 | 15.4775 | 15.4775 | 8618428.0 |
| 2013-06-07 09:55:00 | AAPL | Stock | 15.4775 | 15.5096 | 15.4561 | 15.5054 | 10042984.0 |
| 2013-06-07 10:00:00 | AAPL | Stock | 15.5039 | 15.5196 | 15.4729 | 15.4991 | 8781164.0 |
| 2013-06-07 10:05:00 | AAPL | Stock | 15.4979 | 15.5018 | 15.4621 | 15.4925 | 6732852.0 |
| 2013-06-07 10:10:00 | AAPL | Stock | 15.4925 | 15.5546 | 15.4896 | 15.5511 | 8913072.0 |
| 2013-06-07 10:15:00 | AAPL | Stock | 15.5536 | 15.6103 | 15.5375 | 15.5968 | 12085220.0 |
| 2013-06-07 10:20:00 | AAPL | Stock | 15.6006 | 15.6032 | 15.565 | 15.5682 | 5056772.0 |
| 2013-06-07 10:25:00 | AAPL | Stock | 15.5671 | 15.6107 | 15.5511 | 15.5811 | 6297452.0 |
| 2013-06-07 10:30:00 | AAPL | Stock | 15.5789 | 15.6107 | 15.5675 | 15.5979 | 5247592.0 |
| 2013-06-07 10:35:00 | AAPL | Stock | 15.6042 | 15.6107 | 15.5821 | 15.6057 | 6697880.0 |
| 2013-06-07 10:40:00 | AAPL | Stock | 15.6018 | 15.6664 | 15.6007 | 15.6482 | 11512424.0 |
| 2013-06-07 10:45:00 | AAPL | Stock | 15.6482 | 15.6586 | 15.6196 | 15.6546 | 4998252.0 |
> showing 50 of 333,106 rows — these rows as CSV