PREVIEW / stock_1min / 2006-10-17
file: by_date/stock_1min/2006/2006-10-17.parquet size: 8.7 MB rows: 705,090 symbols: 1,952
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-10-17 06:39:00 | AAPL | Stock | 2.6864 | 2.6864 | 2.6864 | 2.6864 | 2800.0 |
| 2006-10-17 08:00:00 | AAPL | Stock | 2.6839 | 2.6839 | 2.6829 | 2.6829 | 12292.0 |
| 2006-10-17 08:01:00 | AAPL | Stock | 2.6857 | 2.6857 | 2.6857 | 2.6857 | 89908.0 |
| 2006-10-17 08:04:00 | AAPL | Stock | 2.6843 | 2.6857 | 2.6843 | 2.6857 | 14000.0 |
| 2006-10-17 08:05:00 | AAPL | Stock | 2.6843 | 2.6843 | 2.6796 | 2.6796 | 30800.0 |
| 2006-10-17 08:06:00 | AAPL | Stock | 2.6839 | 2.6839 | 2.6839 | 2.6839 | 2800.0 |
| 2006-10-17 08:07:00 | AAPL | Stock | 2.6804 | 2.6804 | 2.6804 | 2.6804 | 2800.0 |
| 2006-10-17 08:09:00 | AAPL | Stock | 2.6861 | 2.6861 | 2.6861 | 2.6861 | 4200.0 |
| 2006-10-17 08:14:00 | AAPL | Stock | 2.6825 | 2.6825 | 2.6825 | 2.6825 | 8400.0 |
| 2006-10-17 08:15:00 | AAPL | Stock | 2.6839 | 2.6839 | 2.6807 | 2.6807 | 53200.0 |
| 2006-10-17 08:16:00 | AAPL | Stock | 2.6807 | 2.6807 | 2.6807 | 2.6807 | 14000.0 |
| 2006-10-17 08:17:00 | AAPL | Stock | 2.6807 | 2.6807 | 2.6807 | 2.6807 | 71400.0 |
| 2006-10-17 08:20:00 | AAPL | Stock | 2.6821 | 2.6821 | 2.6821 | 2.6821 | 2800.0 |
| 2006-10-17 08:30:00 | AAPL | Stock | 2.6825 | 2.6825 | 2.6821 | 2.6821 | 33600.0 |
| 2006-10-17 08:31:00 | AAPL | Stock | 2.6821 | 2.6821 | 2.6757 | 2.6757 | 353500.0 |
| 2006-10-17 08:32:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6757 | 2.6782 | 96600.0 |
| 2006-10-17 08:33:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 22400.0 |
| 2006-10-17 08:34:00 | AAPL | Stock | 2.6782 | 2.6782 | 2.6782 | 2.6782 | 5600.0 |
| 2006-10-17 08:35:00 | AAPL | Stock | 2.6782 | 2.6786 | 2.6768 | 2.6768 | 66640.0 |
| 2006-10-17 08:36:00 | AAPL | Stock | 2.6768 | 2.6768 | 2.6768 | 2.6768 | 5600.0 |
| 2006-10-17 08:39:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 11200.0 |
| 2006-10-17 08:41:00 | AAPL | Stock | 2.6768 | 2.6768 | 2.6768 | 2.6768 | 13608.0 |
| 2006-10-17 08:42:00 | AAPL | Stock | 2.6768 | 2.6768 | 2.6761 | 2.6761 | 56000.0 |
| 2006-10-17 08:44:00 | AAPL | Stock | 2.6768 | 2.6768 | 2.6768 | 2.6768 | 14000.0 |
| 2006-10-17 08:46:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 14000.0 |
| 2006-10-17 08:47:00 | AAPL | Stock | 2.6768 | 2.6768 | 2.6768 | 2.6768 | 28000.0 |
| 2006-10-17 08:48:00 | AAPL | Stock | 2.6768 | 2.6786 | 2.6768 | 2.6786 | 50568.0 |
| 2006-10-17 08:49:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 30800.0 |
| 2006-10-17 08:53:00 | AAPL | Stock | 2.6782 | 2.6782 | 2.6782 | 2.6782 | 14000.0 |
| 2006-10-17 08:56:00 | AAPL | Stock | 2.6782 | 2.6782 | 2.6782 | 2.6782 | 14000.0 |
| 2006-10-17 08:58:00 | AAPL | Stock | 2.6782 | 2.6782 | 2.6782 | 2.6782 | 4900.0 |
| 2006-10-17 08:59:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 96460.0 |
| 2006-10-17 09:02:00 | AAPL | Stock | 2.68 | 2.68 | 2.68 | 2.68 | 2800.0 |
| 2006-10-17 09:05:00 | AAPL | Stock | 2.6796 | 2.6796 | 2.6786 | 2.6786 | 124740.0 |
| 2006-10-17 09:06:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 8400.0 |
| 2006-10-17 09:07:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6768 | 2.6768 | 9660.0 |
| 2006-10-17 09:08:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 82740.0 |
| 2006-10-17 09:09:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 7700.0 |
| 2006-10-17 09:17:00 | AAPL | Stock | 2.6818 | 2.6818 | 2.6818 | 2.6818 | 14000.0 |
| 2006-10-17 09:19:00 | AAPL | Stock | 2.6818 | 2.6818 | 2.6818 | 2.6818 | 14000.0 |
| 2006-10-17 09:22:00 | AAPL | Stock | 2.6818 | 2.6818 | 2.6818 | 2.6818 | 18116.0 |
| 2006-10-17 09:23:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 14000.0 |
| 2006-10-17 09:24:00 | AAPL | Stock | 2.6804 | 2.6804 | 2.6804 | 2.6804 | 84000.0 |
| 2006-10-17 09:25:00 | AAPL | Stock | 2.6839 | 2.6839 | 2.6786 | 2.6786 | 86380.0 |
| 2006-10-17 09:28:00 | AAPL | Stock | 2.6818 | 2.6818 | 2.6818 | 2.6818 | 6188.0 |
| 2006-10-17 09:29:00 | AAPL | Stock | 2.6771 | 2.6814 | 2.6771 | 2.6786 | 94360.0 |
| 2006-10-17 09:30:00 | AAPL | Stock | 2.68 | 2.6839 | 2.6786 | 2.6814 | 4603760.0 |
| 2006-10-17 09:31:00 | AAPL | Stock | 2.6814 | 2.6829 | 2.6793 | 2.6804 | 2335956.0 |
| 2006-10-17 09:32:00 | AAPL | Stock | 2.6804 | 2.6832 | 2.6729 | 2.6793 | 2771104.0 |
| 2006-10-17 09:33:00 | AAPL | Stock | 2.6796 | 2.6818 | 2.6764 | 2.6786 | 2104312.0 |
> showing 50 of 705,090 rows — these rows as CSV