PREVIEW / stock_5min / 2011-04-19
file: by_date/stock_5min/2011/2011-04-19.parquet size: 4.8 MB rows: 326,999 symbols: 3,519
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-04-19 04:05:00 | AAPL | Stock | 11.8639 | 11.8746 | 11.8639 | 11.8746 | 16800.0 |
| 2011-04-19 04:10:00 | AAPL | Stock | 11.8639 | 11.8746 | 11.8639 | 11.8746 | 5600.0 |
| 2011-04-19 04:15:00 | AAPL | Stock | 11.8868 | 11.8868 | 11.8868 | 11.8868 | 2800.0 |
| 2011-04-19 04:20:00 | AAPL | Stock | 11.8868 | 11.8868 | 11.8868 | 11.8868 | 2800.0 |
| 2011-04-19 04:25:00 | AAPL | Stock | 11.9086 | 11.9107 | 11.8989 | 11.9107 | 28000.0 |
| 2011-04-19 04:35:00 | AAPL | Stock | 11.9086 | 11.9086 | 11.9086 | 11.9086 | 2800.0 |
| 2011-04-19 04:40:00 | AAPL | Stock | 11.9157 | 11.9157 | 11.9157 | 11.9157 | 2800.0 |
| 2011-04-19 04:50:00 | AAPL | Stock | 11.9229 | 11.9239 | 11.9229 | 11.9239 | 14000.0 |
| 2011-04-19 05:05:00 | AAPL | Stock | 11.9489 | 11.9489 | 11.9489 | 11.9489 | 11200.0 |
| 2011-04-19 05:10:00 | AAPL | Stock | 11.95 | 11.9579 | 11.95 | 11.9579 | 14000.0 |
| 2011-04-19 05:20:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-04-19 05:45:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 2800.0 |
| 2011-04-19 06:00:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9286 | 11.9286 | 13384.0 |
| 2011-04-19 06:05:00 | AAPL | Stock | 11.9375 | 11.9393 | 11.9375 | 11.9393 | 8400.0 |
| 2011-04-19 06:10:00 | AAPL | Stock | 11.9286 | 11.9286 | 11.9279 | 11.9279 | 5600.0 |
| 2011-04-19 06:20:00 | AAPL | Stock | 11.9279 | 11.9279 | 11.9279 | 11.9279 | 2800.0 |
| 2011-04-19 06:30:00 | AAPL | Stock | 11.9318 | 11.9318 | 11.9318 | 11.9318 | 2800.0 |
| 2011-04-19 06:35:00 | AAPL | Stock | 11.9425 | 11.9425 | 11.9425 | 11.9425 | 2800.0 |
| 2011-04-19 06:50:00 | AAPL | Stock | 11.9389 | 11.9389 | 11.9286 | 11.9286 | 8400.0 |
| 2011-04-19 07:00:00 | AAPL | Stock | 11.9193 | 11.9275 | 11.9 | 11.9246 | 36400.0 |
| 2011-04-19 07:05:00 | AAPL | Stock | 11.9111 | 11.9246 | 11.9111 | 11.9196 | 11200.0 |
| 2011-04-19 07:10:00 | AAPL | Stock | 11.9125 | 11.9214 | 11.9111 | 11.9111 | 43400.0 |
| 2011-04-19 07:15:00 | AAPL | Stock | 11.9111 | 11.9221 | 11.9107 | 11.9107 | 29400.0 |
| 2011-04-19 07:20:00 | AAPL | Stock | 11.9071 | 11.9071 | 11.9071 | 11.9071 | 14000.0 |
| 2011-04-19 07:25:00 | AAPL | Stock | 11.9146 | 11.9161 | 11.905 | 11.9161 | 46480.0 |
| 2011-04-19 07:30:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9057 | 11.9061 | 41440.0 |
| 2011-04-19 07:35:00 | AAPL | Stock | 11.9107 | 11.9125 | 11.9057 | 11.9057 | 22820.0 |
| 2011-04-19 07:40:00 | AAPL | Stock | 11.9107 | 11.9157 | 11.9057 | 11.9107 | 49980.0 |
| 2011-04-19 07:45:00 | AAPL | Stock | 11.9164 | 11.92 | 11.9161 | 11.92 | 67200.0 |
| 2011-04-19 07:50:00 | AAPL | Stock | 11.92 | 11.9221 | 11.9107 | 11.915 | 168700.0 |
| 2011-04-19 07:55:00 | AAPL | Stock | 11.9114 | 11.9189 | 11.9114 | 11.9189 | 44800.0 |
| 2011-04-19 08:00:00 | AAPL | Stock | 11.9175 | 11.9232 | 11.8946 | 11.9214 | 332612.0 |
| 2011-04-19 08:05:00 | AAPL | Stock | 11.9214 | 11.9357 | 11.9214 | 11.93 | 744940.0 |
| 2011-04-19 08:10:00 | AAPL | Stock | 11.9286 | 11.9393 | 11.9236 | 11.9236 | 322448.0 |
| 2011-04-19 08:15:00 | AAPL | Stock | 11.9243 | 11.9268 | 11.9196 | 11.925 | 87780.0 |
| 2011-04-19 08:20:00 | AAPL | Stock | 11.9207 | 11.9207 | 11.9057 | 11.9143 | 247520.0 |
| 2011-04-19 08:25:00 | AAPL | Stock | 11.9132 | 11.9175 | 11.9104 | 11.9171 | 90888.0 |
| 2011-04-19 08:30:00 | AAPL | Stock | 11.9179 | 11.9339 | 11.9179 | 11.9339 | 259784.0 |
| 2011-04-19 08:35:00 | AAPL | Stock | 11.9346 | 11.9368 | 11.9196 | 11.925 | 244664.0 |
| 2011-04-19 08:40:00 | AAPL | Stock | 11.925 | 11.9393 | 11.9232 | 11.9286 | 298480.0 |
| 2011-04-19 08:45:00 | AAPL | Stock | 11.9286 | 11.9339 | 11.9232 | 11.9329 | 161420.0 |
| 2011-04-19 08:50:00 | AAPL | Stock | 11.9321 | 11.9336 | 11.9236 | 11.9257 | 167524.0 |
| 2011-04-19 08:55:00 | AAPL | Stock | 11.9214 | 11.9232 | 11.9071 | 11.9071 | 234500.0 |
| 2011-04-19 09:00:00 | AAPL | Stock | 11.9107 | 11.9129 | 11.9025 | 11.9111 | 149884.0 |
| 2011-04-19 09:05:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9071 | 11.9071 | 106960.0 |
| 2011-04-19 09:10:00 | AAPL | Stock | 11.9104 | 11.9107 | 11.9004 | 11.9036 | 169848.0 |
| 2011-04-19 09:15:00 | AAPL | Stock | 11.9043 | 11.9107 | 11.9043 | 11.9054 | 56756.0 |
| 2011-04-19 09:20:00 | AAPL | Stock | 11.9061 | 11.9086 | 11.9032 | 11.9032 | 58072.0 |
| 2011-04-19 09:25:00 | AAPL | Stock | 11.9036 | 11.9061 | 11.8957 | 11.8968 | 221116.0 |
| 2011-04-19 09:30:00 | AAPL | Stock | 11.8996 | 11.9307 | 11.8661 | 11.9179 | 24160668.0 |
> showing 50 of 326,999 rows — these rows as CSV