PREVIEW / stock_1min / 2008-01-29
file: by_date/stock_1min/2008/2008-01-29.parquet size: 12.4 MB rows: 1,015,999 symbols: 2,667
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-01-29 04:15:00 | AAPL | Stock | 4.6518 | 4.6518 | 4.6518 | 4.6518 | 2800.0 |
| 2008-01-29 05:19:00 | AAPL | Stock | 4.6661 | 4.6661 | 4.6661 | 4.6661 | 2800.0 |
| 2008-01-29 05:58:00 | AAPL | Stock | 4.6789 | 4.6789 | 4.6789 | 4.6789 | 25200.0 |
| 2008-01-29 06:05:00 | AAPL | Stock | 4.6929 | 4.7018 | 4.6929 | 4.7018 | 86800.0 |
| 2008-01-29 06:13:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.7018 | 4.7018 | 28000.0 |
| 2008-01-29 06:19:00 | AAPL | Stock | 4.7036 | 4.7036 | 4.7036 | 4.7036 | 5600.0 |
| 2008-01-29 06:21:00 | AAPL | Stock | 4.7 | 4.7064 | 4.7 | 4.7064 | 5600.0 |
| 2008-01-29 06:38:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.7018 | 4.7018 | 2800.0 |
| 2008-01-29 06:41:00 | AAPL | Stock | 4.7004 | 4.7032 | 4.7004 | 4.7032 | 5600.0 |
| 2008-01-29 06:45:00 | AAPL | Stock | 4.7007 | 4.7007 | 4.7007 | 4.7007 | 2800.0 |
| 2008-01-29 06:53:00 | AAPL | Stock | 4.7039 | 4.7039 | 4.7039 | 4.7039 | 2968.0 |
| 2008-01-29 06:55:00 | AAPL | Stock | 4.7079 | 4.7079 | 4.7054 | 4.7054 | 19600.0 |
| 2008-01-29 07:00:00 | AAPL | Stock | 4.7054 | 4.7079 | 4.7054 | 4.7075 | 37352.0 |
| 2008-01-29 07:01:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.7054 | 4.7054 | 5600.0 |
| 2008-01-29 07:02:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.7054 | 4.7054 | 26152.0 |
| 2008-01-29 07:03:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.7054 | 4.7054 | 28000.0 |
| 2008-01-29 07:04:00 | AAPL | Stock | 4.71 | 4.71 | 4.71 | 4.71 | 2800.0 |
| 2008-01-29 07:05:00 | AAPL | Stock | 4.7054 | 4.7054 | 4.6946 | 4.6946 | 54600.0 |
| 2008-01-29 07:06:00 | AAPL | Stock | 4.6946 | 4.6946 | 4.6946 | 4.6946 | 2800.0 |
| 2008-01-29 07:08:00 | AAPL | Stock | 4.695 | 4.695 | 4.6925 | 4.6929 | 49000.0 |
| 2008-01-29 07:09:00 | AAPL | Stock | 4.6929 | 4.6929 | 4.6786 | 4.6786 | 110516.0 |
| 2008-01-29 07:10:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 57400.0 |
| 2008-01-29 07:11:00 | AAPL | Stock | 4.6754 | 4.6754 | 4.6754 | 4.6754 | 11116.0 |
| 2008-01-29 07:12:00 | AAPL | Stock | 4.6839 | 4.6839 | 4.6839 | 4.6839 | 2800.0 |
| 2008-01-29 07:13:00 | AAPL | Stock | 4.685 | 4.685 | 4.685 | 4.685 | 43680.0 |
| 2008-01-29 07:17:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 5600.0 |
| 2008-01-29 07:18:00 | AAPL | Stock | 4.6821 | 4.6821 | 4.6821 | 4.6821 | 5600.0 |
| 2008-01-29 07:22:00 | AAPL | Stock | 4.6796 | 4.6821 | 4.6796 | 4.6821 | 6300.0 |
| 2008-01-29 07:24:00 | AAPL | Stock | 4.6911 | 4.6911 | 4.6911 | 4.6911 | 8400.0 |
| 2008-01-29 07:28:00 | AAPL | Stock | 4.6893 | 4.6893 | 4.6893 | 4.6893 | 11200.0 |
| 2008-01-29 07:29:00 | AAPL | Stock | 4.6893 | 4.6893 | 4.6893 | 4.6893 | 2800.0 |
| 2008-01-29 07:30:00 | AAPL | Stock | 4.6839 | 4.6839 | 4.6821 | 4.6821 | 18200.0 |
| 2008-01-29 07:31:00 | AAPL | Stock | 4.6821 | 4.6821 | 4.6821 | 4.6821 | 30800.0 |
| 2008-01-29 07:33:00 | AAPL | Stock | 4.6796 | 4.6811 | 4.6796 | 4.6811 | 5600.0 |
| 2008-01-29 07:36:00 | AAPL | Stock | 4.6807 | 4.6807 | 4.6786 | 4.68 | 33600.0 |
| 2008-01-29 07:38:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6718 | 4.6786 | 19600.0 |
| 2008-01-29 07:39:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 2800.0 |
| 2008-01-29 07:44:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 2800.0 |
| 2008-01-29 07:45:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 8400.0 |
| 2008-01-29 07:48:00 | AAPL | Stock | 4.6668 | 4.6668 | 4.6668 | 4.6668 | 8400.0 |
| 2008-01-29 07:49:00 | AAPL | Stock | 4.6668 | 4.6668 | 4.6668 | 4.6668 | 2800.0 |
| 2008-01-29 07:52:00 | AAPL | Stock | 4.6668 | 4.6668 | 4.6668 | 4.6668 | 14000.0 |
| 2008-01-29 07:53:00 | AAPL | Stock | 4.6668 | 4.6668 | 4.6668 | 4.6668 | 50624.0 |
| 2008-01-29 07:57:00 | AAPL | Stock | 4.6625 | 4.6625 | 4.6625 | 4.6625 | 2800.0 |
| 2008-01-29 07:59:00 | AAPL | Stock | 4.6711 | 4.6711 | 4.6711 | 4.6711 | 2800.0 |
| 2008-01-29 08:00:00 | AAPL | Stock | 4.7071 | 4.7071 | 4.6504 | 4.655 | 492660.0 |
| 2008-01-29 08:01:00 | AAPL | Stock | 4.6571 | 4.6693 | 4.6554 | 4.6625 | 130928.0 |
| 2008-01-29 08:02:00 | AAPL | Stock | 4.6643 | 4.6679 | 4.6625 | 4.6679 | 63700.0 |
| 2008-01-29 08:03:00 | AAPL | Stock | 4.6679 | 4.6679 | 4.6679 | 4.6679 | 5600.0 |
| 2008-01-29 08:04:00 | AAPL | Stock | 4.6686 | 4.6686 | 4.6607 | 4.6607 | 30240.0 |
> showing 50 of 1,015,999 rows — these rows as CSV