PREVIEW / stock_5min / 2013-01-07
file: by_date/stock_5min/2013/2013-01-07.parquet size: 4.9 MB rows: 329,242 symbols: 3,480
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-01-07 04:00:00 | AAPL | Stock | 18.8214 | 18.8214 | 18.8214 | 18.8214 | 5600.0 |
| 2013-01-07 04:05:00 | AAPL | Stock | 18.7946 | 18.7946 | 18.7768 | 18.7814 | 25200.0 |
| 2013-01-07 04:10:00 | AAPL | Stock | 18.7821 | 18.7821 | 18.75 | 18.75 | 14000.0 |
| 2013-01-07 04:15:00 | AAPL | Stock | 18.7525 | 18.7679 | 18.7525 | 18.7679 | 11200.0 |
| 2013-01-07 04:20:00 | AAPL | Stock | 18.7836 | 18.7857 | 18.7836 | 18.7857 | 14000.0 |
| 2013-01-07 04:25:00 | AAPL | Stock | 18.7564 | 18.7564 | 18.7564 | 18.7564 | 2800.0 |
| 2013-01-07 04:30:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 2800.0 |
| 2013-01-07 04:55:00 | AAPL | Stock | 18.7636 | 18.7636 | 18.7636 | 18.7636 | 8400.0 |
| 2013-01-07 05:25:00 | AAPL | Stock | 18.7796 | 18.7796 | 18.7796 | 18.7796 | 10976.0 |
| 2013-01-07 05:30:00 | AAPL | Stock | 18.7796 | 18.7796 | 18.7679 | 18.7679 | 30884.0 |
| 2013-01-07 05:35:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 8400.0 |
| 2013-01-07 05:45:00 | AAPL | Stock | 18.75 | 18.75 | 18.75 | 18.75 | 8400.0 |
| 2013-01-07 05:50:00 | AAPL | Stock | 18.7429 | 18.7429 | 18.7375 | 18.7375 | 22400.0 |
| 2013-01-07 06:05:00 | AAPL | Stock | 18.7325 | 18.7325 | 18.7325 | 18.7325 | 5600.0 |
| 2013-01-07 06:10:00 | AAPL | Stock | 18.7493 | 18.7507 | 18.7464 | 18.7507 | 15400.0 |
| 2013-01-07 06:30:00 | AAPL | Stock | 18.7504 | 18.7504 | 18.7504 | 18.7504 | 5600.0 |
| 2013-01-07 07:00:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 6160.0 |
| 2013-01-07 07:05:00 | AAPL | Stock | 18.7504 | 18.7504 | 18.7504 | 18.7504 | 15120.0 |
| 2013-01-07 07:10:00 | AAPL | Stock | 18.7514 | 18.7607 | 18.7382 | 18.75 | 39200.0 |
| 2013-01-07 07:15:00 | AAPL | Stock | 18.7321 | 18.75 | 18.725 | 18.7386 | 69720.0 |
| 2013-01-07 07:20:00 | AAPL | Stock | 18.7429 | 18.7571 | 18.7321 | 18.7571 | 31108.0 |
| 2013-01-07 07:30:00 | AAPL | Stock | 18.75 | 18.75 | 18.7411 | 18.7411 | 22400.0 |
| 2013-01-07 07:35:00 | AAPL | Stock | 18.7411 | 18.7411 | 18.6786 | 18.6786 | 107744.0 |
| 2013-01-07 07:40:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.67 | 18.6711 | 108864.0 |
| 2013-01-07 07:45:00 | AAPL | Stock | 18.6614 | 18.6614 | 18.63 | 18.6421 | 186368.0 |
| 2013-01-07 07:50:00 | AAPL | Stock | 18.6286 | 18.6286 | 18.6125 | 18.6125 | 58016.0 |
| 2013-01-07 07:55:00 | AAPL | Stock | 18.6125 | 18.6418 | 18.6079 | 18.6407 | 91000.0 |
| 2013-01-07 08:00:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6089 | 18.6293 | 507948.0 |
| 2013-01-07 08:05:00 | AAPL | Stock | 18.6232 | 18.6411 | 18.6221 | 18.6411 | 180880.0 |
| 2013-01-07 08:10:00 | AAPL | Stock | 18.6382 | 18.6411 | 18.6254 | 18.6375 | 149436.0 |
| 2013-01-07 08:15:00 | AAPL | Stock | 18.6389 | 18.6946 | 18.6375 | 18.6807 | 413028.0 |
| 2013-01-07 08:20:00 | AAPL | Stock | 18.6864 | 18.6864 | 18.6629 | 18.6786 | 150108.0 |
| 2013-01-07 08:25:00 | AAPL | Stock | 18.6786 | 18.6943 | 18.6496 | 18.6496 | 160776.0 |
| 2013-01-07 08:30:00 | AAPL | Stock | 18.6511 | 18.6607 | 18.6107 | 18.6146 | 445256.0 |
| 2013-01-07 08:35:00 | AAPL | Stock | 18.6168 | 18.6407 | 18.6146 | 18.625 | 81228.0 |
| 2013-01-07 08:40:00 | AAPL | Stock | 18.6196 | 18.6196 | 18.5825 | 18.5971 | 473424.0 |
| 2013-01-07 08:45:00 | AAPL | Stock | 18.6 | 18.6036 | 18.5825 | 18.5929 | 443520.0 |
| 2013-01-07 08:50:00 | AAPL | Stock | 18.5954 | 18.625 | 18.5804 | 18.6243 | 511756.0 |
| 2013-01-07 08:55:00 | AAPL | Stock | 18.6236 | 18.6343 | 18.6079 | 18.615 | 179004.0 |
| 2013-01-07 09:00:00 | AAPL | Stock | 18.6079 | 18.625 | 18.6036 | 18.6036 | 291088.0 |
| 2013-01-07 09:05:00 | AAPL | Stock | 18.6071 | 18.6161 | 18.5961 | 18.6143 | 411908.0 |
| 2013-01-07 09:10:00 | AAPL | Stock | 18.6154 | 18.6336 | 18.6071 | 18.6146 | 295848.0 |
| 2013-01-07 09:15:00 | AAPL | Stock | 18.6179 | 18.6429 | 18.6179 | 18.6293 | 344932.0 |
| 2013-01-07 09:20:00 | AAPL | Stock | 18.6282 | 18.7321 | 18.5868 | 18.6389 | 518728.0 |
| 2013-01-07 09:25:00 | AAPL | Stock | 18.64 | 18.6607 | 18.6343 | 18.6443 | 519260.0 |
| 2013-01-07 09:30:00 | AAPL | Stock | 18.6436 | 18.6629 | 18.5568 | 18.655 | 27162324.0 |
| 2013-01-07 09:35:00 | AAPL | Stock | 18.6489 | 18.6543 | 18.4732 | 18.4832 | 19259212.0 |
| 2013-01-07 09:40:00 | AAPL | Stock | 18.4836 | 18.5125 | 18.4643 | 18.5018 | 13762700.0 |
| 2013-01-07 09:45:00 | AAPL | Stock | 18.5014 | 18.5507 | 18.4871 | 18.5086 | 10087000.0 |
| 2013-01-07 09:50:00 | AAPL | Stock | 18.5061 | 18.5121 | 18.4107 | 18.4196 | 16099720.0 |
> showing 50 of 329,242 rows — these rows as CSV