PREVIEW / stock_1min / 2007-11-30
file: by_date/stock_1min/2007/2007-11-30.parquet size: 12.6 MB rows: 1,023,869 symbols: 2,629
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-11-30 04:20:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 2800.0 |
| 2007-11-30 04:35:00 | AAPL | Stock | 6.6871 | 6.6871 | 6.6871 | 6.6871 | 5600.0 |
| 2007-11-30 04:43:00 | AAPL | Stock | 6.665 | 6.665 | 6.665 | 6.665 | 5600.0 |
| 2007-11-30 04:59:00 | AAPL | Stock | 6.7029 | 6.7029 | 6.7029 | 6.7029 | 2800.0 |
| 2007-11-30 05:02:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.7036 | 6.7036 | 2800.0 |
| 2007-11-30 05:24:00 | AAPL | Stock | 6.6975 | 6.6975 | 6.6975 | 6.6975 | 2800.0 |
| 2007-11-30 05:30:00 | AAPL | Stock | 6.6975 | 6.6975 | 6.6975 | 6.6975 | 2800.0 |
| 2007-11-30 05:45:00 | AAPL | Stock | 6.7086 | 6.7086 | 6.7086 | 6.7086 | 5600.0 |
| 2007-11-30 05:49:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 2800.0 |
| 2007-11-30 05:56:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.67 | 6.67 | 30800.0 |
| 2007-11-30 05:57:00 | AAPL | Stock | 6.67 | 6.6704 | 6.6682 | 6.6682 | 36652.0 |
| 2007-11-30 05:59:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6579 | 6.6579 | 18200.0 |
| 2007-11-30 06:05:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6704 | 6.6704 | 5600.0 |
| 2007-11-30 06:07:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6704 | 6.6704 | 5600.0 |
| 2007-11-30 06:39:00 | AAPL | Stock | 6.6704 | 6.6704 | 6.6704 | 6.6704 | 2800.0 |
| 2007-11-30 06:45:00 | AAPL | Stock | 6.6679 | 6.6679 | 6.6679 | 6.6679 | 5600.0 |
| 2007-11-30 06:50:00 | AAPL | Stock | 6.6579 | 6.6579 | 6.6554 | 6.6554 | 36792.0 |
| 2007-11-30 06:52:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 14000.0 |
| 2007-11-30 06:55:00 | AAPL | Stock | 6.6521 | 6.6521 | 6.6521 | 6.6521 | 5600.0 |
| 2007-11-30 07:00:00 | AAPL | Stock | 6.6554 | 6.6554 | 6.6554 | 6.6554 | 2800.0 |
| 2007-11-30 07:01:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 5600.0 |
| 2007-11-30 07:03:00 | AAPL | Stock | 6.6675 | 6.6704 | 6.6571 | 6.6704 | 50512.0 |
| 2007-11-30 07:06:00 | AAPL | Stock | 6.675 | 6.675 | 6.675 | 6.675 | 2800.0 |
| 2007-11-30 07:07:00 | AAPL | Stock | 6.6875 | 6.6975 | 6.6864 | 6.6975 | 77700.0 |
| 2007-11-30 07:08:00 | AAPL | Stock | 6.7139 | 6.7139 | 6.7139 | 6.7139 | 5600.0 |
| 2007-11-30 07:09:00 | AAPL | Stock | 6.6964 | 6.7139 | 6.6964 | 6.6964 | 29400.0 |
| 2007-11-30 07:10:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6943 | 6.6964 | 11200.0 |
| 2007-11-30 07:11:00 | AAPL | Stock | 6.6929 | 6.7054 | 6.6911 | 6.6911 | 271600.0 |
| 2007-11-30 07:12:00 | AAPL | Stock | 6.7029 | 6.7029 | 6.7029 | 6.7029 | 140000.0 |
| 2007-11-30 07:15:00 | AAPL | Stock | 6.6804 | 6.6804 | 6.6796 | 6.6796 | 35280.0 |
| 2007-11-30 07:23:00 | AAPL | Stock | 6.6957 | 6.6957 | 6.6957 | 6.6957 | 8260.0 |
| 2007-11-30 07:24:00 | AAPL | Stock | 6.6954 | 6.6982 | 6.6954 | 6.6982 | 84560.0 |
| 2007-11-30 07:25:00 | AAPL | Stock | 6.6982 | 6.7036 | 6.6979 | 6.7036 | 172200.0 |
| 2007-11-30 07:27:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6979 | 6.6979 | 246680.0 |
| 2007-11-30 07:34:00 | AAPL | Stock | 6.6896 | 6.6979 | 6.6893 | 6.6979 | 77952.0 |
| 2007-11-30 07:35:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6982 | 6.6982 | 11200.0 |
| 2007-11-30 07:36:00 | AAPL | Stock | 6.6896 | 6.6979 | 6.6896 | 6.6979 | 5600.0 |
| 2007-11-30 07:37:00 | AAPL | Stock | 6.6929 | 6.6929 | 6.6893 | 6.6893 | 23660.0 |
| 2007-11-30 07:40:00 | AAPL | Stock | 6.6893 | 6.6893 | 6.6893 | 6.6893 | 14000.0 |
| 2007-11-30 07:41:00 | AAPL | Stock | 6.6893 | 6.6893 | 6.6893 | 6.6893 | 11900.0 |
| 2007-11-30 07:42:00 | AAPL | Stock | 6.6911 | 6.7 | 6.6911 | 6.6929 | 65800.0 |
| 2007-11-30 07:44:00 | AAPL | Stock | 6.6989 | 6.6989 | 6.6857 | 6.6857 | 14000.0 |
| 2007-11-30 07:45:00 | AAPL | Stock | 6.6893 | 6.6893 | 6.6893 | 6.6893 | 21000.0 |
| 2007-11-30 07:46:00 | AAPL | Stock | 6.6929 | 6.6929 | 6.6929 | 6.6929 | 12040.0 |
| 2007-11-30 07:47:00 | AAPL | Stock | 6.6904 | 6.6929 | 6.6904 | 6.6904 | 70000.0 |
| 2007-11-30 07:48:00 | AAPL | Stock | 6.6843 | 6.6893 | 6.6821 | 6.6893 | 45080.0 |
| 2007-11-30 07:49:00 | AAPL | Stock | 6.6843 | 6.6843 | 6.6829 | 6.6843 | 22400.0 |
| 2007-11-30 07:50:00 | AAPL | Stock | 6.6904 | 6.6904 | 6.6889 | 6.6889 | 11200.0 |
| 2007-11-30 07:51:00 | AAPL | Stock | 6.6857 | 6.6889 | 6.6857 | 6.6889 | 8400.0 |
| 2007-11-30 07:52:00 | AAPL | Stock | 6.6893 | 6.69 | 6.6893 | 6.69 | 16800.0 |
> showing 50 of 1,023,869 rows — these rows as CSV