PREVIEW / stock_1min / 2011-09-14
file: by_date/stock_1min/2011/2011-09-14.parquet size: 13.2 MB rows: 982,616 symbols: 2,827
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-14 04:08:00 | AAPL | Stock | 13.7143 | 13.7143 | 13.7143 | 13.7143 | 2800.0 |
| 2011-09-14 04:27:00 | AAPL | Stock | 13.6964 | 13.6964 | 13.6929 | 13.6929 | 5600.0 |
| 2011-09-14 04:31:00 | AAPL | Stock | 13.6893 | 13.6893 | 13.6893 | 13.6893 | 2800.0 |
| 2011-09-14 05:00:00 | AAPL | Stock | 13.6964 | 13.6964 | 13.6964 | 13.6964 | 2800.0 |
| 2011-09-14 05:14:00 | AAPL | Stock | 13.7011 | 13.7011 | 13.7011 | 13.7011 | 2800.0 |
| 2011-09-14 05:16:00 | AAPL | Stock | 13.7007 | 13.7011 | 13.7007 | 13.7011 | 5600.0 |
| 2011-09-14 05:26:00 | AAPL | Stock | 13.7054 | 13.7054 | 13.7054 | 13.7054 | 2800.0 |
| 2011-09-14 05:48:00 | AAPL | Stock | 13.735 | 13.735 | 13.735 | 13.735 | 2800.0 |
| 2011-09-14 05:49:00 | AAPL | Stock | 13.7318 | 13.7318 | 13.7318 | 13.7318 | 2800.0 |
| 2011-09-14 05:50:00 | AAPL | Stock | 13.7232 | 13.7232 | 13.7232 | 13.7232 | 8400.0 |
| 2011-09-14 05:57:00 | AAPL | Stock | 13.7311 | 13.7311 | 13.7311 | 13.7311 | 2800.0 |
| 2011-09-14 05:58:00 | AAPL | Stock | 13.7286 | 13.7286 | 13.7286 | 13.7286 | 2800.0 |
| 2011-09-14 06:16:00 | AAPL | Stock | 13.725 | 13.725 | 13.725 | 13.725 | 2800.0 |
| 2011-09-14 06:27:00 | AAPL | Stock | 13.7539 | 13.7539 | 13.7539 | 13.7539 | 2800.0 |
| 2011-09-14 06:31:00 | AAPL | Stock | 13.7564 | 13.7564 | 13.7564 | 13.7564 | 5600.0 |
| 2011-09-14 06:45:00 | AAPL | Stock | 13.7768 | 13.7771 | 13.7768 | 13.7768 | 16800.0 |
| 2011-09-14 06:46:00 | AAPL | Stock | 13.7768 | 13.7768 | 13.7768 | 13.7768 | 5600.0 |
| 2011-09-14 06:47:00 | AAPL | Stock | 13.7771 | 13.7832 | 13.7768 | 13.7771 | 18200.0 |
| 2011-09-14 06:55:00 | AAPL | Stock | 13.8036 | 13.8107 | 13.8036 | 13.8107 | 5600.0 |
| 2011-09-14 07:00:00 | AAPL | Stock | 13.81 | 13.81 | 13.81 | 13.81 | 11200.0 |
| 2011-09-14 07:01:00 | AAPL | Stock | 13.8129 | 13.8129 | 13.8118 | 13.8121 | 14000.0 |
| 2011-09-14 07:03:00 | AAPL | Stock | 13.8218 | 13.8361 | 13.8218 | 13.8329 | 8400.0 |
| 2011-09-14 07:04:00 | AAPL | Stock | 13.8318 | 13.8321 | 13.8318 | 13.8321 | 12600.0 |
| 2011-09-14 07:05:00 | AAPL | Stock | 13.8221 | 13.8504 | 13.8221 | 13.8504 | 55692.0 |
| 2011-09-14 07:06:00 | AAPL | Stock | 13.8479 | 13.8486 | 13.8479 | 13.8486 | 8400.0 |
| 2011-09-14 07:07:00 | AAPL | Stock | 13.8475 | 13.8636 | 13.8475 | 13.8636 | 39340.0 |
| 2011-09-14 07:08:00 | AAPL | Stock | 13.8571 | 13.87 | 13.8571 | 13.8571 | 29820.0 |
| 2011-09-14 07:10:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8393 | 13.8393 | 42028.0 |
| 2011-09-14 07:12:00 | AAPL | Stock | 13.8479 | 13.8479 | 13.8393 | 13.8393 | 5600.0 |
| 2011-09-14 07:13:00 | AAPL | Stock | 13.8389 | 13.8393 | 13.8389 | 13.8393 | 5600.0 |
| 2011-09-14 07:14:00 | AAPL | Stock | 13.8304 | 13.8304 | 13.8304 | 13.8304 | 2800.0 |
| 2011-09-14 07:15:00 | AAPL | Stock | 13.8225 | 13.8225 | 13.8225 | 13.8225 | 5600.0 |
| 2011-09-14 07:16:00 | AAPL | Stock | 13.8246 | 13.8286 | 13.8246 | 13.8286 | 5600.0 |
| 2011-09-14 07:17:00 | AAPL | Stock | 13.8254 | 13.8254 | 13.8225 | 13.8225 | 8400.0 |
| 2011-09-14 07:18:00 | AAPL | Stock | 13.8221 | 13.8221 | 13.8218 | 13.8218 | 11200.0 |
| 2011-09-14 07:22:00 | AAPL | Stock | 13.8211 | 13.8225 | 13.8211 | 13.8225 | 32228.0 |
| 2011-09-14 07:23:00 | AAPL | Stock | 13.8146 | 13.82 | 13.8143 | 13.82 | 11200.0 |
| 2011-09-14 07:24:00 | AAPL | Stock | 13.8225 | 13.8225 | 13.8225 | 13.8225 | 6468.0 |
| 2011-09-14 07:25:00 | AAPL | Stock | 13.8211 | 13.8211 | 13.8211 | 13.8211 | 5600.0 |
| 2011-09-14 07:26:00 | AAPL | Stock | 13.8157 | 13.8157 | 13.8157 | 13.8157 | 2800.0 |
| 2011-09-14 07:27:00 | AAPL | Stock | 13.8225 | 13.8264 | 13.8225 | 13.8225 | 89600.0 |
| 2011-09-14 07:28:00 | AAPL | Stock | 13.8204 | 13.8204 | 13.8157 | 13.8157 | 28000.0 |
| 2011-09-14 07:29:00 | AAPL | Stock | 13.8189 | 13.8196 | 13.8189 | 13.8196 | 8400.0 |
| 2011-09-14 07:30:00 | AAPL | Stock | 13.8164 | 13.8214 | 13.8164 | 13.8214 | 11200.0 |
| 2011-09-14 07:31:00 | AAPL | Stock | 13.82 | 13.8264 | 13.82 | 13.8254 | 33600.0 |
| 2011-09-14 07:32:00 | AAPL | Stock | 13.8246 | 13.8246 | 13.8196 | 13.8196 | 11200.0 |
| 2011-09-14 07:34:00 | AAPL | Stock | 13.8154 | 13.8154 | 13.8154 | 13.8154 | 5600.0 |
| 2011-09-14 07:35:00 | AAPL | Stock | 13.8111 | 13.8125 | 13.8111 | 13.8125 | 8400.0 |
| 2011-09-14 07:36:00 | AAPL | Stock | 13.8157 | 13.8157 | 13.8157 | 13.8157 | 5600.0 |
| 2011-09-14 07:37:00 | AAPL | Stock | 13.8107 | 13.8107 | 13.8089 | 13.8089 | 5600.0 |
> showing 50 of 982,616 rows — these rows as CSV