PREVIEW / stock_1min / 2010-10-22
file: by_date/stock_1min/2010/2010-10-22.parquet size: 11.7 MB rows: 884,678 symbols: 2,832
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-22 05:18:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 11200.0 |
| 2010-10-22 05:44:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 11200.0 |
| 2010-10-22 07:00:00 | AAPL | Stock | 10.9925 | 10.9925 | 10.9925 | 10.9925 | 2800.0 |
| 2010-10-22 07:02:00 | AAPL | Stock | 11.0157 | 11.0157 | 11.0057 | 11.0061 | 22596.0 |
| 2010-10-22 07:05:00 | AAPL | Stock | 11.0 | 11.0 | 11.0 | 11.0 | 2800.0 |
| 2010-10-22 07:07:00 | AAPL | Stock | 11.0 | 11.0 | 11.0 | 11.0 | 2800.0 |
| 2010-10-22 07:08:00 | AAPL | Stock | 11.005 | 11.0054 | 11.005 | 11.0054 | 15204.0 |
| 2010-10-22 07:10:00 | AAPL | Stock | 11.0007 | 11.0007 | 11.0007 | 11.0007 | 2800.0 |
| 2010-10-22 07:22:00 | AAPL | Stock | 11.0107 | 11.0107 | 11.0107 | 11.0107 | 2800.0 |
| 2010-10-22 07:24:00 | AAPL | Stock | 11.0107 | 11.0107 | 11.0107 | 11.0107 | 5600.0 |
| 2010-10-22 07:29:00 | AAPL | Stock | 11.0161 | 11.0161 | 11.0161 | 11.0161 | 2800.0 |
| 2010-10-22 07:31:00 | AAPL | Stock | 11.0154 | 11.0161 | 11.0154 | 11.0161 | 13664.0 |
| 2010-10-22 07:34:00 | AAPL | Stock | 11.0089 | 11.0089 | 11.0089 | 11.0089 | 2800.0 |
| 2010-10-22 07:35:00 | AAPL | Stock | 11.0107 | 11.0107 | 11.0107 | 11.0107 | 8400.0 |
| 2010-10-22 07:36:00 | AAPL | Stock | 11.0111 | 11.0111 | 11.0107 | 11.0107 | 11200.0 |
| 2010-10-22 07:37:00 | AAPL | Stock | 11.0143 | 11.0143 | 11.0143 | 11.0143 | 2800.0 |
| 2010-10-22 07:43:00 | AAPL | Stock | 11.0246 | 11.025 | 11.0246 | 11.025 | 11200.0 |
| 2010-10-22 07:44:00 | AAPL | Stock | 11.0214 | 11.0214 | 11.0214 | 11.0214 | 30800.0 |
| 2010-10-22 07:51:00 | AAPL | Stock | 11.0207 | 11.0207 | 11.0207 | 11.0207 | 2800.0 |
| 2010-10-22 07:54:00 | AAPL | Stock | 11.0182 | 11.0182 | 11.0182 | 11.0182 | 2800.0 |
| 2010-10-22 07:55:00 | AAPL | Stock | 11.0182 | 11.025 | 11.0179 | 11.025 | 28000.0 |
| 2010-10-22 07:58:00 | AAPL | Stock | 11.025 | 11.025 | 11.025 | 11.025 | 5600.0 |
| 2010-10-22 08:00:00 | AAPL | Stock | 11.0214 | 11.0268 | 11.0089 | 11.0125 | 154812.0 |
| 2010-10-22 08:01:00 | AAPL | Stock | 11.0179 | 11.0246 | 11.0179 | 11.0246 | 60200.0 |
| 2010-10-22 08:02:00 | AAPL | Stock | 11.0214 | 11.025 | 11.0214 | 11.025 | 119560.0 |
| 2010-10-22 08:03:00 | AAPL | Stock | 11.0296 | 11.0429 | 11.0296 | 11.0361 | 71820.0 |
| 2010-10-22 08:04:00 | AAPL | Stock | 11.0418 | 11.0425 | 11.0304 | 11.0304 | 74200.0 |
| 2010-10-22 08:05:00 | AAPL | Stock | 11.0232 | 11.0232 | 11.0232 | 11.0232 | 2800.0 |
| 2010-10-22 08:06:00 | AAPL | Stock | 11.0232 | 11.0311 | 11.0221 | 11.0311 | 11200.0 |
| 2010-10-22 08:07:00 | AAPL | Stock | 11.0186 | 11.0186 | 11.0107 | 11.0164 | 84000.0 |
| 2010-10-22 08:09:00 | AAPL | Stock | 11.0168 | 11.0179 | 11.0107 | 11.0107 | 57624.0 |
| 2010-10-22 08:10:00 | AAPL | Stock | 11.0039 | 11.0039 | 11.0039 | 11.0039 | 5600.0 |
| 2010-10-22 08:12:00 | AAPL | Stock | 11.0043 | 11.0043 | 11.0039 | 11.0043 | 29064.0 |
| 2010-10-22 08:13:00 | AAPL | Stock | 11.0046 | 11.0071 | 11.0046 | 11.0071 | 7700.0 |
| 2010-10-22 08:14:00 | AAPL | Stock | 11.0071 | 11.0107 | 11.0071 | 11.0107 | 23800.0 |
| 2010-10-22 08:15:00 | AAPL | Stock | 11.0107 | 11.0125 | 11.0107 | 11.0125 | 5600.0 |
| 2010-10-22 08:16:00 | AAPL | Stock | 11.0139 | 11.0154 | 11.0107 | 11.0107 | 25200.0 |
| 2010-10-22 08:17:00 | AAPL | Stock | 11.0107 | 11.0107 | 11.0089 | 11.0089 | 42000.0 |
| 2010-10-22 08:18:00 | AAPL | Stock | 11.0118 | 11.0125 | 11.0107 | 11.0125 | 147000.0 |
| 2010-10-22 08:19:00 | AAPL | Stock | 11.0061 | 11.0061 | 11.0061 | 11.0061 | 2800.0 |
| 2010-10-22 08:21:00 | AAPL | Stock | 11.0071 | 11.0071 | 11.0071 | 11.0071 | 5600.0 |
| 2010-10-22 08:22:00 | AAPL | Stock | 11.0082 | 11.0089 | 11.0079 | 11.0089 | 19600.0 |
| 2010-10-22 08:23:00 | AAPL | Stock | 11.0118 | 11.0121 | 11.0054 | 11.0054 | 55300.0 |
| 2010-10-22 08:24:00 | AAPL | Stock | 11.0125 | 11.0125 | 11.0125 | 11.0125 | 5600.0 |
| 2010-10-22 08:25:00 | AAPL | Stock | 11.0125 | 11.0125 | 11.0125 | 11.0125 | 2800.0 |
| 2010-10-22 08:26:00 | AAPL | Stock | 11.0096 | 11.0096 | 11.0082 | 11.0082 | 11200.0 |
| 2010-10-22 08:27:00 | AAPL | Stock | 11.0143 | 11.015 | 11.0143 | 11.015 | 33600.0 |
| 2010-10-22 08:28:00 | AAPL | Stock | 11.0154 | 11.0154 | 11.0118 | 11.0118 | 8400.0 |
| 2010-10-22 08:29:00 | AAPL | Stock | 11.0157 | 11.0243 | 11.0157 | 11.0243 | 50400.0 |
| 2010-10-22 08:30:00 | AAPL | Stock | 11.0239 | 11.0268 | 11.0239 | 11.0268 | 178444.0 |
> showing 50 of 884,678 rows — these rows as CSV