PREVIEW / stock_5min / 2006-10-13
file: by_date/stock_5min/2006/2006-10-13.parquet size: 3.2 MB rows: 232,000 symbols: 2,392
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-13 07:30:00 | AAPL | Stock | 2.6843 | 2.6843 | 2.6843 | 2.6843 | 5600.0 |
| 2006-10-13 07:40:00 | AAPL | Stock | 2.6889 | 2.6896 | 2.6889 | 2.6896 | 25200.0 |
| 2006-10-13 07:45:00 | AAPL | Stock | 2.6914 | 2.6914 | 2.6896 | 2.6896 | 9240.0 |
| 2006-10-13 08:00:00 | AAPL | Stock | 2.6914 | 2.6929 | 2.6864 | 2.6875 | 94640.0 |
| 2006-10-13 08:05:00 | AAPL | Stock | 2.6875 | 2.6911 | 2.6875 | 2.6911 | 55300.0 |
| 2006-10-13 08:10:00 | AAPL | Stock | 2.6925 | 2.6932 | 2.6911 | 2.6925 | 180068.0 |
| 2006-10-13 08:15:00 | AAPL | Stock | 2.6954 | 2.7025 | 2.6954 | 2.6982 | 371196.0 |
| 2006-10-13 08:20:00 | AAPL | Stock | 2.6982 | 2.7014 | 2.6968 | 2.6968 | 410900.0 |
| 2006-10-13 08:25:00 | AAPL | Stock | 2.6975 | 2.7014 | 2.6975 | 2.7 | 141680.0 |
| 2006-10-13 08:30:00 | AAPL | Stock | 2.6982 | 2.6989 | 2.6925 | 2.6964 | 300580.0 |
| 2006-10-13 08:35:00 | AAPL | Stock | 2.6982 | 2.7011 | 2.6975 | 2.6982 | 189840.0 |
| 2006-10-13 08:40:00 | AAPL | Stock | 2.6982 | 2.6986 | 2.6964 | 2.6964 | 155400.0 |
| 2006-10-13 08:45:00 | AAPL | Stock | 2.6982 | 2.7007 | 2.6964 | 2.6986 | 464380.0 |
| 2006-10-13 08:50:00 | AAPL | Stock | 2.6982 | 2.7011 | 2.6968 | 2.6996 | 73360.0 |
| 2006-10-13 08:55:00 | AAPL | Stock | 2.6979 | 2.7 | 2.6964 | 2.7 | 149520.0 |
| 2006-10-13 09:00:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6932 | 2.6936 | 366660.0 |
| 2006-10-13 09:05:00 | AAPL | Stock | 2.6943 | 2.6964 | 2.6932 | 2.6936 | 68852.0 |
| 2006-10-13 09:10:00 | AAPL | Stock | 2.6964 | 2.7007 | 2.6964 | 2.6964 | 291312.0 |
| 2006-10-13 09:15:00 | AAPL | Stock | 2.6982 | 2.7007 | 2.6964 | 2.6964 | 181552.0 |
| 2006-10-13 09:20:00 | AAPL | Stock | 2.695 | 2.6957 | 2.6936 | 2.6957 | 91000.0 |
| 2006-10-13 09:25:00 | AAPL | Stock | 2.6936 | 2.7036 | 2.6936 | 2.6979 | 1176672.0 |
| 2006-10-13 09:30:00 | AAPL | Stock | 2.7011 | 2.7139 | 2.6996 | 2.7064 | 26894392.0 |
| 2006-10-13 09:35:00 | AAPL | Stock | 2.7061 | 2.7129 | 2.7014 | 2.7125 | 20019300.0 |
| 2006-10-13 09:40:00 | AAPL | Stock | 2.7125 | 2.7204 | 2.7125 | 2.7164 | 19363652.0 |
| 2006-10-13 09:45:00 | AAPL | Stock | 2.7161 | 2.7179 | 2.71 | 2.7157 | 14095452.0 |
| 2006-10-13 09:50:00 | AAPL | Stock | 2.7155 | 2.7179 | 2.7104 | 2.7136 | 11124624.0 |
| 2006-10-13 09:55:00 | AAPL | Stock | 2.7136 | 2.7232 | 2.7121 | 2.7211 | 12242216.0 |
| 2006-10-13 10:00:00 | AAPL | Stock | 2.7204 | 2.73 | 2.7204 | 2.7232 | 20074628.0 |
| 2006-10-13 10:05:00 | AAPL | Stock | 2.7229 | 2.7354 | 2.7225 | 2.7275 | 16516920.0 |
| 2006-10-13 10:10:00 | AAPL | Stock | 2.7275 | 2.7332 | 2.7261 | 2.7293 | 9012724.0 |
| 2006-10-13 10:15:00 | AAPL | Stock | 2.7293 | 2.7457 | 2.7293 | 2.7411 | 18719764.0 |
| 2006-10-13 10:20:00 | AAPL | Stock | 2.7414 | 2.7425 | 2.7321 | 2.7325 | 13195952.0 |
| 2006-10-13 10:25:00 | AAPL | Stock | 2.7329 | 2.7354 | 2.7311 | 2.7329 | 9805124.0 |
| 2006-10-13 10:30:00 | AAPL | Stock | 2.7327 | 2.7411 | 2.7307 | 2.7386 | 12307848.0 |
| 2006-10-13 10:35:00 | AAPL | Stock | 2.7382 | 2.7386 | 2.7318 | 2.7336 | 9163028.0 |
| 2006-10-13 10:40:00 | AAPL | Stock | 2.7332 | 2.7336 | 2.7268 | 2.7271 | 8684424.0 |
| 2006-10-13 10:45:00 | AAPL | Stock | 2.7268 | 2.7293 | 2.7236 | 2.7243 | 9611280.0 |
| 2006-10-13 10:50:00 | AAPL | Stock | 2.7243 | 2.7282 | 2.7225 | 2.7264 | 10833312.0 |
| 2006-10-13 10:55:00 | AAPL | Stock | 2.7268 | 2.7311 | 2.7257 | 2.7282 | 5079956.0 |
| 2006-10-13 11:00:00 | AAPL | Stock | 2.73 | 2.73 | 2.7182 | 2.7183 | 8748404.0 |
| 2006-10-13 11:05:00 | AAPL | Stock | 2.7189 | 2.7218 | 2.7164 | 2.7179 | 12097540.0 |
| 2006-10-13 11:10:00 | AAPL | Stock | 2.7182 | 2.7232 | 2.7146 | 2.7168 | 8991584.0 |
| 2006-10-13 11:15:00 | AAPL | Stock | 2.7164 | 2.72 | 2.7157 | 2.7186 | 5839260.0 |
| 2006-10-13 11:20:00 | AAPL | Stock | 2.7179 | 2.7186 | 2.7071 | 2.7075 | 10307332.0 |
| 2006-10-13 11:25:00 | AAPL | Stock | 2.7071 | 2.7161 | 2.7064 | 2.7139 | 8205288.0 |
| 2006-10-13 11:30:00 | AAPL | Stock | 2.7136 | 2.7186 | 2.7107 | 2.7136 | 6555808.0 |
| 2006-10-13 11:35:00 | AAPL | Stock | 2.7132 | 2.7164 | 2.7118 | 2.715 | 3213336.0 |
| 2006-10-13 11:40:00 | AAPL | Stock | 2.7146 | 2.7161 | 2.7118 | 2.7139 | 3352412.0 |
| 2006-10-13 11:45:00 | AAPL | Stock | 2.7139 | 2.7164 | 2.7125 | 2.7164 | 4158560.0 |
| 2006-10-13 11:50:00 | AAPL | Stock | 2.7164 | 2.7182 | 2.7143 | 2.7157 | 5398288.0 |
> showing 50 of 232,000 rows — these rows as CSV