PREVIEW / stock_5min / 2008-07-24
file: by_date/stock_5min/2008/2008-07-24.parquet size: 4.5 MB rows: 319,146 symbols: 3,330
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-24 06:40:00 | AAPL | Stock | 5.945 | 5.945 | 5.945 | 5.945 | 2800.0 |
| 2008-07-24 07:00:00 | AAPL | Stock | 5.9346 | 5.9346 | 5.9346 | 5.9346 | 2800.0 |
| 2008-07-24 07:25:00 | AAPL | Stock | 5.9371 | 5.9371 | 5.9371 | 5.9371 | 16100.0 |
| 2008-07-24 07:35:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9375 | 5.9375 | 2800.0 |
| 2008-07-24 07:40:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.9089 | 5.9089 | 34300.0 |
| 2008-07-24 07:45:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9018 | 5.9018 | 153020.0 |
| 2008-07-24 08:00:00 | AAPL | Stock | 5.9211 | 5.9329 | 5.9111 | 5.9282 | 187292.0 |
| 2008-07-24 08:05:00 | AAPL | Stock | 5.9221 | 5.9282 | 5.9114 | 5.9225 | 109984.0 |
| 2008-07-24 08:10:00 | AAPL | Stock | 5.9157 | 5.9229 | 5.9143 | 5.9179 | 69300.0 |
| 2008-07-24 08:15:00 | AAPL | Stock | 5.9179 | 5.9379 | 5.9179 | 5.9232 | 3266144.0 |
| 2008-07-24 08:20:00 | AAPL | Stock | 5.925 | 5.9286 | 5.9232 | 5.9232 | 92960.0 |
| 2008-07-24 08:25:00 | AAPL | Stock | 5.9354 | 5.9375 | 5.9232 | 5.9375 | 353500.0 |
| 2008-07-24 08:30:00 | AAPL | Stock | 5.9286 | 5.9379 | 5.9111 | 5.9175 | 183316.0 |
| 2008-07-24 08:35:00 | AAPL | Stock | 5.9175 | 5.9175 | 5.9143 | 5.9143 | 16520.0 |
| 2008-07-24 08:40:00 | AAPL | Stock | 5.9196 | 5.9196 | 5.9161 | 5.9161 | 33600.0 |
| 2008-07-24 08:45:00 | AAPL | Stock | 5.9143 | 5.9171 | 5.9111 | 5.9125 | 258300.0 |
| 2008-07-24 08:50:00 | AAPL | Stock | 5.9111 | 5.9111 | 5.8964 | 5.8964 | 356300.0 |
| 2008-07-24 08:55:00 | AAPL | Stock | 5.8986 | 5.8986 | 5.8786 | 5.8839 | 725452.0 |
| 2008-07-24 09:00:00 | AAPL | Stock | 5.8839 | 5.8936 | 5.8821 | 5.8936 | 167356.0 |
| 2008-07-24 09:05:00 | AAPL | Stock | 5.8975 | 5.9007 | 5.8786 | 5.8825 | 407960.0 |
| 2008-07-24 09:10:00 | AAPL | Stock | 5.8829 | 5.8929 | 5.875 | 5.8825 | 311612.0 |
| 2008-07-24 09:15:00 | AAPL | Stock | 5.8857 | 5.8879 | 5.8804 | 5.8843 | 152600.0 |
| 2008-07-24 09:20:00 | AAPL | Stock | 5.8857 | 5.8979 | 5.8857 | 5.8907 | 462084.0 |
| 2008-07-24 09:25:00 | AAPL | Stock | 5.8929 | 5.8939 | 5.8571 | 5.8696 | 1358644.0 |
| 2008-07-24 09:30:00 | AAPL | Stock | 5.8711 | 5.9021 | 5.8221 | 5.8264 | 25295900.0 |
| 2008-07-24 09:35:00 | AAPL | Stock | 5.8257 | 5.8493 | 5.825 | 5.8286 | 15775256.0 |
| 2008-07-24 09:40:00 | AAPL | Stock | 5.8286 | 5.8429 | 5.8154 | 5.8339 | 17112676.0 |
| 2008-07-24 09:45:00 | AAPL | Stock | 5.8343 | 5.8521 | 5.8236 | 5.8318 | 13190296.0 |
| 2008-07-24 09:50:00 | AAPL | Stock | 5.8314 | 5.8489 | 5.8071 | 5.8479 | 14482468.0 |
| 2008-07-24 09:55:00 | AAPL | Stock | 5.8475 | 5.8739 | 5.8436 | 5.8621 | 15460648.0 |
| 2008-07-24 10:00:00 | AAPL | Stock | 5.8621 | 5.8625 | 5.8193 | 5.8281 | 14557564.0 |
| 2008-07-24 10:05:00 | AAPL | Stock | 5.8268 | 5.8307 | 5.7857 | 5.7871 | 20340964.0 |
| 2008-07-24 10:10:00 | AAPL | Stock | 5.7868 | 5.8021 | 5.7718 | 5.7914 | 20918632.0 |
| 2008-07-24 10:15:00 | AAPL | Stock | 5.7914 | 5.8089 | 5.7893 | 5.7979 | 11624872.0 |
| 2008-07-24 10:20:00 | AAPL | Stock | 5.7975 | 5.8014 | 5.7829 | 5.7934 | 9672740.0 |
| 2008-07-24 10:25:00 | AAPL | Stock | 5.7925 | 5.795 | 5.7686 | 5.7843 | 11845344.0 |
| 2008-07-24 10:30:00 | AAPL | Stock | 5.7846 | 5.8036 | 5.7793 | 5.7896 | 13237616.0 |
| 2008-07-24 10:35:00 | AAPL | Stock | 5.7882 | 5.8054 | 5.7882 | 5.7936 | 12375468.0 |
| 2008-07-24 10:40:00 | AAPL | Stock | 5.7943 | 5.8025 | 5.7718 | 5.7775 | 9214016.0 |
| 2008-07-24 10:45:00 | AAPL | Stock | 5.7775 | 5.7811 | 5.7429 | 5.7496 | 21344652.0 |
| 2008-07-24 10:50:00 | AAPL | Stock | 5.7486 | 5.7636 | 5.7332 | 5.7404 | 15623132.0 |
| 2008-07-24 10:55:00 | AAPL | Stock | 5.7404 | 5.7554 | 5.7379 | 5.7464 | 11327344.0 |
| 2008-07-24 11:00:00 | AAPL | Stock | 5.7468 | 5.7514 | 5.7339 | 5.7486 | 9349172.0 |
| 2008-07-24 11:05:00 | AAPL | Stock | 5.7489 | 5.75 | 5.7179 | 5.7232 | 12846764.0 |
| 2008-07-24 11:10:00 | AAPL | Stock | 5.7221 | 5.723 | 5.685 | 5.6882 | 22281896.0 |
| 2008-07-24 11:15:00 | AAPL | Stock | 5.6882 | 5.7021 | 5.6743 | 5.6861 | 18859260.0 |
| 2008-07-24 11:20:00 | AAPL | Stock | 5.6861 | 5.7096 | 5.68 | 5.7032 | 15300600.0 |
| 2008-07-24 11:25:00 | AAPL | Stock | 5.7021 | 5.7179 | 5.6957 | 5.7104 | 13732040.0 |
| 2008-07-24 11:30:00 | AAPL | Stock | 5.7114 | 5.7307 | 5.7018 | 5.7296 | 12495672.0 |
| 2008-07-24 11:35:00 | AAPL | Stock | 5.7296 | 5.7457 | 5.7239 | 5.7454 | 12056632.0 |
> showing 50 of 319,146 rows — these rows as CSV