PREVIEW / stock_5min / 2010-08-31
file: by_date/stock_5min/2010/2010-08-31.parquet size: 4.7 MB rows: 322,902 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-31 04:45:00 | AAPL | Stock | 8.6786 | 8.6786 | 8.6786 | 8.6786 | 2800.0 |
| 2010-08-31 06:15:00 | AAPL | Stock | 8.6725 | 8.6786 | 8.6725 | 8.6786 | 5600.0 |
| 2010-08-31 06:20:00 | AAPL | Stock | 8.6714 | 8.6714 | 8.6714 | 8.6714 | 2800.0 |
| 2010-08-31 06:55:00 | AAPL | Stock | 8.6711 | 8.6711 | 8.6607 | 8.6607 | 9352.0 |
| 2010-08-31 07:00:00 | AAPL | Stock | 8.6479 | 8.6568 | 8.6479 | 8.6568 | 11788.0 |
| 2010-08-31 07:05:00 | AAPL | Stock | 8.6554 | 8.6554 | 8.6389 | 8.6389 | 22400.0 |
| 2010-08-31 07:15:00 | AAPL | Stock | 8.6439 | 8.6439 | 8.6439 | 8.6439 | 2800.0 |
| 2010-08-31 07:20:00 | AAPL | Stock | 8.645 | 8.645 | 8.6318 | 8.6321 | 84896.0 |
| 2010-08-31 07:25:00 | AAPL | Stock | 8.6218 | 8.6246 | 8.615 | 8.615 | 30800.0 |
| 2010-08-31 07:30:00 | AAPL | Stock | 8.6246 | 8.625 | 8.6246 | 8.625 | 11200.0 |
| 2010-08-31 07:50:00 | AAPL | Stock | 8.6325 | 8.6325 | 8.6325 | 8.6325 | 7980.0 |
| 2010-08-31 07:55:00 | AAPL | Stock | 8.6493 | 8.6493 | 8.6493 | 8.6493 | 2800.0 |
| 2010-08-31 08:00:00 | AAPL | Stock | 8.6396 | 8.6536 | 8.635 | 8.6429 | 183708.0 |
| 2010-08-31 08:05:00 | AAPL | Stock | 8.6418 | 8.6482 | 8.6418 | 8.6482 | 70000.0 |
| 2010-08-31 08:10:00 | AAPL | Stock | 8.6464 | 8.65 | 8.6393 | 8.6393 | 40292.0 |
| 2010-08-31 08:15:00 | AAPL | Stock | 8.635 | 8.635 | 8.6286 | 8.6286 | 29400.0 |
| 2010-08-31 08:20:00 | AAPL | Stock | 8.6314 | 8.6429 | 8.6214 | 8.63 | 357728.0 |
| 2010-08-31 08:25:00 | AAPL | Stock | 8.6296 | 8.6382 | 8.6296 | 8.6357 | 41720.0 |
| 2010-08-31 08:30:00 | AAPL | Stock | 8.6293 | 8.6321 | 8.6179 | 8.6204 | 64820.0 |
| 2010-08-31 08:35:00 | AAPL | Stock | 8.6193 | 8.6225 | 8.5946 | 8.5996 | 219016.0 |
| 2010-08-31 08:40:00 | AAPL | Stock | 8.5993 | 8.6039 | 8.5893 | 8.5893 | 232960.0 |
| 2010-08-31 08:45:00 | AAPL | Stock | 8.5929 | 8.6039 | 8.59 | 8.6018 | 289072.0 |
| 2010-08-31 08:50:00 | AAPL | Stock | 8.6107 | 8.6132 | 8.6025 | 8.6093 | 124096.0 |
| 2010-08-31 08:55:00 | AAPL | Stock | 8.6093 | 8.6161 | 8.6057 | 8.6161 | 84700.0 |
| 2010-08-31 09:00:00 | AAPL | Stock | 8.6161 | 8.635 | 8.6161 | 8.625 | 213500.0 |
| 2010-08-31 09:05:00 | AAPL | Stock | 8.6318 | 8.645 | 8.6286 | 8.6307 | 131264.0 |
| 2010-08-31 09:10:00 | AAPL | Stock | 8.6375 | 8.6536 | 8.6357 | 8.6425 | 389732.0 |
| 2010-08-31 09:15:00 | AAPL | Stock | 8.6429 | 8.6607 | 8.64 | 8.655 | 274624.0 |
| 2010-08-31 09:20:00 | AAPL | Stock | 8.6514 | 8.6568 | 8.6464 | 8.6464 | 82320.0 |
| 2010-08-31 09:25:00 | AAPL | Stock | 8.6454 | 8.6568 | 8.6264 | 8.6343 | 711368.0 |
| 2010-08-31 09:30:00 | AAPL | Stock | 8.635 | 8.6571 | 8.6161 | 8.6179 | 9760884.0 |
| 2010-08-31 09:35:00 | AAPL | Stock | 8.6186 | 8.6267 | 8.595 | 8.6111 | 11301948.0 |
| 2010-08-31 09:40:00 | AAPL | Stock | 8.6136 | 8.6246 | 8.5839 | 8.612 | 8991080.0 |
| 2010-08-31 09:45:00 | AAPL | Stock | 8.6154 | 8.6782 | 8.6054 | 8.6711 | 12930456.0 |
| 2010-08-31 09:50:00 | AAPL | Stock | 8.6721 | 8.6932 | 8.6629 | 8.6825 | 12052068.0 |
| 2010-08-31 09:55:00 | AAPL | Stock | 8.6804 | 8.6936 | 8.6596 | 8.6704 | 7546084.0 |
| 2010-08-31 10:00:00 | AAPL | Stock | 8.6718 | 8.7267 | 8.6696 | 8.7257 | 18141256.0 |
| 2010-08-31 10:05:00 | AAPL | Stock | 8.7261 | 8.7343 | 8.7046 | 8.7161 | 9015916.0 |
| 2010-08-31 10:10:00 | AAPL | Stock | 8.7168 | 8.7329 | 8.715 | 8.7179 | 8401204.0 |
| 2010-08-31 10:15:00 | AAPL | Stock | 8.7182 | 8.7286 | 8.6982 | 8.6986 | 6932632.0 |
| 2010-08-31 10:20:00 | AAPL | Stock | 8.6989 | 8.7075 | 8.6854 | 8.6857 | 4791108.0 |
| 2010-08-31 10:25:00 | AAPL | Stock | 8.6857 | 8.6993 | 8.6814 | 8.6993 | 5108544.0 |
| 2010-08-31 10:30:00 | AAPL | Stock | 8.6986 | 8.7107 | 8.6914 | 8.7014 | 4381804.0 |
| 2010-08-31 10:35:00 | AAPL | Stock | 8.7007 | 8.7018 | 8.6646 | 8.6704 | 7811720.0 |
| 2010-08-31 10:40:00 | AAPL | Stock | 8.6696 | 8.6732 | 8.6532 | 8.6721 | 5758396.0 |
| 2010-08-31 10:45:00 | AAPL | Stock | 8.6721 | 8.6721 | 8.6546 | 8.6636 | 2887640.0 |
| 2010-08-31 10:50:00 | AAPL | Stock | 8.6629 | 8.6834 | 8.6629 | 8.6682 | 4178356.0 |
| 2010-08-31 10:55:00 | AAPL | Stock | 8.6679 | 8.6768 | 8.6632 | 8.675 | 2462628.0 |
| 2010-08-31 11:00:00 | AAPL | Stock | 8.675 | 8.6807 | 8.6711 | 8.6732 | 3951248.0 |
| 2010-08-31 11:05:00 | AAPL | Stock | 8.6739 | 8.6796 | 8.6629 | 8.6643 | 3063088.0 |
> showing 50 of 322,902 rows — these rows as CSV