PREVIEW / stock_1min / 2005-09-01
file: by_date/stock_1min/2005/2005-09-01.parquet size: 7.4 MB rows: 611,245 symbols: 1,702
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-01 08:00:00 | AAPL | Stock | 1.675 | 1.675 | 1.675 | 1.675 | 7000.0 |
| 2005-09-01 08:01:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6757 | 1.6757 | 9800.0 |
| 2005-09-01 08:03:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6754 | 1.6754 | 19600.0 |
| 2005-09-01 08:10:00 | AAPL | Stock | 1.6754 | 1.6754 | 1.6754 | 1.6754 | 8400.0 |
| 2005-09-01 08:22:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6757 | 1.6757 | 2800.0 |
| 2005-09-01 08:25:00 | AAPL | Stock | 1.6779 | 1.6779 | 1.6779 | 1.6779 | 5656.0 |
| 2005-09-01 08:27:00 | AAPL | Stock | 1.6768 | 1.6768 | 1.6768 | 1.6768 | 2800.0 |
| 2005-09-01 08:30:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6757 | 1.6757 | 28000.0 |
| 2005-09-01 08:31:00 | AAPL | Stock | 1.6757 | 1.6757 | 1.6757 | 1.6757 | 11200.0 |
| 2005-09-01 08:34:00 | AAPL | Stock | 1.6746 | 1.6746 | 1.6746 | 1.6746 | 11200.0 |
| 2005-09-01 08:36:00 | AAPL | Stock | 1.6764 | 1.6782 | 1.6746 | 1.6782 | 61600.0 |
| 2005-09-01 08:37:00 | AAPL | Stock | 1.6782 | 1.6782 | 1.6782 | 1.6782 | 14000.0 |
| 2005-09-01 08:38:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6786 | 1.6786 | 11200.0 |
| 2005-09-01 08:43:00 | AAPL | Stock | 1.6786 | 1.6804 | 1.6786 | 1.68 | 54096.0 |
| 2005-09-01 08:44:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 19600.0 |
| 2005-09-01 08:45:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 8400.0 |
| 2005-09-01 08:47:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 11200.0 |
| 2005-09-01 08:48:00 | AAPL | Stock | 1.6814 | 1.6821 | 1.6804 | 1.6821 | 56000.0 |
| 2005-09-01 08:49:00 | AAPL | Stock | 1.6821 | 1.6843 | 1.6821 | 1.6843 | 148400.0 |
| 2005-09-01 08:50:00 | AAPL | Stock | 1.6821 | 1.6821 | 1.6821 | 1.6821 | 19096.0 |
| 2005-09-01 08:51:00 | AAPL | Stock | 1.6829 | 1.6829 | 1.6821 | 1.6821 | 8400.0 |
| 2005-09-01 08:53:00 | AAPL | Stock | 1.6821 | 1.6829 | 1.6821 | 1.6829 | 25200.0 |
| 2005-09-01 08:54:00 | AAPL | Stock | 1.6821 | 1.6821 | 1.6821 | 1.6821 | 8904.0 |
| 2005-09-01 08:55:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 5096.0 |
| 2005-09-01 08:57:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 2800.0 |
| 2005-09-01 08:58:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 8400.0 |
| 2005-09-01 09:04:00 | AAPL | Stock | 1.6746 | 1.6804 | 1.6746 | 1.6804 | 30772.0 |
| 2005-09-01 09:15:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 2800.0 |
| 2005-09-01 09:16:00 | AAPL | Stock | 1.6804 | 1.6804 | 1.6804 | 1.6804 | 5600.0 |
| 2005-09-01 09:20:00 | AAPL | Stock | 1.6761 | 1.6761 | 1.6761 | 1.6761 | 2021600.0 |
| 2005-09-01 09:21:00 | AAPL | Stock | 1.6789 | 1.6789 | 1.6761 | 1.6761 | 36400.0 |
| 2005-09-01 09:22:00 | AAPL | Stock | 1.6789 | 1.6789 | 1.6789 | 1.6789 | 2800.0 |
| 2005-09-01 09:24:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6786 | 1.6786 | 198800.0 |
| 2005-09-01 09:25:00 | AAPL | Stock | 1.6782 | 1.6786 | 1.6768 | 1.6782 | 22400.0 |
| 2005-09-01 09:27:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6761 | 1.6786 | 641732.0 |
| 2005-09-01 09:28:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6786 | 1.6786 | 19600.0 |
| 2005-09-01 09:29:00 | AAPL | Stock | 1.6782 | 1.6786 | 1.675 | 1.675 | 386400.0 |
| 2005-09-01 09:30:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6729 | 1.675 | 6077008.0 |
| 2005-09-01 09:31:00 | AAPL | Stock | 1.6754 | 1.6754 | 1.6725 | 1.6732 | 1597232.0 |
| 2005-09-01 09:32:00 | AAPL | Stock | 1.6754 | 1.6764 | 1.6729 | 1.6758 | 1456728.0 |
| 2005-09-01 09:33:00 | AAPL | Stock | 1.6761 | 1.6764 | 1.6714 | 1.6729 | 5589752.0 |
| 2005-09-01 09:34:00 | AAPL | Stock | 1.6725 | 1.6786 | 1.6668 | 1.6679 | 6949516.0 |
| 2005-09-01 09:35:00 | AAPL | Stock | 1.6682 | 1.6711 | 1.6679 | 1.6704 | 5046076.0 |
| 2005-09-01 09:36:00 | AAPL | Stock | 1.67 | 1.6711 | 1.6686 | 1.669 | 1981336.0 |
| 2005-09-01 09:37:00 | AAPL | Stock | 1.6693 | 1.6711 | 1.6682 | 1.6711 | 1611428.0 |
| 2005-09-01 09:38:00 | AAPL | Stock | 1.6714 | 1.6786 | 1.6707 | 1.6768 | 2745988.0 |
| 2005-09-01 09:39:00 | AAPL | Stock | 1.6771 | 1.6786 | 1.6764 | 1.6775 | 5295612.0 |
| 2005-09-01 09:40:00 | AAPL | Stock | 1.6779 | 1.6789 | 1.6761 | 1.6782 | 1879808.0 |
| 2005-09-01 09:41:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6765 | 1.6771 | 2921884.0 |
| 2005-09-01 09:42:00 | AAPL | Stock | 1.6771 | 1.6782 | 1.6764 | 1.6768 | 1191400.0 |
> showing 50 of 611,245 rows — these rows as CSV