PREVIEW / stock_5min / 2013-08-29
file: by_date/stock_5min/2013/2013-08-29.parquet size: 5.0 MB rows: 332,733 symbols: 3,519
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-29 04:10:00 | AAPL | Stock | 17.5821 | 17.5821 | 17.5821 | 17.5821 | 2800.0 |
| 2013-08-29 04:15:00 | AAPL | Stock | 17.5821 | 17.5821 | 17.5821 | 17.5821 | 5600.0 |
| 2013-08-29 04:40:00 | AAPL | Stock | 17.5896 | 17.5896 | 17.5896 | 17.5896 | 2800.0 |
| 2013-08-29 04:45:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 5600.0 |
| 2013-08-29 04:55:00 | AAPL | Stock | 17.6421 | 17.6464 | 17.6421 | 17.6429 | 58240.0 |
| 2013-08-29 05:25:00 | AAPL | Stock | 17.6136 | 17.6136 | 17.6136 | 17.6136 | 8400.0 |
| 2013-08-29 05:40:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 2800.0 |
| 2013-08-29 05:45:00 | AAPL | Stock | 17.5821 | 17.5821 | 17.5821 | 17.5821 | 2800.0 |
| 2013-08-29 07:00:00 | AAPL | Stock | 17.6036 | 17.6036 | 17.5964 | 17.5964 | 8400.0 |
| 2013-08-29 07:05:00 | AAPL | Stock | 17.5893 | 17.5893 | 17.5893 | 17.5893 | 16800.0 |
| 2013-08-29 07:15:00 | AAPL | Stock | 17.6057 | 17.6071 | 17.6057 | 17.6071 | 7840.0 |
| 2013-08-29 07:20:00 | AAPL | Stock | 17.6071 | 17.6171 | 17.6071 | 17.6171 | 11200.0 |
| 2013-08-29 07:25:00 | AAPL | Stock | 17.6214 | 17.6214 | 17.6171 | 17.6171 | 5600.0 |
| 2013-08-29 07:30:00 | AAPL | Stock | 17.6229 | 17.625 | 17.6229 | 17.625 | 49476.0 |
| 2013-08-29 07:35:00 | AAPL | Stock | 17.6404 | 17.6679 | 17.6404 | 17.6464 | 57540.0 |
| 2013-08-29 07:40:00 | AAPL | Stock | 17.6539 | 17.6782 | 17.6539 | 17.6714 | 36400.0 |
| 2013-08-29 07:45:00 | AAPL | Stock | 17.6782 | 17.6786 | 17.6696 | 17.6768 | 28000.0 |
| 2013-08-29 07:50:00 | AAPL | Stock | 17.6714 | 17.6714 | 17.6596 | 17.6607 | 28000.0 |
| 2013-08-29 07:55:00 | AAPL | Stock | 17.6589 | 17.6589 | 17.6589 | 17.6589 | 5320.0 |
| 2013-08-29 08:00:00 | AAPL | Stock | 17.66 | 17.6607 | 17.5893 | 17.6346 | 358960.0 |
| 2013-08-29 08:05:00 | AAPL | Stock | 17.6346 | 17.6429 | 17.625 | 17.6389 | 164640.0 |
| 2013-08-29 08:10:00 | AAPL | Stock | 17.6389 | 17.6518 | 17.6368 | 17.6507 | 133980.0 |
| 2013-08-29 08:15:00 | AAPL | Stock | 17.6536 | 17.6571 | 17.65 | 17.65 | 44044.0 |
| 2013-08-29 08:20:00 | AAPL | Stock | 17.6454 | 17.6493 | 17.6393 | 17.6393 | 53200.0 |
| 2013-08-29 08:25:00 | AAPL | Stock | 17.6386 | 17.6411 | 17.6354 | 17.6354 | 50400.0 |
| 2013-08-29 08:30:00 | AAPL | Stock | 17.6346 | 17.66 | 17.6286 | 17.6429 | 181160.0 |
| 2013-08-29 08:35:00 | AAPL | Stock | 17.6393 | 17.6429 | 17.6393 | 17.6393 | 44800.0 |
| 2013-08-29 08:40:00 | AAPL | Stock | 17.6393 | 17.6518 | 17.6393 | 17.6518 | 73388.0 |
| 2013-08-29 08:45:00 | AAPL | Stock | 17.6518 | 17.6571 | 17.6429 | 17.6429 | 139020.0 |
| 2013-08-29 08:50:00 | AAPL | Stock | 17.6461 | 17.6461 | 17.6275 | 17.6361 | 192220.0 |
| 2013-08-29 08:55:00 | AAPL | Stock | 17.635 | 17.6432 | 17.6304 | 17.6393 | 153496.0 |
| 2013-08-29 09:00:00 | AAPL | Stock | 17.6389 | 17.6389 | 17.6196 | 17.6214 | 159432.0 |
| 2013-08-29 09:05:00 | AAPL | Stock | 17.62 | 17.625 | 17.5911 | 17.6214 | 602728.0 |
| 2013-08-29 09:10:00 | AAPL | Stock | 17.6293 | 17.6425 | 17.6243 | 17.6425 | 113820.0 |
| 2013-08-29 09:15:00 | AAPL | Stock | 17.6457 | 17.6457 | 17.6179 | 17.625 | 503832.0 |
| 2013-08-29 09:20:00 | AAPL | Stock | 17.6254 | 17.6336 | 17.6221 | 17.6268 | 189672.0 |
| 2013-08-29 09:25:00 | AAPL | Stock | 17.6286 | 17.6321 | 17.5439 | 17.5582 | 669620.0 |
| 2013-08-29 09:30:00 | AAPL | Stock | 17.5661 | 17.6386 | 17.5561 | 17.638 | 11696468.0 |
| 2013-08-29 09:35:00 | AAPL | Stock | 17.6375 | 17.6929 | 17.634 | 17.6929 | 11772376.0 |
| 2013-08-29 09:40:00 | AAPL | Stock | 17.6918 | 17.7082 | 17.6463 | 17.6603 | 8232532.0 |
| 2013-08-29 09:45:00 | AAPL | Stock | 17.6611 | 17.7018 | 17.6511 | 17.6584 | 7182924.0 |
| 2013-08-29 09:50:00 | AAPL | Stock | 17.6561 | 17.6927 | 17.6504 | 17.6925 | 5370456.0 |
| 2013-08-29 09:55:00 | AAPL | Stock | 17.6929 | 17.7321 | 17.6857 | 17.7125 | 9829820.0 |
| 2013-08-29 10:00:00 | AAPL | Stock | 17.7139 | 17.7321 | 17.6875 | 17.6996 | 7931728.0 |
| 2013-08-29 10:05:00 | AAPL | Stock | 17.6986 | 17.7171 | 17.6679 | 17.6918 | 5824924.0 |
| 2013-08-29 10:10:00 | AAPL | Stock | 17.6929 | 17.6993 | 17.68 | 17.6943 | 3603824.0 |
| 2013-08-29 10:15:00 | AAPL | Stock | 17.6943 | 17.6964 | 17.6725 | 17.6832 | 2590280.0 |
| 2013-08-29 10:20:00 | AAPL | Stock | 17.6832 | 17.6875 | 17.6468 | 17.6607 | 4066356.0 |
| 2013-08-29 10:25:00 | AAPL | Stock | 17.6571 | 17.6629 | 17.6514 | 17.6582 | 2048228.0 |
| 2013-08-29 10:30:00 | AAPL | Stock | 17.6568 | 17.6761 | 17.6518 | 17.6732 | 3086048.0 |
> showing 50 of 332,733 rows — these rows as CSV