PREVIEW / stock_5min / 2013-05-17
file: by_date/stock_5min/2013/2013-05-17.parquet size: 5.0 MB rows: 330,893 symbols: 3,513
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-05-17 05:30:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 2800.0 |
| 2013-05-17 05:50:00 | AAPL | Stock | 15.5354 | 15.5357 | 15.5354 | 15.5357 | 5600.0 |
| 2013-05-17 06:05:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 5600.0 |
| 2013-05-17 06:15:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-05-17 06:25:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-05-17 06:35:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 2800.0 |
| 2013-05-17 06:40:00 | AAPL | Stock | 15.535 | 15.535 | 15.535 | 15.535 | 11200.0 |
| 2013-05-17 06:45:00 | AAPL | Stock | 15.5343 | 15.5518 | 15.5343 | 15.5518 | 26684.0 |
| 2013-05-17 06:55:00 | AAPL | Stock | 15.5861 | 15.5861 | 15.5861 | 15.5861 | 2800.0 |
| 2013-05-17 07:00:00 | AAPL | Stock | 15.5929 | 15.6036 | 15.5886 | 15.6036 | 44940.0 |
| 2013-05-17 07:05:00 | AAPL | Stock | 15.6336 | 15.6336 | 15.5971 | 15.6143 | 22456.0 |
| 2013-05-17 07:10:00 | AAPL | Stock | 15.6243 | 15.6321 | 15.6182 | 15.625 | 24640.0 |
| 2013-05-17 07:15:00 | AAPL | Stock | 15.6214 | 15.6518 | 15.6214 | 15.6393 | 108304.0 |
| 2013-05-17 07:20:00 | AAPL | Stock | 15.6411 | 15.6929 | 15.6411 | 15.6929 | 345660.0 |
| 2013-05-17 07:25:00 | AAPL | Stock | 15.6925 | 15.6979 | 15.6689 | 15.6789 | 234864.0 |
| 2013-05-17 07:30:00 | AAPL | Stock | 15.6696 | 15.6964 | 15.6607 | 15.6964 | 193564.0 |
| 2013-05-17 07:35:00 | AAPL | Stock | 15.6964 | 15.7286 | 15.6964 | 15.7214 | 281008.0 |
| 2013-05-17 07:40:00 | AAPL | Stock | 15.7307 | 15.7679 | 15.7304 | 15.7321 | 381304.0 |
| 2013-05-17 07:45:00 | AAPL | Stock | 15.7339 | 15.7357 | 15.7036 | 15.7196 | 147560.0 |
| 2013-05-17 07:50:00 | AAPL | Stock | 15.725 | 15.725 | 15.7075 | 15.7079 | 54600.0 |
| 2013-05-17 07:55:00 | AAPL | Stock | 15.7136 | 15.725 | 15.7136 | 15.725 | 63560.0 |
| 2013-05-17 08:00:00 | AAPL | Stock | 15.7161 | 15.75 | 15.6143 | 15.6964 | 534576.0 |
| 2013-05-17 08:05:00 | AAPL | Stock | 15.6964 | 15.7054 | 15.6786 | 15.6786 | 139160.0 |
| 2013-05-17 08:10:00 | AAPL | Stock | 15.6725 | 15.6857 | 15.6629 | 15.6679 | 158480.0 |
| 2013-05-17 08:15:00 | AAPL | Stock | 15.6682 | 15.6696 | 15.6682 | 15.6696 | 8400.0 |
| 2013-05-17 08:20:00 | AAPL | Stock | 15.67 | 15.6786 | 15.6689 | 15.6689 | 70560.0 |
| 2013-05-17 08:25:00 | AAPL | Stock | 15.6732 | 15.6732 | 15.6625 | 15.6714 | 22400.0 |
| 2013-05-17 08:30:00 | AAPL | Stock | 15.6718 | 15.6786 | 15.6696 | 15.6764 | 75880.0 |
| 2013-05-17 08:35:00 | AAPL | Stock | 15.6775 | 15.6786 | 15.6739 | 15.6746 | 66248.0 |
| 2013-05-17 08:40:00 | AAPL | Stock | 15.6764 | 15.6854 | 15.6718 | 15.6786 | 203728.0 |
| 2013-05-17 08:45:00 | AAPL | Stock | 15.6786 | 15.6893 | 15.6746 | 15.6886 | 110936.0 |
| 2013-05-17 08:50:00 | AAPL | Stock | 15.6893 | 15.6964 | 15.6754 | 15.6782 | 126924.0 |
| 2013-05-17 08:55:00 | AAPL | Stock | 15.6782 | 15.6814 | 15.6693 | 15.6693 | 152572.0 |
| 2013-05-17 09:00:00 | AAPL | Stock | 15.6743 | 15.6854 | 15.6607 | 15.6854 | 242228.0 |
| 2013-05-17 09:05:00 | AAPL | Stock | 15.6743 | 15.6893 | 15.6743 | 15.6825 | 149268.0 |
| 2013-05-17 09:10:00 | AAPL | Stock | 15.6854 | 15.6871 | 15.5189 | 15.6729 | 191492.0 |
| 2013-05-17 09:15:00 | AAPL | Stock | 15.6714 | 15.6732 | 15.6661 | 15.6732 | 64400.0 |
| 2013-05-17 09:20:00 | AAPL | Stock | 15.6693 | 15.6839 | 15.6693 | 15.6786 | 117488.0 |
| 2013-05-17 09:25:00 | AAPL | Stock | 15.6786 | 15.6879 | 15.6736 | 15.6736 | 655956.0 |
| 2013-05-17 09:30:00 | AAPL | Stock | 15.6804 | 15.7175 | 15.6129 | 15.6823 | 34139112.0 |
| 2013-05-17 09:35:00 | AAPL | Stock | 15.6764 | 15.6876 | 15.5621 | 15.5947 | 14130452.0 |
| 2013-05-17 09:40:00 | AAPL | Stock | 15.5939 | 15.6314 | 15.5543 | 15.5771 | 9896544.0 |
| 2013-05-17 09:45:00 | AAPL | Stock | 15.5721 | 15.5914 | 15.5414 | 15.57 | 7903644.0 |
| 2013-05-17 09:50:00 | AAPL | Stock | 15.5679 | 15.5968 | 15.5286 | 15.5929 | 9863980.0 |
| 2013-05-17 09:55:00 | AAPL | Stock | 15.5921 | 15.6464 | 15.5889 | 15.6246 | 12398176.0 |
| 2013-05-17 10:00:00 | AAPL | Stock | 15.625 | 15.6943 | 15.6207 | 15.6429 | 11005344.0 |
| 2013-05-17 10:05:00 | AAPL | Stock | 15.6437 | 15.6457 | 15.5957 | 15.6036 | 6770540.0 |
| 2013-05-17 10:10:00 | AAPL | Stock | 15.6007 | 15.6089 | 15.5536 | 15.573 | 8187872.0 |
| 2013-05-17 10:15:00 | AAPL | Stock | 15.5693 | 15.5886 | 15.5396 | 15.5886 | 8102360.0 |
| 2013-05-17 10:20:00 | AAPL | Stock | 15.5887 | 15.5993 | 15.5464 | 15.55 | 5023900.0 |
> showing 50 of 330,893 rows — these rows as CSV