PREVIEW / stock_5min / 2007-11-08
file: by_date/stock_5min/2007/2007-11-08.parquet size: 4.6 MB rows: 324,979 symbols: 3,195
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-08 05:25:00 | AAPL | Stock | 6.6154 | 6.6154 | 6.6154 | 6.6154 | 5600.0 |
| 2007-11-08 06:10:00 | AAPL | Stock | 6.6304 | 6.6429 | 6.6304 | 6.6429 | 42000.0 |
| 2007-11-08 06:15:00 | AAPL | Stock | 6.6429 | 6.6457 | 6.6429 | 6.6457 | 8400.0 |
| 2007-11-08 06:55:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 16800.0 |
| 2007-11-08 07:00:00 | AAPL | Stock | 6.6964 | 6.7071 | 6.6964 | 6.7071 | 135800.0 |
| 2007-11-08 07:05:00 | AAPL | Stock | 6.7071 | 6.7143 | 6.7036 | 6.7036 | 139440.0 |
| 2007-11-08 07:10:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 5600.0 |
| 2007-11-08 07:15:00 | AAPL | Stock | 6.7018 | 6.7071 | 6.6986 | 6.7071 | 56000.0 |
| 2007-11-08 07:20:00 | AAPL | Stock | 6.6929 | 6.7036 | 6.6875 | 6.7036 | 81200.0 |
| 2007-11-08 07:25:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 5740.0 |
| 2007-11-08 07:30:00 | AAPL | Stock | 6.6964 | 6.7036 | 6.6964 | 6.7036 | 22540.0 |
| 2007-11-08 07:35:00 | AAPL | Stock | 6.6989 | 6.6989 | 6.6989 | 6.6989 | 5600.0 |
| 2007-11-08 07:40:00 | AAPL | Stock | 6.6954 | 6.7 | 6.6893 | 6.6893 | 131180.0 |
| 2007-11-08 07:45:00 | AAPL | Stock | 6.6804 | 6.6804 | 6.6804 | 6.6804 | 2800.0 |
| 2007-11-08 07:50:00 | AAPL | Stock | 6.6821 | 6.7232 | 6.6821 | 6.7143 | 538160.0 |
| 2007-11-08 07:55:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7054 | 6.7054 | 165200.0 |
| 2007-11-08 08:00:00 | AAPL | Stock | 6.7136 | 6.7321 | 6.6854 | 6.6882 | 1041712.0 |
| 2007-11-08 08:05:00 | AAPL | Stock | 6.6929 | 6.6964 | 6.6857 | 6.6857 | 347760.0 |
| 2007-11-08 08:10:00 | AAPL | Stock | 6.6929 | 6.7021 | 6.6882 | 6.6982 | 291144.0 |
| 2007-11-08 08:15:00 | AAPL | Stock | 6.6989 | 6.7025 | 6.6971 | 6.6979 | 182560.0 |
| 2007-11-08 08:20:00 | AAPL | Stock | 6.6979 | 6.7 | 6.6936 | 6.6954 | 149940.0 |
| 2007-11-08 08:25:00 | AAPL | Stock | 6.6961 | 6.7018 | 6.6961 | 6.7 | 110180.0 |
| 2007-11-08 08:30:00 | AAPL | Stock | 6.7018 | 6.7054 | 6.7007 | 6.7032 | 174020.0 |
| 2007-11-08 08:35:00 | AAPL | Stock | 6.7036 | 6.705 | 6.6936 | 6.6982 | 762356.0 |
| 2007-11-08 08:40:00 | AAPL | Stock | 6.6964 | 6.6968 | 6.6939 | 6.6946 | 434700.0 |
| 2007-11-08 08:45:00 | AAPL | Stock | 6.6946 | 6.6946 | 6.6839 | 6.6839 | 355068.0 |
| 2007-11-08 08:50:00 | AAPL | Stock | 6.6829 | 6.6964 | 6.6629 | 6.6721 | 738444.0 |
| 2007-11-08 08:55:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6643 | 6.6679 | 238112.0 |
| 2007-11-08 09:00:00 | AAPL | Stock | 6.6686 | 6.6843 | 6.6661 | 6.6821 | 506408.0 |
| 2007-11-08 09:05:00 | AAPL | Stock | 6.6786 | 6.6875 | 6.6786 | 6.6814 | 260764.0 |
| 2007-11-08 09:10:00 | AAPL | Stock | 6.6796 | 6.6796 | 6.6711 | 6.6739 | 226520.0 |
| 2007-11-08 09:15:00 | AAPL | Stock | 6.675 | 6.675 | 6.6725 | 6.6725 | 86520.0 |
| 2007-11-08 09:20:00 | AAPL | Stock | 6.6696 | 6.6754 | 6.6675 | 6.6679 | 278684.0 |
| 2007-11-08 09:25:00 | AAPL | Stock | 6.6689 | 6.6718 | 6.6518 | 6.6618 | 801668.0 |
| 2007-11-08 09:30:00 | AAPL | Stock | 6.6668 | 6.675 | 6.6343 | 6.6586 | 27444816.0 |
| 2007-11-08 09:35:00 | AAPL | Stock | 6.6593 | 6.6629 | 6.6186 | 6.6311 | 19208616.0 |
| 2007-11-08 09:40:00 | AAPL | Stock | 6.6304 | 6.6346 | 6.4843 | 6.4993 | 48231932.0 |
| 2007-11-08 09:45:00 | AAPL | Stock | 6.4968 | 6.5357 | 6.4471 | 6.5354 | 44849056.0 |
| 2007-11-08 09:50:00 | AAPL | Stock | 6.5343 | 6.5639 | 6.5086 | 6.5615 | 23134608.0 |
| 2007-11-08 09:55:00 | AAPL | Stock | 6.5611 | 6.6007 | 6.5432 | 6.5971 | 24944304.0 |
| 2007-11-08 10:00:00 | AAPL | Stock | 6.5986 | 6.5993 | 6.5346 | 6.5493 | 26900496.0 |
| 2007-11-08 10:05:00 | AAPL | Stock | 6.55 | 6.5618 | 6.5211 | 6.5441 | 25674656.0 |
| 2007-11-08 10:10:00 | AAPL | Stock | 6.5436 | 6.55 | 6.5061 | 6.5204 | 17984512.0 |
| 2007-11-08 10:15:00 | AAPL | Stock | 6.52 | 6.5604 | 6.5072 | 6.5589 | 18478012.0 |
| 2007-11-08 10:20:00 | AAPL | Stock | 6.5589 | 6.5889 | 6.5477 | 6.555 | 18578784.0 |
| 2007-11-08 10:25:00 | AAPL | Stock | 6.5543 | 6.5668 | 6.5229 | 6.5357 | 12432308.0 |
| 2007-11-08 10:30:00 | AAPL | Stock | 6.5354 | 6.5368 | 6.5 | 6.5131 | 18787160.0 |
| 2007-11-08 10:35:00 | AAPL | Stock | 6.5118 | 6.5339 | 6.4846 | 6.501 | 18095028.0 |
| 2007-11-08 10:40:00 | AAPL | Stock | 6.5004 | 6.5243 | 6.4932 | 6.5143 | 13671252.0 |
| 2007-11-08 10:45:00 | AAPL | Stock | 6.5154 | 6.5154 | 6.4793 | 6.4957 | 17556224.0 |
> showing 50 of 324,979 rows — these rows as CSV