PREVIEW / stock_1min / 2013-02-21
file: by_date/stock_1min/2013/2013-02-21.parquet size: 13.8 MB rows: 1,012,270 symbols: 2,825
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-21 05:47:00 | AAPL | Stock | 15.9339 | 15.9339 | 15.9339 | 15.9339 | 5600.0 |
| 2013-02-21 05:53:00 | AAPL | Stock | 15.9279 | 15.9279 | 15.9279 | 15.9279 | 2800.0 |
| 2013-02-21 05:54:00 | AAPL | Stock | 15.9279 | 15.9279 | 15.9279 | 15.9279 | 2800.0 |
| 2013-02-21 06:46:00 | AAPL | Stock | 15.9464 | 15.9464 | 15.9464 | 15.9464 | 2800.0 |
| 2013-02-21 06:55:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 8400.0 |
| 2013-02-21 06:59:00 | AAPL | Stock | 15.9118 | 15.9118 | 15.9118 | 15.9118 | 2800.0 |
| 2013-02-21 07:01:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9196 | 15.9196 | 2800.0 |
| 2013-02-21 07:09:00 | AAPL | Stock | 15.9264 | 15.9286 | 15.9264 | 15.9286 | 15148.0 |
| 2013-02-21 07:10:00 | AAPL | Stock | 15.9293 | 15.9293 | 15.9289 | 15.9289 | 8400.0 |
| 2013-02-21 07:12:00 | AAPL | Stock | 15.9364 | 15.9364 | 15.9364 | 15.9364 | 2800.0 |
| 2013-02-21 07:17:00 | AAPL | Stock | 15.9293 | 15.9293 | 15.9293 | 15.9293 | 2800.0 |
| 2013-02-21 07:18:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 26040.0 |
| 2013-02-21 07:19:00 | AAPL | Stock | 15.9261 | 15.9261 | 15.9261 | 15.9261 | 2800.0 |
| 2013-02-21 07:20:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 2800.0 |
| 2013-02-21 07:23:00 | AAPL | Stock | 15.9282 | 15.9286 | 15.9282 | 15.9286 | 24920.0 |
| 2013-02-21 07:24:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 2800.0 |
| 2013-02-21 07:28:00 | AAPL | Stock | 15.9286 | 15.9286 | 15.9286 | 15.9286 | 5600.0 |
| 2013-02-21 07:34:00 | AAPL | Stock | 15.9214 | 15.9214 | 15.9196 | 15.9196 | 12040.0 |
| 2013-02-21 07:36:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9068 | 15.9068 | 36092.0 |
| 2013-02-21 07:37:00 | AAPL | Stock | 15.9036 | 15.9036 | 15.9036 | 15.9036 | 2800.0 |
| 2013-02-21 07:38:00 | AAPL | Stock | 15.8986 | 15.8986 | 15.8929 | 15.8929 | 41384.0 |
| 2013-02-21 07:39:00 | AAPL | Stock | 15.8929 | 15.9 | 15.8929 | 15.9 | 19180.0 |
| 2013-02-21 07:41:00 | AAPL | Stock | 15.9089 | 15.9089 | 15.8996 | 15.8996 | 19600.0 |
| 2013-02-21 07:42:00 | AAPL | Stock | 15.9032 | 15.9036 | 15.8929 | 15.8929 | 105784.0 |
| 2013-02-21 07:43:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.8929 | 15.8929 | 5600.0 |
| 2013-02-21 07:44:00 | AAPL | Stock | 15.8968 | 15.8968 | 15.8857 | 15.8857 | 28308.0 |
| 2013-02-21 07:45:00 | AAPL | Stock | 15.8893 | 15.9104 | 15.8893 | 15.9086 | 88452.0 |
| 2013-02-21 07:46:00 | AAPL | Stock | 15.9064 | 15.9064 | 15.9064 | 15.9064 | 2800.0 |
| 2013-02-21 07:47:00 | AAPL | Stock | 15.9054 | 15.9054 | 15.9054 | 15.9054 | 2800.0 |
| 2013-02-21 07:48:00 | AAPL | Stock | 15.9054 | 15.9054 | 15.9054 | 15.9054 | 2800.0 |
| 2013-02-21 07:49:00 | AAPL | Stock | 15.895 | 15.895 | 15.8939 | 15.8939 | 8400.0 |
| 2013-02-21 07:50:00 | AAPL | Stock | 15.8993 | 15.8993 | 15.8975 | 15.8975 | 14000.0 |
| 2013-02-21 07:52:00 | AAPL | Stock | 15.9107 | 15.9107 | 15.9107 | 15.9107 | 4200.0 |
| 2013-02-21 07:53:00 | AAPL | Stock | 15.9121 | 15.9121 | 15.9121 | 15.9121 | 2800.0 |
| 2013-02-21 07:54:00 | AAPL | Stock | 15.9111 | 15.9111 | 15.9107 | 15.9107 | 8400.0 |
| 2013-02-21 07:55:00 | AAPL | Stock | 15.9107 | 15.9107 | 15.9071 | 15.9071 | 11200.0 |
| 2013-02-21 07:56:00 | AAPL | Stock | 15.9071 | 15.9071 | 15.9071 | 15.9071 | 5600.0 |
| 2013-02-21 07:58:00 | AAPL | Stock | 15.9107 | 15.9161 | 15.9107 | 15.9161 | 14000.0 |
| 2013-02-21 07:59:00 | AAPL | Stock | 15.9157 | 15.9161 | 15.9079 | 15.9079 | 8960.0 |
| 2013-02-21 08:00:00 | AAPL | Stock | 15.9157 | 15.9354 | 15.8936 | 15.9354 | 276724.0 |
| 2013-02-21 08:01:00 | AAPL | Stock | 15.9354 | 15.9357 | 15.9296 | 15.9321 | 33600.0 |
| 2013-02-21 08:03:00 | AAPL | Stock | 15.9357 | 15.9375 | 15.925 | 15.9286 | 29120.0 |
| 2013-02-21 08:05:00 | AAPL | Stock | 15.935 | 15.935 | 15.935 | 15.935 | 2800.0 |
| 2013-02-21 08:06:00 | AAPL | Stock | 15.9289 | 15.9382 | 15.9286 | 15.9382 | 26012.0 |
| 2013-02-21 08:07:00 | AAPL | Stock | 15.9375 | 15.9379 | 15.9296 | 15.9325 | 55720.0 |
| 2013-02-21 08:08:00 | AAPL | Stock | 15.9286 | 16.0714 | 15.9286 | 15.935 | 44800.0 |
| 2013-02-21 08:09:00 | AAPL | Stock | 15.9339 | 15.9339 | 15.9286 | 15.9339 | 11480.0 |
| 2013-02-21 08:10:00 | AAPL | Stock | 15.9339 | 15.9375 | 15.9321 | 15.9339 | 49000.0 |
| 2013-02-21 08:11:00 | AAPL | Stock | 15.9368 | 15.9379 | 15.9368 | 15.9379 | 5600.0 |
| 2013-02-21 08:12:00 | AAPL | Stock | 15.9379 | 15.9382 | 15.9379 | 15.9379 | 14000.0 |
> showing 50 of 1,012,270 rows — these rows as CSV