PREVIEW / stock_5min / 2008-07-31
file: by_date/stock_5min/2008/2008-07-31.parquet size: 4.5 MB rows: 315,278 symbols: 3,339
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-31 05:45:00 | AAPL | Stock | 5.7164 | 5.7164 | 5.7164 | 5.7164 | 2800.0 |
| 2008-07-31 06:40:00 | AAPL | Stock | 5.6929 | 5.6964 | 5.6929 | 5.6946 | 16800.0 |
| 2008-07-31 07:00:00 | AAPL | Stock | 5.6718 | 5.6718 | 5.6718 | 5.6718 | 2800.0 |
| 2008-07-31 07:05:00 | AAPL | Stock | 5.7089 | 5.7143 | 5.7089 | 5.7143 | 16800.0 |
| 2008-07-31 07:20:00 | AAPL | Stock | 5.6968 | 5.6968 | 5.6968 | 5.6968 | 14000.0 |
| 2008-07-31 07:25:00 | AAPL | Stock | 5.7107 | 5.7107 | 5.7107 | 5.7107 | 19600.0 |
| 2008-07-31 07:30:00 | AAPL | Stock | 5.7107 | 5.7168 | 5.7107 | 5.7168 | 41832.0 |
| 2008-07-31 07:35:00 | AAPL | Stock | 5.7114 | 5.7114 | 5.7114 | 5.7114 | 14000.0 |
| 2008-07-31 07:45:00 | AAPL | Stock | 5.7179 | 5.7229 | 5.7179 | 5.7229 | 28000.0 |
| 2008-07-31 08:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7096 | 5.7143 | 57008.0 |
| 2008-07-31 08:05:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.6968 | 5.7054 | 64736.0 |
| 2008-07-31 08:10:00 | AAPL | Stock | 5.6911 | 5.6929 | 5.6911 | 5.6911 | 16800.0 |
| 2008-07-31 08:15:00 | AAPL | Stock | 5.6918 | 5.6918 | 5.6918 | 5.6918 | 2800.0 |
| 2008-07-31 08:20:00 | AAPL | Stock | 5.6961 | 5.6971 | 5.6932 | 5.6971 | 24920.0 |
| 2008-07-31 08:25:00 | AAPL | Stock | 5.7 | 5.7036 | 5.6971 | 5.7018 | 66416.0 |
| 2008-07-31 08:30:00 | AAPL | Stock | 5.7018 | 5.7018 | 5.6071 | 5.625 | 1428840.0 |
| 2008-07-31 08:35:00 | AAPL | Stock | 5.6214 | 5.6429 | 5.6125 | 5.6125 | 277872.0 |
| 2008-07-31 08:40:00 | AAPL | Stock | 5.6125 | 5.6246 | 5.6121 | 5.6239 | 251888.0 |
| 2008-07-31 08:45:00 | AAPL | Stock | 5.6275 | 5.6307 | 5.6218 | 5.6307 | 95620.0 |
| 2008-07-31 08:50:00 | AAPL | Stock | 5.635 | 5.6439 | 5.6339 | 5.6379 | 210728.0 |
| 2008-07-31 08:55:00 | AAPL | Stock | 5.6336 | 5.6371 | 5.6271 | 5.6271 | 181580.0 |
| 2008-07-31 09:00:00 | AAPL | Stock | 5.6271 | 5.6307 | 5.625 | 5.625 | 116284.0 |
| 2008-07-31 09:05:00 | AAPL | Stock | 5.6268 | 5.63 | 5.6021 | 5.6025 | 729540.0 |
| 2008-07-31 09:10:00 | AAPL | Stock | 5.6025 | 5.62 | 5.6018 | 5.6111 | 639996.0 |
| 2008-07-31 09:15:00 | AAPL | Stock | 5.6107 | 5.6161 | 5.6 | 5.615 | 532840.0 |
| 2008-07-31 09:20:00 | AAPL | Stock | 5.6171 | 5.6207 | 5.6161 | 5.6182 | 53200.0 |
| 2008-07-31 09:25:00 | AAPL | Stock | 5.6196 | 5.6329 | 5.6161 | 5.6311 | 305844.0 |
| 2008-07-31 09:30:00 | AAPL | Stock | 5.6307 | 5.6339 | 5.6064 | 5.6153 | 17254440.0 |
| 2008-07-31 09:35:00 | AAPL | Stock | 5.6171 | 5.6429 | 5.6075 | 5.6204 | 16392236.0 |
| 2008-07-31 09:40:00 | AAPL | Stock | 5.62 | 5.6971 | 5.6132 | 5.6754 | 23052232.0 |
| 2008-07-31 09:45:00 | AAPL | Stock | 5.6757 | 5.6943 | 5.655 | 5.6895 | 14996324.0 |
| 2008-07-31 09:50:00 | AAPL | Stock | 5.6886 | 5.7518 | 5.6768 | 5.7264 | 26244988.0 |
| 2008-07-31 09:55:00 | AAPL | Stock | 5.7264 | 5.7321 | 5.685 | 5.6982 | 16577428.0 |
| 2008-07-31 10:00:00 | AAPL | Stock | 5.6982 | 5.7161 | 5.6921 | 5.6989 | 10533936.0 |
| 2008-07-31 10:05:00 | AAPL | Stock | 5.6993 | 5.7132 | 5.6857 | 5.6961 | 8435672.0 |
| 2008-07-31 10:10:00 | AAPL | Stock | 5.6964 | 5.7268 | 5.6893 | 5.7196 | 9177532.0 |
| 2008-07-31 10:15:00 | AAPL | Stock | 5.7193 | 5.7489 | 5.7168 | 5.7446 | 13247164.0 |
| 2008-07-31 10:20:00 | AAPL | Stock | 5.7429 | 5.7536 | 5.7321 | 5.7496 | 15495592.0 |
| 2008-07-31 10:25:00 | AAPL | Stock | 5.7489 | 5.7714 | 5.7482 | 5.7657 | 15133356.0 |
| 2008-07-31 10:30:00 | AAPL | Stock | 5.7654 | 5.7821 | 5.76 | 5.7797 | 14904904.0 |
| 2008-07-31 10:35:00 | AAPL | Stock | 5.78 | 5.7804 | 5.755 | 5.7739 | 10389344.0 |
| 2008-07-31 10:40:00 | AAPL | Stock | 5.7732 | 5.7925 | 5.7657 | 5.7843 | 12278000.0 |
| 2008-07-31 10:45:00 | AAPL | Stock | 5.7846 | 5.7929 | 5.7732 | 5.7832 | 9474304.0 |
| 2008-07-31 10:50:00 | AAPL | Stock | 5.7843 | 5.7911 | 5.7732 | 5.7764 | 7101640.0 |
| 2008-07-31 10:55:00 | AAPL | Stock | 5.7768 | 5.7804 | 5.765 | 5.775 | 8268792.0 |
| 2008-07-31 11:00:00 | AAPL | Stock | 5.7736 | 5.7771 | 5.7611 | 5.7679 | 6820660.0 |
| 2008-07-31 11:05:00 | AAPL | Stock | 5.7696 | 5.7714 | 5.7589 | 5.7596 | 4376568.0 |
| 2008-07-31 11:10:00 | AAPL | Stock | 5.7589 | 5.7632 | 5.7543 | 5.7571 | 5064668.0 |
| 2008-07-31 11:15:00 | AAPL | Stock | 5.7571 | 5.76 | 5.7518 | 5.7543 | 5514208.0 |
| 2008-07-31 11:20:00 | AAPL | Stock | 5.7546 | 5.7554 | 5.7418 | 5.7457 | 7311780.0 |
> showing 50 of 315,278 rows — these rows as CSV