PREVIEW / stock_5min / 2006-12-28
file: by_date/stock_5min/2006/2006-12-28.parquet size: 3.3 MB rows: 239,094 symbols: 2,484
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-12-28 04:50:00 | AAPL | Stock | 2.8282 | 2.8282 | 2.8282 | 2.8282 | 5600.0 |
| 2006-12-28 06:00:00 | AAPL | Stock | 2.8143 | 2.8143 | 2.8143 | 2.8143 | 28000.0 |
| 2006-12-28 06:05:00 | AAPL | Stock | 2.8232 | 2.8232 | 2.8232 | 2.8232 | 140000.0 |
| 2006-12-28 06:15:00 | AAPL | Stock | 2.8257 | 2.8257 | 2.8257 | 2.8257 | 11200.0 |
| 2006-12-28 06:20:00 | AAPL | Stock | 2.825 | 2.825 | 2.825 | 2.825 | 28000.0 |
| 2006-12-28 06:30:00 | AAPL | Stock | 2.8257 | 2.8261 | 2.8257 | 2.8261 | 11200.0 |
| 2006-12-28 06:35:00 | AAPL | Stock | 2.8257 | 2.8257 | 2.8257 | 2.8257 | 2800.0 |
| 2006-12-28 06:40:00 | AAPL | Stock | 2.8268 | 2.8268 | 2.8268 | 2.8268 | 112000.0 |
| 2006-12-28 06:50:00 | AAPL | Stock | 2.8179 | 2.8179 | 2.8179 | 2.8179 | 139636.0 |
| 2006-12-28 06:55:00 | AAPL | Stock | 2.8161 | 2.8161 | 2.8143 | 2.8143 | 114800.0 |
| 2006-12-28 07:00:00 | AAPL | Stock | 2.8161 | 2.8161 | 2.8039 | 2.8161 | 223048.0 |
| 2006-12-28 07:05:00 | AAPL | Stock | 2.8168 | 2.8168 | 2.8132 | 2.8143 | 134400.0 |
| 2006-12-28 07:10:00 | AAPL | Stock | 2.8143 | 2.8143 | 2.7932 | 2.7932 | 845656.0 |
| 2006-12-28 07:15:00 | AAPL | Stock | 2.7932 | 2.7932 | 2.7714 | 2.7714 | 611128.0 |
| 2006-12-28 07:20:00 | AAPL | Stock | 2.7754 | 2.7754 | 2.7579 | 2.775 | 1468376.0 |
| 2006-12-28 07:25:00 | AAPL | Stock | 2.775 | 2.8143 | 2.7714 | 2.7779 | 845600.0 |
| 2006-12-28 07:30:00 | AAPL | Stock | 2.775 | 2.8007 | 2.775 | 2.7929 | 1647128.0 |
| 2006-12-28 07:35:00 | AAPL | Stock | 2.7893 | 2.8036 | 2.7893 | 2.7982 | 643412.0 |
| 2006-12-28 07:40:00 | AAPL | Stock | 2.8 | 2.8089 | 2.8 | 2.8036 | 786800.0 |
| 2006-12-28 07:45:00 | AAPL | Stock | 2.8018 | 2.8214 | 2.8018 | 2.8143 | 1460788.0 |
| 2006-12-28 07:50:00 | AAPL | Stock | 2.8107 | 2.8121 | 2.8036 | 2.8079 | 611548.0 |
| 2006-12-28 07:55:00 | AAPL | Stock | 2.81 | 2.8321 | 2.8089 | 2.825 | 2086868.0 |
| 2006-12-28 08:00:00 | AAPL | Stock | 2.8236 | 2.8321 | 2.8125 | 2.8304 | 3492748.0 |
| 2006-12-28 08:05:00 | AAPL | Stock | 2.8296 | 2.84 | 2.8268 | 2.8332 | 3085236.0 |
| 2006-12-28 08:10:00 | AAPL | Stock | 2.8332 | 2.8429 | 2.825 | 2.8346 | 3280004.0 |
| 2006-12-28 08:15:00 | AAPL | Stock | 2.8343 | 2.8375 | 2.8282 | 2.8289 | 1517684.0 |
| 2006-12-28 08:20:00 | AAPL | Stock | 2.8311 | 2.8357 | 2.8296 | 2.8357 | 3486616.0 |
| 2006-12-28 08:25:00 | AAPL | Stock | 2.8357 | 2.8357 | 2.8314 | 2.8339 | 2010960.0 |
| 2006-12-28 08:30:00 | AAPL | Stock | 2.8343 | 2.8393 | 2.8321 | 2.8382 | 2016840.0 |
| 2006-12-28 08:35:00 | AAPL | Stock | 2.8382 | 2.8393 | 2.8354 | 2.8386 | 746368.0 |
| 2006-12-28 08:40:00 | AAPL | Stock | 2.8386 | 2.8539 | 2.8379 | 2.8536 | 3665508.0 |
| 2006-12-28 08:45:00 | AAPL | Stock | 2.8536 | 2.8579 | 2.8489 | 2.8511 | 4364388.0 |
| 2006-12-28 08:50:00 | AAPL | Stock | 2.8511 | 2.8618 | 2.8446 | 2.8596 | 4531520.0 |
| 2006-12-28 08:55:00 | AAPL | Stock | 2.8586 | 2.8607 | 2.8493 | 2.8557 | 3514308.0 |
| 2006-12-28 09:00:00 | AAPL | Stock | 2.8554 | 2.8657 | 2.8539 | 2.8639 | 5749688.0 |
| 2006-12-28 09:05:00 | AAPL | Stock | 2.8639 | 2.8704 | 2.8607 | 2.8621 | 3156216.0 |
| 2006-12-28 09:10:00 | AAPL | Stock | 2.8611 | 2.8721 | 2.8607 | 2.865 | 3803856.0 |
| 2006-12-28 09:15:00 | AAPL | Stock | 2.865 | 2.87 | 2.8629 | 2.8686 | 1658384.0 |
| 2006-12-28 09:20:00 | AAPL | Stock | 2.8689 | 2.8696 | 2.8518 | 2.8646 | 1991360.0 |
| 2006-12-28 09:25:00 | AAPL | Stock | 2.8634 | 2.8668 | 2.8554 | 2.8643 | 1822548.0 |
| 2006-12-28 09:30:00 | AAPL | Stock | 2.865 | 2.8807 | 2.8446 | 2.8786 | 58345728.0 |
| 2006-12-28 09:35:00 | AAPL | Stock | 2.8786 | 2.8864 | 2.87 | 2.8804 | 39005624.0 |
| 2006-12-28 09:40:00 | AAPL | Stock | 2.88 | 2.88 | 2.8571 | 2.8579 | 26825372.0 |
| 2006-12-28 09:45:00 | AAPL | Stock | 2.8579 | 2.8675 | 2.8561 | 2.8575 | 31640644.0 |
| 2006-12-28 09:50:00 | AAPL | Stock | 2.8579 | 2.8614 | 2.8568 | 2.8607 | 26028352.0 |
| 2006-12-28 09:55:00 | AAPL | Stock | 2.86 | 2.8664 | 2.8575 | 2.8614 | 25250512.0 |
| 2006-12-28 10:00:00 | AAPL | Stock | 2.8611 | 2.8661 | 2.8579 | 2.8607 | 27933640.0 |
| 2006-12-28 10:05:00 | AAPL | Stock | 2.8607 | 2.87 | 2.8607 | 2.8657 | 22239392.0 |
| 2006-12-28 10:10:00 | AAPL | Stock | 2.8654 | 2.8721 | 2.8632 | 2.8646 | 19655804.0 |
| 2006-12-28 10:15:00 | AAPL | Stock | 2.865 | 2.8671 | 2.8596 | 2.8625 | 14893760.0 |
> showing 50 of 239,094 rows — these rows as CSV