PREVIEW / stock_5min / 2007-08-29
file: by_date/stock_5min/2007/2007-08-29.parquet size: 4.0 MB rows: 292,438 symbols: 3,103
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-08-29 09:30:00 | AAPL | Stock | 4.6368 | 4.6629 | 4.6264 | 4.6629 | 47992392.0 |
| 2007-08-29 09:35:00 | AAPL | Stock | 4.6618 | 4.695 | 4.6482 | 4.6832 | 54679380.0 |
| 2007-08-29 09:40:00 | AAPL | Stock | 4.6839 | 4.6893 | 4.6643 | 4.6671 | 31870412.0 |
| 2007-08-29 09:45:00 | AAPL | Stock | 4.6671 | 4.6829 | 4.6611 | 4.6757 | 19348000.0 |
| 2007-08-29 09:50:00 | AAPL | Stock | 4.6757 | 4.6857 | 4.6668 | 4.6711 | 17697036.0 |
| 2007-08-29 09:55:00 | AAPL | Stock | 4.6707 | 4.6768 | 4.6571 | 4.6729 | 17774568.0 |
| 2007-08-29 10:00:00 | AAPL | Stock | 4.6732 | 4.6764 | 4.6636 | 4.6704 | 15492568.0 |
| 2007-08-29 10:05:00 | AAPL | Stock | 4.6704 | 4.7036 | 4.6696 | 4.6939 | 32396896.0 |
| 2007-08-29 10:10:00 | AAPL | Stock | 4.6936 | 4.7093 | 4.6675 | 4.6922 | 22780884.0 |
| 2007-08-29 10:15:00 | AAPL | Stock | 4.6914 | 4.6996 | 4.6789 | 4.6854 | 18849516.0 |
| 2007-08-29 10:20:00 | AAPL | Stock | 4.6854 | 4.7064 | 4.6832 | 4.6982 | 19278252.0 |
| 2007-08-29 10:25:00 | AAPL | Stock | 4.6982 | 4.6986 | 4.6896 | 4.6954 | 8266944.0 |
| 2007-08-29 10:30:00 | AAPL | Stock | 4.6954 | 4.7007 | 4.6871 | 4.6925 | 10684856.0 |
| 2007-08-29 10:35:00 | AAPL | Stock | 4.6929 | 4.6943 | 4.6789 | 4.6857 | 9692676.0 |
| 2007-08-29 10:40:00 | AAPL | Stock | 4.6861 | 4.7036 | 4.6857 | 4.7036 | 12312776.0 |
| 2007-08-29 10:45:00 | AAPL | Stock | 4.7036 | 4.7046 | 4.6921 | 4.7007 | 9804592.0 |
| 2007-08-29 10:50:00 | AAPL | Stock | 4.7007 | 4.7304 | 4.7007 | 4.73 | 29170988.0 |
| 2007-08-29 10:55:00 | AAPL | Stock | 4.7304 | 4.7354 | 4.7236 | 4.7279 | 17953712.0 |
| 2007-08-29 11:00:00 | AAPL | Stock | 4.7282 | 4.7386 | 4.7221 | 4.7386 | 16179912.0 |
| 2007-08-29 11:05:00 | AAPL | Stock | 4.7382 | 4.7436 | 4.7321 | 4.7354 | 15736672.0 |
| 2007-08-29 11:10:00 | AAPL | Stock | 4.735 | 4.7368 | 4.7229 | 4.7271 | 12338704.0 |
| 2007-08-29 11:15:00 | AAPL | Stock | 4.7271 | 4.7289 | 4.5714 | 4.7268 | 7386652.0 |
| 2007-08-29 11:20:00 | AAPL | Stock | 4.7268 | 4.7286 | 4.7164 | 4.7166 | 11671856.0 |
| 2007-08-29 11:25:00 | AAPL | Stock | 4.7166 | 4.7279 | 4.7089 | 4.7268 | 15324848.0 |
| 2007-08-29 11:30:00 | AAPL | Stock | 4.7264 | 4.7311 | 4.7232 | 4.7264 | 7947212.0 |
| 2007-08-29 11:35:00 | AAPL | Stock | 4.7271 | 4.7432 | 4.7236 | 4.7364 | 11460484.0 |
| 2007-08-29 11:40:00 | AAPL | Stock | 4.7371 | 4.7532 | 4.7339 | 4.7461 | 16446080.0 |
| 2007-08-29 11:45:00 | AAPL | Stock | 4.7457 | 4.7568 | 4.7429 | 4.7432 | 13563536.0 |
| 2007-08-29 11:50:00 | AAPL | Stock | 4.7429 | 4.7457 | 4.7354 | 4.7364 | 7630812.0 |
| 2007-08-29 11:55:00 | AAPL | Stock | 4.7356 | 4.7482 | 4.7356 | 4.7402 | 6940696.0 |
| 2007-08-29 12:00:00 | AAPL | Stock | 4.74 | 4.7421 | 4.7325 | 4.7332 | 7649824.0 |
| 2007-08-29 12:05:00 | AAPL | Stock | 4.7325 | 4.735 | 4.7246 | 4.7286 | 8487024.0 |
| 2007-08-29 12:10:00 | AAPL | Stock | 4.7279 | 4.7314 | 4.6411 | 4.7311 | 7252756.0 |
| 2007-08-29 12:15:00 | AAPL | Stock | 4.7304 | 4.7343 | 4.7282 | 4.7321 | 4377296.0 |
| 2007-08-29 12:20:00 | AAPL | Stock | 4.7321 | 4.7389 | 4.7304 | 4.7339 | 6967324.0 |
| 2007-08-29 12:25:00 | AAPL | Stock | 4.7336 | 4.7357 | 4.7257 | 4.7336 | 6066480.0 |
| 2007-08-29 12:30:00 | AAPL | Stock | 4.7332 | 4.7334 | 4.7293 | 4.7325 | 4488092.0 |
| 2007-08-29 12:35:00 | AAPL | Stock | 4.7321 | 4.735 | 4.7186 | 4.7214 | 7139188.0 |
| 2007-08-29 12:40:00 | AAPL | Stock | 4.7214 | 4.7254 | 4.7204 | 4.7236 | 4691540.0 |
| 2007-08-29 12:45:00 | AAPL | Stock | 4.7236 | 4.7254 | 4.7182 | 4.7207 | 5155892.0 |
| 2007-08-29 12:50:00 | AAPL | Stock | 4.7204 | 4.7211 | 4.7032 | 4.7055 | 10106096.0 |
| 2007-08-29 12:55:00 | AAPL | Stock | 4.7057 | 4.7118 | 4.6979 | 4.7046 | 12052656.0 |
| 2007-08-29 13:00:00 | AAPL | Stock | 4.7039 | 4.7139 | 4.7021 | 4.7133 | 9161208.0 |
| 2007-08-29 13:05:00 | AAPL | Stock | 4.7132 | 4.7243 | 4.7118 | 4.7214 | 9746128.0 |
| 2007-08-29 13:10:00 | AAPL | Stock | 4.7211 | 4.7221 | 4.7154 | 4.7164 | 6768496.0 |
| 2007-08-29 13:15:00 | AAPL | Stock | 4.7161 | 4.7296 | 4.7161 | 4.7204 | 7434168.0 |
| 2007-08-29 13:20:00 | AAPL | Stock | 4.7204 | 4.7218 | 4.7057 | 4.7071 | 12016032.0 |
| 2007-08-29 13:25:00 | AAPL | Stock | 4.7064 | 4.7107 | 4.7018 | 4.7046 | 8395352.0 |
| 2007-08-29 13:30:00 | AAPL | Stock | 4.7043 | 4.7154 | 4.6982 | 4.7099 | 9115708.0 |
| 2007-08-29 13:35:00 | AAPL | Stock | 4.7093 | 4.7139 | 4.7024 | 4.7093 | 6820884.0 |
> showing 50 of 292,438 rows — these rows as CSV