PREVIEW / stock_1min / 2011-05-17
file: by_date/stock_1min/2011/2011-05-17.parquet size: 14.0 MB rows: 1,057,417 symbols: 2,890
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-05-17 04:42:00 | AAPL | Stock | 11.9243 | 11.9243 | 11.9243 | 11.9243 | 2800.0 |
| 2011-05-17 05:54:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 11816.0 |
| 2011-05-17 05:57:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 14000.0 |
| 2011-05-17 06:04:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-05-17 06:47:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 14000.0 |
| 2011-05-17 06:50:00 | AAPL | Stock | 11.9518 | 11.9518 | 11.9464 | 11.9464 | 19600.0 |
| 2011-05-17 06:53:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 2800.0 |
| 2011-05-17 06:56:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 10584.0 |
| 2011-05-17 06:57:00 | AAPL | Stock | 11.9464 | 11.9464 | 11.9464 | 11.9464 | 56000.0 |
| 2011-05-17 07:00:00 | AAPL | Stock | 11.9396 | 11.9554 | 11.9393 | 11.9554 | 51716.0 |
| 2011-05-17 07:01:00 | AAPL | Stock | 11.9414 | 11.9582 | 11.9411 | 11.9582 | 14000.0 |
| 2011-05-17 07:02:00 | AAPL | Stock | 11.94 | 11.94 | 11.94 | 11.94 | 2800.0 |
| 2011-05-17 07:03:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 14000.0 |
| 2011-05-17 07:06:00 | AAPL | Stock | 11.9493 | 11.9493 | 11.9493 | 11.9493 | 2800.0 |
| 2011-05-17 07:08:00 | AAPL | Stock | 11.95 | 11.95 | 11.95 | 11.95 | 5600.0 |
| 2011-05-17 07:10:00 | AAPL | Stock | 11.9393 | 11.9393 | 11.9393 | 11.9393 | 7000.0 |
| 2011-05-17 07:11:00 | AAPL | Stock | 11.9214 | 11.9214 | 11.9214 | 11.9214 | 2800.0 |
| 2011-05-17 07:17:00 | AAPL | Stock | 11.9425 | 11.9425 | 11.9425 | 11.9425 | 5600.0 |
| 2011-05-17 07:19:00 | AAPL | Stock | 11.9346 | 11.9589 | 11.9346 | 11.9589 | 145320.0 |
| 2011-05-17 07:27:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 9800.0 |
| 2011-05-17 07:29:00 | AAPL | Stock | 11.9429 | 11.9429 | 11.9429 | 11.9429 | 7980.0 |
| 2011-05-17 07:31:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 42000.0 |
| 2011-05-17 07:33:00 | AAPL | Stock | 11.9407 | 11.9411 | 11.9407 | 11.9411 | 8400.0 |
| 2011-05-17 07:42:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 3080.0 |
| 2011-05-17 07:43:00 | AAPL | Stock | 11.925 | 11.925 | 11.9236 | 11.9236 | 9380.0 |
| 2011-05-17 07:46:00 | AAPL | Stock | 11.9218 | 11.9218 | 11.9214 | 11.9214 | 19600.0 |
| 2011-05-17 07:47:00 | AAPL | Stock | 11.9304 | 11.9304 | 11.9304 | 11.9304 | 3080.0 |
| 2011-05-17 07:49:00 | AAPL | Stock | 11.925 | 11.925 | 11.925 | 11.925 | 2800.0 |
| 2011-05-17 07:53:00 | AAPL | Stock | 11.9168 | 11.9254 | 11.9168 | 11.9254 | 13944.0 |
| 2011-05-17 07:54:00 | AAPL | Stock | 11.9168 | 11.9168 | 11.9107 | 11.9143 | 19544.0 |
| 2011-05-17 07:56:00 | AAPL | Stock | 11.9207 | 11.9207 | 11.9207 | 11.9207 | 5600.0 |
| 2011-05-17 07:57:00 | AAPL | Stock | 11.9207 | 11.9207 | 11.9207 | 11.9207 | 8400.0 |
| 2011-05-17 07:59:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9089 | 11.9107 | 8400.0 |
| 2011-05-17 08:00:00 | AAPL | Stock | 11.9196 | 11.9196 | 11.9107 | 11.9107 | 54432.0 |
| 2011-05-17 08:01:00 | AAPL | Stock | 11.9186 | 11.9186 | 11.9186 | 11.9186 | 7000.0 |
| 2011-05-17 08:04:00 | AAPL | Stock | 11.9193 | 11.9193 | 11.9193 | 11.9193 | 9520.0 |
| 2011-05-17 08:05:00 | AAPL | Stock | 11.9157 | 11.9157 | 11.9043 | 11.9043 | 33796.0 |
| 2011-05-17 08:06:00 | AAPL | Stock | 11.9132 | 11.9132 | 11.9043 | 11.9043 | 11564.0 |
| 2011-05-17 08:07:00 | AAPL | Stock | 11.9139 | 11.9139 | 11.9057 | 11.9057 | 14000.0 |
| 2011-05-17 08:09:00 | AAPL | Stock | 11.9107 | 11.9136 | 11.9107 | 11.9136 | 11200.0 |
| 2011-05-17 08:10:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9107 | 11.9107 | 12684.0 |
| 2011-05-17 08:11:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9071 | 11.9071 | 8400.0 |
| 2011-05-17 08:12:00 | AAPL | Stock | 11.9043 | 11.9043 | 11.8929 | 11.8929 | 119420.0 |
| 2011-05-17 08:13:00 | AAPL | Stock | 11.8929 | 11.8929 | 11.8857 | 11.8857 | 44800.0 |
| 2011-05-17 08:14:00 | AAPL | Stock | 11.8875 | 11.8875 | 11.8807 | 11.8821 | 38780.0 |
| 2011-05-17 08:15:00 | AAPL | Stock | 11.8846 | 11.8846 | 11.8843 | 11.8843 | 16800.0 |
| 2011-05-17 08:16:00 | AAPL | Stock | 11.8843 | 11.8843 | 11.8804 | 11.8829 | 44800.0 |
| 2011-05-17 08:17:00 | AAPL | Stock | 11.8839 | 11.8839 | 11.8789 | 11.8789 | 37660.0 |
| 2011-05-17 08:18:00 | AAPL | Stock | 11.8839 | 11.8839 | 11.8793 | 11.8829 | 21000.0 |
| 2011-05-17 08:19:00 | AAPL | Stock | 11.8843 | 11.8843 | 11.8804 | 11.8804 | 11200.0 |
> showing 50 of 1,057,417 rows — these rows as CSV