PREVIEW / stock_5min / 2014-01-27
file: by_date/stock_5min/2014/2014-01-27.parquet size: 5.8 MB rows: 374,988 symbols: 3,542
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-01-27 04:00:00 | AAPL | Stock | 19.6061 | 19.6061 | 19.6061 | 19.6061 | 16800.0 |
| 2014-01-27 04:10:00 | AAPL | Stock | 19.5989 | 19.6025 | 19.5989 | 19.6025 | 14000.0 |
| 2014-01-27 04:15:00 | AAPL | Stock | 19.6025 | 19.6068 | 19.6025 | 19.6068 | 13636.0 |
| 2014-01-27 04:30:00 | AAPL | Stock | 19.6054 | 19.6054 | 19.6054 | 19.6054 | 2800.0 |
| 2014-01-27 04:35:00 | AAPL | Stock | 19.6211 | 19.6211 | 19.6211 | 19.6211 | 4284.0 |
| 2014-01-27 04:40:00 | AAPL | Stock | 19.625 | 19.625 | 19.625 | 19.625 | 2800.0 |
| 2014-01-27 04:45:00 | AAPL | Stock | 19.6189 | 19.6189 | 19.6143 | 19.6143 | 5600.0 |
| 2014-01-27 04:50:00 | AAPL | Stock | 19.6336 | 19.6336 | 19.6336 | 19.6336 | 4200.0 |
| 2014-01-27 04:55:00 | AAPL | Stock | 19.6404 | 19.6404 | 19.6336 | 19.6336 | 26124.0 |
| 2014-01-27 05:00:00 | AAPL | Stock | 19.6361 | 19.6361 | 19.6361 | 19.6361 | 23324.0 |
| 2014-01-27 05:05:00 | AAPL | Stock | 19.6425 | 19.6425 | 19.6425 | 19.6425 | 5656.0 |
| 2014-01-27 05:10:00 | AAPL | Stock | 19.6393 | 19.6393 | 19.6393 | 19.6393 | 5600.0 |
| 2014-01-27 05:15:00 | AAPL | Stock | 19.635 | 19.635 | 19.635 | 19.635 | 2800.0 |
| 2014-01-27 05:20:00 | AAPL | Stock | 19.6257 | 19.6393 | 19.6254 | 19.6393 | 58800.0 |
| 2014-01-27 05:50:00 | AAPL | Stock | 19.62 | 19.62 | 19.6143 | 19.6189 | 50400.0 |
| 2014-01-27 06:00:00 | AAPL | Stock | 19.625 | 19.6418 | 19.625 | 19.6268 | 10024.0 |
| 2014-01-27 06:05:00 | AAPL | Stock | 19.6246 | 19.6246 | 19.6246 | 19.6246 | 2800.0 |
| 2014-01-27 06:10:00 | AAPL | Stock | 19.6221 | 19.6246 | 19.6143 | 19.6143 | 28896.0 |
| 2014-01-27 06:15:00 | AAPL | Stock | 19.6143 | 19.6246 | 19.6054 | 19.6246 | 25200.0 |
| 2014-01-27 06:30:00 | AAPL | Stock | 19.6393 | 19.6421 | 19.625 | 19.6282 | 64400.0 |
| 2014-01-27 06:35:00 | AAPL | Stock | 19.6389 | 19.6432 | 19.6389 | 19.6432 | 19376.0 |
| 2014-01-27 06:50:00 | AAPL | Stock | 19.6371 | 19.6554 | 19.6318 | 19.6554 | 43400.0 |
| 2014-01-27 06:55:00 | AAPL | Stock | 19.6732 | 19.7032 | 19.6732 | 19.7032 | 5600.0 |
| 2014-01-27 07:00:00 | AAPL | Stock | 19.6964 | 19.7107 | 19.6964 | 19.7107 | 63000.0 |
| 2014-01-27 07:05:00 | AAPL | Stock | 19.71 | 19.7104 | 19.6786 | 19.6786 | 116564.0 |
| 2014-01-27 07:10:00 | AAPL | Stock | 19.6732 | 19.6857 | 19.6696 | 19.6786 | 37296.0 |
| 2014-01-27 07:15:00 | AAPL | Stock | 19.6711 | 19.7411 | 19.6711 | 19.7411 | 191184.0 |
| 2014-01-27 07:20:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7154 | 19.7154 | 99764.0 |
| 2014-01-27 07:25:00 | AAPL | Stock | 19.7157 | 19.7304 | 19.7032 | 19.7304 | 237524.0 |
| 2014-01-27 07:30:00 | AAPL | Stock | 19.7282 | 19.7304 | 19.7143 | 19.7143 | 30800.0 |
| 2014-01-27 07:35:00 | AAPL | Stock | 19.7168 | 19.725 | 19.7157 | 19.7157 | 64484.0 |
| 2014-01-27 07:40:00 | AAPL | Stock | 19.7146 | 19.725 | 19.6857 | 19.6925 | 139244.0 |
| 2014-01-27 07:45:00 | AAPL | Stock | 19.7032 | 19.7032 | 19.6914 | 19.6914 | 6020.0 |
| 2014-01-27 07:50:00 | AAPL | Stock | 19.6961 | 19.705 | 19.6921 | 19.6921 | 107492.0 |
| 2014-01-27 07:55:00 | AAPL | Stock | 19.6914 | 19.6982 | 19.6829 | 19.6829 | 192248.0 |
| 2014-01-27 08:00:00 | AAPL | Stock | 19.6857 | 19.7321 | 19.6786 | 19.6929 | 593264.0 |
| 2014-01-27 08:05:00 | AAPL | Stock | 19.7046 | 19.7107 | 19.6811 | 19.6811 | 274428.0 |
| 2014-01-27 08:10:00 | AAPL | Stock | 19.6857 | 19.6936 | 19.6611 | 19.6686 | 222040.0 |
| 2014-01-27 08:15:00 | AAPL | Stock | 19.6732 | 19.6786 | 19.6561 | 19.6625 | 207564.0 |
| 2014-01-27 08:20:00 | AAPL | Stock | 19.6575 | 19.6743 | 19.6429 | 19.6504 | 242956.0 |
| 2014-01-27 08:25:00 | AAPL | Stock | 19.65 | 19.6525 | 19.6418 | 19.6418 | 277116.0 |
| 2014-01-27 08:30:00 | AAPL | Stock | 19.645 | 19.6607 | 19.6325 | 19.6536 | 173824.0 |
| 2014-01-27 08:35:00 | AAPL | Stock | 19.6571 | 19.6643 | 19.6571 | 19.6643 | 109508.0 |
| 2014-01-27 08:40:00 | AAPL | Stock | 19.6732 | 19.675 | 19.6586 | 19.6611 | 75600.0 |
| 2014-01-27 08:45:00 | AAPL | Stock | 19.6679 | 19.6679 | 19.6582 | 19.6635 | 65184.0 |
| 2014-01-27 08:50:00 | AAPL | Stock | 19.6525 | 19.6607 | 19.65 | 19.6532 | 69860.0 |
| 2014-01-27 08:55:00 | AAPL | Stock | 19.6532 | 19.6532 | 19.6468 | 19.6525 | 75600.0 |
| 2014-01-27 09:00:00 | AAPL | Stock | 19.6525 | 19.6646 | 19.6504 | 19.6579 | 122248.0 |
| 2014-01-27 09:05:00 | AAPL | Stock | 19.6571 | 19.6636 | 19.6571 | 19.6636 | 84280.0 |
| 2014-01-27 09:10:00 | AAPL | Stock | 19.6575 | 19.6607 | 19.6507 | 19.6593 | 137760.0 |
> showing 50 of 374,988 rows — these rows as CSV