PREVIEW / stock_1min / 2006-01-04
file: by_date/stock_1min/2006/2006-01-04.parquet size: 8.2 MB rows: 664,826 symbols: 1,782
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-01-04 07:04:00 | AAPL | Stock | 2.6696 | 2.6696 | 2.6696 | 2.6696 | 2800.0 |
| 2006-01-04 07:59:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 14000.0 |
| 2006-01-04 08:00:00 | AAPL | Stock | 2.6779 | 2.6786 | 2.67 | 2.6732 | 205156.0 |
| 2006-01-04 08:01:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6704 | 2.6714 | 129948.0 |
| 2006-01-04 08:02:00 | AAPL | Stock | 2.6714 | 2.6714 | 2.6714 | 2.6714 | 19600.0 |
| 2006-01-04 08:03:00 | AAPL | Stock | 2.675 | 2.6764 | 2.675 | 2.6764 | 36400.0 |
| 2006-01-04 08:04:00 | AAPL | Stock | 2.6764 | 2.6789 | 2.6764 | 2.6786 | 233100.0 |
| 2006-01-04 08:05:00 | AAPL | Stock | 2.68 | 2.6857 | 2.6786 | 2.6857 | 168560.0 |
| 2006-01-04 08:06:00 | AAPL | Stock | 2.685 | 2.685 | 2.6821 | 2.6821 | 15400.0 |
| 2006-01-04 08:07:00 | AAPL | Stock | 2.6821 | 2.6839 | 2.6821 | 2.6839 | 35364.0 |
| 2006-01-04 08:08:00 | AAPL | Stock | 2.6839 | 2.6839 | 2.6839 | 2.6839 | 12964.0 |
| 2006-01-04 08:10:00 | AAPL | Stock | 2.6804 | 2.6804 | 2.6804 | 2.6804 | 16800.0 |
| 2006-01-04 08:11:00 | AAPL | Stock | 2.6807 | 2.6821 | 2.6807 | 2.6821 | 56000.0 |
| 2006-01-04 08:12:00 | AAPL | Stock | 2.6821 | 2.6836 | 2.6807 | 2.6821 | 92400.0 |
| 2006-01-04 08:13:00 | AAPL | Stock | 2.6807 | 2.6807 | 2.6807 | 2.6807 | 8400.0 |
| 2006-01-04 08:14:00 | AAPL | Stock | 2.6807 | 2.6807 | 2.6796 | 2.6796 | 35000.0 |
| 2006-01-04 08:15:00 | AAPL | Stock | 2.6807 | 2.6807 | 2.6807 | 2.6807 | 8400.0 |
| 2006-01-04 08:16:00 | AAPL | Stock | 2.6793 | 2.6793 | 2.6793 | 2.6793 | 8400.0 |
| 2006-01-04 08:17:00 | AAPL | Stock | 2.6814 | 2.6814 | 2.6789 | 2.68 | 60564.0 |
| 2006-01-04 08:18:00 | AAPL | Stock | 2.6818 | 2.6829 | 2.6789 | 2.6789 | 143164.0 |
| 2006-01-04 08:19:00 | AAPL | Stock | 2.6804 | 2.6804 | 2.6804 | 2.6804 | 19600.0 |
| 2006-01-04 08:20:00 | AAPL | Stock | 2.6793 | 2.68 | 2.6793 | 2.6793 | 30800.0 |
| 2006-01-04 08:22:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6775 | 2.6786 | 64260.0 |
| 2006-01-04 08:23:00 | AAPL | Stock | 2.6771 | 2.6771 | 2.675 | 2.675 | 77000.0 |
| 2006-01-04 08:24:00 | AAPL | Stock | 2.675 | 2.6779 | 2.675 | 2.6779 | 58800.0 |
| 2006-01-04 08:25:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 14000.0 |
| 2006-01-04 08:27:00 | AAPL | Stock | 2.6764 | 2.6779 | 2.6764 | 2.6779 | 11200.0 |
| 2006-01-04 08:28:00 | AAPL | Stock | 2.6761 | 2.6761 | 2.6761 | 2.6761 | 36400.0 |
| 2006-01-04 08:29:00 | AAPL | Stock | 2.6775 | 2.6786 | 2.6775 | 2.6786 | 5600.0 |
| 2006-01-04 08:30:00 | AAPL | Stock | 2.6779 | 2.6779 | 2.6768 | 2.6779 | 42000.0 |
| 2006-01-04 08:31:00 | AAPL | Stock | 2.6775 | 2.6775 | 2.6775 | 2.6775 | 5600.0 |
| 2006-01-04 08:33:00 | AAPL | Stock | 2.6754 | 2.6754 | 2.675 | 2.675 | 50960.0 |
| 2006-01-04 08:34:00 | AAPL | Stock | 2.6732 | 2.6732 | 2.6732 | 2.6732 | 26740.0 |
| 2006-01-04 08:35:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 7000.0 |
| 2006-01-04 08:36:00 | AAPL | Stock | 2.6736 | 2.6757 | 2.6729 | 2.6757 | 29120.0 |
| 2006-01-04 08:37:00 | AAPL | Stock | 2.6757 | 2.6757 | 2.6732 | 2.6732 | 50176.0 |
| 2006-01-04 08:39:00 | AAPL | Stock | 2.6771 | 2.6771 | 2.6771 | 2.6771 | 5600.0 |
| 2006-01-04 08:40:00 | AAPL | Stock | 2.675 | 2.675 | 2.675 | 2.675 | 5460.0 |
| 2006-01-04 08:41:00 | AAPL | Stock | 2.675 | 2.6786 | 2.675 | 2.6786 | 228284.0 |
| 2006-01-04 08:42:00 | AAPL | Stock | 2.6793 | 2.6821 | 2.6786 | 2.6786 | 200564.0 |
| 2006-01-04 08:43:00 | AAPL | Stock | 2.6789 | 2.6804 | 2.6789 | 2.6789 | 29400.0 |
| 2006-01-04 08:44:00 | AAPL | Stock | 2.6789 | 2.68 | 2.6789 | 2.68 | 16800.0 |
| 2006-01-04 08:45:00 | AAPL | Stock | 2.68 | 2.68 | 2.6786 | 2.6786 | 173348.0 |
| 2006-01-04 08:47:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6779 | 2.6786 | 70000.0 |
| 2006-01-04 08:48:00 | AAPL | Stock | 2.6779 | 2.6779 | 2.6779 | 2.6779 | 5600.0 |
| 2006-01-04 08:50:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6771 | 2.6771 | 74620.0 |
| 2006-01-04 08:51:00 | AAPL | Stock | 2.6771 | 2.6771 | 2.6771 | 2.6771 | 28000.0 |
| 2006-01-04 08:54:00 | AAPL | Stock | 2.6771 | 2.6786 | 2.6771 | 2.6786 | 30800.0 |
| 2006-01-04 08:55:00 | AAPL | Stock | 2.6771 | 2.6775 | 2.6768 | 2.6775 | 82852.0 |
| 2006-01-04 08:56:00 | AAPL | Stock | 2.6779 | 2.6786 | 2.6779 | 2.6786 | 19796.0 |
> showing 50 of 664,826 rows — these rows as CSV