PREVIEW / stock_5min / 2006-07-14
file: by_date/stock_5min/2006/2006-07-14.parquet size: 3.1 MB rows: 226,238 symbols: 2,304
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-07-14 07:55:00 | AAPL | Stock | 1.8643 | 1.8643 | 1.8643 | 1.8643 | 2800.0 |
| 2006-07-14 08:00:00 | AAPL | Stock | 1.8668 | 1.8668 | 1.8654 | 1.8654 | 96600.0 |
| 2006-07-14 08:05:00 | AAPL | Stock | 1.8654 | 1.8732 | 1.8654 | 1.8732 | 57400.0 |
| 2006-07-14 08:10:00 | AAPL | Stock | 1.8696 | 1.875 | 1.8654 | 1.8679 | 170800.0 |
| 2006-07-14 08:25:00 | AAPL | Stock | 1.8736 | 1.8736 | 1.8736 | 1.8736 | 22400.0 |
| 2006-07-14 08:30:00 | AAPL | Stock | 1.8721 | 1.8743 | 1.8721 | 1.8743 | 30800.0 |
| 2006-07-14 08:35:00 | AAPL | Stock | 1.8714 | 1.8714 | 1.8679 | 1.8679 | 64400.0 |
| 2006-07-14 08:45:00 | AAPL | Stock | 1.8686 | 1.8707 | 1.8686 | 1.8696 | 176372.0 |
| 2006-07-14 08:50:00 | AAPL | Stock | 1.8696 | 1.8714 | 1.8686 | 1.8686 | 28000.0 |
| 2006-07-14 08:55:00 | AAPL | Stock | 1.8711 | 1.8796 | 1.8711 | 1.8796 | 282940.0 |
| 2006-07-14 09:00:00 | AAPL | Stock | 1.8786 | 1.8786 | 1.8757 | 1.8786 | 125888.0 |
| 2006-07-14 09:05:00 | AAPL | Stock | 1.8782 | 1.8786 | 1.8782 | 1.8782 | 198072.0 |
| 2006-07-14 09:10:00 | AAPL | Stock | 1.8771 | 1.8829 | 1.8771 | 1.88 | 116144.0 |
| 2006-07-14 09:15:00 | AAPL | Stock | 1.8804 | 1.8807 | 1.88 | 1.88 | 14868.0 |
| 2006-07-14 09:20:00 | AAPL | Stock | 1.8811 | 1.8829 | 1.8811 | 1.8829 | 32732.0 |
| 2006-07-14 09:25:00 | AAPL | Stock | 1.8807 | 1.8836 | 1.8757 | 1.8761 | 946792.0 |
| 2006-07-14 09:30:00 | AAPL | Stock | 1.875 | 1.8889 | 1.8746 | 1.8854 | 21092260.0 |
| 2006-07-14 09:35:00 | AAPL | Stock | 1.8854 | 1.8854 | 1.8568 | 1.8632 | 20382292.0 |
| 2006-07-14 09:40:00 | AAPL | Stock | 1.8636 | 1.8807 | 1.8414 | 1.8604 | 36268008.0 |
| 2006-07-14 09:45:00 | AAPL | Stock | 1.8604 | 1.8604 | 1.8418 | 1.8439 | 21184016.0 |
| 2006-07-14 09:50:00 | AAPL | Stock | 1.8432 | 1.8464 | 1.8246 | 1.8282 | 29888572.0 |
| 2006-07-14 09:55:00 | AAPL | Stock | 1.8282 | 1.8379 | 1.8221 | 1.8364 | 25851420.0 |
| 2006-07-14 10:00:00 | AAPL | Stock | 1.8368 | 1.8443 | 1.8286 | 1.8304 | 22836240.0 |
| 2006-07-14 10:05:00 | AAPL | Stock | 1.8304 | 1.8364 | 1.8254 | 1.8286 | 20524868.0 |
| 2006-07-14 10:10:00 | AAPL | Stock | 1.8286 | 1.8411 | 1.8282 | 1.8286 | 19852336.0 |
| 2006-07-14 10:15:00 | AAPL | Stock | 1.8289 | 1.8343 | 1.8264 | 1.8282 | 18640916.0 |
| 2006-07-14 10:20:00 | AAPL | Stock | 1.8281 | 1.8354 | 1.825 | 1.8332 | 15436820.0 |
| 2006-07-14 10:25:00 | AAPL | Stock | 1.8332 | 1.8357 | 1.8275 | 1.8336 | 16153284.0 |
| 2006-07-14 10:30:00 | AAPL | Stock | 1.8339 | 1.8346 | 1.8293 | 1.8346 | 11657240.0 |
| 2006-07-14 10:35:00 | AAPL | Stock | 1.8346 | 1.8436 | 1.8336 | 1.8389 | 17993388.0 |
| 2006-07-14 10:40:00 | AAPL | Stock | 1.8389 | 1.8446 | 1.8361 | 1.8404 | 13707260.0 |
| 2006-07-14 10:45:00 | AAPL | Stock | 1.8407 | 1.8425 | 1.8286 | 1.8293 | 13767348.0 |
| 2006-07-14 10:50:00 | AAPL | Stock | 1.8304 | 1.835 | 1.8275 | 1.8311 | 11592476.0 |
| 2006-07-14 10:55:00 | AAPL | Stock | 1.8311 | 1.8329 | 1.8282 | 1.8296 | 10007732.0 |
| 2006-07-14 11:00:00 | AAPL | Stock | 1.8296 | 1.8318 | 1.8243 | 1.83 | 13730780.0 |
| 2006-07-14 11:05:00 | AAPL | Stock | 1.8304 | 1.8339 | 1.8293 | 1.8332 | 9385152.0 |
| 2006-07-14 11:10:00 | AAPL | Stock | 1.8332 | 1.8339 | 1.8179 | 1.8193 | 13537776.0 |
| 2006-07-14 11:15:00 | AAPL | Stock | 1.8193 | 1.8243 | 1.8193 | 1.8232 | 11278708.0 |
| 2006-07-14 11:20:00 | AAPL | Stock | 1.8232 | 1.83 | 1.8225 | 1.8293 | 8541820.0 |
| 2006-07-14 11:25:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8175 | 1.8175 | 8932980.0 |
| 2006-07-14 11:30:00 | AAPL | Stock | 1.8175 | 1.8214 | 1.81 | 1.8107 | 16754808.0 |
| 2006-07-14 11:35:00 | AAPL | Stock | 1.8107 | 1.8179 | 1.8057 | 1.8175 | 15765148.0 |
| 2006-07-14 11:40:00 | AAPL | Stock | 1.8171 | 1.8239 | 1.8168 | 1.8211 | 11247460.0 |
| 2006-07-14 11:45:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8129 | 1.8136 | 8075788.0 |
| 2006-07-14 11:50:00 | AAPL | Stock | 1.8137 | 1.8196 | 1.8079 | 1.8111 | 10378872.0 |
| 2006-07-14 11:55:00 | AAPL | Stock | 1.8114 | 1.8175 | 1.81 | 1.8175 | 10873968.0 |
| 2006-07-14 12:00:00 | AAPL | Stock | 1.8175 | 1.8207 | 1.8129 | 1.8136 | 10829924.0 |
| 2006-07-14 12:05:00 | AAPL | Stock | 1.8136 | 1.8196 | 1.8132 | 1.8185 | 7223916.0 |
| 2006-07-14 12:10:00 | AAPL | Stock | 1.8182 | 1.8193 | 1.8111 | 1.8164 | 7813232.0 |
| 2006-07-14 12:15:00 | AAPL | Stock | 1.8164 | 1.8207 | 1.8111 | 1.8207 | 12080208.0 |
> showing 50 of 226,238 rows — these rows as CSV